Import templates, Sites – Turning Technologies Triton Web User Manual
Page 45
Triton Data Collection System
43
tritondatacollectionsystem.com/triton-support
IMPORT TEMPLATES
The template files are CSV files that can be opened in Microsoft Excel. Use the template to enter the appropriate
information that corresponds to the column headers.
•
•
•
•
•
Sites
A Site upload file may not contain more than 5,000 rows.
Column Header
Max Field
Length
Description
Required
SITE_NAME
50
The name used to identify the site.
Yes
SITE_ID
20
The unique identifier for this Site on Triton.
Yes
SITE_PRIMARY_
TELEPHONE_NUMBER
50
The primary telephone number for this Site.
No
SITE_ADDRESS_LINE_1
50
The Site’s main street address.
No
SITE_ADDRESS_LINE_2
50
The Site’s secondary street address.
No
SITE_ADDRESS_LINE_3
50
The Site’s secondary street address.
No
SITE_ADDRESS_LINE_4
50
The Site’s secondary street address.
No
SITE_CITY
50
The Site’s city.
No
SITE_STATE_OR_
PROVINCE
50
The Site’s state or province.
No
SITE_POSTAL_CODE
50
The Site’s zip code.
No
SITE_COUNTRY
3
No
MANAGER_ID
50
The institution's identification for the
manager.
Yes
MANAGER_ID_STATE
50
The state government’s identification number
for the manager.
No
MANAGER_ID_FEDERAL
50
The federal government’s identification
number for the manager.
No
MANAGER_FIRST_NAME
50
The first name of the manager.
Yes
MANAGER_LAST_NAME
50
The last name of the manager.
Yes
MANAGER_MIDDLE_NAME
50
The middle name of the manager.
No