-->
Welcome, Guest
Username: Password: Remember me
You can also tweak your setup of Dolibarr by setting hidden configurations found in Dolibarr Setup Other

TOPIC: importing information in bulk

importing information in bulk 2 months 1 week ago #36569

  • boulbul
  • boulbul's Avatar
  • OFFLINE
  • Junior
  • Posts: 29
  • Karma: 0
Hi,

I would like to import Product data in bulk into Dolibarr 8.0.3. Every time I try to do that it comes up with an error message which says:

* Line 1
> Wrong value for field number 17 (value 'Unit price (net)' does not match regex rule ^[0|1]$)
> Wrong value for field number 18 (value 'Unit price' does not match regex rule ^[0|1]$)
> Wrong value for field number 19 (value 'Tax Rate' does not match regex rule ^[0|1]$)
> Wrong value for field number 21 (value 'For purchase' does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$)

I have used both excel and csv file but the result is the same.

I looked on the net for option with says as per one response in the forum, but could not find it.

I have attached a copy of the csv file wich has only one record for your perusal.

Thank you very much for your kind help.

Kind regards,


Nabil
The administrator has disabled public write access.

importing information in bulk 2 months 1 week ago #36570

  • eapcorreo
  • eapcorreo's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 19
  • Thank you received: 6
  • Karma: 0
Hi,
It looks like there are bad values in some columns.
Column 17,18,19 need a number, like price or tax, if you dont have it, put zero (0)
Column 21 is a flag, value 0 or 1, so if you put 1, that product is able to purchase, eather put 0.

Sorry my english, not my language.

Regards,
Eduardo.
The administrator has disabled public write access.

importing information in bulk 2 months 1 week ago #36574

  • ksar
  • ksar's Avatar
  • OFFLINE
  • Moderator
  • Posts: 235
  • Thank you received: 58
  • Karma: 10
Hi,

Could you attached a exemple file ?
The administrator has disabled public write access.

importing information in bulk 2 months 1 week ago #36576

  • torvista
  • torvista's Avatar
  • OFFLINE
  • Expert
  • Posts: 96
  • Thank you received: 21
  • Karma: 0
You should read this thread and act on my post to help your import:
https://www.dolibarr.org/forum/527-bugs-on-a-stable-version/28514-mass-import-export-8-0-3#35631
Last Edit: 2 months 1 week ago by torvista.
The administrator has disabled public write access.

importing information in bulk 2 months 3 days ago #36626

  • eapcorreo
  • eapcorreo's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 19
  • Thank you received: 6
  • Karma: 0
Hi. this file works in Dolibarr 5.x

Regards.
Last Edit: 2 months 3 days ago by eapcorreo. Reason: link
The administrator has disabled public write access.
Time to create page: 0.117 seconds