<SOLVED> Mozilla Thunderbird will not import my .csv files correctly

[gfresh]

Hi,

Im using version 1.31
When i save my .csv newsletter file from prestashop and attempt to import it into Thunderbird the fields are not displayed correctly as seen in the pic..
The fields are displayed all over one row and does not seperate the fields for me.
Do i need to alter the csv file in any way for thunderbird to recognise or am i doing something wrong?
Many thanks,

Gary

[gfresh]

any ideas anyone? I would have thought this should be a simple fix but need some help

[MrBaseball34]

Looks to me like it may be using a different delimiter than Thunderbird is looking for.

[gfresh]

ok. so does that mean that should use a different email client or change something to make thunderbird understand the format? Do you have any probs with importing newsletter addresses through your email client?
thanks in advance..
Gary

[MrBaseball34]

Change this line in module/newsletter/newsletter.php

$line = implode(';', $array);

to this to change to comma separator:

$line = implode(',', $array);

Remember, it's "Frenchies" developing this software and they use semi-colons as separators vs. commas It shoul dhave been a configurable option in this module.
Oh, BTW, I don't use that module, I just pull the addresses from the database myself and use SendBlaster to send out my newsletters.

[gfresh]

Thanks for the reply, will have a shot at it now.
have just checked out sendblaster, looks good

[gfresh]

thanks, it worked a treat