Excel Data Mappings

Input

Description

Import

Allows the value to be pulled from the spreadsheet

Property Name

The input value that will be populated from the spreadsheet

Import Type

This will determine how the values are populated. They can either be through the spreadsheet or by defining a custom value.

Value/Column Index

The value that will be imported for each program entry. This input is dependent on the import type:

Spreadsheet: The number defined will import the corresponding spreadsheet columns data.

Column indexes are based on the top left cell entered.

Constant: The value defined will be imported for each entry.

Spreadsheet Unit

The unit that is used in the importing spreadsheet. This is important because Eriksson programing using specific internal units.

Failure to properly specify this unit may cause erroneous value conversions on import.