Exported csv not importing into new install

Using my Dolibarr
1

I am moving to a new url and simply trying to export customers from old dolibarr and import into new dolibarr. When i try to import to the new one I cannot due to this:

* Line 1
> Wrong value for field number 1 (value ‘Contact Id’ is not a Third party existing ref)
> Wrong value for field number 8 (value ‘Private’ is not a value available into field code of table Countries)
> Wrong value for field number 9 (value ‘Address’ does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$)
> Wrong value for field number 18 (value ‘E-mail’ does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9]0-9?$)
* Line 2
> Wrong value for field number 9 (value ‘1705 Edgewater Drive Box 540212’ does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$)
> Wrong value for field number 18 (value ‘nick@melodicrevolution.com’ does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9]0-9?$)
* Line 3
> Wrong value for field number 9 (value ‘5241 N Osceola Ave’ does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$)
> Wrong value for field number 18 (value ‘mark@progrock.com’ does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9]0-9?$)
* Line 4
> Wrong value for field number 9 (value ‘3238 Sturbridge Ln.’ does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$)
> Wrong value for field number 18 (value ‘stan.cocheo@gmail.com’ does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9]0-9?$)
* Line 5
> Wrong value for field number 9 (value ‘2505 West 2nd Avenue Suite 5’ does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$)
> Wrong value for field number 18 (value ‘jeffgrundmann@gmail.com’ does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9]0-9?$)
* Line 6
> Wrong value for field number 9 (value ‘112 Airport Rd. #339’ does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$)
> Wrong value for field number 18 (value ‘rosfest@gmail.com’ does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9]0-9?$)
* Line 7
> Wrong value for field number 9 (value ‘18450 Carlwyn dr’ does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$)
> Wrong value for field number 18 (value ‘Beckyavelar@aol.com’ does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9]0-9?$)
* Line 8
> Wrong value for field number 9 (value ‘18863 Moro Circle’ does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$)
> Wrong value for field number 18 (value ‘cali.jellyroll@gmail.com’ does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9]0-9?$)
* Line 9
> Wrong value for field number 9 (value ‘186 Willamette Dr.’ does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$)
> Wrong value for field number 18 (value ‘songman42@aol.com’ does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9]0-9?$)
* Line 10
> Wrong value for field number 18 (value ‘greggolson@roadrunner.com’ does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9]0-9?$)

2

I give up, It makes no sense that if I export from dolibarr and try to import back into dolibarr that all the fields are not available and it never frigging works.
It should be very simple - export from dolibarr to csv - import to dolibarr from csv without having to jump through hoops and walk through fire. There is no format change in the process, I export all fields and then try to import back in, I should not have to rearrange fields AT ALL…

3

Hi kingblake,
Firstly if you are just changing the location (URL) of your Dolibarr why are using export/import option? It is easier and quicker to just move all folder to the new location. Secondly have you had a look at https://wiki.dolibarr.org/index.php/Importing_customers_automatically?
You have probably selected to export Field 1 (Id) but in the import file 1st column should contain Company Name and not the ID column and probably that is why you have a problem.
Regards

4

I tried moving the whole folder, database etc. It did not work, always failed.

5

what was the error message? Did you have a look at conf.php file to see if there are some links that need to be edited?