Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2007
    Posts
    16
    Plugin Contributions
    0

    Default Importing Email Into Subscription Manager

    Hi Guys,

    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
    take care.

    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:
    email NULL
    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 protected], [email protected], [email protected]


    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: [email protected], html, [email protected], html, [email protected], html



    Does anybody have experience importing, and would you mind explaining how I should layout my flat file in order to import properly?

    Thanks!

  2. #2
    Join Date
    Feb 2007
    Posts
    16
    Plugin Contributions
    0

    Default Re: Importing Email Into Subscription Manager

    Does anybody have any suggestions?

    Maybe I wasn't very good at explaining my problem.

  3. #3

    Default Re: Importing Email Into Subscription Manager

    It would be nice if someone could explain the details of importing email address's via the subscription manager module...

  4. #4
    Join Date
    Jun 2009
    Posts
    7
    Plugin Contributions
    0

    Default Re: Importing Email Into Subscription Manager

    Dear all,
    I think I have solved it out. I just input the email address in row1column1 in an excel file. Then I save the file as tab delimited file.
    I upload the file I saved in "File to import" field and then input \t in "Fields separated by" in the control panel. I chose HTML as "Default email format" and then I click "UPLOAD" and the email address is up successfully. Hope it helps.
    Kitty

 

 

Similar Threads

  1. v150 newsletter subscription: No 'Subscription Manager'
    By lina0962 in forum All Other Contributions/Addons
    Replies: 5
    Last Post: 31 Jan 2013, 08:02 PM
  2. v1371 Issue Importing Orders into Stone Edge Order Manager
    By Stars in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 2 Feb 2012, 07:39 PM
  3. Replies: 15
    Last Post: 22 Dec 2010, 04:52 AM
  4. Sorting email addresses in Subscription Manager?
    By Realm Home in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 21 Jun 2010, 03:07 PM
  5. Resetting subscription & customers list with Customer & Subscription Manager
    By pshop in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 6 Nov 2009, 08:24 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR