[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/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 do i import emails - what field delimeter is a square

how do i import emails - what field delimeter is a square

Start here! No need to ask twice :)

how do i import emails - what field delimeter is a square

Postby pws » 3:04am, Sat 27 Sep, 2003

pws
phpList newbie
 
Posts: 4
Joined: 4:10pm, Thu 25 Sep, 2003

Postby michiel » 1:18pm, Sun 28 Sep, 2003

michiel
Admin
 
Posts: 1022
Joined: 10:18pm, Fri 11 Apr, 2003
Location: Buenos Aires, Argentina

Postby rois » 7:53am, Mon 19 Apr, 2004

rois
phpList newbie
 
Posts: 2
Joined: 7:48am, Mon 19 Apr, 2004

Postby pdbrett » 9:51am, Mon 19 Apr, 2004

Paul Brett
pdbrett
PL Geek
 
Posts: 85
Joined: 12:22pm, Thu 08 Jan, 2004
Location: England

Postby shopnz » 10:02pm, Sat 05 Jun, 2004

shopnz
phpLister
 
Posts: 13
Joined: 9:54pm, Sat 05 Jun, 2004

Postby shopnz » 4:18am, Sun 06 Jun, 2004

shopnz
phpLister
 
Posts: 13
Joined: 9:54pm, Sat 05 Jun, 2004

Import problem

Postby zirius » 2:59am, Mon 27 Sep, 2004

I am trying to import 2000 names from a list following your instructions above, but continue at each import attempt to get the message:

Fatal Error: Some characters that are not valid have been found. These might be delimiters. Please check the file and select the right delimiter. ,

The list is in a .txt file saved from an Excel spreadsheet as a tab delimited file.

The columns are labeled according to the attribute field where they should be placed, and the names contain no spaces.

Can you help me figure out what is going on? Does the order of the fields make a difference?
zirius
phpList newbie
 
Posts: 1
Joined: 2:45am, Mon 27 Sep, 2004

import cap

Postby wazoo » 6:13pm, Fri 15 Oct, 2004

is there a way to import more than 7500 emails at once, because its quite a pain to split up my lists into 7500 email blocks. i thought about just hacking the import code apart into my own script but that proved to be more work than it was worth. any help would be usefull.
wazoo
phpList newbie
 
Posts: 3
Joined: 5:58pm, Fri 15 Oct, 2004

Postby Luigi » 1:33am, Sat 23 Oct, 2004

Hi:

This is what i did an it worked for me....(i´m using 2.9.1)

* have your database in regular exel format, make sure in the first line on each square (cell) is the title of the field ( email, name, city...and so on..)

* order in the name colums is not important..

* do not save it as cvs format, save it as Text tab delimited

* in your control panel go to manage users > import email

* use the first option the give you: import emails with different values for attributes

* select the text file to import, you can check the Test output box to see the results before you import the file.

* do not check this boxes it´s not necesary
Field Delimiter: (default is TAB)
Record Delimiter: (default is line break)

* you can check either one of this boxes, acording to your needs
Send Notification email
Make confirmed immediately

* hit the import buttom and

* if you are satisfied with the output , go on and hit confirm Import to upload the file

* make sure the name fields on your text file (first line) correspond to the names found on the attributes page,if not no problem, if the system can´t match the fields automatically it will give you the chance to do it manually.

It should work with this procedure

Make sure your text files are small no more than 500 mails in one file.(pain in the kneck) depending on your server capability..
or you might have this error that can freeze you list system
Database error 1226 User 'website_user' has exceeded the 'max_questions' resource (current value: 50000)
if you run into this problem, don´t worry i have the pill for that too. :lol:

I hope it helps
Luigi
Luigi
PL Nut
 
Posts: 18
Joined: 10:15pm, Fri 15 Oct, 2004

De-duping

Postby johnny » 4:57am, Fri 03 Dec, 2004

johnny
phpList newbie
 
Posts: 3
Joined: 4:54am, Fri 03 Dec, 2004

Postby michiel » 9:44am, Fri 03 Dec, 2004

michiel
Admin
 
Posts: 1022
Joined: 10:18pm, Fri 11 Apr, 2003
Location: Buenos Aires, Argentina

import list

Postby johnny » 3:21pm, Fri 03 Dec, 2004

johnny
phpList newbie
 
Posts: 3
Joined: 4:54am, Fri 03 Dec, 2004

Postby michiel » 3:54pm, Fri 03 Dec, 2004

michiel
Admin
 
Posts: 1022
Joined: 10:18pm, Fri 11 Apr, 2003
Location: Buenos Aires, Argentina

Postby johnny » 4:45pm, Fri 03 Dec, 2004

johnny
phpList newbie
 
Posts: 3
Joined: 4:54am, Fri 03 Dec, 2004

Be careful; Excel misbehaves

Postby Pete F. » 1:11pm, Thu 06 Jan, 2005

Pete F.
phpLister
 
Posts: 5
Joined: 1:00pm, Thu 06 Jan, 2005

Next

Return to Frequently Asked Questions

Who is online

Users browsing this forum: No registered users and 3 guests