The File Import Module (FIM) has been added to OxyGen.
This module allows the initiation of Workflow execution by importing a file into the system.
Along with this, module can be used in the middle of the Workflow:
User can configure FIM be triggered as a Processing Module and grab file(s) from the incoming payload for further automated import. NOTE: DMM or FTP (download mode) modules can be used for incoming payload generation.
Module supports Excel the following file types:
Excel (*.xls; .xlsx; .xlsm)
Standard Delimited Text Files (*.csv; .psv; .tsv; *.txt)
Create File Specifications for further use during File Import automated validation.
File Specifications can be created from scratch or based on an uploaded Sample file. View, edit, and delete File Specifications and add them to the FIM Module on the Workflow Canvas.
FIM’s “Has Header” parameter allows User to set if default column names need to be added to the file or not. Logic was applied to both File Specification settings and FIM Module settings on the Canvas UI.
The module supports visual indicators (cell and header colors) for File Specification/Import validation results.
Module supports custom delimiter configurations that can be applied to both File Specification settings and FIM Module settings on the Canvas UI.
FIM has the ability to use Batch and Row-by-Row processing modes.
Additionally, it allows the addition of payload parameters using URL queries and the "Build JSON" Module's control.
Module supports ODBC Provider and can be used for DSN and DSN-less connections.
A new module, the Bulk Table Import Module (BTI), has been added to OxyGen.
This module provides the ability to upload data to the selected Database table.
The BTI module supports Bulk Processing, significantly increasing the speed of data insert operations.
The module also supports variable syntax, providing the ability to insert data from the Payload data sets.
Module supports ODBC Provider and can be used for DSN and DSN-less connections.
User can add OUT parameters values to the module’s outgoing payload. NOTE: SQL bulk import does not support this function.
DMM was updated to support processing in the middle of the Workflow:
User can configure DMM module to be added after any module and triggered as a Processing Module.
Enhancements and Updates:
New libraries were added to the Frontend:
kendo-react-common, version 7.0.2
kendo-svg-icons, version 2.1.0
Several libraries were updated:
react-js-cron from 3.0.1 to 5.0.1
kendo-react-editor from 5.14.1 to 5.19.0
DMM was updated to have File and Batch Data Processing modes determining number of files added to the outgoing payload.
FTP was updated to have file(s) downloaded from the Remote Folder be added to the outgoing payload and transferred to the next mosule.
Schedule templates dialog layout was updated to have better UX.
Input Triggers were refactored to utilize new Inherited Base Class Functions.
CDN support was added to Annotated Summary and Note Editor.
Some improvements were applied to the SPM module for proper ODBC handling and Parameters handling.
Application Corrections and Bug Fixes:
SPM - Required SPM parameters for ODBC connection.
Exempt workflows publication license checks.
Grid dialogs api optimization.
Help instruction for Recovery control was fixed.
Common controls layout and dynamic logic.
Confirmation dialogs for common toolbar tools.
API runaway Logging; No event record for user to see error information.
ARM - ARM Cerdentials not cleared on Export.
EMM - Delayed processing exception handling updated to provide exception message details to the event record.
EMM - Event record on creation now is populated with the email message JSON.
EMM - A failed email in delayed processing will now activate a completed workflow trigger and set the workflow event to Pending.
EMM Failing without Error Message was corrected in 2.3 as well.
Comments