# Problem importing 1mil of leads

**URL:** <https://forum.mautic.org/t/problem-importing-1mil-of-leads/2250>\
**Category:** Product Support\
**Created:** [August 27, 2015, 3:10pm UTC](https://forum.mautic.org/t/problem-importing-1mil-of-leads/2250 "2015-08-27T15:10:57Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![igor.sovcik](https://avatars.discourse-cdn.com/v4/letter/i/4bbf92/32.png) [@igor.sovcik](https://forum.mautic.org/u/igor.sovcik)\
**Post date:** [August 27, 2015, 3:10pm UTC](https://forum.mautic.org/t/problem-importing-1mil-of-leads/2250/1 "2015-08-27T15:10:57Z")

</div>

Hi, im having a problem with importing leads. I need to import aproximatelly 1 000 000 leads, the file is about 200Mb. How can i manage that? Mautic is just telling me that it is to big file.

---

<div class="post-metadata">

**Author:** ![igor.sovcik](https://avatars.discourse-cdn.com/v4/letter/i/4bbf92/32.png) [@igor.sovcik](https://forum.mautic.org/u/igor.sovcik)\
**Post date:** [August 27, 2015, 3:10pm UTC](https://forum.mautic.org/t/problem-importing-1mil-of-leads/2250/2 "2015-08-27T15:10:57Z")

</div>

Hi, im having a problem with importing leads. I need to import aproximatelly 1 000 000 leads, the file is about 200Mb. How can i manage that? Mautic is just telling me that it is to big file.

---

<div class="post-metadata">

**Author:** ![chad.windnagle](https://avatars.discourse-cdn.com/v4/letter/c/7feea3/32.png) [@chad.windnagle](https://forum.mautic.org/u/chad.windnagle)\
**Post date:** [August 27, 2015, 3:23pm UTC](https://forum.mautic.org/t/problem-importing-1mil-of-leads/2250/3 "2015-08-27T15:23:29Z")

</div>

That is a lot of leads!

The biggest issue you’re going to have is the file size and file upload limits on your server. Hopefully you’re running some serious hardware for your servers.

You’ll need to change php’s file upload limits (php.ini) and Mautic’s upload limits (mautic \> configuration \> upload limits).

I would recommend that you split your file into at least 4 - 6 files. That should get each file size down to roughly 50mb - 30mb, figure out the largest file size your servers can manage and let 'er rip.

---

<div class="post-metadata">

**Author:** ![chad.windnagle](https://avatars.discourse-cdn.com/v4/letter/c/7feea3/32.png) [@chad.windnagle](https://forum.mautic.org/u/chad.windnagle)\
**Post date:** [August 27, 2015, 3:24pm UTC](https://forum.mautic.org/t/problem-importing-1mil-of-leads/2250/4 "2015-08-27T15:24:10Z")

</div>

PS; the only other solution is to do something like an php script which reads the file and uses the mautic api to load each row in and create the leads. but you’ll have to be into programming to do that.

---

<div class="post-metadata">

**Author:** ![igor.sovcik](https://avatars.discourse-cdn.com/v4/letter/i/4bbf92/32.png) [@igor.sovcik](https://forum.mautic.org/u/igor.sovcik)\
**Post date:** [August 27, 2015, 3:30pm UTC](https://forum.mautic.org/t/problem-importing-1mil-of-leads/2250/5 "2015-08-27T15:30:50Z")

</div>

Thank you for prompt reply Chad I will try it this way.

---

<div class="post-metadata">

**Author:** ![chad.windnagle](https://avatars.discourse-cdn.com/v4/letter/c/7feea3/32.png) [@chad.windnagle](https://forum.mautic.org/u/chad.windnagle)\
**Post date:** [September 2, 2015, 2:33pm UTC](https://forum.mautic.org/t/problem-importing-1mil-of-leads/2250/6 "2015-09-02T14:33:56Z")

</div>

Hi Igor

Just checking in, how did this go for you? We’d love to hear some feedback on how mautic performs with big lead databases.

---

<div class="post-metadata">

**Author:** ![igor.sovcik](https://avatars.discourse-cdn.com/v4/letter/i/4bbf92/32.png) [@igor.sovcik](https://forum.mautic.org/u/igor.sovcik)\
**Post date:** [September 3, 2015, 10:01am UTC](https://forum.mautic.org/t/problem-importing-1mil-of-leads/2250/7 "2015-09-03T10:01:41Z")

</div>

At this point we only imported approximatelly 100 k leads. We checking the performance carefully before uploading whole package.

Is there any recomanded setting for points?

---

<div class="post-metadata">

**Author:** ![trops](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/trops/32/3998_2.png) [@trops](https://forum.mautic.org/u/trops)\
**Post date:** [November 2, 2015, 7:47pm UTC](https://forum.mautic.org/t/problem-importing-1mil-of-leads/2250/8 "2015-11-02T19:47:49Z")

</div>

I am currently trying to import 15k leads and no response. Sitting on the page “Please don’t leave this page” during import…is something happening? How can I tell?

---

<div class="post-metadata">

**Author:** ![escopecz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/escopecz/32/370_2.png) [@escopecz](https://forum.mautic.org/u/escopecz)\
**Post date:** [November 4, 2015, 10:22am UTC](https://forum.mautic.org/t/problem-importing-1mil-of-leads/2250/9 "2015-11-04T10:22:35Z")

</div>

Look at the logs. If you use Mautic 1.2.1+, open the admin right menu \> System Info \> Logs, if older version, look at app/logs folder content and check the server logs to see the error messages. My bet is that memory limit or script execution time limit in php.ini are too low. If you cannot increase them, divide the CSV with leads to more files and upload those separately.

---

<div class="post-metadata">

**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\
**Post date:** [February 2, 2020, 10:57pm UTC](https://forum.mautic.org/t/problem-importing-1mil-of-leads/2250/10 "2020-02-02T22:57:23Z")

</div>


