Seaward PATGuard Elite SQL - Manual (Page 24)

Seaward PATGuard Elite SQL 2 User Manual
- 22 - Rev. 1.4
To Summarise:
Asset Group is used to reference an Asset Group within the database.
Site and Location can be used to reference existing Sites and Locations or create new Sites and Locations. Non
SSS format data only.
All other Options (Asset Description, Person, Make, Model, Serial Number, Repair) fill out the appropriate
field in the Asset Details or Test Details window as appropriate. Person will be ignored for SSS format data and
will override any Person setting in the Download dialog box.
No Options setting (other than Asset Group and Location) will cause any field in an existing Asset to be
overwritten.
SSS Format Data
The Supernova, Europa and PrimeTest 300 / 350 tester families have two download formats; SSS and ASCII text.
As the SSS format contains all information, this program will only accept Download to Database in the SSS
format from these testers. The ASCII text output is for use with non-Seaward programs.
The SSS output contains Site, Location, User (Person) and Testcode this affects the way Options are processed as
follows:
Any Site and Location Options settings will be ignored, as this information is taken direct from the Test Result for
SSS format data.
Make, Model and Serial Number can be processed using Options, as these are not contained in any Test Result.
Asset Group can be processed using Options. If the referenced Asset Group does not contain a Testcode or the
Asset Group option was not used, the Testcode will be added to a new Asset or update an existing Asset.
Repair information will be placed in the Test Type column of Test Details with a Status set to Repair.
The Test Details screen is not subject to Options settings (other than Repair) therefore the Testcodes and User
information is derived from the SSS output.
Short Codes
The lower half of the screen is used to save time entering information while PAT testing. It enables a code up to
three characters to be set which can represent regularly typed text. There is no limit to the number of codes that can
be set.
To enable this action:
1. Check the Use code abbreviations on tester check box.
2. Use the Show codes for drop down and select the appropriate Asset Details field.
3. Select Add to enable the code and value fields.
4. Enter a code up to three characters in the Code field.
5. Enter the text that the code represents in the Value field
6. A third column to enter a Cost is provided for Repair selection
Other codes for other Asset Details fields can be entered before saving the settings with the OK button. When
using Short Codes at the tester: prefix the code by 9 so that PATGuard Elite SQL will recognise the value as a
Short Code.