Mapping fields from import file to IEE

Where possible, import task templates include a Custom Field Mapping Group parameter that enables you to customize the mappings between the import data and the IEE database. For example, you can map an Account field in the import file to the AccountNumber field in IEE.

1. Next to the Custom Field Mapping Group parameter, click Edit.

   Defines mapping groups, which are useful if you have multiple Integrator or PremierPlus4 systems. You can create a custom field mapping for each system by creating a new mapping group. Import files have key fields in them, such as AccountNumber, RouteID, PremiseNumber, MeterNumber, and RegisterNumber. In a flat-file import such as PremierPlus4 or Integrator, these fields should appear in a specific place in the import file. Sometimes the IDs are not filled-in or are placed in a different location. IEE supports mapping those fields.

   Click Edit to open the dialog and modify the mappings.

2. Select a field from the Mappings list and enter its values, then click OK. If the import file does not specify a Commodity Type or a Meter Multiplier, IEE uses the default value.

Sometimes information you need to upload doesn't have a specific field, and some customers use a different field to collect information. This data can be stored in the "Pass through field." Map the incoming data to a specific field or define a starting location with a specific length for data upload.

Related topics:

• Import task functions

• Creating missing configuration from import task template