Skip to Content
Menú
This question has been flagged
3 Respostes
251 Vistes

I have been trying to import contacts (using the template provided). Run across these errors:

The file contains blocking errors (see below)

Contacts require a name at multiple rows

BUT I don't see any errors below (or beside the field in question, as showed up when I tried a different csv), and I don't see what I need to do to address these errors. Bug or?

Help please. 

Avatar
Descartar
Autor Best Answer

Thanks all. Yes I managed to work out it is some of the empty name fields - which had not in other CRMs stopped the import. 

Avatar
Descartar
Best Answer

Hi,


You're likely encountering "Contacts require a name" errors during Odoo contact import due to a missing or incorrectly formatted "Name" field in your CSV file. Ensure the "Name" column is populated for all contacts, correctly mapped during import, and free of hidden characters or spaces. Incorrect file encoding, especially if not UTF-8, can also cause this issue.


To troubleshoot, download a fresh contact import template from Odoo to ensure correct formatting. Simplify your CSV with minimal data to isolate the problem and inspect the file in a text editor for hidden characters or encoding issues. During import, carefully map CSV columns to Odoo fields, paying close attention to the "Name" field. If the problem persists, it could be a bug in your Odoo version, so check for updates or consult Odoo forums and support.


Please try to look at the following:

* https://www.cybrosys.com/blog/how-to-import-customers-and-vendors-in-odoo-17

* https://www.odoo.com/documentation/19.0/applications/essentials/export_import_data.html

* https://www.odoo.com/sl_SI/slides/slide/exporting-and-importing-data-609


Hope it helps

Avatar
Descartar
Best Answer

there are some input fields that are required, if they are not showing on the CSV, then they won-t show in red.
One of those is the name of the contact.

I'd suggest doing the following. 
send a screen of the CSV you are using so we see the fields you are filling. 
and a screen of the error so we can better guide you =)

using the template is a good idea, but sometimes, you make some mistakes like missing a required field or leaving something blank where it shouldnt. 

What i tend to do is, Create a full Contact with fake info, but fill in everything in the contact form. 
then, click it on contact lists, and go to actions -> export. and make sure to click on "I'll use it later" option so i get all the info i need when i decide to import it. 
after this, try to match all the fields from this file with the information you wnat to import. 

be ready and expect to have several errors the first times... its normal. 

for example, if you try to import companies and contacts from said company at the same time, you tend to create problems when importing. 

Avatar
Descartar
Related Posts Respostes Vistes Activitat
1
d’oct. 25
345
2
d’oct. 25
565
1
de maig 25
2120
1
de març 25
2122
1
de febr. 25
9126