Turning Technologies Triton Web - 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
• Staff
• Participants
• Programs
• Participant Lists
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 Country Codes 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