Data Import Database Issues

Using my Dolibarr
1

I am using Dolibarr 13.0.2 on a google server, from a Bitnami stack.

I have just imported my customer file using the import assistant in Third-parties and their properties.

I am however experiencing a problem – my province code of CA (California) is coming in as CAGLIARI. PA is coming up as PALERMO. It is importing TX (Texas) correctly as TEXAS.

I was wondering what I am doing wrong, or if this is a bug. I am putting this data in field 12 State/Province Code of the CSV file.

I am using a test instance of Dolibarr and would also like to know if there is a quick way to edit the incorrect information in bulk, or if I will need to purge the entire database, and start over from my backups.

2

Hi Lucian,

Please check your country and lang file settings. If it is pointing to US, then CA will resolve to California and if it is pointing to Italy, then CA will resolve to Cagliari.

image
image1127×511 13 KB

If you could resolve the problem, with this, please check the solution so that it may be useful for users searching for similar problems.

thanks,
yesbee

1 Like
3

Country is set to US/United States in Company and Organization.

The Customer is set to US/United States. Dolibarr still shows the wrong State/Province.

image

image

Thanks for your help.

LucianS