How to export a codification to MS Access?

1. Export type Authorization Organizer (AO)
2. Export type Authorization Auditor (AA)
3. Export Query variants (QA)

Remark: it is recommended to validate your codification before export.

To export a codification follow the instructions:

Codification > Export codification

The Codification export dialog window pops up.

Choose the type of export.

• Authorization Organizer (AO)
• Authorization Auditor (AA)

Depending on the choice you made the codification export window and its options may look differently.

A codification exported to AO or AA cannot be re-imported in the Accelerator. You can however import the codification into another SQL server database.

Export type Authorization Organizer (AO)

1 - General

Select the export type.

Choose the location where the codification is to be saved.

Since the codification is saved as an Access Database, you can choose between Access 97 and Access 2000.

Authorization Organizer (AO) does not support actions, modules, extended1 and extended2, but you can merge these restrictions into the taskcode restriction.

2 - Authorization fields

After choosing the location and the desired options proceed further by clicking on Next button In the next screen use the checkboxes to select the desired sheets and modules to be exported.

3 - Export

Click on Export button to export.

Export type Authorization Auditor (AA)

1 - General

Choose a location for the Authorization Auditor file to be exported.

Only the Variant options are available - all other options are grayed out.

Variants can be added to the existing list of variant, or all variants can be replaced with those from Accelerator.

Append variants : insert the new variants, keep the existing variants unchanged.

Replace variants: all existing variants in the AA file are removed and replaced with the list of variants from Accelerator.

2 - Authorization fields

After choosing the location where the AA file is to be saved, continue by clicking the Next button.

In the next screen use the checkboxes to select the desired modules to be exported.

Tip:
Flag the checkbox at the bottom left of the screen (see screenshot below) to active the save changes in the field definition - option.
If you flag this checkbox then all changes in the field definitions will be exported.

Click the Next button to proceed.

Tip : a domains tree view node already allows selection of the domain for use as a variant for audit.

Tip : a codification field

3 - Domains

In this screen you need to select the domains to be exported.

To export all domains of a codification, flag the Export all domains checkbox.

Otherwise, select the desired domains by:

• typing the correct name of the domain to be exported in the Domain field
• or by typing the first letters of a domain. Press enter to show the popup with a the list of all selected domains.
• or type ** and press enter to show the popup with a the list of all domains.

Note: this window shows which domains are accepting conflicts - its corresponding checkbox will be flagged.

See "Modifying domains (from library)"

Now click on Next button to export.

4 - Export

Click Export button to export the codification.

Export type Query variants (QA)

1 - General

Choose to append or replace variants. (See also Query Variants)

2 - Authorization fields

Check the authorization fields to export.

3 - Domains

Select the domains for export.

4 - Export

Transfer codification to QA.

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