You can create a synonym file manually,
or by generating a synonym file from the information that is contained
in a Microsoft Excel spreadsheet,
using the following set of instructions.
The following set of instructions describes how to create
a synonym file where the original mapping requirement is written in Microsoft Excel. If your original
requirement is written in a table in Microsoft Word you must copy and paste
the table into Microsoft Excel
before you begin.
Amend the process to allow for extra facilities
that your enterprise uses.
- Select the section of the Microsoft Excel spreadsheet that you require. For example, if you have a Product that you want to map to a
Part number, select that section of the spreadsheet.
- Remove all columns from the spreadsheet, except the ones
containing the input field name and the output field name. You
might have to edit some of the cells. For example, if your mapping
instruction includes the phrase based on, remove
this phrase.
- If the input or output fields contain paths, remove the
paths to leave only the short names of the item. However,
it is helpful to sort the column before removing the paths. Sorted
path names can indicate which is the best input or output to select
when invoking the action. If all the interested inputs (or outputs)
start with the same path prefix, you might consider selecting the
lowest input (or output) node in the tree which has that common path
prefix.
- Remove all rows that do not have an input field name and
an output field name. For example, if you have an obsolete
product that no longer has a part number and you have put n/a in
the input, remove that row.
- Select the Save As function in Microsoft Excel to save the
spreadsheet into a format that is supported by IBM® Integration
Toolkit. You can
use either a Tab delimited .txt file or a comma delimited .csv file.
A comma delimited file can be opened using Microsoft Excel and it looks like the original Microsoft Excel file; the file
can also be viewed using a text editor.
- Create the mappings using the synonym file. Select the
options in the Auto Map wizard that match your
requirements; for example, select the default options of Map
all simple descendants of the selected elements and Alphanumeric
characters (Letters and digits only). When
you have chosen these options, select Create transforms
when the input and output names are matched to synonyms defined in
a file.
If you need to map same-name inputs to outputs,
and the synonym file does not contain rows with those names (for example
a row with car,car), select the Create transforms
when the names of inputs and outputs are the same option,
in addition to Create transforms when the input and output
names are matched to synonyms defined in a file.
You
can select both Create transforms when the names of inputs
and outputs are the same and Create transforms
when the names of inputs and outputs are more similar than,
in addition to Create transforms when the input and output
names are matched to synonyms defined in a file, if your
synonym file does not contain a row color,colour and you want
to map between them.
- Click Finish.