how to import more than 10 000 emails in one go

[gandalf100]

Is it possible to import more than 10000 emails in one go?

[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]

Have you tried some of the solutions mentioned under the "Tip & Tricks from the forum" paragraph of http://docs.phplist.com/ImportUsersInfo

* phpList import and safe_mode fixed∞
* Import Emails from another Database Solution∞
* Importing users without file uploads∞
* Small hack to make CSV import work (Excel - phplist)∞
* Import users pre-marked to receive html in CSV file∞
* Importing more than the 1Mb limit∞
* Importing much more than the 1Mb limit

[thisisit3]

I've had the same problem, i couldn't import large text files of emails due to an error that the file was too big.

i had to edit the file admin/import1.php and change the limit from 1MB to 5MB, worked fine.

[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!

[kompset]

Im made all of that and i cant import more than 3.5 mb.

phpini is 10 mb
importcsv 10mb
import1 10 mb
im using phplist version 2.11.3


i dont know what to do .
thanks
RM

[chris87]

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?

Does someone else has this problem?

I can't imagine the 1-MB-Limit does influence the file that it is impossible to upload a file that has less than 100KB.

I've never uploaded more than 2500 adresses in one upload...


Thanks,

Christoph

[chris87]

I've got another idea:

I'm using Linux (Ubuntu), may this causes the problem?

I'll try it with windows at the weekend.


Greetings,

Christoph