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/.