[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4758: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3893)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4760: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3893)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4761: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3893)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4762: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3893)
phplist forums • View topic - how to import more than 10 000 emails in one go

how to import more than 10 000 emails in one go

Solutions for other phpList version 2 users
Forum rules
Please do not ask questions here, this is for Solutions you have discovered or come across.

how to import more than 10 000 emails in one go

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

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: 1378
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

phpList | | | |
H2B2
Moderator
 
Posts: 7188
Joined: 1:51am, Wed 15 Mar, 2006

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

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!
nigelduc
phpList newbie
 
Posts: 2
Joined: 1:27pm, Thu 24 May, 2007

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

chris87
phpList newbie
 
Posts: 3
Joined: 12:04pm, Tue 04 Sep, 2007

Re: Importing Over 1MB File Size

Postby suntereo » 6:51pm, Mon 21 Dec, 2009

suntereo
phpList newbie
 
Posts: 1
Joined: 6:48pm, Mon 21 Dec, 2009

Re: how to import more than 10 000 emails in one go

Postby rickpcb » 9:55pm, Wed 23 Dec, 2009

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...
rickpcb
phpLister
 
Posts: 6
Joined: 9:53pm, Wed 23 Dec, 2009

Re: how to import more than 10 000 emails in one go

Postby jc19 » 7:13am, Sun 27 Dec, 2009

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.
jc19
phpList newbie
 
Posts: 1
Joined: 7:08am, Sun 27 Dec, 2009

[HOWTO] import csv from server

Postby pro2sell » 6:21am, Fri 19 Feb, 2010

pro2sell
phpList newbie
 
Posts: 3
Joined: 5:11pm, Mon 15 Feb, 2010

Re: how to import more than 10 000 emails in one go

Postby Dragonrider » 1:27pm, Wed 24 Feb, 2010

My sites:- http://wharfedalefestival.co.uk, http://ilkleygardeners.org.uk, http://emergencyaid.net, http://dragonrider.co.uk
version is now 3.0.12 (3 February 2015) and requires a minimum of MySQL 5.0 and PHP 5.3.x
Dragonrider
Moderator
 
Posts: 3460
Joined: 6:58am, Sun 02 Jul, 2006
Location: Ilkley, West Yorkshire, United Kingdom

Re: how to import more than 10 000 emails in one go

Postby moinhaidar » 6:17am, Wed 05 May, 2010

moinhaidar
phpList newbie
 
Posts: 3
Joined: 5:58am, Wed 05 May, 2010

Next

Return to Answers, Howtos, Tips & Tricks

Who is online

Users browsing this forum: No registered users and 1 guest

cron