Exporting data as CSV and opening them in Excel
November 14th, 2009
The CSV files generated by LeagueManager and ProjectManager are truly tab delimited files and directly opening them in Excel will likely cause problems. First the file needs to be saved to the harddisk and afterwards imported into Excel. For details see attached short documentation, which describes every step for ProjectManager. It also applies to LeagueManager. OpenOffice automatically opens an import dialog where you can choose the delimiter.
I have been playing with your Leaguemanager plugin and have it working but have run into some problems importing data. I wanted to import the results from the last few seasons so I set up a couple of matches and exported it to see what the data format looked like.
LeagueManager will not import the data it exports. When importing tab delimited data two errors will be issued for each line in the file. The good thing is the data seems to import correctly.
I also ran into an issue importing teams before I had defined a season so now it appears I have 100’s of team in my database but I can’t see them.
This is the error I see when importing data. The same error repeats for each line in the import file. You can replicate this by trying to import a LM Export file.
Warning: Missing argument 10 for LeagueManagerAdminPanel::addMatch(), called in [path hidden]/wp-content/plugins/leaguemanager/admin/admin.php on line 1320 and defined in [path hidden]/wp-content/plugins/leaguemanager/admin/admin.php on line 823
Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in [path hidden]/wp-includes/wp-db.php on line 450
I am having the same problems. There are no instructions on importing a csv, specifically on how to format the file prior to importing it. Any help would be appreciated.