CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • Country/Province (State) drop downs in two languages?
Pages: [1]

Author Topic: Country/Province (State) drop downs in two languages?  (Read 970 times)

vavroom

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 4
    • Part of a Whole
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress
  • MySQL version: 5.6.11
  • PHP version: 5.5.3
Country/Province (State) drop downs in two languages?
October 14, 2013, 04:38:33 pm
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?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Country/Province (State) drop downs in two languages?
October 15, 2013, 06:26:16 am

2 possible solutions. neither of them great :(

a. split the file up into french and english and do the import that way

b. use excel to translate all country / province names to your language of choice

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

vavroom

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 4
    • Part of a Whole
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress
  • MySQL version: 5.6.11
  • PHP version: 5.5.3
Re: Country/Province (State) drop downs in two languages?
October 15, 2013, 06:30:57 am
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 :D

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Country/Province (State) drop downs in two languages?
October 15, 2013, 06:35:18 am

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

when u spit out the mailing label / use that data, it should show the right context (since they are FK's to other table which get translated on the fly)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

vavroom

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 4
    • Part of a Whole
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress
  • MySQL version: 5.6.11
  • PHP version: 5.5.3
Re: Country/Province (State) drop downs in two languages?
October 15, 2013, 06:38:12 am
Quote from: Donald Lobo on October 15, 2013, 06:35:18 am

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

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Country/Province (State) drop downs in two languages?
October 15, 2013, 06:40:40 am

please do test the theory out with a small import :)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

vavroom

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 4
    • Part of a Whole
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress
  • MySQL version: 5.6.11
  • PHP version: 5.5.3
Re: Country/Province (State) drop downs in two languages?
October 15, 2013, 06:41:53 am
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.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • Country/Province (State) drop downs in two languages?

This forum was archived on 2017-11-26.