Import List Not Working and No Errors Created

[mmandell]

When I try to upload a list, I am able to map fields, and then upload.
The process reports that it is complete but 0 records are created and no errors appear.

How can I diagnose the error?

[tanya]

Hello
Check espocrm logs, please

[mmandell]

There are no errors in the logs, I see entries but all have 200 success codes, no errors at all.

[mmandell]

I tried to import only company field and nothing else and it didn't work.

Here's what I've tested:
- Contacts
- Leads
- Accounts

- Create Only
- Create & Update

- Mapping All Fields
- Mapping Only 1 Field

Nothing is working. The file is read and I can see the test rows on the first page of the import with no issues.

Is there a sample download file that might have different encoding I should copy the data into?
I am starting with an XLS file and then saving as CSV.

Thanks for your help.

M

[tanya]

Could you attach the file (you can crypt important field)? Also, is it possible you have duplicates in ids?

[mmandell]

Here is a file with a sample of 5 rows.

[tanya]

Not found. Is it full link?

[mmandell]

The link was truncated. Try this pasted as text.

https://fs03n3.sendspace.com/dl/dc4b4ca56af8afddfa0a49b936e195c0/597b0fca097bae84/kjfncw/Test%20Import.csv

By enabling Cron checkbox I was able to get 3 columns to import, but when I map all the fields it doesn't work.

Are there fields where if I map First Name / Last Name I cannot map Account Name for example?
Perhaps this is a conflict with something like that?

[tanya]

In your csv file line breaks with "\r" symbol, needs to be "\n"

[mmandell]

I was able to import some fields, but now all.

Are there fields where if I map First Name / Last Name I cannot map Account Name for example?
Perhaps this is a conflict with something like that?

[tanya]

Still think the problem is with csv file (for ex. line breaking).
Try to replace

$contents = str_replace("\r\n", "\n", $contents);

with

 $contents = str_replace(["\r\n", "\r"], "\n", $contents);

at 363 (+-) line application/Espo/Services/Import.php

[mmandell]

I opened the csv file in text editor and I don't see the \n.
How can I run these commands on the file?

Thank you for your help on solving this!

[tanya]

line breaking symbols:

\n is used for Unix systems (including Linux, and OSX).

\r\n is mainly used on Windows.

\r is used on really old Macs.

In text redactor you can see only new line. With Find option you can check, if any symbol is included.

Did you modify the file Import.php?

[mmandell]

We never touched the import.php file.
How can we test and see how to fix it?

[mmandell]

I just edited the import.php file and got the same results.
One of the imports worked for a few fields but would not work for all fields.

What do you recommend?

[tanya]

Validate your csv file
check the log
separate data to recognize the problem reason