-->
Welcome, Guest
Username: Password: Remember me

TOPIC: Exported csv not importing into new install

Exported csv not importing into new install 5 months 2 weeks ago #33441

  • kingblake
  • kingblake's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 3
  • Karma: 0
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]( [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 'This email address is being protected from spambots. You need JavaScript enabled to view it. ' does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[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 'This email address is being protected from spambots. You need JavaScript enabled to view it. ' does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[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 'This email address is being protected from spambots. You need JavaScript enabled to view it. ' does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[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 'This email address is being protected from spambots. You need JavaScript enabled to view it. ' does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[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 'This email address is being protected from spambots. You need JavaScript enabled to view it. ' does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[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 'This email address is being protected from spambots. You need JavaScript enabled to view it. ' does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[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 'This email address is being protected from spambots. You need JavaScript enabled to view it. ' does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[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 'This email address is being protected from spambots. You need JavaScript enabled to view it. ' does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[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 'This email address is being protected from spambots. You need JavaScript enabled to view it. ' does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]( [0-9][0-9]:[0-9][0-9]:[0-9][0-9])?$)
The administrator has disabled public write access.

Exported csv not importing into new install 5 months 2 weeks ago #33446

  • kingblake
  • kingblake's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 3
  • Karma: 0
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..........
The administrator has disabled public write access.

Exported csv not importing into new install 5 months 2 weeks ago #33447

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
The administrator has disabled public write access.

Exported csv not importing into new install 5 months 2 weeks ago #33450

  • kingblake
  • kingblake's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 3
  • Karma: 0
I tried moving the whole folder, database etc. It did not work, always failed.
The administrator has disabled public write access.

Exported csv not importing into new install 5 months 2 weeks ago #33451

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?
The administrator has disabled public write access.
Time to create page: 0.067 seconds