Importing Subscribers with blank fields

Once you've installed phpList... ask questions here!
Forum rules
Please help the volunteers to help you by supplying the version of phpList you are using, browser & version and if possible, a link to your phpList installation.

Importing Subscribers with blank fields

Postby gavins38 » 10:20am, Thu 04 Dec, 2014

I'm having some problems with how phpList 3 handles importing subscribers who have blank fields. One of the things we want to do is send out customised emails with our subscribers' contact details on, but it's only just been brought to my attention that when I import a list of subscribers who don't have data in every custom field, phpList inserts 'NULL' into the field. This is causing some confusion for some subscribers and doesn't look very professional on our part.

Where is this behaviour defined and is there anyway that I can change it to leave blank fields blank?
gavins38
phpLister
 
Posts: 7
Joined: 10:12am, Thu 04 Dec, 2014

Re: Importing Subscribers with blank fields

Postby gavins38 » 1:45pm, Mon 05 Jan, 2015

I solved this problem. It turns out that it is my SQL database that is generating the NULL values when I export a CSV list.
gavins38
phpLister
 
Posts: 7
Joined: 10:12am, Thu 04 Dec, 2014


Return to Questions and Problems after Installing

Who is online

Users browsing this forum: No registered users and 2 guests

cron