Does not import some fields

[ferradeira]

When doing an import from a CSV, there are some fields it does not import, have no error and no message. Just does not import. How can I investigate it?

[victor]

Please provide more details (screenshots of an example import file with multiple records). If the import fails, at least in the latest version of EspoCRM the reasons are logged.

[ferradeira]

In this example I'm trying to import, update only, Quantity from the CSV to SQM, nothing happens and no errors, as you can see in the attachments.

[ThomasB]

Well, from the screenshot (import1.png) it looks like the quantity fields are empty in the CSV file. In Import4.png I can not see the collum names.

[ferradeira]

at least it should have imported one cell with quantity 9 in line 20. See attached import5.png

[ThomasB]

Best to provide more data. Which version of EspoCRM are you using. The field SQM. What field type is that? Is your CSV File in UTF-8 Mode?

You could also enable more logging: https://docs.espocrm.com/administration/log/

[ferradeira]

Version 10.0.2. CSV File is in UTF-8 Mode. SQL is an integer.

[ferradeira]

There is no log for today. I updated to version 10.0.2 today. Do you think that has anything to do with it? Because I was able to import the other fields from the same CSV file yesterday.
But now I cannot do an import update only.

[victor]

Please provide more details an example import file with some records. Replace sensitive data in it first.

[ferradeira]

Attached

[victor]

Your file does not specify a "name" for each record.
For the test, I specified the Account column for "name" and everything imported without problems.

[ferradeira]

Sorry, what do you mean by "your file does not specify a name for each record"?
I was able to import Account column, Event, Exhibition Code, Hall, Booth but for example was not able to import FullName, FullMobile, Email, Quantity.
I still don't understand why.

[victor]

No records in your import file have a "name" field.

[ferradeira]

I change Account for name (see attached) but still did not work. I did an update only for the import. Should I use Create and update?

[victor]

In your file, I changed the Account column to Name. The following steps are sequentially shown in the screenshots:

[ferradeira]

Ok, I was able to import Account (Name) but was not able to import email and some other columns. Should I change the name of the other columns too?

[victor]

In my third screenshot, the system automatically recognized the "Name" column from the import file as the "name" field. The rest of the fields need to be assigned manually. I advise you to read the documentation: https://docs.espocrm.com/administration/import/.

[ferradeira]

I still cannot import some fields. In this example I was not able to import Contact Name, Contact Phone and Contact email. From the CSV file TESTE2.csv.
Please see the attached files.
Thanks

[victor]

1. Firstly import Opportunity1 without related data from Contact entity.
2. Then import Contact1 separately, in a separate import file, where opposite one of the columns will be indicated the ID of your Opportunity1, which you imported in the previous point.

In this way, you import Contacts and Opportunities separately, which will be interconnected with the help of these two steps. And just importing Opportunity1 and immediately Contact1, you will not be able to immediately relate them together.

[ferradeira]

The point is, contact name in the CSV file is not equal to the contact name in the Contacts Entity, that's why I can not import it.