Skip to Content
This question has been flagged
salesimport
4 Replies
20851 Views
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
Discard
Avatar
Jérémy Kersten (jke)
Best Answer

Field name is required...

At first view, you have Empty line...

Avatar
Discard
Avatar
Alex
Author 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
Discard
Jérémy Kersten (jke)

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

Related Posts Replies Views Activity
Sales Import Template
sales import Accounting
Avatar
0
Feb 24
320
Moving sales report to spreadsheet gives me wrong info
sales import spreadsheets
Avatar
0
Nov 23
313
Import Sales Order/ Quotation having Sales Order Status - V10 Solved
sales import salesorder
Avatar
Avatar
2
Dec 22
4491
Import SO and PO procedure Solved
purchase sales import
Avatar
1
Sep 21
1885
I can't close TPV sessions in POS at the end of the day
sales
Avatar
Avatar
1
Dec 24
31