Importing Recipiants

[bfletcher]

Hi,

I have an .xls file with a long list of emails that I would like to import into OpenEMM. When I convert the file to .csv it comes up in the following format:

Code: Select all

gender,email,mailtype
Unknown,a@b.c,html
Unknown,a@b.c,html
Unknown,a@b.c,html

then when I create an access table and export it as csv I get the following format:

Code: Select all

1;"Unknown";"a@b.c";"HTML"
2;"Unknown";"a@b.c";"HTML"
3;"Unknown";"a@b.c";"HTML"

Each time I try to import only one email address appears in the preview page and I get the following error on the result page. "Errors in gender values: 11"

When I click on the disk symbol beside the above error I get the following:

Code: Select all

1;"Unknown";"a@b.c";"HTML"
2;"Unknown";"a@b.c";"HTML";Error, Text missing!gender
3;"Unknown";"a@b.c";"HTML";Error, Text missing!gender

Should I be using a different program to create the .csv files? If so how do I go about converting the old ones, as all my email addresses are saved into .xls.

I am pretty sure that I am doing something simple wrong here. If anyone would be able to help it would be greatly appreciated.

[maschoff]

Please use code 2 for unknown (0=male, 1=female) and code 1 for HTML (0=text, 2= inline HTML), i.e.

gender,email,mailtype
2, a@b.c, 1

[bfletcher]

Brilliant,

Thank You.