edit the newsletter csv export file?

[Lpeek]

Does anyone know where the code is for the export of csv files in the newsletter module? I cant find anything anywhere, and theres is no reference to it in the blockNewsletter module???

I need to change what fields are exported in the csv file as the defult prestashop settings dont work with any email marketing software like mail chimp or constant contact.

[rocky]

The _getBlockNewsletter function in modules/newsletter/newsletter.php gets the newsletter data and the _postProcess function writes the CSV file.

[FunnyBunnyHelena]

I am sorry for bringing up this old topic, but I want to modify too..

But I have NO clues about PHP, sorry.

I want to have the output list of ONLY email addresses and nothing else.
I use Eudora and I have yet to figure out how to import things there. I only get one box that asks for PST files.

[Patric]

If you want to export the e-mails of the regitered persons, you can use the dedicated module :
Back Office >> Modules
Newsletter (section Tools)
Configure >>

[FunnyBunnyHelena]

But that's what I am doing, and the result file contains fields I do not wish to be there, I just want a file with email addresses only, no other data. (such as name, date, ip )

[MrBaseball34]

Geez man, it's a CSV file, open it in Excel and remove the fields you don't want, then save it again.

[FunnyBunnyHelena]

I don't have Excel installed..

[MrBaseball34]

OK, then to make it only export the emails, you must modify the newsletter.php file. Can you handle that?

Change this code, around line 112:

private function _getBlockNewsletter()
{
     $rq = Db::getInstance()->ExecuteS('
     SELECT *
     FROM `'._DB_PREFIX_.'newsletter`');
     $header = array('id_customer', 'email', 'newsletter_date_add', 'ip_address');
     $result = (is_array($rq) ? array_merge(array($header), $rq) : $header);
     return $result;
}

to this:

private function _getBlockNewsletter()
{
     $rq = Db::getInstance()->ExecuteS('
     SELECT email
     FROM `'._DB_PREFIX_.'newsletter`');
     $header = array('email');
     $result = (is_array($rq) ? array_merge(array($header), $rq) : $header);
     return $result;
}

[MrBaseball34]

I find that code very strange because I don't see a table called ps_newsletter in ANY of my installations. v1.25, v1.3.0.1 or v1.3.1.

[FunnyBunnyHelena]

Thank you for your help.

[Patric]

I find that code very strange because I don't see a table called ps_newsletter in ANY of my installations. v1.25, v1.3.0.1 or v1.3.1.

This is because you do not have the Newsletter block module installed.

I would recommand using OpenOffice Calc (free) instead of Excel to manage CSV files.

[MrBaseball34]

Well, I thought we did but, whatever...Thanks.