Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
salesimport
4 Odgovori
23396 Prikazi
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
Opusti
Avatar
Jérémy Kersten (jke)
Best Answer

Field name is required...

At first view, you have Empty line...

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

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

Related Posts Odgovori Prikazi Aktivnost
Suddenly the products cannot be imported anymore Solved
sales product import
Avatar
1
jul. 25
1446
Sales Import Template
sales import Accounting
Avatar
0
feb. 24
2155
Moving sales report to spreadsheet gives me wrong info
sales import spreadsheets
Avatar
0
nov. 23
1397
Import Sales Order/ Quotation having Sales Order Status - V10 Solved
sales import salesorder
Avatar
Avatar
2
dec. 22
5784
Import SO and PO procedure Solved
purchase sales import
Avatar
1
sep. 21
3855