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 li
you'll definitely have to create a new one - if you edited an existing report, whilst it would work for now, the next time you update WHMCS, it will get overwritten and your changes will be lost.
I don't think that you need to do what Support suggested, e.g querying a second database table - just querying the clients database table should be enough for your needs... if i'm wrong on that (and it needs the insurance policy of checking the second table for confirmation), then it's still doab