Exporting from Optiva

Optiva workflows are used to publish items and formulas. The PUB_PROCITEMMASTER workflow is used to publish items and PUB_SYNCBOM is used to publish formulas.

The BODs that Optiva publishes are:

  • Process.ItemMaster
  • Sync.BillOfMaterials

The action script provides support for listing the standard fields, custom fields, and technical parameters that are to be included in the published BOD XML. The script inserts the BOD XML into ION outbox tables in the Optiva database.

To add custom fields into standard BODs with the PUB_PROCITEMMASTER or PUB_SYNCBOM workflows, you can overwrite the Action scripts:

Protected Overrides Sub ParametersToExport()
 'This is a VB.NET List of all the Parameters you want to export
 '_ExportParams.Add("ASH")
_ExportParams.Add("DENSITY")
 _ExportParams.Add("FORMULA COST")
_ExportParams.Add("MOISTURE")
 End Sub
Protected Overrides Sub ContextToExport()
'This is a VB.NET List of all the Set Codes you want to export
_Context.Add("SELLOC")
_Context.Add("C_ENDUSE")
End Sub
Protected Overrides Sub CustomFieldsToExport()
'This is where you will add the custom parameters that you wish to export
'these custom parameters have no "home" in the BOD structure, so are all
'exported as specifications, with a type="custom parameter" attribute
_CustomFieldExport.Add(New BODNode("DIVISION", "Division", DataType.dataString))
'_CustomFieldExport.Add(New BODNode("FREIGHTITEM", "Freight Item", DataType.dataString))
'_CustomFieldExport.Add(New BODNode("FILLATTRIBUTE", "Fill Attribute", DataType.dataString))

Changes should not made directly to the Infor Provided ION Script Libraries, such as IONBASE262.

We recommend making a copy of the Action scripts as well. The original scripts can be overwritten by Optiva during upgrades.