Import CSV

[Extrem94]

How do you format your csv to be imported to Zen Cart via the sub. add-on module?
Do you have a sample for importing a list of Email?
Thank you for your time.

[kobra]

How do you format your csv to be imported to Zen Cart via the sub. add-on module?

I believe that the Module to add the backup + restore to the admin only deals with sql files but not 100% positive

[Louis]

Assuming you are still referring to the newsletter add-on then the following:

Admin>Customers>Subscription Manager then click on import.

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.

This needs to be applied to the following layout.

email NULL format NULL

A sample would then look like this:

(field 1)mail@somewhere~(field 2)blank~(field 3)HTML (or text)~blank

where ~ is space.

[Extrem94]

Thank you,
I'll try that.

[Extrem94]

I tried but it fails to import the list properly, it imports all in the same record...
I keep searching for the solution since I don't have the time to import 1500 e-mail addresses.

[Louis]

You must have each e-mail on a new line in your import file. If this does not work, send me your file by PM and I will have a look at your layout for you.