Extracting PDW and Eclipse Product Data

Use the PDW File Extract Utility to download data from the Product Data Warehouse (PDW) Catalog and Eclipse Product File into an ASCII formatted file.

You must design the format of how the data downloads on the PDW File Extract Utility screen. After you design the format and instruct the system to begin the extract, the system compiles all of the data into the correct format and messages you when the data is ready for download.

To extract PDW and Eclipse product data:

From the Tools > Product Data Warehouse (PDW) menu, select PDW File Extract Utility to display the PDW File Extract Utility screen.

In the Design ID field, enter the name for your extract design or select a pre-existing design ID.
In the Description field, enter a description for your extract design, such as Pricing Download if you are downloading pricing information.
To download customer-specific part numbers or pricing, complete the following fields:

In the Customer field, select the customer name.
Select the Use Customer Part Numberscheck box to download only the products flagged for that customer.

Select the Print Column Heading check box to download column headings from your file.
In the Layout field, select a layout:

Fixed - Downloads the file as-is without formatting or data separation. If you select this file layout, then the next two fields are deactivated.
Delimited - Uses a selected character for separating data values in the flat files. For this file layout, complete the following fields:

Field

Description

Delimited Character

The character that separates fields of data.

Note: For a tab delimiter, type TAB.

Envelope Character

The character to use to surround fields of data.

If your data contains commas (,) and you selected a comma for your delimiting character, use quotation marks (") as the enveloping character.

Note: The Pricing Date, Pricing Branch, Qty, and UoM fields are used for pricing downloads are only activated after setting the Type column to PRC.

In the following columns, enter the file source and download layout information that you want to appear in the respective columns labeled in the Col column for your ASCII formatted file:

Field	Description
Type	The type of data to display in the respective column. Press F10 and select one of the following: PRD - Product file dictionary item. PDW - PDW Catalog metadata item. PRC - Customer price. Selecting this option activates the Pricing area and the Pricing Date, Pricing Branch, Qty, and UoM fields. PQTY - Pricing quantity. PUOM - Pricing UOM. CPN - Customer Part Number.
Dictionary/Meta Item	The dictionary or metadata item to download.
Justify	L - Left justify the data in the field. R - Right justify the data in the field.
Width	For Fixed layouts only, the number of characters to allocate to this field.
Column Heading	If you entered Y in the Print Col Heading field, the heading to display in the respective column. If you entered N in the Print Col Heading field, leave this field blank.
Format	Formatting for quantities needing decimals, such as MR2 (mask right 2 positions). Eclipse provides most formatting when it is needed.

From the File menu, select Begin or Schedule to start or schedule the file build, and exit the screen.

The phantom runs the file build and messages you when it is finished and ready for download.

More Options for Extracting Data

The PDW File Extract Utility screen also offers these options.

File Menu or Right-Click Option	Function
Select Data	Displays the PDW File Extract Selection screen. Use this screen to define selection criteria for the file build.
Column Data	If a dictionary item can be updated, use this hot key to enter properties for the dictionary item. A columned screen appears where you enter the property data.
Delete	Deletes the current extract design.
Copy	Copies the current design so you can create a new design based on the current.
Log	Displays the maintenance log for this utility.