Importing CSV file of subscribers.

Questions related to the phpList Hosted service

Importing CSV file of subscribers.

Postby derekjackson » 10:20am, Mon 20 Jun, 2011

Hi,
I'm struggling to import our contact list in CSV format. I was hoping to bring in the person's first name, surname and company along with their email address but I keep getting this message:
Fatal Error: Cannot find column with email, please make sure the column is called "email" and not eg e-mail, and that your column delimiter is correct


My list is in an Excel table setup like the attached image. As my email column seems to be named as required, I guess the error is the column delimiter - what should I be doing here? (I've left the Field and Record Delimiter values as default)

Any help appreciated!

Thanks,

Derek
Attachments
CSV file.jpg
CSV file example
CSV file.jpg (201.35 KiB) Viewed 3795 times
derekjackson
phpList newbie
 
Posts: 3
Joined: 3:48pm, Thu 16 Jun, 2011

Re: Importing CSV file of subscribers.

Postby Dragonrider » 12:03pm, Mon 20 Jun, 2011

Easiest way I have found to be sure I get the format correct is to do an export from phpList, then use that as the basic format to import your own data.
My sites:- http://wharfedalefestival.co.uk, http://ilkleygardeners.org.uk, http://emergencyaid.net, http://dragonrider.co.uk
Latest phpList 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


Return to phpList Hosted

Who is online

Users browsing this forum: No registered users and 1 guest

cron