Hi
I am sorry, for obvious reasons I cannot share the actual CSV, at best I can show a bogus line of it.
Example_of_import_file_societe_BOGUS.csv.txt (677 Bytes)
As CSV export filter I used ; as field separator, " as string delimiter, unicode UTF-8
The CSV itself seems to be not the major problem, the problem for me was much the scarcity of information on how to create the CSV, I had to empirically find out/guess many things. Would be nice to have an updated detailed guide on how to create a proper CSV file and then what to do exactly do in order to have the columns filled properly where one does not have real data.
E.g., afterwards watching the DB , I noticed that all the NULL values are wrong as inserted as actual text data and not as actual NULL as Mysql want to see it, that meanwhile leaving the cells empty did not work, the importer required in many columns that some data is present.
I have seen that observing the NULL that creates Dolibarr using the front end forms, those are actual NULL, while the NULL imported from CSV are alike text data.
Therefore, how to have real NULL in the DB after import?
In order to not have errors I had to work quite some on the sample CSV given by Dolibarr, I do not remember now all the adjustments I had to do on the file, but in general it was a matter of reading the kind of errors given by Dolibarr after the “import simulation” operation and fill the columns indicated each time with proper data or leave it empty.
Finally also I had to avoid to import an amount of columns leaving Dolibarr filling it automatically, that is done by moving the fields in the the “no import” area in the bottom and put the “do not import” tag in the corresponding field in the upper part of the form.
It is quite tricky to import data, however I reached to import without errors the third parties, products and supplier prices.
When importing the products I had to take care to use the dot instead of the comma for the prices, all numbers as far as I could see should be set as text to be recognized.
So far I was quite happy that the importer declared that there were no errors and then to effectively verify that everything seems to work fine enough except this latest 15 third parties modified not being updated.
I wish the mass importer would be refined in Dolibarr, is extremely important to allow easy migration from other ERPs (and therefore to help the diffusion of Dolibarr), as it is done now is hard for non experts as me (and in my opinion very hard for end users).
The alternative to import data with other ways is even harder and tricky for non experts (eg. using phpmyadimn or using the MySQL query), a good knowledge about databases in general and of the Dolibarr database is necessary.
It is sort of odd to have that function stuck showing the same third parties all the times despite inserting new entries and updating existing ones, even tough the system seems to work for all other operations that I did try so far (eg. emitting quoting) the system in this way looks buggy at first glance and there is the fear that because of that mangle other things might not work well later on.
Does anyone know where to look in the DB or elsewhere and what to fix in order to have the latest third parties modified view working?
Thank you
Kind regards