Schema Mapper

The Schema Mapper connects entities, SharePoint fields, form fields, web methods, or other data sources to your AgilePoint NX schema.

Figure: Schema Mapper screen

Schema Mapper screen

Connect a Schema with your Process Schema

To connect, or map, a data source to your XML schema, do the procedure in this topic.

Examples

How to Start

  1. On the Application Explorer screen, do one of these:
  2. Add or change an activity that uses the Schema Mapper.
  3. On the related configuration screen, click Schema Mapping Schema Mapping icon. The procedures are different for different activities.

Procedure

  1. (Optional) To connect all the fields in the data source and the process schema that have the same name, on the Schema Mapper screen, click Auto Map.
  2. Drag the elements from the source schema to target schema as necessary to connect them.
  3. For the data conversion between the source and the destination schema fields, complete this field as necessary.
    Field Name Definition

    Data Conversion

    Function:
    Specifies the data conversion between the source and the destination schema fields.
    Accepted 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
  4. (Optional) for custom data conversion, click Add or Edit to open the Custom Mapping screen screen.

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 Name Definition

Mapping Schema

Function:
Connects the schemas to your schema.

The source and the destination schemas show in a tree view in the left and right panes.

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

Reset

Function:
Deletes all connections that have been made in the Schema Mapper for this activity.

Data Conversion

Function:
Specifies the data conversion between the source and the destination schema fields.
Accepted 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

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.

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 Name Definition

Input Type

Function:
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.

Accepted Values:
Read only.

Output Type

Function:
Specifies the data type of a target schema data field.

Specifies the data type of an element from the source schema.

Accepted Values:
Read only.

Method Name

Function:
Specifies the name of your data conversion method.
Accepted Values:
One line of text with no 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

Function:
Specifies the code for the custom data conversion.
Accepted Values:
A valid C# code snippet.
Default Value:
None

Validate

Function:
Makes sure the code for the custom data conversion is correct.

Back Back icon

Function:
Goes back to the Schema Mapper screen.