The Fields Mapping
dialog display when you are importing data into a catalog from a Excel
spreadsheet. Before the data can be imported, the fields in the Excel worksheet
must first be mapped to their corresponding column of the table in the catalog.
When a new Map record is added to the Fields Mapping
dialog, click in the column fields to display a drop down list of selections to
To add a New Mapping, click the
This will add a new record and allow you to define the
Click in the Sheets field and select a sheet option from
Click in the Sheet Columns and select a field from the
drop down list (shown below), then select an EC field from the Table Columns
Continue mapping the Sheet Columns to the Table Columns as shown
When finished mapping a sheet, click Import Data to
import the data to the catalog.
While importing user might have data in different formats
and want to apply lookup or customize data while importing from excel.
Use Lookup Tables
If you right click in a mapping field, the
Use As Lookup
dialog lets you mark the mapping
entry to map the value from defined lookup information. Below the highlighted
mapping entry is applied "lkup_Imperial_Sizes
show sizes in fractional form. (e.g. size 0.5 as 1/2).
With the help of expression based customization user can
format data while importing into the catalog. For example if I want to
field to have _IM attached
at the end user can edit and apply the change by clicking the green check icon
as shown below.
Arithmetic expression allows user to customize data based
on preliminary arithmetic operators (+, -, ;, *, and /). These arithmetic
operations are performed on Numeric type of columns to provide numeric result
otherwise it acts as text expression.
For example, if you want to multiply the
by factor 5 on importing to
column then use
" expression (without
quotes) to get the desired results.
Preview Mappings Applied
icon to review the results of the
defined mappings in the
Preview Mappings Applied dialog.