The first time you run the PDW Import Utility, use the Preview Report to view how the data from your data source will populate the Product Data Warehouse (PDW) Catalog. When you run the utility in Preview mode, the system places the report in your Hold file.
On the report, each product record populates one row. The product record ID precedes the product data.
As you review the preview report, be aware of the following:
The report shows that x number of items were imported. The x number varies depending on the number of bytes and width of the imported file bins. Do not be alarmed when you see 27 items on the first load and eight items on the next load.
When importing from DOS, if you do not remove column headers from a .csv or .txt file, the first item populates with all of the column headers from the data source. So remove column headers on .csv and .txt files.
The report displays one of the following messages:
Found match data will map to - Indicates that this data already exists in the PDW Catalog. You should receive this message if you are attempting to match to existing data.
No match found will map to - Indicates that this data is new to the PDW Catalog. You should receive this message if you are not attempting to match to existing data.
To view the PDW Preview Report:
Access your Hold file in one of the following ways:
Click the Your
Hold Entries icon from the Solar Desktop icon bar:
From the System > Printers menu, select Your Hold Entries.
From any screen in Eclipse, press Shift-F2.
Double click the report title you want to preview.
See Also: