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

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:

How to Start

  1. 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..

Figure: Schema Mapper screen

Schema Mapper screen

Fields

Field NameDefinition

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:

AutoMap

Function:
Maps all fields in the data source and the process schema that have the same name.
Example:
Refer to:

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:

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:

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 Back icon

Function:
Goes to the previous screen.

Custom Mapping screen

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

Figure: Custom Mapping screen

Custom Mapping screen

Fields

Field NameDefinition

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:

Validate

Description:
Makes sure the code for the custom data conversion is correct.
Example:
Refer to:

Back Back icon

Function:
Goes back to the Schema Mapper screen.