Page 1 of 1
Player name query
Posted: Thu Dec 28, 2017 12:35 pm
by John Upham
Does anyone know the correct name for a payer listed as
de La Motte de Bro�ns de Vauvert, Sa�k
whose ECF grading code is 309787A from Oxford City Chess Club ?
This record in the ECF membership list is causing an import process to barf when attempting to import the ECF membership list into the various LMS systems I manage.
The record is on line 2292 of today's membership list.
Re: Player name query
Posted: Thu Dec 28, 2017 12:59 pm
by Mike Truran
He is shown as de La Motte, Saik on the OCA database.
Re: Player name query
Posted: Thu Dec 28, 2017 1:33 pm
by Matthew Carr
What is your LMS software using? ASCII or UNICODE or something else?
Re: Player name query
Posted: Thu Dec 28, 2017 2:17 pm
by John Upham
Matthew Carr wrote: ↑Thu Dec 28, 2017 1:33 pm
What is your LMS software using? ASCII or UNICODE or something else?
The back-end databases uses MySQL as their engine.
I download the Membership List, remove the first record / header and then export CSV format.
This is then imported into the MySQL db via the phpMyAdmin GUI.
The default character set (I suspect this is what you are asking) is utf-8.
Re: Player name query
Posted: Thu Dec 28, 2017 3:10 pm
by Richard Thursby
Re: Player name query
Posted: Fri Dec 29, 2017 10:56 am
by Richard James
Diaereses seem to be an issue.
I used to have a problem uploading the master database into UTU because of a player with the first name Gaël, but his name has now been changed to Gael. It looks like the bug has been partially corrected in the current version of UTU: Dr de la Motte was accepted last time I uploaded but the letters with diaereses were replaced with question marks.
I presume he's related to
this French bishop.