Loading a reformatted csv database

[Fearghal O'Boyle]

Hi,
My database shows all the players in capital letters. To fix this I thought I would save the file in csv format and open it in excel and reformat the first name and surname field. This worked perfectly but now I have trouble reloading the reformatted csv file. Any ideas?

[ianmac]

I suspect that excel has changed the format.
It is better to work with a text editor where you have control over format.
Note that the next SP will offer an option to show names in capitalized format like "Brown"

[Fearghal O'Boyle]

Great news but will it fix my existing database?

[ianmac]

No.
Go back to a save or correct the format of the csv file.
Send a copy of the csv file to support (support@asecomputing.com) if you need some help with that.

[ianmac]

Fearghal,
the problem with the csv file is its missing a comma at the end of many lines and these are ignored.

Have a look at the file with an editor (eg textpad) and note the last thing in a line is the date not followed by a comma in many cases. Put commas there and it will work.

Ian