Import CSV

[brotherhud]

I am trying to import a .csv file into the newsletter add-on. The csv file is just a list of emails and it looks like this

"[email protected]"
"lady##################"
"[email protected]"

and so on. Each email is in quotes and each is on a new line. I can't get it to import correctly. Any help would be appreciated. Thanks

[Louis]

You have to fill this field with the quotes used.

If fields are enclosed by quotes or other character, enter it here:

and you have to set

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.

to this

email NULL NULL NULL

[brotherhud]

If in the list each email address is on a new line what do I put in the field that asks how each record is seperated?
And for the part where it asks what each record is enclosed in do I put one " or do I put "" ?

[Louis]

If in the list each email address is on a new line what do I put in the field that asks how each record is seperated?

Nothing, it actually refers to Fields rather than records "Fields separated by (| , \s \t etc):"


And for the second question. One " should do the trick.

[brotherhud]

I tried that and it still isn't working. Here is what is happening. It says imported 1 address successfully and it looks like this:

[email protected] "[email protected] [email protected]

and so on, I can't get these to import for the life of me

[kobra]

You need to get your info into the table structure format...

You could create, or export this table in sql fmt and append your new entries and it would look something like this:

INSERT INTO `subscribers` VALUES (353, NULL, '[email protected]', 'HTML', 'bm9MZ0', '2007-02-06');
INSERT INTO `subscribers` VALUES (354, NULL, '[email protected]', 'HTML', '1', '2007-02-08');
INSERT INTO `subscribers` VALUES (355, NULL, '[email protected]', 'HTML', 'L1FreU', '2007-02-09');
INSERT INTO `subscribers` VALUES (356, NULL, '???????????##################', 'TEXT', 'YVp2dz', '2007-02-13');

Where each is comma separated and after appending the additional records you run/import this table
Or a csv/excell file more on the line of:

353,NULL,[email protected],HTML,bm9MZ0,2/6/2007
354,NULL,[email protected],HTML,1,2/8/2007
355,NULL,[email protected],HTML,L1FreU,2/9/2007
356,NULL,??????????##################,TEXT,YVp2dz,2/13/2007