Mapping PDW Data Elements to Eclipse Dictionary Items

Before you export data into the Eclipse Product file, you need to define export maps to ensure that all values for your metadata items follow the correct path to a dictionary item. Use PDW Data Export Maintenance to map Product Data Warehouse (PDW) metadata items to dictionary items.

Note: You must be assigned the PDW.IMPORT.EXPORT.MAP authorization key to view or edit the import maps.

To map metadata items match them to the correct dictionary item. For example, you would match the metadata item UPC# to the dictionary item UPC. For metadata items whose mapping is not as intuitive, use the PDW Data Viewer to view actual metadata item values. These values can help you determine which dictionary item the metadata item most matches.

The system provides a default map to help you get started in the export mapping process. On the default map, the system suggests the dictionary items most often mapped to. You must enter the metadata items to map to the dictionary items. You can also edit any dictionary items entered on the default map.

Like Import Map Maintenance, Export Maintenance also allows you to create translate and convert statements and filter the export. You can also assign priority to multiple metadata items which are mapped to the same dictionary item. This priority tells the system to use the item with highest priority when exporting.

Use Export Maintenance to run a sample export in order to ensure that you have mapped the metadata items correctly before running a true export.

To create the default export map:

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

In the Export Map field, press F10 and select Default from the displayed list.

The system populates the Description field with Default Map and the Eclipse Dictionary column with all suggested dictionary items to map to metadata items. Leave the Trigger Meta and Value(s) fields blank.

Use the following columns to create a default export map:

Columns	Description
Eclipse Dictionary	Do the following: To delete a dictionary item, select the item and press Alt-Delete. To add a dictionary item, position the cursor on a blank line, press F10, and select a dictionary item from the list. If necessary, from the displayed list you can press F10 again to display a secondary list of archived dictionary items. Note: Pressing F10 does not display i-descriptors.
Br/Tr/All	If the dictionary item is branch or territory specific, enter that branch or territory. The system enters ******** if the dictionary item is not branch or territory specific.
Update	Enter one of the following: N (nonstock or new) - Indicates the item is to be updated when new items are created in the Primary Product File through Nonstock Entry or PDW Mass Product Imports. B (batch or both) - Indicates the item is to be updated when the Product File Batch Update program is run and when new items are created.
Priority	If you are assigning more than one metadata item to a dictionary item, enter a priority number for the metadata items to indicate which item to export when both items exist in the PDW Product file. High numbers have higher priority.
PDW Meta Item	Enter the metadata item to map to the matching dictionary item.
File Name	Enter the Eclipse file name to use for the export.
Properties	The Meta Data Properties, such as Eclipse Dictionary, Property, and Setting. Double click the icon to display the values. An "i" icon indicates properties have been applied. If a plus sign displays, no properties have been added.
Translate	Add a translate statement, if needed. This option allows you to get data from another location or source to bring it into the system before when the system retrieves the information.
Convert	Add a conversion statement, if needed. This option allows you to adjust the value of the data after the system retrieves the information.

Repeat steps 3-7, as needed, to add additional dictionary items.
Press Esc to save changes and exit the screen.
Run the Eclipse Product File Batch Update Utility.

More Options for Creating the Default Export Map

The PDW Export Maintenance screen also offers these options.

Hot Key / File Menu Option	Function
View	Use to view the mapping between metadata items and dictionary items by branch or territory.
Props	If highlighted in red for the selected dictionary item, use to enter settings for the dictionary item's properties, such as multi-valued or branch specific properties. Under the Settings column, enter the line or branch to use.
Translate	Displays the PDW Translation Table for the selected metadata item. Use this table to modify incoming or outgoing data elements in the PDW to match required formats.
Convert	Displays the PDW Conversion Table for the selected metadata item. Use this table to change the values of incoming or outgoing data elements in the PDW.
Dict	Displays the Dictionary Maintenance screen for the selected dictionary item. View the dictionary item's properties on this screen.
Meta	Displays the PDW Metadata Maintenance screen for the selected metadata item. View the metadata item's properties on this screen.
Sample Item	Use to view the actual data items that will be mapped according to the defined map.
Copy	Use to copy the current map to a new map. At the New Export Map ID prompt, enter an ID for the new map.
Delete	Use to delete the currently displayed export map. The system prompts you to confirm the deletion.