Title: Adding Bulk Matches
Last modified: August 21, 2020

---

# Adding Bulk Matches

 *  Resolved [crodat](https://wordpress.org/support/users/crodat/)
 * (@crodat)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/adding-bulk-matches/)
 * I’ve come back to this plug-in after a few years away and it’s as good as I remember
   although it seems that I can’t remember some basics!
 * I’m attempting to add yesterday’s released English Premier League fixtures added
   bulk via CSV but I can’t quite work it out, so far I have an example row as:
 * 2020-09-12 15:00:00;ARS;SOU;”Premier Pundits”;”English Premier League”;;;;;0;1;
   [https://premierpundits.com/wp-content/uploads/2020/08/ARS.png;https://premierpundits.com/wp-content/uploads/2020/08/AST.png](https://premierpundits.com/wp-content/uploads/2020/08/ARS.png;https://premierpundits.com/wp-content/uploads/2020/08/AST.png);;;
   0;1;
 * (I have ‘flags’ for each team, hence the PNG)
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fadding-bulk-matches%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Author [AntoineH](https://wordpress.org/support/users/antoineh/)
 * (@antoineh)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/adding-bulk-matches/#post-13294370)
 * The column layout for a full data import is:
 * `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`
 * So, looking at your example, that would be something like:
 * `2020-09-12 15:00:00;ARS;SOU;"Premier Pundits";"English Premier League";;https://
   premierpundits.com/wp-content/uploads/2020/08/ARS.png;;"English Premier League";
   1;1;;https://premierpundits.com/wp-content/uploads/2020/08/AST.png;;"English 
   Premier League";1;1;`
 * /disclaimer: not tested.
 * Tip: create one match (plus 2 teams, match type, etc.) via the admin and then
   export it on the matches page. You can use that export as a template to add all
   other matches.
 *  Thread Starter [crodat](https://wordpress.org/support/users/crodat/)
 * (@crodat)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/adding-bulk-matches/#post-13303390)
 * Thank you for the quick reply.
 * I have attempted this using your tip (add in one match manually and download 
   the scedule and use that as a template) but when I add a second row, and try 
   and import it, I get the error:
 * Invalid column count on row 2.
 * This is the current contents of my CSV on rows 1, 2 and 3 (I’m testing without
   flags for the moment) – I added the top fixture and then copy and pasted on to
   the next row and just changed the team names:
 * 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
    2020-09-12 15:00:00;CRY;SOU;”English Premier League”;”English 
   Premier League”;;;;;0;1;;;;;0;1; 2020-09-12 15:00:00;ARS;FUL;”English Premier
   League”;”English Premier League”;;;;;0;1;;;;;0;1;
 *  Plugin Author [AntoineH](https://wordpress.org/support/users/antoineh/)
 * (@antoineh)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/adding-bulk-matches/#post-13306186)
 * If I copy & paste your data in a text file, then it works perfectly on my test
   install.
 * Import result:
 *     ```
       Team 1 added: CRY
       Team 2 added: SOU
       Stadium 1 added: ”English Premier League”
       Match Type 22 added: ”English Premier League”
       Match 1 imported: CRY - SOU for date "2020-09-12 15:00:00"
       Team 3 added: ARS
       Team 4 added: FUL
       Match 2 imported: ARS - FUL for date "2020-09-12 15:00:00"
       ```
   
 * So, the data seems fine. One other option is that the file is not correct. Can
   you try saving the file with a tool like notepad++ where you can also specify/
   convert encoding of the file (should be UTF-8).
 * p.s. you can find the file that I tested with, [here](https://www.dropbox.com/s/hhadcbewvlaj7nj/importtest.txt?dl=0).
 *  [unimke](https://wordpress.org/support/users/unimke/)
 * (@unimke)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/adding-bulk-matches/#post-13307633)
 * Hi Crodat
    Can i have your excel spreedsheet for EPL 2020/2021 season? My email
   is [unimkeabana@gmail.com](https://wordpress.org/support/topic/adding-bulk-matches/unimkeabana@gmail.com?output_format=md)
 * Thank you
 *  Thread Starter [crodat](https://wordpress.org/support/users/crodat/)
 * (@crodat)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/adding-bulk-matches/#post-13309874)
 * Perfect, it now works – Thanks Antoine.
 * In Notepad++ I had to select
 * > Encoding > Encoding in UTF-8
 * Then when I saved it, I just had to type the .csv extension and it’s imported
   fine.
 *  Thread Starter [crodat](https://wordpress.org/support/users/crodat/)
 * (@crodat)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/adding-bulk-matches/#post-13309890)
 * Although, I sporadically get the message:
 * > Column 1 header should be “play_date” ⇒ not “play_date”
 *  Plugin Author [AntoineH](https://wordpress.org/support/users/antoineh/)
 * (@antoineh)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/adding-bulk-matches/#post-13311588)
 * Make sure you choose “UTF-8” and not “UTF-8 with BOM”. The latter will not work
   and I think causes the problem that you mention.
 * p.s. extension can also be .txt or anything else, that doesn’t matter for the
   script.
 *  Thread Starter [crodat](https://wordpress.org/support/users/crodat/)
 * (@crodat)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/adding-bulk-matches/#post-13315367)
 * Thank you, this now works.
 * I had to select encoding as ‘UTF-8 without BOM’ in Notepad++.
 * Saving as .txt also worked.

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

The topic ‘Adding Bulk Matches’ is closed to new replies.

 * ![](https://ps.w.org/football-pool/assets/icon-256x256.png?rev=983880)
 * [Football Pool](https://wordpress.org/plugins/football-pool/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/football-pool/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/football-pool/)
 * [Active Topics](https://wordpress.org/support/plugin/football-pool/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/football-pool/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/football-pool/reviews/)

## Tags

 * [add](https://wordpress.org/support/topic-tag/add/)
 * [csv](https://wordpress.org/support/topic-tag/csv/)
 * [fixtures](https://wordpress.org/support/topic-tag/fixtures/)
 * [txt](https://wordpress.org/support/topic-tag/txt/)
 * [upload](https://wordpress.org/support/topic-tag/upload/)
 * [utf-8](https://wordpress.org/support/topic-tag/utf-8/)

 * 8 replies
 * 3 participants
 * Last reply from: [crodat](https://wordpress.org/support/users/crodat/)
 * Last activity: [5 years, 9 months ago](https://wordpress.org/support/topic/adding-bulk-matches/#post-13315367)
 * Status: resolved