Importing Email Into Subscription Manager
I've been having trouble importing a list of email addresses from a flat file.
I've tried it a few different ways, and at this point I'm unable to grasp the concept, I suppose.
I read the readme file, but for the most part it is the same info provided in the admin.
IMPORTING E-MAILS FROM A FILE:
I've tested the import script with a list of 2500 emails and it went
without problems, but if you have very large lists, you might want to
Use the file selector to select the file to import.
Indicate how fields are separated (\t for tabs, , for commas, etc)
If the fields are wrapped in quotes, fill in that field.
Enter a sample record. This lets the import script know what fields to
import. Use NULL for fields not to import, 'email' for the address, and
'format' for format. Adding format is optional-you can specify a default.
Note that you don't have to enter the entire record. If each record is 10
fields long, but email is the first field, just enter:
If email was the third field, and format the second, enter:
NULL format email NULL
If there is a header row (excel files often have them), check the box and
the first row will not be imported.
Indicate the fallback email format to use if there is none in the record,
or is not 'HTML' or 'TEXT' (the check is case-insensitive-'html' is okay)
Cross your fingers, hold your breath and submit.
I guess I don't understand the "fields" concept.
In the admin where it says" Enter a sample record, using 'format' for email format field and 'email' for email. Use NULL to indicate fields not to import.
Separate fields with a single space."
And they have this example in the input box: email NULL format NULL
If my flat file is just a list of email addresses seperate by comma's
EX: email@example.com, firstname.lastname@example.org, email@example.com
with the format field, my understanding is that in order to assign each address to receive HTML email, I should make my flat file to read as this
EX: firstname.lastname@example.org, html, email@example.com, html, firstname.lastname@example.org, html
Does anybody have experience importing, and would you mind explaining how I should layout my flat file in order to import properly?
By syseeker in forum General Questions
Last Post: 18 Jan 2012, 01:41 AM
By Moncia in forum PayPal Express Checkout support
Last Post: 4 Oct 2007, 12:37 PM
By petpromises in forum General Questions
Last Post: 8 Nov 2006, 01:48 PM
By pinocao in forum Basic Configuration
Last Post: 3 Sep 2006, 12:04 AM
Content and Graphics Copyright (c) 2003 - 2013 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC