With the export utility, cases from SupportCalls
folders (from Outlook) can be exported out to Microsoft
Access, MS SQL or other ODBC- compliant database such as
Oracle, MySQL etc. Choose what type of cases are eligible
for export - ongoing, resolved or both. You can choose any
number of fields of your interest including the case body
field (with HTML format) for export. Exporting cases to a
relational database serve many purposes, one primary reason
being able to extract reports and statistics on Help Desk
activity, as well as for in-house data warehousing and
mining requirements.
Select the fields to be exported to the selected
database.
The following fields are available:
Case Number
Date Created
Asset Field4
*
Subject
Date Modified Last
Asset Field5
*
Body
Date Due
Custom Field1
*
Problem Category
Date Closed
Custom Field2
*
Problem Type
Technicians
Custom Field3
*
Caller Name
Status
Custom Field4
*
Caller Email
Origin
Caller Company
Author
Caller Address
Time Spent
Caller Phone
Asset Name
Caller Mobile
Asset Field2
*
Caller Department
Asset Field3
*
*
- the actual user
specified titles will be displayed instead.
Enable export of the HTML body field. There
are two formats that is available for the body field
- plain text or HTML.
Select the case type to export - Ongoing,
Resolved or both.
Specify the database type to export.
The following databases are supported:
Microsoft Access
Microsoft SQL Server
Oracle database
MySQL database
For Oracle database and MySQL, you would
require the proper ODBC driver installed on
the particular system.
The database server name. This is not
applicable if you have selected a Microsoft Access
database option.
Specify the name of the database. If a
database exists with that specified name, it would
be overwritten.
Specify the user name credential of the database
server.
Specify the password credential of the specified
user.
