Data Mapper Screen (Magic xpi 4.14)

Once you complete the file selection process, Magic xpi retrieves the information and displays the data graphically in schema form.

To map the data, you must first enter a Source and Destination and make sure that the properties are entered for each. If you have not yet entered the Source or Destination properties, click here for more information. To expand a node, park on it and press the PLUS SIGN (+) or right-click on it and select Expand. To collapse a node, park on it and press the MINUS SIGN (-) or right-click on it and select Collapse. To expand a parent node and all its child nodes, park on the parent node and press the asterisk (*) button, or right-click on the parent node and select Expand All.

The Data Mapper screen lets you map multiple Sources into multiple Destinations. Multiple Sources can be used to create a single Destination and multiple Destinations can be created from a single Source.

The Data Mapper can work with existing XML Destination documents and append the new mapping to them.

To connect and test the nodes:

1. Right-click on a node on the Source side, and select Connect.

2. Drag the mouse to the node on the Destination side that you want to connect to, and click on it. A line is drawn from the Source node and connected to the Destination node to visually indicate the mapped data.

To make all possible simple connections between two nodes with the same name that contain simple elements with the same matching name in both the Source and Destination, select Connect All > Simple from the shortcut menu. All connections for all nodes with the same matching name in the Source and Destination nodes are made. (The prefixes are ignored.)

Connect All menu also provides other two options, namely Fuzzy and 1:1. To know more about these options, click here.

For example:

• If the Source node contains the simple elements:

• • Name

  • Address

  • Email

  • Phone

  • Cell Phone

• And the Destination node contains the simple elements:

• • Name

  • Address

  • Email

  • Telephone

  • Mobile

• Only these elements are connected:

• • Name

  • Address

  • Email

Related Topics

Node Properties

Data Mapper Screen – Color Coding and Display

Replicating Mapper Nodes

Undo and Redo Actions in the Data Mapper Screen

Data Mapper Rules

Deleting Connections

Mapping Execution Order

Mapping Using the Expression Editor

Data Mapper Filter

Data Mapper - Connect All

Save/Load Connections

Mapper Alerts

Data Mapper Troubleshooting