how to import more than 10 000 emails in one go

Solutions for other phplisters - Questions go in the questions and problems forum

Moderators: Dragonrider, J_S, Hernol, vancoovur, H2B2, bevan, Heritage

how to import more than 10 000 emails in one go

Postby gandalf100 » 3:47pm, Sun 20 Aug, 2006

Is it possible to import more than 10000 emails in one go?
gandalf100
phplister
 
Posts: 10
Joined: 10:32am, Sun 20 Aug, 2006

Postby Hernol » 1:22pm, Tue 22 Aug, 2006

I dont think so, I think it crash after 1mb file.
Hernol
Admin
 
Posts: 1381
Joined: 6:39pm, Thu 18 May, 2006
Location: Argentina

the answer

Postby gandalf100 » 8:19am, Thu 24 Aug, 2006

Well it does.
I increased the value memory_limit in php.ini and it worked for over 60,000 emails.
gandalf100
phplister
 
Posts: 10
Joined: 10:32am, Sun 20 Aug, 2006

Postby ramziddin » 10:41am, Tue 06 Mar, 2007

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
ramziddin
PL Nut
 
Posts: 31
Joined: 11:46am, Thu 01 Mar, 2007

I would like to import over 62,000 emails...

Postby Jason Kuenkler » 9:16pm, Fri 13 Apr, 2007

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?
Jason Kuenkler
phplist newbie
 
Posts: 4
Joined: 9:11pm, Fri 13 Apr, 2007

Postby H2B2 » 9:50pm, Fri 13 Apr, 2007

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
H2B2
phpList Guru
 
Posts: 5890
Joined: 1:51am, Wed 15 Mar, 2006

Postby thisisit3 » 5:23pm, Wed 02 May, 2007

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.
thisisit3
PL Nut
 
Posts: 27
Joined: 12:32pm, Thu 26 Apr, 2007

Importing Over 1MB File Size

Postby nigelduc » 2:11pm, Thu 24 May, 2007

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!
...
Nigel
nigelduc
phplist newbie
 
Posts: 2
Joined: 1:27pm, Thu 24 May, 2007
Location: USA

Importing more than 3.5

Postby kompset » 3:29pm, Tue 03 Jul, 2007

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
kompset
phplist newbie
 
Posts: 1
Joined: 1:48pm, Tue 03 Jul, 2007

Postby chris87 » 2:32pm, Mon 10 Sep, 2007

ramziddin wrote: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
phplist newbie
 
Posts: 4
Joined: 12:04pm, Tue 04 Sep, 2007

Postby chris87 » 1:15pm, Fri 14 Sep, 2007

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
chris87
phplist newbie
 
Posts: 4
Joined: 12:04pm, Tue 04 Sep, 2007


Return to Answers, Howtos, Tips & Tricks

Who is online

Users browsing this forum: No registered users and 1 guest