Import problems

[daniil.gorenko]

Hello Yuri. Im using espo for 8-9 months.CRM v.3.3.0

I have already over 100k of leads uploaded and created in my espo crm. Every month I import up to 10k leads and my managers call that leads.
Problem that firstly I have been allowed to import 5000 leads, later 1500, later 700, now I can't upload even 200. Host provider says that is CRM problem.
Every times it's stops now at 200 maximum.

[yuri]

Hi

What error do you get when 200 is exceeded?

[yuri]

We added duplicate checking and also ability to revert import. That has increased an addressing to database essentially. Maybe timeout gets exceeded in your case. If a format of your import files is consistent I'd recommend your to run import in COMMAND LINE INTERFACE to avoid a timeout issue. You can write simple php script and call Import service with needed parameters.

[daniil.gorenko]

Hi

What error do you get when 200 is exceeded?

Error 500 in ajax message box

Ok, I'll try and write later here.

[fingerprn]

Has anything been figured out here? I'm having the same problem. At first I was getting an Error 500, but later started getting an Error 404. Each time the number of leads I can import gets smaller. I increased MySQL timeout settings but it had no effect. My guess is that it's the duplicate checker bogging down the system. Any way to make that optional when importing?

[yuri]

MySQL timeout won't help. Try max_execution_time in php.ini

[fingerprn]

max_execution_time was already set to 300. That should be more than enough.

By breaking my list into parts I was able to import everything, so I'm fine for now. Just wanted you to know what was going on so you can help others.