Defining PDW Import Layouts

Use the PDW Import Maintenance screen to map your electronic data to the associated metadata elements in the Product Data Warehouse (PDW) Catalog.

To import data from electronic files into the PDW, you need to define the record layout of these files for the system. Use the Import File Layout screen to define a layout ID for the record, describe the fields in the record, and choose the record type. For each file layout, define field names, positions, and format. You can also translate any field to another value using the Translate hot key.

From the Tools > Product Data Warehouse (PDW) menu, select PDW Import Maps to display the PDW Import Maintenance screen.

In the Layout ID field, press F10 to select a current layout or type new to create a new layout.
At the NEW prompt, press Enter to indicate that you are defining a new layout.

The system displays the PDW Import File Layout screen and populates the Layout ID field with the name you entered on the PDW Import Maintenance screen.

In the Description field, enter a name to describe the file you are importing.

Note: When you search for the layout during data import, this layout description displays to the right of the import ID.

In the Record Type field, press F10 and select Fixed or Delimited.

Your selection in this field determines the entries and fields on the remainder of the screen.

If the record type is Fixed, complete the following fields:

Field	Description
Data Identifier	An alphanumeric name that identifies the field for the imported data. Note: You cannot use "Key" as a data identifier. This word is reserved for Eclipse internal use only.
Start Pos	The beginning location for the record data. This location follows the last characters of header information. For example, if the header has 50 characters and you want to begin importing data immediately after the header, enter 51 to begin the record at the first position after the header.
Record Length	The number of characters in one record. For example, enter 1000 if each record contains 1000 characters.

For each field you want to import, complete the following columns:

Field	Description
Start	The starting position in the record from where the system pulls the information for the designated field. For example, enter 1 for the system to pull information from the beginning position.
Length	The number of characters in the designated field. For example, enter 50 for the system to pull the information from positions 1-50.
Format	Press F10 and select one of the following formats for the field entry if you want to assign a format to the field's entry: MR# – Masks right the indicated number of decimal positions. For example, if you are importing the numbers 236 to represent the dollar amount $2.36, select MR2 to insert a decimal point two positions to the right of the ending digit. D2/ D4/ – Masks the indicated number of spaces for dates.

Note: The Pos column does not apply to the Fixed format.

If the record type is Delimited, complete the following fields:

Field	Description
Data Identifier	An alphanumeric name that identifies the field for the imported data. Note: You cannot use "Key" as a data identifier. This word is reserved for Eclipse-use only.
Delim Char	One of the following field delimiters: The ASCII character. A caret (^) followed by the ASCII number of the character. Tab for the tab character.
Envelope Char	If the text in each field is enclosed by an envelope character, such as quotation marks, enter the character in this field.

For each field you want to import, complete the following columns:

Field

Description

Pos

The field's position within the record.

Format

Press F10 and select one of the following formats for the field entry if you want to assign a format to the field's entry:

MR# – Masks right the indicated number of decimal positions.
For example, if you are importing the numbers 236 to represent the dollar amount $2.36, select MR2 to insert a decimal point two positions to the right of the ending digit.

D2/ D4/ – Masks the indicated number of spaces for dates.

Note: The Start and Length columns do not apply to the Delimited format.

To create a translate statement for a data identifier in the layout, select the data identifier and use the Translate hot key.

Map the PDW Import Data for your files.
Press Esc to save the layout and return to the PDW Import Maintenance screen.

You can now map the data import layout to the PDW.