Schema Mapper screen

The Schema Mapper is used to connect, or map, variables in one data source to variables in a different data source. When you map the variables, it synchronizes their values in the two data sources.

Background and Setup

Examples

(Example) Schema Mapper
(Example) Configure an Excel Read Activity
(Example) Configure an Excel Write Activity
(Example) Create Zoom Meeting
(Example) Store Data from an eForm in Data Entities with a Data Entities Activity
Examples - Step-by-step use case examples, information about what types of examples are provided in the AgilePoint NX Product Documentation, and other resources where you can find more examples.

Good to Know

In the Schema Mapper, the source and the target variables show in a tree view in the left and right panes. You can drag and drop from one pane to the other. If you map the variables:
- A green line indicates that the data type of the source and target variables are the same and no data conversion is required.
- A blue line indicates that the data type of source and target variables are different. The data conversion is required to map the variables. To change the data types of the variables, refer to:
  - Default Data Conversion
  - Custom Data Conversion

How to Start

You can open the Schema Mapper from many places in AgilePoint NX where a group of variables in one data source must exchange data with another data source. Usually the Schema Mapper opens with a button called Map Schema.

Schema Mapper screen

Maps SharePoint fields, form fields, web methods, or other input sources to an XML schema..

Fields

Field Name	Definition
Mapping Schema	Description: Connects the schemas to your process schema. The source and the destination schemas show in a tree view in the left and right panes. Allowed Values: Read only - However, the drag and drop operations are supported to map the schemas. Drag a data node from the source schema pane to the destination schema pane: Green line - The data type of source and destination nodes matches. Blue line - The data type of source and destination nodes doesn't match. The data conversion is required to map the schemas. Red line - Specifies that the custom data conversion is required. Example: Refer to: (Example) Schema Mapper (Example) How Can I Map a Repeating Schema Element to Data Population? (Example) Create Zoom Meeting
AutoMap	Function: Maps all fields in the data source and the process schema that have the same name. Example: Refer to: (Example) Schema Mapper
Reset	Function: Deletes all connections that have been made in the Schema Mapper for this activity.
Data Conversion	Description: Specifies the data conversion between the source and the destination schema fields. Allowed Values: No Data Conversion Needed - The data type of the source schema elements matches the data type of the target schema elements, or no data type conversion is necessary. Default Conversion - The data type of the source schema elements does not match the data type of the target schema elements. This option uses a default conversion methodology. Custom Data Conversion - Uses a data conversion method you specify. If you specify a custom data conversion method, it must return the results in valid XML format. Default Value: No Data Conversion Needed Example: Refer to: (Example) Schema Mapper
Add	Opens this Screen: Custom Mapping screen Function of this Screen: Specifies custom C# code that can be used to map fields to an XML schema. Example: Refer to: (Example) Schema Mapper
Edit	Opens this Screen: Custom Mapping screen Function of this Screen: Specifies custom C# code that can be used to map fields to an XML schema.
Delete	Function: Deletes the selected custom data conversion from the list.
Back	Function: Goes to the previous screen.

Custom Mapping screen

Specifies custom C# code that can be used to map fields to an XML schema.

Fields

Field Name	Definition
Input Type	Description: Specifies the data type of an element from the source schema. Shows the data type of the source schema field does not match to the destination schema field on the Schema Mapper screen screen. Allowed Values: Read only.
Output Type	Description: Specifies the data type of a target schema data field. Specifies the data type of an element from the source schema. Allowed Values: Read only.
Method Name	Description: Specifies the name of your data conversion method. Allowed Values: One line of text (a string). Not Accepted: Spaces Default Value: Completed on the based on the data type of the selected schema fields on the Schema Mapper screen screen.
Custom Mapping Method Code	Description: Specifies the code for the custom data conversion. Allowed Values: A valid C# code snippet. Default Value: None Example: Refer to: (Example) Schema Mapper
Validate	Description: Makes sure the code for the custom data conversion is correct. Example: Refer to: (Example) Schema Mapper
Back	Function: Goes back to the Schema Mapper screen.