how to import more than 10 000 emails in one go

[gandalf100]

[Hernol]

I dont think so, I think it crash after 1mb file.

[gandalf100]

Well it does.
I increased the value memory_limit in php.ini and it worked for over 60,000 emails.

[ramziddin]

Hi Everybody

I am new to php list and I am really wondering how you managed(more precisely succeeded) to import so many users in one go. I looked to the php.ini and the maximum upload limit is set to 25 MB. But I cannot upload 100 KB of file with user emails. It is only possible to import 2750 emails in one go in my case.
What might be causing this problem?

Could you give me some suggestion on resolving my issue?

Multo Gracio

Ramziddin

[Jason Kuenkler]

And we had a ubbthreads site, and have a mysql database with a table that houses the 62K + email addresses.

How do I tie phplists to the database, so it pulls in new subscriptions and new members whenever we send out a newsletter?

We've tried the csv method, and it's crashing all the time. Is there no way to just use a sql database as it's email source?

[H2B2]

[thisisit3]

[nigelduc]

I had to import 12,000 names in a 5MB file. I tried the suggestions found in the forum, increasing the memory_limit in php.ini and a limit set in /admin/import1.php and neither worked, I still got the "file too big" error. I searched for that text and found it in /admin/commonlib/pages/importcsv.php line 95 where there is a limit set on the tmp file:

if (filesize($_FILES["import_file"]['tmp_name']) > 1000000) { /* Change 1000000 */

This fixed it for me and I have successfully imported 6MB files. I hope this helps someone else.

Thanks for a great little app!

[chris87]

[suntereo]

[rickpcb]

I found a tool for splitting large csv files into smaller ones - it's pretty handy...
unfortunately I can't post the link here... do a google search for split excel csv into smaller files - the result is in the top 5 - it is on fxfisherman dot com in the forums...

[jc19]

nigelduc wrote:
I had to import 12,000 names in a 5MB file. I tried the suggestions found in the forum, increasing the memory_limit in php.ini and a limit set in /admin/import1.php and neither worked, I still got the "file too big" error. I searched for that text and found it in /admin/commonlib/pages/importcsv.php line 95 where there is a limit set on the tmp file:

if (filesize($_FILES["import_file"]['tmp_name']) > 1000000) { /* Change 1000000 */
****************************************
Can you tell me where to access /admin/commonlib/pages/importcsv.php ? Thank you.

[pro2sell]

[Dragonrider]

[moinhaidar]