new row for relation "res_partner" violates check constraint

sales import

4 Svar

24896 Vyer

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

Jérémy Kersten (jke)

Bästa svar

Field name is required...

At first view, you have Empty line...

Alex

Författare

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...

Jérémy Kersten (jke)

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

Njuter du av diskussionen? Läs inte bara, delta också!

Skapa ett konto idag för att ta del av exklusiva funktioner och engagera dig i vår fantastiska community!

Registrera dig

Relaterade inlägg	Svar	Vyer
Suddenly the products cannot be imported anymore Löst sales product import	1 juli 25	2457
Sales Import Template sales import Accounting	0 feb. 24	3162
Moving sales report to spreadsheet gives me wrong info sales import spreadsheets	0 nov. 23	2143
Import Sales Order/ Quotation having Sales Order Status - V10 Löst sales import salesorder	2 dec. 22	6638
Import SO and PO procedure Löst purchase sales import	1 sep. 21	5100

Denna fråga har flaggats

Njuter du av diskussionen? Läs inte bara, delta också!