Problem product import

Using my Dolibarr
1

Hello everyone,

I’m trying to import a database of products in the CRM, but i’m stucked with “the adding date”. I made you a screenshot of the problem.

After the importation, Dolibarr says "Wrong value for the field N°16. (the value “2013/03/10” doesn’t respect the rule YYYY-MM-DD).

But the thing is, i wrote the date like it should be in excel (2013-03-10), but when i save the file in .CSV, the date
switch to 2013/03/10 for no reason…

Si if you have any idea how can I force Excel to accept my date the way dolibarr want it, please answer, i’m stucked because of this insignificant stuff :happy:

Thanks for your answers!

2

Hi,
Normally, selecting the column in excel, then right click, ‘Format Cells’, and choose ‘date’ with the right ‘YYYY-MM-DD’ format example should do the trick.

Anyway, you will probably face up other problems, as MS-Excel often want to be smart in your place for this kind of operation (choosing the separator, the escape char, the collating sequence character…), In my experience, using OpenOffice, LibreOffice or even google spreadsheet in google docs is much more convenient for this kind of task.

3

The thing is, the “format cells” is the right… I’ll try with spreadsheet, why not.

4

I think excel changes things at save time. I always use LibreOffice.

5

LibreOffice is the best choice for importing in CVS, I have always had problems with excel importing its CVS into it so Yes I use LibreOffice also for that task

6

Hi,

I just format the cells into text and type the date according to dolibarr’s requirement, e.g. 2017-11-07
That is my way of solving it.

7

It’s better if you use csv file format