s/United States/USA

[Claster]

Hi,

When I imported a csv file from cubecomp.de to cubecomps.com, it showed be an error 'Unknown country "United States".' When I modified csv, replacing it with "USA", it worked. So I believe that when exporting, this country should be "USA".

[fw42]

I'm using the country names from the WCA database, which also uses "United States" (not "USA"), so I think this is a bug in cubecomps.com, not a bug in cubecomp.de?

[Claster]

Sorry, this thread slipped out of my mind, but now my organizer used cubecomp.de for registrations once more, and I hit this bug again.

When you download the WCA database export, you will see that competitors from US have the country "USA", not "United States". https://www.worldcubeassociation.org/results/misc/export.html

@SAuroux, could you please confirm which string is expected for US competitors?

[SAuroux]

I think I see the problem here: cubecomp.de uses the country's "name" instead of the country's "id".

This is the same for most countries, but not for all:

SELECT * FROM Countries where id <> name

@fw42 so, instead of using the "name" column from the Countries table in the WCA database, you should be using the "id" column.