Export affiliate Members with Emails

[GoogieHost 10]

Hey!

I want to export all affiliate members list with email addresses but there is no such tool in Report section, can someone guide me into this ?

[brian! 1,754]

11 hours ago, GoogieHost said:

I want to export all affiliate members list with email addresses but there is no such tool in Report section, can someone guide me into this ?

easiest way would be to edit the existing Affiliates Overview Report and add the email address into that output - which you can then export as a csv.

upload the attached file to /modules/reports and next time you visit the Reports page, you should see a link to "Affiliates Emails Overview" - click on it, and you'll get your list of affiliates with their email addresses. 😀

affiliates_emails_overview.php

[GoogieHost 10]

I uploaded this file in the same dir but I didn't get overwrite warning then tried Affiliates Emails Overview but nothing was changed 

[brian! 1,754]

2 minutes ago, GoogieHost said:

I uploaded this file in the same dir but I didn't get overwrite warning

you wouldn't because I gave it a unique filename - during future WHMCS updates, WHMCS won't remove this report file.

4 minutes ago, GoogieHost said:

then tried Affiliates Emails Overview but nothing was changed

are you at least seeing Email in the headings?

if not, try pressing CTRL+R (if using Firefox) to reload the page..

[GoogieHost 10]

Hey!

I found the correct file and replaced with your modified version and working fine now 

[brian! 1,754]

2 hours ago, GoogieHost said:

I found the correct file and replaced with your modified version and working fine now 

if you renamed the file to affiliates_overview.php to replace the default file (without emails) that was already there, then WHMCS will overwrite it during an update.