Announcement

Collapse
No announcement yet.

Import problems

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Import problems

    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.

  • #2
    Hi

    What error do you get when 200 is exceeded?

    Comment


    • #3
      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.

      Comment


      • #4
        Originally posted by yurikuzn View Post
        Hi

        What error do you get when 200 is exceeded?
        Error 500 in ajax message box

        Ok, I'll try and write later here.

        Comment


        • #5
          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?

          Comment


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

            Comment


            • #7
              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.
              Last edited by fingerprn; 11-09-2015, 03:54 PM.

              Comment

              Working...
              X