Get answers quicker by searching

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

Custom Fields for exports
  • Hi,

    Sendy is a great app and it works well, but there is one feature I really think it could use. When you export csv files from a campaign it only includes the name and the e-mail. I wish it would include which list the contact is in as well. What would be great is if a pop up came up with all possible fields and you check which fields you want in the report. Or at the least just include the list the contact is in.

    Thanks, Kevin

  • 9 Comments
  • Vote Up0Vote Down addactiveaddactive
    Posts: 46Sendy user

    +1

  • Vote Up0Vote Down rarijararija
    Posts: 15Sendy user

    +1 for this

  • Hi kevinmcmahonmilspray

    I am not sure if you have any programming experience

    There is probably an easy fix for exporting custom fields, in export-csv.php file you could change the sql query on line 188 to

    $select = 'SELECT name, email, custom_fields FROM '.$table.' where id IN ('.$subscribers.') '.$additional_query;

    and then just below line 205 you could add

    $value = str_replace( '%s%' , ',' , $value );

    and in regards to getting "which list the contact is in?" you could include the list column in the above sql query otherwise you would need to do a join to get the list name?

    By the way make sure you backup this file, becuase I take no responsibility :)

    Ben, I hope it is ok for me to share this information?

  • Vote Up0Vote Down powaspowas
    Posts: 8Sendy user

    This feature would be great. In the current version, when you export the suscribers that opened the email for example, it only exports the Name and Email.

  • Vote Up0Vote Down msaadwmsaadw
    Posts: 1Sendy user

    Hi can anyone help to get this sorted? There are 3 files with the file name export-csv.php in difference folders. Which one to be amended?

  • Vote Up0Vote Down powaspowas
    Posts: 8Sendy user

    If you want to export a group of contacts from a campaign report, you should modify the file in /includes/reports/.

    Hope it helps.

    Pablo

  • Vote Up0Vote Down vajrovajro
    Posts: 4Sendy user

    That query worked fine but I have multiple custom_fields and when I export, all the custom fields merged into a single column. Is there any way to split those custom fields to separate columns using their respective names? Thanks

  • +1 for this

  • Vote Up0Vote Down kalltripkalltrip
    Posts: 4Sendy user

    Need to this work by showing all those who opened an email and have my team do a follow up call. But when we download the list, there are no phone numbers, even though this shows when we click the name on last 10 opened list