Graphical Mapper and Scripting to Manage Data

1

From JSON to BOD

In the first scenario, you have a database table containing records of items you want to create in your ERP system. By using the ION Connector of type "database," you can retrieve these records in JSON format. However, to successfully create the items in the ERP, the data must be converted into a BOD format. This requires managing the data format transformation. Below is the document flow and its description.

Use the db_itm_json_2_std_itm.xml file.

After reading the data in JSON format from the database you convert it into XML using the below ION Scripting

The script uses inheritance in the function definition to convert an incoming object to XML.

In the script, initially, a Converter class is defined which takes an object as a parameter.

The class in JsonToXML , which inherits from Converter class( parent/superclass ).

The super method takes 2 arguments ( JsonToXML, self ) where JsonToXML is a subclass and self is an instance of the object to convert and is using a method “ convert ”).

The “ convert ” method is described below:

1. If the input to the method is a “dictionary”, then all the keys of the dictionary are read in the form of a list.

2. All the keys are read into a ‘root’ or main tag.

3. Else, if the input to the method is a “list”, then all the elements are directly read into a ‘root’.

4. From the list, the first key is assigned as a “Root tag”.

5. This “Root tag” is converted out as an XML “root” element of the tree which is the hierarchical data format for representing data.

The next method ( _convert ) method is described below:

1. If the object passed in is of a dictionary type, then loop through all the keys and child in it.
2. The text present in each tag is assigned to the parent tag.
3. Else if the top-most element does not contain text, then the key and child are attached as the element attributes.
4. Else if the child element is of a type list, then iterate through all the elements in the list, and the tags are converted into element tree elements and then appended to the parent tag or main tag. Each element is converted in the same way.
5. If all the above conditions turn false, then the value in the dictionary is assigned as text to the parent tag.
6. This generates a “result” structure with all the root tags, children, and attributes.

Finally, a full XML is generated with all the tags, child, and text elements. Further, the script uses a library called “ Create FULL-BOD ” to create the full structure of BOD dynamically.

In the above script, the following functions are used to create a full BOD structure:

1. “ renameTag ” is used to rename the XML generated above from ‘ root ’ to ‘ DB_ITEM_WRAPPER ’ which is the name of the custom Noun of the custom BOD.
2. Then the ‘ root ’ element is converted as an XML tree element ‘ top ’ and the result is added to it.
3. Then, the full structure of the XML is generated in the following way:

• Adding a root element with the proper namespace:
• The Application area contains the logical ID and component ID.
• Adding the following XML subelements:
• Verb
• Accounting entity
• Location ID
• Action criteria
• Action expression
• The BOD is renamed from “SyncDB_ITEM” to “Sync_DB_ITEM_WRAPPER”.
• The final XML output is converted to a string using the “toString” method with UTF-8 encoding to ensure that non-ASCII characters can be read as well. The final output is obtained as “xml_output”.

The Output from the ION Scripting component is in the form of Single-line XML.

Here, a splitter is used to split the single-line XML into a multi-line XML format.

Splitter formats each tag into a separate line to generate a multi-line XML.

This multi-line XML is further converted into a standard BOD format by using the Mapper transformation (XSLT) as shown below

The XSLT converts the custom fields of the document into standard fields by using mapper transformations.

Here, a “Sync DB Item Wrapper” is converted to a “Process Item Master” following XSL Transformations.

Three main XSLT rules used in this transformation are:

1. XSL Template Match: “XSL template match” contains rules to apply when a specific node is matched. The “match” attribute is used to associate a template with an XML element and add it to the output stream of transformation.
2. XSL Value Of: “XSL Value Of” is used to extract the value of an XML element and add it to the output stream of transformation.
3. XSL Copy Of: Creates a copy of the current node.

Steps:

1. First, the source BOD name is identified and mapped to a target BOD name using the template match().
2. The “Application area” of the Target BOD is mapped as the same / copy as that of the Source BOD. Hence, the fields Logical ID, Component ID, Confirmation Code, Creation Date Time, and BODID values are copied from the Source to the Target BOD.
3. In the “Data Area”, the verb “Sync” is converted to “Process,” and the values of Accounting EntityID and Location ID elements within it are copied as-is.
4. The ActionCriteria tag with the actionCode is copied as it is.
5. The next noun “DB_ITEM_WRAPPER” is selected in the Source BOD and converted to “ITEM MASTER” in the Target BOD.
6. The value of the ID inside the Item tag is converted into an ItemID tag.
7. The value of the Description is selected in the Description tag.
8. The Classification tag is mapped for Groups and types of 2 elements inside the DB Item Master tag, and both element types and groups are copied using a “value-of” rule.
9. The BaseUOMCode tag is mapped for the UOMA Code of both items.
10. The remaining items inside the Source BOD are mapped inside the “User Area” of the Target BOD.
11. In the User Area, the Item_EXT tag is defined with the values of Colour, Height, Width, Depth, UOMB, same as the Source BOD values.
12. This completes the XML BOD mapping from Source BOD to a standard Infor OAGIS BOD using XSLT rules. The final output of XSLT is shown below.

The final output as shown above is integrated into LN.

2

From custom BOD to standard BOD

