Difference between revisions of "Exporting Call Profiles"
Jump to navigation
Jump to search
(Created page with "From the main Supportworks client * 1. Go to "Database Searches" * 2. Click on new and for name put in call profile. For the sql query, please put the following: ''' SELECT...") |
|||
Line 1: | Line 1: | ||
− | From the main Supportworks client | + | From the main Supportworks client and follow the steps below: |
+ | |||
* 1. Go to "Database Searches" | * 1. Go to "Database Searches" | ||
* 2. Click on new and for name put in call profile. For the sql query, please put the following: | * 2. Click on new and for name put in call profile. For the sql query, please put the following: | ||
− | ''' | + | |
− | SELECT code, info as Profile from pcdesc order by info''' | + | |
+ | '''SELECT code, info as Profile from pcdesc order by info''' | ||
+ | |||
* 3. Click on OK | * 3. Click on OK | ||
Line 12: | Line 15: | ||
* 5. You can proceed to export to a csv file. | * 5. You can proceed to export to a csv file. | ||
+ | |||
Please bear in mind, if you have a lot of code profiles, then this will just show you the first 100. To show everything, on the database search, if you scroll down, you have a limit search results to:, you will see it is 100, put in a bigger value there | Please bear in mind, if you have a lot of code profiles, then this will just show you the first 100. To show everything, on the database search, if you scroll down, you have a limit search results to:, you will see it is 100, put in a bigger value there | ||
Also if you wish to export the resolution profiles, on step 2, for the sql query, you just need to put in for that: | Also if you wish to export the resolution profiles, on step 2, for the sql query, you just need to put in for that: | ||
+ | |||
'''SELECT code, info as Profile from rcdesc order by info''' | '''SELECT code, info as Profile from rcdesc order by info''' |
Latest revision as of 14:32, 20 June 2018
From the main Supportworks client and follow the steps below:
- 1. Go to "Database Searches"
- 2. Click on new and for name put in call profile. For the sql query, please put the following:
SELECT code, info as Profile from pcdesc order by info
- 3. Click on OK
- 4. Now double click on the where it says Call Profile, and you will see a list under "Search Results". Right click on one of them and you will have a popup box. Select "Export Data | All Rows".
- 5. You can proceed to export to a csv file.
Please bear in mind, if you have a lot of code profiles, then this will just show you the first 100. To show everything, on the database search, if you scroll down, you have a limit search results to:, you will see it is 100, put in a bigger value there
Also if you wish to export the resolution profiles, on step 2, for the sql query, you just need to put in for that:
SELECT code, info as Profile from rcdesc order by info