ETL Template Worksheets

ETL Example Templates : ETL Template Worksheets

ETL Template Worksheets

The following worksheets are included on separate tabs in a typical ETL CSV template:

Instructions

Shows basic instructions for creating an ETL import file, including a legend that describes the colors and formatting for the template.

Template

Outlines the formatting for the ETL template. It shows column names, descriptions, types, and whether or not the field is required. Most templates also list the table and field names that each column corresponds to in a database.

Sample_CSV

Provides an example of a sample .csv file that imports successfully into a Yardi database.

Screen Shot

Contains a graphics-capture of the front-end Voyager screen that corresponds to the ETL template. It identifies which template column headers are associated with the fields on the screen.

Instructions	Shows basic instructions for creating an ETL import file, including a legend that describes the colors and formatting for the template.
Template	Outlines the formatting for the ETL template. It shows column names, descriptions, types, and whether or not the field is required. Most templates also list the table and field names that each column corresponds to in a database.
Sample_CSV	Provides an example of a sample .csv file that imports successfully into a Yardi database.
Screen Shot	Contains a graphics-capture of the front-end Voyager screen that corresponds to the ETL template. It identifies which template column headers are associated with the fields on the screen.