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

[brotherhud]

Ok I actually figured out the main problem. There was a ' in the csv file that made an error in the syntax. There is a new problem though, Whenever I import the file it imports it as 3 subscribers and each one is a long list of all the email addresses, I can't figure out how to import each address as its own.

[kobra]

I can't figure out how to import each address as its own.

How many do you have to do?

The sql file append is the easiest bet

[brotherhud]

I am not really familiar with this as I've never done it before. The file I am working with is just a list of email addresses, nothing else, no names, numbers, dates added, etc. Nothing but email addresses. Should I have the person that provided me with the list export in a different way? I'm not very clean on what you mean with the sql stuff. There are probably close to 1000 email addresses

[kobra]

You might get some insight if you look at the sql file that comes with the add-on as far as structure.

The #is required to extend the list correctly, the next can be "NULL", the next is the email addy, the next is the preferred mode text or html, then a pass and I believe that this can be NULL and the date NULL but am not positive on this

The cart will look for the mode html or text and with out the # will lose track