How to import Survey data from ServiceDesk Plus to Analytics Plus?
A recent research revealed that 96% of unhappy customers don't complain but, 91% of those unhappy customers leave and never come back. That is sad, isn't it?
That brings me to this topic!
As you know, currently, Analytics Plus doesn't support Survey data from ServiceDesk Plus out of the box. However, Survey module will be supported in one of our future releases but, we know how important it is to you.
"Where there is a will, there is a workaround"
So, here you go finally! The steps to import Survey data and run advanced analytics.
To set this up, you will need-
- To find out the port on which your ServiceDesk Plus' database is running. If you have integrated Analytics Plus with ServiceDesk Plus, check database_connection_params.conf file to find out the connection details.
2. Network connectivity between your Analytics Plus server and ServiceDesk Plus server. You should be able to connect to the ServiceDesk Plus database port from the Analytics Plus server. You can use Telnet or Putty to check the connection.
If ServiceDesk Plus and Analytics Plus are running on the same server, the connectivity should already be there.
Steps to import survey data
Text Instructions:
Step 1:
Click New and choose New Table / Import Data.
Step 2:
Click Local and Cloud Databases.
Step 3:
Fill the database server details for the connection in the following section and click Next. (In this case, we have chosen Postgres as example)
Step 4:
Choose Custom Query (radio button) and paste the custom query(from attachment) inside the query editor.
Step 5:
Type the table name(Survey_localDB) and choose the proper datatypes for the columns in the preview. Click Next to proceed.
Below are the datatypes for the columns.
Step 6:
Schedule the import and click create to complete the import
Step 7:
Open Survey_LocalDB Table, and select "Request ID". Now, choose " Change to Lookup column" from Column properties drop down
Choose "Request ID" from the Request Table. This is done to link the survey data with the rest of the request related fields.
New to ADSelfService Plus?
Related Articles
Change module data : Import into Analytics Plus
Change module data : Import into Analytics Plus Note: When Analytics Plus officially supports Change module integration Out of the box, then these imported tables and reports might get overwritten. Please ensure to name the table as 'Change_localDB'. ...How to import description field details from ServiceDesk Plus to Analytics Plus?
Description details from the Requests' module are not available out-of-the box in Analytics Plus as it might contain HTML contents and cannot be displayed properly for reporting. However, if you wish to import description details into Analytics Plus, ...Steps to import Archived Request into Analytics Plus
By default, we don't import archived request details into Analytics Plus but we are working on a model to import these details out of the box and will be available in one of our future builds. Meanwhile, please follow the below text instructions Step ...Why does Analytics plus import less number of tickets from Servicedesk Plus?
While integrating Servicedesk Plus with Analytics Plus, only few rows/tickets are imported into Analytics Plus, while the Servicedesk Plus actually has more number of tickets. The primary reason for this behavior is that the date chosen to ...Importing Projects Module data into Analytics Plus
We are yet to sync 'Projects' module's data into Analytics Plus. Meanwhile, you can use custom queries to import those data from ServcieDesk Plus. Step 1: Login into Analytics Plus and open ServiceDesk Plus database. Step 2: Click 'Import Data' and ...