Data wizard architecture overview

This section provides a high-level overview of the data wizard architecture.

You modify two forms to make the data wizard work with your customizations: DLD:SYS:DataWizardProductStatus and DLD:SYS:DataWizAction.

In the following figure, the numbers indicate the sequence of steps that occur when you perform a count or modification from the Data Wizard Console.

High-level architecture overview

The following table describes the forms and plugins included or touched by the data wizard.

Forms and plugins included or touched by the data wizard

Form or plugin	Customize?	Description
Data Wizard Console (DLD:DataWizardConsole form)	No	Console from which the user runs the data wizard.
DLD:SYS:DataWizAction form	Yes	The core of the data wizard. All filters containing count or update SQL statements reside on this form. These filters run in different guides, based on the action and type of data. These SQL statements look at T tables and C columns.
DLD:SYS:DataWizardProducts form	Yes, but only if adding new forms to be updated by the data wizard	A join of data in the SHARE:Application_Properties form and the DLD:SYS:DataWizardProductStatus form. To make the data wizard work with new forms you add data to the DLD:SYS:DataWizardProductStatus form. The DLD:SYS:DataWizardProductStatus form contains the data displayed in the Status window when an action runs. Each record contains the application ID, data administration type, and target object. The target object is the form name displayed by the Status window. On this form, do not delete any record installed with the data wizard.
DLD:SYS:DataWizardAudit form	No	Contains a record of each count or update of each form for audit
DLD:SYS:DataWizardStatus form	No	Updates the Status window to indicate whether a count or update is in progress or complete.
Target form	Not applicable	Counted or updated by the data wizard.
DLD:Lock form	No	Prevents the data wizard from running a count or update while another count or update is in progress.
CAI plugins	Not applicable	Breaks the workflow from the user interface, which releases control to the user.

When the user performs a count or update, the data wizard performs the following steps:

The user completes the information about the Data Wizard Console and clicks Go.
The data wizard uses the DLD:SYS:DataWizAction form to create a new record in the DLD:Lock form.
The DLD:SYS:DataWizAction form pushes to the CAI plugin, which releases console control back to the user.
The CAI plugin continues to run filter actions on the DLD:SYS:DataWizAction form.
The DLD:SYS:DataWizAction form copies the list of forms from the DLD:SYS:DataWizardProducts form.
The DLD:SYS:DataWizAction form updates the status on the DLD:SYS:DataWizardStatus form to In progress.
The DLD:SYS:DataWizAction form counts and updates target forms.
The DLD:SYS:DataWizAction form gets the number of records to be updated (only for a count).
For each form that contains one or more fields of the data administration type, the DLD:SYSDataWizAction form creates a record on the DLD:SYS:DataWizAudit form.
The DLD:SYS:DataWizAction form updates the status on the DLD:SYS:DataWizardStatus form to Completed.
The DLD:SYSDataWizAction form deletes the record from the DLD:Lock form.

The filter actions in the following table control the data wizard.

Filter actions for the data wizard

Execution order range	Filter actions	Range to customize
0 - 149	Validation. Check and create a DLD:Lock record	None
150	Push to CAI plugin	None
200 - 499	Perform count	400 - 499
500 - 849	Perform update	700 - 799
850	Related to updating categorizations	None
900	Deletes the DLD:Lock record	None

Data wizard architecture overview

Comments