-->
Welcome, Guest
Username: Password: Remember me
Check that your potential issue isn't already confirmed and fixed in the recent releases. A summary of all changes can be found in the Dolibarr Changelogs

TOPIC: Bad Import of State Field

Bad Import of State Field 3 months 2 weeks ago #37435

  • Glasair
  • Glasair's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 1
  • Karma: 0
On Version 9.0.3 I have imported via XLS (spreadsheet) for both Third Party as well as Contacts and in both instances instead of importing the state of "CA" California it imports it as "CAGLIARI". In all cases it dies see the "US" entry and accepts and import the "United States" as country.

I have attached an copy of my import files for both.

In addition the "State" field is not available as a column in the full List view. How can that be added for sort purposes
The administrator has disabled public write access.

Bad Import of State Field 3 months 2 weeks ago #37437

  • torvista
  • torvista's Avatar
  • OFFLINE
  • Expert
  • Posts: 106
  • Thank you received: 25
  • Karma: 2
You need to know the id/ref (unique in the table) of the state to import it correctly. Importing it using the abbreviation just matches it to the first one, as you have seen.
www.dolibarr.org/forum/12-howto-help/278...untry-state-province

I worked on this, and my changes got into the development version,:
github.com/Dolibarr/dolibarr/pull/10261

Since then I have not been working on Dolibarr so I don't know which version of Dolibarr will have those changes (9, 10, 11?).
The administrator has disabled public write access.
Time to create page: 0.055 seconds