Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Adeptia Connect offers you two kind of interfaces (textual and graphical) to create and use mapping rules while mapping the source and destination elements. The interfaces are known as "Textual Rule" and "Graphical Rule". The graphical interface makes it easy for you to see the graphical representation of elements and allows you to perform mapping by connecting source element to any target element or to any mapping functions. Applying mapping rule is also very convenient as you can see the functions graphically and use the context menu options to connect to both source and target elements.
This section guides you on how to use the Graphical rule option while mapping the elements and also introduces the different components of this option.
Table of Contents | ||
---|---|---|
|
Elements of Graphical Rule
The Mapping Expression area has a floating menu that contains two options for you to switch between the Graphical and Textual rule. You can drag this floating menu anywhere in the Mapping Expression area.
Graphical elements are components which are used to represent any source, destination, mapping function, or parameter elements visually in Mapping Expression area. The following types of annotations described describe the type, behavior, and functioning of the graphical interface and their elements.
- Floating Menu
- Inputs
- Label
- Element type
- Context Menus
- Menu
Image Added
Floating Menu
Floating menu contains two options for you to switch between the Graphical and Textual rule. You can drag this floating menu anywhere in the Mapping Expression areaInputs
The number of inputs a mapping function or a target element can have. Also, you can drag a line from input element to this section to use that as an input in this mapping function /or target element.
Label
The name of the element.
Element
Typetype
Type of element being used in the mapping rule. The following list explains the types of elements:
Element type | Description |
---|---|
f(x) | A mapping function, variable, custom method, key function, context variable, connection variable, etc. |
S | A source element. |
D | A destination element. |
T | An XSL Template. |
VM | A Value Map. |
C | A Constant value. |
Context Menu
Context Menu options are used to perform the following actions:
Image Added
- To draw the connecting lines to map an element to another element(s).
- Remove an element/box To remove the field/function from the Mapping Expression area.
- More Menu To go into More menu option. It contains the following action items:
- Information option to know the details about the element.
- Remove Mapping option to remove the mapping from the element.
- Add As Local Variable option to add the the element's syntax/expression as a local variable.
Image Removed
Applying mapping functions using Graphical Rule
Mapping Expression tab gives you two interfaces, Textual and Graphical, to perform the mapping. By default, the Graphical Rule is active.
Tip |
---|
For quick understanding, you can take a look at this video explaining the concept discussed herein. |
Image Added
Note |
---|
You can switch to the Textual Rule interface by clicking the Textual Rule Image Added icon in the floating menu. A warning message is displayed asking for your confirmation, click Yes to switch to Textual Rule. To perform mapping in Textual Rule interface, click refer to this document. |
You can use the option, Graphical Rule, available under the Mapping Expression tab in the web mapper.
- Ensure that the source and destination layouts are loaded and all their elements are listed under their respective nodes.
Select a destination element which you want to map.
Tip Until you select a destination element first, the Mapping Expression tab will be remain grayed out. Click Mapping Expression tab at the left bottom of the screen.
The destination element that you have selected will be visible in the mapping expression area.- Double-click a source element that you want to map with to the destination element.
Click a mapping function that you want to use and select the desired sub-function and use it to map the source and destination elements. For example, using you can use the Concat sub-function.
Note You can also add a parameters parameter in the mapping expression area by double-clicking the parameter's name in the Parameters panel. Click String mapping function and select Concat sub-function.
Once you have all the corresponding graphical elements (source elements, destination element, and mapping sub function) available in the mapping expression area, do the following:Tip You can drag and reposition the graphical mapping elements anywhere in the Mapping Expression area. - Click each of the source elements and select the Image Added icon from the Context Menu to connect the source with the respective Inputs of Concat sub-function.
Click the Concat sub-function and select the Image Added icon from the Context Menu to connect with the destination element.
The source elements are now mapped with to the destination element using Concat sub-function and the mapping is visible in the mapping panel.
Image AddedTip You can reposition the entire mapping within the Mapping Expression area by clicking anywhere and moving the cursor.
You will be notified of an error message in the Comments section if the mapping function and destination element does do not have the proper mapping.
Anchor | ||||
---|---|---|---|---|
|
Multimedia | ||||||
---|---|---|---|---|---|---|
|
Color coding of connecting lines
The color of the connecting lines depend upon the following three factors:
Color | Description |
---|---|
Green | Lines connecting two elements will be green in color if the both elements are visible in the current space of Mapping Expression area. |
Gray | Lines connecting two elements will be gray in color if any of the two elements is not visible in current space of Mapping Expression area. |
Orange | Lines connecting two elements will be orange in color if any of the elements is selected. |
Note |
---|
You can scroll up and down to view the hidden fields/elements in the Mapping Expression area. |
Adding a constant
You can add a Constant while mapping the source and destination elements. This option is visible only when you are applying the graphical mapping rule.
Perform the following steps to add a Constant:
- Click Add Constant button Image Added button located at the bottom of the Mapping Expression window.
A graphical notation for the Constant will be added to the Mapping Expression area. - Double-click the Constant notation.
Add Constant window appears. - Enter a constant value in the Constant Value field.
- Select the Add Quotes check box if the value is String type.
- Click Ok.
- Click the Constant notation and select the Image Added icon from the Context Menu to connect with the destination element.
Using Lookup
Mappingmapping function for a reference field in target
fieldlayout
When the destination element of target layout is a reference field, the Mapping Expression feature gives you an additional option of Lookup Mapping on the floating menu.
Lookup mapping function is used to set the dynamic value for the reference field by searching a value in the source field that matches the corresponding record of a destination field. For example, if you know the Account name at the source and do not know its respective ID, you may use the Lookup function and find it.
The Lookup function is supported for the following business applications:
- BigCommerce
- FreshBooks
- Magento
- QuickBooks
- Salesforce
- Service Now
- Xero
- Zendesk
Perform the following steps to use the Lookup mapping function:
- Select the reference field element for which you want to use Lookup mapping function.
Click Mapping Expression tab at the left bottom of the screen.
The Lookup option will be become available on the floating menu and you get options in the mapping expression area to choose the reference account.- Select the Lookup option.
Image Added - Perform the following steps to define the criteria based on which the reference field value will be fetched:
- Select the destination field for which you want to match value at source from the Target Field.
Select Equals operator from the Condition.
Note You will find other operators in case of Service Now application only. Depending on the selected Target Field type (integer, boolean, string, date/time, reference, and GUID) the operators will differ. Select the source field that should match the value of the selected destination field from the Source Field.
Note You can select multiple fields if you have selected is one of or is not one of operator in the Condition drop-down list. You can select two fields only if you have selected between operator in the Condition drop-down list.
Panel | ||||
---|---|---|---|---|
| ||||
What's newBest practicesTraining guidesFrequently asked questionsAdeptia Connect APIsAdeptia security report |