[Solved] Editing newletter values to work with mail chimp

[johnmoore84]

Hi everyone, looked throug the forium and cant find a answer to this.

When I export the newletter cvs file for newsletter subcriptions to upload to mailchimp its gives errors,

the reason is the values ie first name, last name, email are seperated by ; and not , which it needs to be ie

How the cvs files looks when downloaded into excel

john;moore;[email protected]

How I need it to look when downloaded

john,moore,[email protected]

simply need to replace the ; with a ,

Anyone now how to change this, i think i need to go to modules, newletter and open newletter.php but dont no what to change.

Need help with this please

[jeckyl]

Hi,

you can do that with your notpad.

[johnmoore84]

Hi, how i do that. Do you mean change all the ; manualy to , because i got alot of newletter sign ups.

Thanks for your advice

[jeckyl]

Hi, how i do that. Do you mean change all the ; manualy to , because i got alot of newletter sign ups.

Thanks for your advice

no, use a software to said replace all ; by ,.

And if you don't do that manually, you can use my module to synchronise prestashop with mailchimp.

http://www.prestatoolbox.com/advertising-marketing/84-synchronisation-prestashop-with-mailchimp.html