Exporting Call Profiles

From support-works
Revision as of 14:31, 20 June 2018 by Nanette (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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 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