Passa al contenuto
È necessario essere registrati per interagire con la community.
Tutti gli articoli Persone Badge
Etichette (Mostra tutto)
odoo accounting v14 pos v15
Sul forum
La domanda è stata contrassegnata
uploadimportingerrors
3 Risposte
4816 Visualizzazioni
Avatar
Adam Noll

Odoo Community Version 11 


Hi Odoo Community! I am attempting to import a product data set (in CSV and Excel formatting) and I am receiving an error in the name column it looks like. Our developers recommended us to 'Encode' the files as Unicode (UTF-8) (accessed through Save As>Tools>Web Options>Encoding) then saving the document as Unicode (UTF-8). This is the error I am receiving: 


  • null value in column "name" violates not-null constraint DETAIL: Failing row contains (140215, null, null, 62825LF-GL, 1, 0, 1176.00, 1, 3, null, null, null, 255232, 15, 6, 2020-03-25 16:45:41.924174, 6, 2020-03-25 16:45:41.924174, 0.00, 0). at row 2
  • null value in column "name" violates not-null constraint DETAIL: Failing row contains (140216, null, null, 62825LF-PC, 1, 0, 811.00, 1, 3, null, null, null, 255233, 15, 6, 2020-03-25 16:45:41.924174, 6, 2020-03-25 16:45:41.924174, 0.00, 0). at row 3

Is this related to how our Version 11 is setup or am I not uploading the data set in the correct way?

Adam

Avatar
Abbandona
Avatar
Ashish Singh
Risposta migliore

Hi, Adam


Seems like "name" column is not present in your CSV or there is false value for "name" column due to this you are getting "null column" issue. So please check and update these values as "name" field is required for the product.

In case you still have the same issue then please share your CSV in order to check this issue.


Thanks,
Ashish Singh (Team Lead)
Webkul Software Private Limited
Avatar
Abbandona
Avatar
Adam Noll
Autore Risposta migliore

Ashish Singh - I can share the file but unfortunately I don't have enough 'coins' if you will to do so. I need to gain Karma to comment or share anything with you. I can certainly email you directly the file in CVS format? My direct email below. 

I can certainly try that Mustufa Rangwala but I have over 1,000 and I still find trouble exporting data and re-uploading the data set back in troubling. 

anoll@mingleteam.com

Avatar
Abbandona
Avatar
Mustufa Rangwala
Risposta migliore

Hello,

It is not issue of Odoo 11 setup but format of your excel file.

You may try to first export from product and try to use same csv/excel to import - may be it can help.

Regards,

Mustufa Rangwala

Avatar
Abbandona
Post correlati Risposte Visualizzazioni Attività
V17 .sh import excel file: time data '2025-01-31' does not match format '%m.%d.%Y'
importing
Avatar
Avatar
Avatar
3
lug 25
3367
Odoo journal entry modification after posting by import
importing
Avatar
Avatar
1
apr 25
2516
Import mehrerer Artikel mit Varianten
importing
Avatar
0
ott 24
1953
Importing Excel/CSV using custom unique field instead of XML ID
importing
Avatar
Avatar
Avatar
2
mag 24
5128
Product export then import duplicates everything
importing
Avatar
0
apr 24
1975