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

Start here! No need to ask twice :)

Re: Be careful; Excel misbehaves

Postby gazebo » 2:17pm, Thu 06 Jan, 2005

Pete F. wrote:I've had a quick look at my source spreadsheet in Excel to see if there's anything causing these extra tab characters to appear, but there doesn't appear to be... :roll:

The last cell in each record of my email database was a comments field which often had more than one line of text. In Excel it showed as square at the end of each line which appeared to be interpreted as a TAB by phplist, since the information got separated into different records with invalid emails when I imported.

I deleted all the squares I could find and saved the file again. There were still extra records created in phplist as invalid emails. The comments were still on several lines in one cell even though I'd deleted the squares so I guess the new line character was interpreted as a TAB on import.

By the way, it's a bugger when you save your data as .txt from Excel and subsequently want to edit it, you have to reimport it and then things like several lines in one cell get split. What I did was to save information as a csv file (except some formatting doesn't seem to be saved with it), edit it if necessary, and then when finally ok save it as txt before importing to phplist.
gazebo
 

Re: Be careful; Excel misbehaves

Postby Kelton » 1:36pm, Fri 07 Jan, 2005

Pete F. wrote:When exporting to a tab delimited text file from Excel, be aware that Excel can dump extra tab characters - seemingly at random - at the end of each line before the return carriage (in the exported text file). <<snip>>

I've had a quick look at my source spreadsheet in Excel to see if there's anything causing these extra tab characters to appear, but there doesn't appear to be... :roll:


If your excel spreadsheet has anything in a column to the right of your desired data table, then it will add extra tab characters. If you press <CRTL><END> keys the cursor goes to the end of the worksheet... if it is past the last column of your desired data, then you'll probably get those extra tabs.

My solution... delete those columns to the right of the desired data, shift the cursor back to "home", save the workbook, close it, then re-open it.


I hope it works for you..

regards
Kelton
phpLister
 
Posts: 7
Joined: 6:04am, Thu 23 Dec, 2004
Location: Melbourne Australia

Postby nandoe » 6:30pm, Thu 22 Sep, 2005

be sure there are not characters used as:

"
:
<space> such as in " abc@ def .biz"
,
;
nandoe
PL Nut
 
Posts: 24
Joined: 3:24pm, Wed 19 May, 2004
Location: Ede, The Netherlands

Postby shumisha » 3:54pm, Thu 06 Apr, 2006

You can try have a look at my post:

http://www.phplist.com/forums/viewtopic.php?t=5085

for CSV import
shumisha
PL Geek
 
Posts: 82
Joined: 8:06am, Tue 04 Apr, 2006

Postby ollie » 11:55am, Wed 01 Nov, 2006

shopnz wrote:What a pain the import turned out to be.


I was able to import 27,000 emails very easily. I used a csv file and selected "import emails with different values for attributes".
ollie
phpList newbie
 
Posts: 4
Joined: 11:46am, Wed 01 Nov, 2006

Postby jackbremer » 5:26pm, Thu 30 Nov, 2006

nandoe wrote:be sure there are not characters used as:

"
:
<space> such as in " abc@ def .biz"
,
;


spot on, hadn't thought to check for : - worked a treat!

Importing a list of 26505 right now, just emails, same values for other fields.
jackbremer
PL Geek
 
Posts: 100
Joined: 10:28am, Thu 22 Jun, 2006

import emails

Postby marcosfernandez » 11:38pm, Thu 28 Dec, 2006

I want to import my emails addreses from several word documents. Please explain step by step, to convert this documents, because I intent in manny times but comes the "error to read this document".
Thanks.
marcosfernandez
phpLister
 
Posts: 7
Joined: 7:20pm, Thu 28 Dec, 2006
Location: Argentina

importing my list

Postby dteague » 5:13am, Fri 23 Feb, 2007

I followed the steps that Luigi posted but I'm now getting this error:

Fatal Error: Cannot find column with email, please make sure the column is called "email" and not eg e-mail

