Skip to Content
This question has been flagged
salesimport
4 Respostes
22701 Vistes
Avatar
Alex

Hello!

I'm trying to import my customer list to the Sales app inside Odoo, but getting some errors. I've verified that the file is valid as I was able to import it to the newsletter app. I tried to export the list from the newsletter app and import that to the sales module, but still the same errors.

Here is a screenshot: https://cl.ly/3B0X0E0z151Y

And the errors:

new row for relation "res_partner" violates check constraint "res_partner_check_name" DETAIL: Failing row contains (18102, null, 1, null, null, 2016-12-03 22:52:04.563735, 0, person, null, null, null, null, null, null, null, null, f, null, email@email.com, f, null, t, null, null, null, f, null, 2016-12-03 22:52:04.563735, t, Europe/Oslo, 1, en_US, 1, null, null, contact, f, null, null, null, null, null, always, null, f, null, null, null, null, null, null, null). at row 2

Avatar
Descartar
Avatar
Jérémy Kersten (jke)
Best Answer

Field name is required...

At first view, you have Empty line...

Avatar
Descartar
Avatar
Alex
Autor Best Answer

Ok, so the name field can't be empty? But on some on the contacts I only have the email, but intend to collect the name later...

Avatar
Descartar
Jérémy Kersten (jke)

Yes, name cannot be empty !Add a default value / placeholder (eg: 'unknow' or the email)

Related Posts Respostes Vistes Activitat
Suddenly the products cannot be imported anymore Solved
sales product import
Avatar
1
de jul. 25
902
Sales Import Template
sales import Accounting
Avatar
0
de febr. 24
1592
Moving sales report to spreadsheet gives me wrong info
sales import spreadsheets
Avatar
0
de nov. 23
936
Import Sales Order/ Quotation having Sales Order Status - V10 Solved
sales import salesorder
Avatar
Avatar
2
de des. 22
5338
Import SO and PO procedure Solved
purchase sales import
Avatar
1
de set. 21
3198