Where are the email addresses and names of the people who opened sales tickets stored?

[Teknikl]

Is there a way to extract that list easily or do I need to go into the DB?

 

and where are they stored in the DB? I want to do a mailchimp campaign to all previous people who requested quotes through whmcs.

 

Thanks!

 

M

[brian!]

Is there a way to extract that list easily or do I need to go into the DB?

define "easily" ?

 

I don't think they'll be a way to do it from the admin area out of the box - you could write a report to generate the output and then use that to export the list to a csv file, but I suspect if you knew the SQL it would be easier to query the DB directly.

 

and where are they stored in the DB? I want to do a mailchimp campaign to all previous people who requested quotes through whmcs.

if they've opened tickets, it would be in tbltickets... I would imagine if they weren't existing clients (or logged in as such) when they submitted the ticket, then the 'userid' value will be 0 (any other value and they're existing clients)...

[Teknikl]

Ah yes, tbltickets it is! I was on sheet 1/3 on the tables in phpmyadmin duhh. thanks! I exported from phpmyadmin as csv.