I'm not sure what to do now.

Thanks Debbie
dteague
phpList newbie
 
Posts: 1
Joined: 5:07am, Fri 23 Feb, 2007

Re: importing my list

Postby H2B2 » 11:38pm, Sun 25 Feb, 2007

dteague wrote:I followed the steps that Luigi posted but I'm now getting this error:

Fatal Error: Cannot find column with email, please make sure the column is called "email" and not eg e-mail

Did you check that the file you exported contains the field (column) names in the first row,
and that the field name for email addresses is called email?
H2B2
Moderator
 
Posts: 7188
Joined: 1:51am, Wed 15 Mar, 2006

What is the key .....

Postby websquad » 3:03pm, Thu 21 Jun, 2007

michiel wrote:phplist will never duplicate an email in the system
Have a newbee question: does this lead me to believe that phpList uses the Email address as the key to its user table? If so, does it normalize the Email string to all lower case as part of the process?

I thought I read somewhere that if you had an established member database, but with some of the members missing attributes, you could import a record for an existing member and insert attributes in place of null values ... true of false? :?:
websquad
phpList newbie
 
Posts: 3
Joined: 4:37am, Tue 10 Apr, 2007

Re: What is the key .....

Postby H2B2 » 3:55pm, Thu 21 Jun, 2007

websquad wrote:phpList uses the Email address as the key to its user table? If so, does it normalize the Email string to all lower case as part of the process?
Yes, the email address is the identifier for a user. Not sure whether case gets changed.
You could run some tests to find out and let us know.

websquad wrote:I thought I read somewhere that if you had an established member database, but with some of the members missing attributes, you could import a record for an existing member and insert attributes in place of null values ... true of false? :?:
Yes, that seems to be possible. as described in the docs under the option "Overwrite Existing".
You'd better run some test with this too, to be sure this will do what you expect it to do.
H2B2
Moderator
 
Posts: 7188
Joined: 1:51am, Wed 15 Mar, 2006

What worked for me...

Postby amoswright » 7:38pm, Tue 13 May, 2008

I was getting frustrated - had a very simple list of approx 15,000 emails, one per line, should work as usual... bud didn't.

Turns out, the list had forbidden characters such as "," ";" ":" "#" or "\t". After deleting them (find/replace), imported fine. I guess the file can't have these characters at all, which I didn't realize (unless you specify one as your delimiter?).

...Probably obvious to most folks, but stumped me for a while... With a long list of user generated emails, I guess there are bound to be a number of typos (i.e. ",com"), so something to keep in mind.

PhpList RULES!
amoswright
phpLister
 
Posts: 8
Joined: 4:22pm, Tue 25 Mar, 2008

Choose the right option

Postby harikaram » 12:47pm, Tue 03 Mar, 2009

Hi,

Most of the issues on this post (including strict invalid character checking) can be avoided by choosing the

"import emails with different values for attributes"

option rather than

"import emails with same values for attributes"

...as I've just discovered after an hour of fiddling :roll:

And, you have to ensure the email column has the header "email"

The it works like a charm...

-HKS
harikaram
phpList newbie
 
Posts: 4
Joined: 6:42pm, Thu 12 Feb, 2009

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

Postby soundtherapy » 9:48am, Tue 12 May, 2009

Hi
I can't import any users list because of this message:
Warning: The temporary directory for uploading is not writable, so import will fail ()

should I contact my server provider?
hope you can help me
thanks
soundtherapy
phpList newbie
 
Posts: 3
Joined: 4:19pm, Fri 08 May, 2009

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

Postby harikaram » 9:53am, Tue 12 May, 2009

sounds like a permissions issue. Contact your host support unless you know how to change permissions.
harikaram
phpList newbie
 
Posts: 4
Joined: 6:42pm, Thu 12 Feb, 2009

PreviousNext

Return to Frequently Asked Questions

Who is online

Users browsing this forum: No registered users and 1 guest