catalinvrt

I have found the way, thanks to this post.

Got it: $filterfields = [ 'id' => 'ID', 'firstname' => 'First Name', 'lastname' => 'Last Name', 'companyname' => 'Company Name', 'email' => 'Email', 'address1' => 'Address 1', 'address2' => 'Address 2', 'city' => 'City', 'state' => 'State', 'postcode' => 'Postcode', 'country' => 'Country', 'phonenumber' => 'Phone Number', 'currency' => 'Currency', 'groupid' => 'Client Group ID', 'credit' => 'Credit', 'datecreated' => 'Creation Date', 'notes' => 'Notes', 'status' => 'Status', 'emailoptout'=>'Email Optout', 'marketing_emails_opt_in'=>'Email OptIN' ];

Hi, I am interested in doing the same, but the code has changed. Can you provide an update?

I need to export a csv with the clients that have optin for email marketing in order to import the list in my email solution. However, after talking with whmcs support it seems it doesn't exist a way t do that but rather I'll have to edit the report file(or create new one). This is what they told me: Can anyone help me with this? I have located the report file that does the export, but I don't understand where to add the code received from support. The code looks to me more like a half of an sql query . Regards clients.php