Add Individual Entries | Archive Entries | Import Data | General Import Guidelines
You can load information regarding the producers, projects, and vendors that you work with into COI Track for use in managing your certificates.
Add Individual Entries
- Select COI Track from the Applications menu in the platform navigation bar
- Select Producers, Projects, or Vendors from the Setup menu in the COI Track navigation bar
- Click the New button in the upper-right
- Enter the desired information
- Required fields are marked with a gold border
- Click Save & Close when finished
Archive Entries
- Select COI Track from the Applications menu in the platform navigation bar
- Select Producers, Projects, or Vendors from the Setup menu in the COI Track navigation bar
- Check the box to the left of the desired entries
- Click the Archive button in the upper-right
You can view archived entries by clicking the Archived button in the bottom-right. Archived entries are saved until they are deleted or restored by a user.
Import Data
- Select COI Track from the Applications menu in the platform navigation bar
- Select Producers, Projects, or Vendors from the Setup menu in the COI Track navigation bar
- Click the Import button in the upper-right
- Click the Download Spreadsheet link in the Import Data panel
- Fill out the spreadsheet in accordance with the instructions in the Instructions tab and save it to your computer
- Click the Select File button, then browse to and select your updated import spreadsheet
- Click Import to begin uploading data
General Import Guidelines
- Imports are site-specific! Be sure to select the appropriate site before beginning an import.
- Required fields are indicated by shading the header row yellow in all import spreadsheets. Some additional fields will be required depending on the optional fields that are entered. For instance, entering data in an optional Line 1 Address field will cause the City, State, and Zip Code for that address to be required also.
- Notes are included in the header of columns that require data in a specific format and are indicated by a red triangle in the top-right corner of the cell.
- Altering the structure of the import spreadsheet, such as by adding or removing sheets or columns, may cause the import to fail.