The second scenario describes the sequence of steps to read an item table with a stored procedure to generate a custom BOD , then with a mapping to convert to Process.ItemMaster BOD and then send to LN for creating an item in LN.

The custom message is generated from the Database Connection point (through an Enterprise Connector) which was explained in part 1 of the tutorial (Customize Object Schema) using a Stored Procedure. The generated message is in XML format.

The XML is further converted into a standard Infor BOD format by using a Mapper transformation (XSLT) as shown below.

The XSLT converts the custom fields of the document into standard fields by using mapper transformations. Here, a “Sync DB Item” is converted to a “Process Item Master” following XSL Transformations.

Three main XSLT rules used in this transformation are:

1. XSL Template Match: “XSL template match” contains rules to apply when a specific node is matched. The “match” attribute is used to associate a template with an XML element and add it to the output stream of transformation.
2. XSL Value Of: “XSL Value Of” is used to extract the value of an XML element and add it to the output stream of transformation.
3. XSL Copy Of: Creates a copy of the current node.

Steps:

1. First, the source BOD name is identified and mapped to a target BOD name using template match().
2. All the “Sync” verbs are converted to “Process” verbs.
3. The “Application area” of the Target BOD is mapped as the same / copy as that of the Source BOD. Thus, the fields Logical ID, Component ID, Confirmation Code, Creation Date Time, and BODID values are created as a copy from Source to Target BOD.
4. In the “Data Area”, the verb “Sync” is converted to “Process,” and the values of Accounting EntityID, Location ID, and Action Criteria elements within it are copied.
5. The ActionCriteria tag with the actionCode is copied.
6. The next noun “DB_ITEM” is selected in the Source BOD and converted to “ITEM MASTER” in the Target BOD.
7. The value of ITEM is copied as ITEM ID in the target BOD.
8. The value of the Description is selected into the Description tag.
9. The Classification tag is mapped for Item Groups and Item types of 2 elements inside the DB Item Master tag, and both element types and groups are copied using a “value-of” rule.
10. The BaseUOMCode tag is mapped for the UOMA Code of both items.
11. The remaining items inside the Source BOD are mapped inside the “User Area” of the Target BOD.
12. In the User Area, the Item_EXT tag is defined with the values of Color, Height, Width, Depth, and UOMB, copied from the Source BOD values.
13. This completes the XML BOD mapping from Source BOD to a standard Infor OAGIS BOD using XSLT rules as shown below.
14. The final output BOD is shown below.

In the final step, the above-generated Process.ItemMaster is sent to an application(LN) for creating an item in LN.

3

From CSV file to standard BOD

The third scenario describes the process to read a CSV file as an item from a 3rd party and convert the custom BOD to Process.ItemMaster and create an item in LN .

The CSV file is read from a Shared Folder which was explained in part 1 of the tutorial (Customize Object Schema) and generates a custom BOD. This BOD (Sync.External_Item) is converted to an Infor standard BOD (Process. ItemMaster) to create an item in LN.

This custom BOD is further converted into a standard BOD format by using a Mapper transformation (XSLT) as shown below

The XSLT converts the custom fields of the document into standard fields by using mapper transformations. Here, a “Sync External_Item” is converted to a “Process Item Master” following XSL Transformations.

Three main XSLT rules used in this transformation are:

1. XSL Template Match: “XSL template match” contains rules to apply when a specific node is matched. The “match” attribute is used to associate a template with an XML element and add it to the output stream of transformation.
2. XSL Value Of: “XSL Value Of” is used to extract the value of an XML element and add it to the output stream of transformation.
3. XSL Copy Of: Creates a copy of the current node.

Steps:

1. First, the source BOD name is identified and mapped to a target BOD name using template match().
2. All the “Sync” verbs are converted to “Process” verbs.
3. The “Application area” of the Target BOD is mapped as the same / copy as that of the Source BOD. Thus, the fields Logical ID, Component ID, Confirmation Code, Creation Date Time, and BODID values are created as a copy from Source to Target BOD.
4. In the “Data Area”, the verb “Sync” is converted to “Process,” and the values of Accounting EntityID, Location ID, and Action Criteria elements within it are copied.
5. The ActionCriteria tag with the actionCode is copied.
6. The next noun “DB_ITEM” is selected in the Source BOD and converted to “ITEM MASTER” in the Target BOD.
7. The value of ITEM is copied as ITEM ID in the target BOD.
8. The value of the Description is selected into the Description tag.
9. The Classification tag is mapped for Item Groups and Item types of 2 elements inside the DB Item Master tag, and both element types and groups are copied using a “value-of” rule.
10. The BaseUOMCode tag is mapped for the UOMA Code of both items.
11. The remaining items inside the Source BOD are mapped inside the “User Area” of the Target BOD.
12. In the User Area, the Item_EXT tag is defined with the values of Colour, Height, Width, Depth, and UOMB, copied from the Source BOD values.
13. This completes the XML BOD mapping from Source BOD to a standard Infor OAGIS BOD using XSLT rules.

In this final step, the Process. ItemMaster generated in the previous step is further sent to a file and application using a Parallel flow.

Using a Shared Folder transfer protocol, the Process.Itemmaster is sent to a Target File(file2) for storage.

Further, the Process.ItemMaster is sent to an application (LN) to create an item in LN.