Click the links to the topics outlined below to learn more information:

Managing Contacts

Importing Contacts

Exporting Contacts


Managing Contacts


Contacts can be set up independently or linked to specific customers. Besides manually keying in the details, you can import as CSV files, through the LDAP Integrator, or can obtain them through Microsoft Outlook.

If you are importing your Contacts via CSV load, please consult the Importing Contacts Guide For adding Contacts from Microsoft Outlook, consult the Microsoft Outlook Guide. If you are adding them manually, please follow the guidelines below:

If you wish though to enter your Customers and Contacts manually, this is done via the Your Company drop-down.
"your company" drop-down menuClicking on Contacts and “Add New Contact add button” will bring up the details screen in which you can create your new Contact record. There are numerous fields in which you can add as much or as little data as is required.add new contact details pageDepending on whether you are supporting internal or external IT, there are fields on the Ticket record in which you can capture end user information. Upon selecting the Customer from the drop-down list, or free typing and selecting, associated contact details including Phone No. E-Mail, Dept. and Location can be brought forward into the Ticket details on incident page

Back to Top

Importing Contacts 


HotH has the ability to load external Contact data files directly into the databases. You can therefore download data from any existing databases and populate the HotH databases.

In addition, HotH also has the ability to export your Contact data from the HotH database to a CSV file, which you can learn more about on the Exporting Contacts Guide.

The files to be imported must be flat files of comma-separated values. Each line in the text file represents a HotH record of a particular type. The first characters in each line indicate the type of record to be loaded. You should also note that special rules apply to some fields, please take advice from Support before loading new data type. You can use Import to execute a SQL string, but again please take advice from Support before doing this.

How to Import Files

In the WebServer, go to Import CSV from Settings.import csv file pageSelect the file to import records and click Import. If there are errors they will be listed. You need to review the errors. The error log is listed to the file suppdesk.err. If there are no errors you can navigate away.

In the Windows interface the Import CSV option is on the Database ribbon tab/menu. You need to navigate to where the import file is located.

Import Format

Excel column headings are supplied below to assist. You do not need to supply data for every field, just enter those you need. (Though there are some validation rules, these are not documented here.)

Dates should be entered as DD/MM/YYYY for UK format and MM/DD/YYYY if US format is in use.

Contact Record – Type CC

BReferenceUp to 40 characters, mandatory
(The Customer must exist).
CDate10 characters
If omitted, today’s date is used.
DNameUp to 40 characters
EDepartmentUp to 120 characters
FLocationUp to 40 characters
GAddress Line 1Up to 40 characters
HAddress Line 2Up to 40 characters
IAddress Line 3Up to 40 characters
JAddress Line 4Up to 40 characters
KAddress Line 5Up to 40 characters
LPost CodeUp to 16 characters
MPhone No 1Up to 40 characters
NPhone No 2Up to 40 characters
OE-MailUp to 120 characters
PFax NoUp to 40 characters
QNarrativeUp to 2000 characters
RTitleUp to 60 characters
S-WExtra Fields (pre 2002)5 fields of up to 25 characters each
XSystem IdNumeric – leave blank for new records
YSalutationUp to 25 characters
ZService LevelUp to 32 characters.
AAMobileUp to 40 characters
ABClassificationsUp to 10,000 characters
ACResponseUp to 25 characters
ADAssistantUp to 40 characters
AETime ZoneUp to 16 characters
AHJob RoleUp to 40 characters
AIE-mail TemplateNumeric
AJIP PhoneUp to 40 characters
AKArchive0 for live, 1 for archive
ALPrimary Contact0 for no, 1 for yes
AMExpiry Date10 characters (date)
AOGroup LevelNumeric
AP Leave Blank
AQNewsUp to 400 characters


Back to Top

Exporting Contacts


You can export the current Contact databases into a named file. The output records have the same layout as the corresponding Import records. This is useful if you want to create an import file; create a ‘dummy’ record, populating the required fields with discernible text, such as REF in a reference field. The exported data can then be used as a template for the import layout.

How to Export Contacts

To export data, show the Contact records in the summary and filter the list as required.

In the Webserver, navigate to Your Company > Contacts, then use the Export option in the Summary Options navigation bar; this will then offer the option to View the output. Now, you can open or save the file.exporting tab on webserverIn the Windows interface, you can export the Contact records in the summary list using Export CSV on the File ribbon tab/Menu. Additionally, in the Windows version you can use the Export CSV option on the Database menu to export more Contact records.exporting customers windowTick the Customer box, click the OK button and then choose a location and file name for the export file. The default is export.txt on the HotH directory. If this file already exists, you must confirm to replace the existing file. On completion, you can view the export file before being returned to the main window. Navigate to the bottom of the .txt file and your Contact database will be found under “Contacts (CC)“.

Back to Top