User guide

Triton Data Collection System

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.

MANAGER_ID_FEDERAL 50 The federal government’s identification

number for the manager.

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