Importing a cvs file

[timarebel]

hello

I have a question what is the limits of raw can espocrm import?

thank you in advance

[item]

Hi,
if i understand the question, it's not espoCrm dependant..
it's config/server and so.

For big file, always use back-end .. front-end have many limitation (web server and so... no espoCrm)

Edit : ha sorry, you ask import.. i don't know.. but if big file, is better you create some in back-end

[Kyle]

I have found that there is a significant decrease in performance with larger files. I have been able to import 100,000 records quite quickly but 200,000 takes a very long time. Much quicker to do it in batches.

[timarebel]

item how can i do it from the back-end ?
to be more clear, I have an excel table with 5000recordes, when I try to import it to Espocrm I only get 100 which is not normal that why I asked what is the maximum of records I can import !

Kyle I only have 5000 and I cannot import it at all only 100 at the time which is not functional

[item]

Hello,
strange your import stuck at 100 ...
and 5000 record is not a problem for espocrm.
or maybe you files are not good encoded..
you need give more info about your environment. (php/espoCrm.. Version and so)

[timarebel]

Hello;

I have changed everything to the recommended 180
I have the latest version of Espocrm 7.0.8
It's a simple table with based info 5000raw and 9column it went from Excel to CVS
I didn't notice at first this problem until yesterday, so I cannot ask my client for a new contact table

[Kyle]

Could the job stopping be related to this issue: https://github.com/espocrm/espocrm/issues/2133

[timarebel]

hello

it's is but i don't know how to pass over it

[timarebel]

I tried with the backend code but nothing !! i even check the whole record and made them correct and still stops at 100. does anybody have a solution

[esforim]

Two relevant thread I would recommend to try if you have not:

https://forum.espocrm.com/forum/general/61868-uploading-large-files

https://forum.espocrm.com/forum/installation-and-upgrade-help/57881-trouble-importing-data#post58119

Taken from: https://github.com/o-data/EspoCRM-Le...nd-Design/wiki