Importing CSV

Hi @hockeyrivenord,

We’re working on a bit of documentation around this, but here is an outline of how to use the csv importer:

1. Download the sample CSV file via Tools > Import > SportsPress Events (CSV) > “Click here to download a sample.”

2. Open the CSV file in your favorite spreadsheet program. We recommend Google Drive because it ensures proper line endings and encoding.

3. If you’re not using the default soccer preset, change the column names after the “Player” column to reflect the performance values used on your site. To find a list of performance values, go to SportsPress > Settings > Configure > Performance.

4. The date field can be tricky. SportsPress requires the date format:

yyyy/mm/dd

You can change the date format in most spreadsheet programs including Excel and Google Drive.

5. Save (as UTF-8) and upload.

I hope this helps! I’ll let you know when the official documentation becomes available.

Hi,

I have some pb too with importing events.

L Stephan

So i followed the procedure to import events from Google Drive but only one event is imported instead of the 2 events in spreadsheet…

If someone succeeded in importing events?

Thanks a lot

Hi @lstephan,

I’d like to have a look at the imported file. Could you open the CSV file (using notepad or similar) and paste it in below?

Hi,

Here my csv file open from notepad (fromm google drive):

2015-12-10,,Stade Francis Le Blé,Stade Brestois 29
,,,combrit
2015-12-10,,Stade Francis Le Blé,Stade Brestois 29
,,,quimper

Thanks a lot.

Hi again!

Just wondering, does the csv file have a header row, or is it just those 2 rows?

If it’s just the 2 rows, you’ll need to insert a header row (since the first row gets discarded during import). The header row should be something like this:

Date,Time,Venue,Teams,Results,Outcome,Players,Goals,Assists,Yellow Cards,Red Cards

Let me know if this was the issue.

Oh thanks i will try with first row.

Regards
L Stephan