ltellier

Looks like the only way is to build up a SQL query and export the result into a CSV file. Does anyone have achieved such SQL query ? Thanks, - Luc

Hello guys, Is there a way to easily export addons products such as the way we are exporting main products ("Reports" -> "Exports" -> "Products/Services") ? The report generated by "Products/Services" does not include add-on products. Thanks, - Luc

That did the trick ! Thanks for your help. - Luc

Yep; it runs on a 5 mins basis.

Hello guys, I have created an escalation based on the following conditions : - Departments : Support, Installation - Statuses : Answered - Priorities : Low, Medium, High - Time Elapsed : 14400 minutes (10 days) The action should be the following : - Status : closed - Notify Admins (checked) However, whenever the script runs, tickets that are older than 10 days aren't getting closed. Am I missing something ? Thanks, - Luc

After further verification, it appears that indeed; the problem was with the email address assigned with the department. It wasn't matching the email address where mails were sent to. Thanks for pointing this out ! - Luc

That's odd... I am definitely sending the email to sales@ but for some reason, WHMCS caught it as if I was sending it to support@ : ------------------------------------------------------------------------------------ Viewing Imported Email Message To: support@someemail.com From: Someone «some@email.com» Subject: test Status: Ticket Imported Successfully test ------------------------------------------------------------------------------------ Is there a way to identify the email headers that are caught by WHMCS ? Thanks, - Luc

Hello guys, WHMCS : Version: 5.1.2 I am trying to configure email piping using pop3. WHMCS is able to fetch emails from our specific email accounts, but, for some reason, tickets will only be created in the first department. If I change the department order, tickets will be created in the first department, no matter what email account is assigned to that department. eg.: 1) Support (support@someemailaddress.com) 2) Sales (sales@someemailaddress.com) [...] If I do send an email to sales@someemailaddress.com, ticket will be created in the Support department. If I change the order (Sales being the first department), and send an email to support@someemailaddress.com, the ticket will then be created in the Sales department. I'd like new tickets to be created to the proper department / email account. If you guys need more details, please do not hesitate to let me know. - Luc