• Resolved geoffw41

    (@geoffw41)


    I can’t get the dates of matches to import correctly – they end up being replaced with the current date. I have used the same format as in the Euro2020 example file – I exported this then modified the matches.
    first line of my csv file: 1;”1″;”1″;”2″;”0″;”2″;”2022-10-21 18:46:00″;”1″

    The date “2022-10-21 18:46:00” is modified to “2021-11-15 18:46:00” on import (i.e. todays date)

    What am I doing incorrect?

    • This topic was modified 4 years, 10 months ago by geoffw41.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author AntoineH

    (@antoineh)

    Looks like the format of your file is not correct. It should be either 5 columns (short format) or 18 columns (extended format). But both formats should always start with the date in the first column.

    My advice: take this file as an example and adjust it with your data.

    Or, if you prefer the short format, then import the previous file. Make sure you have the setting on the plugin options page set to the short format and then export the schedule to get an example of the short format.

    Thread Starter geoffw41

    (@geoffw41)

    Sorry, I posted the wrong csv data, this is the correct csv file:

    play_date;home_team;away_team;stadium;match_type;home_team_photo;home_team_flag;home_team_link;home_team_group;home_team_group_order;home_team_is_real;away_team_photo;away_team_flag;away_team_link;away_team_group;away_team_group_order;away_team_is_real;stadium_photo
    2022-11-21 11:00:00;H1;A1;Al Bayt;Group Stage;;tr.png;;Group A;3;1;;it.png;;Group A;1;1;
    2022-11-21 14:00:00;H2;A2;Al Thumana;Group Stage;;gb-wls.png;;Group A;4;1;;ch.png;;Group A;2;1;
    2022-11-21 17:00:00;H3;A3;Khalifa Internat.;Group Stage;;dk.png;;Group B;2;1;;fi.png;;Group B;3;1;
    2022-11-21 20:00:00;H4;A4;Ahmad Bin Ali;Group Stage;;be.png;;Group B;1;1;;ru.png;;Group B;4;1;
    Plugin Author AntoineH

    (@antoineh)

    What version of the plugin are you on?

    Thread Starter geoffw41

    (@geoffw41)

    Version 2.9.7. I only installed it last weekend.

    Thread Starter geoffw41

    (@geoffw41)

    SOLVED: Had to change the Date Format in WP Settings/General to Y/m/d

    Plugin Author AntoineH

    (@antoineh)

    Perfect 🙂

    I was just typing you a message that I didn’t understand why it wasn’t working, because in my install it worked perfectly.

    FYI: Next version of the plugin will have some configuration options for the import format. I already made some improvements to that code, but I will test it again with your feedback (because the display settings of WP shouldn’t have any impact on the import in my opinion).

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Matches Import File – Date format error’ is closed to new replies.