Skip to Content
This question has been flagged
salesimport
4 Replies
22943 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
Suddenly the products cannot be imported anymore Solved
sales product import
Avatar
1
Jul 25
1148
Sales Import Template
sales import Accounting
Avatar
0
Feb 24
1762
Moving sales report to spreadsheet gives me wrong info
sales import spreadsheets
Avatar
0
Nov 23
1060
Import Sales Order/ Quotation having Sales Order Status - V10 Solved
sales import salesorder
Avatar
Avatar
2
Dec 22
5476
Import SO and PO procedure Solved
purchase sales import
Avatar
1
Sep 21
3456