Title: CSV Import Issue
Last modified: August 21, 2016

---

# CSV Import Issue

 *  [Scott](https://wordpress.org/support/users/scooter1/)
 * (@scooter1)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/csv-import-issue-1/)
 * [@themeboy](https://wordpress.org/support/users/themeboy/):
 * Yesterday you advised me that I could list the two teams in an event CSV import
   with a “|” as follows: Team 1 | Team 2
    When I do this it actually creates a 
   team called “Team 1 | Team 2”, rather than recognizing the entry as two different
   teams… I tried separating the teams with a comma and that didn’t work. I did 
   notice that in the import window it provides two import formats “friendly” and“
   league”. I’ve been selecting “league” and wonder if that matters? Also, both 
   the event and team names are duplicated, and I’m wondering if creating an additional
   field “Event” in the CSV would work? *NOTE: The plugin updated this morning and
   the date issue is still there. It has to be formatted: yyyy-mm-dd.
 * [https://wordpress.org/plugins/sportspress/](https://wordpress.org/plugins/sportspress/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [ThemeBoy](https://wordpress.org/support/users/themeboy/)
 * (@themeboy)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/csv-import-issue-1/#post-5081672)
 * [@scooter1](https://wordpress.org/support/users/scooter1/) Ah, apologies for 
   that. It’s actually only “Outcomes” that can be separate by a vertical line. 
   Multiple teams should be added as separate rows. The sample CSV file has an example
   of how you would add 2 teams to an event.
 * The formats select will apply a format to all events imported. “League” events
   count toward league tables and player statistics, and “Friendly” events will 
   not count toward any of the league tables or statistics.
 * Event names are generated automatically by combining team names. The CSV importer
   is not able to assign unique event names, so you’d need to change these manually
   after import.
 * Regarding the date format, the CSV file itself has dates in the format yyyy-mm-
   dd, but some programs (like Microsoft Excel) seem to automatically change the
   way they are displayed. If you open it in a plain text editor, you’ll see the
   correct format. When using Excel or similar software, you can change the date
   format by selecting the date column, and either via the menu or right-click menu,
   applying a date format.

Viewing 1 replies (of 1 total)

The topic ‘CSV Import Issue’ is closed to new replies.

 * ![](https://ps.w.org/sportspress/assets/icon-256x256.png?rev=1252005)
 * [SportsPress - Sports Club & League Manager](https://wordpress.org/plugins/sportspress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/sportspress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/sportspress/)
 * [Active Topics](https://wordpress.org/support/plugin/sportspress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/sportspress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/sportspress/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [ThemeBoy](https://wordpress.org/support/users/themeboy/)
 * Last activity: [11 years, 10 months ago](https://wordpress.org/support/topic/csv-import-issue-1/#post-5081672)
 * Status: not resolved