CiviCRM Community Forums (archive)

I've setup CiviCRM to run in both English (Canada) and French (Canada), with French as the default language.

When I look at the interface in FR, I see the list of countries and provinces in FR. When I look at the interface in EN, I see same in EN.

Problem being - I am looking at importing ~10,000 records from an Excel spreadsheet. Half of them have country/province in FR, the other half in EN. Trying to do the import in one shot leads to problems - it b0rks on the records that have data that doesn't match the drop down arrays exactly (eg Québec vs Quebec, or États-Unis vs United States).

I've looked on the web, manuals, and forum and I can't seem to find a solution. It's probably there, but I'm not finding.

Any pointer would be appreciated.

Thank you

P.S. Should I cross post something like this to the francophone forum, in French, as well?

Thanks lobo. Neither of them great is right, you got that right

Manually sifting through the thousands of record is going to be a pain.

As for translating the countries/province into one language, that's not acceptable from our point of view. Our French members won't be happy to see things in English, and vice versa.

Ah well, I know how I'm going to be spending my week Could be worse - I *could* be trying to run mailings from said spreadsheets directly

note that you are translating the state/province name for 'import' purposes only

Ah ha! Thank you. That's excellent to know. The detail I wasn't aware of because I don't (yet) know CiviCRM

Cheers

yes, testing always.

which leads me into my other problem with the timezone issue - every test of mailings is timeshifted by 3 hours!!! must sort this out.