Export queries and SoD rules to MS Access.

Open the export form via menu Tools > Export > Queries.

1 - Source

CSI AA query file

• The full file path of the AA query file that will be used for export.

  The file open button opens the file dialog to select a query file.

  Type a new query file name or select an existing query set to export to.

The Source tab has a Load button that allows to load a set of options (auto execute file) for exporting queries.

Holding the shift key will execute the selected auto execute file.

The export grid lists the data that will get exported.

Xml file

• The full file path of the xml file used for export.
  The file open button opens the file dialog to select an existing xml file or type a new name.
  

Tip: You can also create a new database.

Options

E2E export button : use the save location of the default E2E query export file.

Documents button: the My Documents folder of the pc.

Default button : the default export directory as found in the User preferences.

Create new query set: an existing file is deleted, a new file is created.

Access 97, Access 2000, Access 2007, Xml file : choose the type of export file, an Access database or xml format.

Export user preferences: for compatibility with the Access applications.

Export concept relations:export Query Role Norm data and Query User Norm data.

Export control relations: export the query links with Process, Risk, Control objective and Control measure.

2 - Stat fields

Stat fields bind the Stat1, Stat2 and Stat3 column from the CSI AA Query database to free fields on the Queries.

The drop down box shows the True/False free fields on the Queries table, if any.

The application will show the free fields that were used for import as defaults for export.

However, the application doesn't know whether Boolean free fields are stat fields and these are shown in the drop down list as well. That is, any existing True/False free field on the Queries table can be used for export to stat fields.

Tip: selected stat fields are added to an auto execute file. (The Schedule button in the Export pane).

Remark: removing a free field results in a loss of data - all values for that column are gone.

Remark : recreating a free field after removal still results in a loss of data - all values for that column are still gone.

3 - Export

Click Export to start the process.

The Schedule button allows to save the selected options to an auto execute file for a later (background) run.

Use the Load button in the Source pane for running auto execute files.

Export Result Container

1 - Source

Destination

• export to access file (.rcd) : save the result to an rcd file, the file should not already exist, as it is created before the export.
• export into archive (SQL) : export the result container from the application database to the archive database.

Save location : choose a folder and file to save the export to.

Save options

• Access 97 : save to the access 97 database format.
• Access 2000 or later : save to the access 2000 database format, or a more recent format.

All RC Export options can be saved to create an auto execute file.

Use the Schedule button in the Export pane.

The Load button in the Source pane will set all options previously saved.

Holding the Shift key on the Load button will execute the auto execute file (click Yes to simulate the automated export).

This document is up to date with version 10.0.8.19 of CSI Accelerator