Seaward PATGuard Elite SQL - Manual (Page 65)

Seaward PATGuard Elite SQL 2 User Manual
- 63 - Rev. 1.4
Figure 52: Download File Open – txt type
These dialog boxes allow you to set parameters for processing the file.
If the Preview checkbox is selected (only available for SSS file type) the results can be viewed and/or edited before
they are processed into the database (see Download Preview).
The Client drop down will enable Assets to be automatically moved between Sites for the selected Client, if the
downloaded data indicates a Site re-location. The program will only allow this if Asset IDs are unique across all
Sites for the selected Client. Leaving the Client set to will not restrict the download to one Client but allow
the downloaded data to be processed for the whole database (assuming Site is also set to ), these are the
normal setting.
Test Results can be sent to an individual Site, chosen from the Site drop down, or . Setting the Site field to
will allow Test Results for different Sites to be routed to those Sites. The option requires the
Usercode to be set to Site to route the Test Results to the correct Sites for non-SSS downloads.
The Usercode can be used to route multi-Site test results if set to Site and each test result contains a Site name in
the Usercode field. Or the Usercode can be used to capture additional information, for example the individual
personnel who carried out the testing. The Usercode field will only be available for testers with ASCII text output
only.
Use the Person drop down to select from registered Personnel the appropriate person who carried out the testing.
This is only required if the test results do not contain his information either directly or via the Usercode. The
Person field will only be available for testers with ASCII text output only.
The download data will be processed as if it came directly from the PAT tester.
Spreadsheet Files
PATGuard Elite SQL has the ability to create spreadsheet Asset record files of different levels of the database as a
comma separated variable (csv) file which can be opened by spreadsheet applications such as Windows Excel.
To create a spreadsheet, select a Client, Site or Location. The item selected and all lower level items will be
included in the file. Right mouse click will display the context menu. Choose Send to… then File. A Save As
dialog box will be displayed. Select the path and File name where the file is to be saved. Spreadsheet files have a
File Type of *.csv. Select Save to create the file.
Creating a PATGuard Viewer CD
PATGuard Viewer is a ‘view’ only version of the program that can be freely issued to Clients and others so that
they can view the database in real-time and print their own Reports.
Note
CD Viewer databases will be created in Microsoft Database format (*.mdb) and are not available in SQL database
formats.