Report Writer > Setup > RW Data Dictionary Import Wizard

RW Data Dictionary Import Wizard

You use this program to create the Report Writer Data Dictionary from the standard dictionary supplied with SYSPRO.

The SYSPRO Report Writer Data Dictionary defines the data structures that can be used by the Report Writer. It contains details of all the tables, columns and the logical links, keys and comments between them.

An easy-to-use Wizard guides you through the process of setting up your Report Writer Data Dictionary. The wizard displays a number of screens, some of which provide you with information; others which require that you make certain selections.

Custom form table information for SQL databases can be imported into the Report Writer Data Dictionary using the Custom Form Design program.

Report Writer Data Dictionary Wizard

The report writer data dictionary defines the data structures that can be used by the report writer. It contains details of the tables, columns and logical links between them.

The report writer wizard guides you through the process of setting up your report writer data dictionary.

This screen enables you to select the modules you want to import into the data dictionary.

Field Description
<Back Select this to display the previous screen.
Next> Select this to display the next screen.
Cancel Select this to exit from the Wizard, without saving any selections you have made.
Select the modules you wish to have installed in the Report Data Dictionary  
Available modules

All the modules listed in this list box may be added into the data dictionary.

Once a module is added into the data dictionary, it is then removed from the available modules list box and is displayed under the contents of the data dictionary list box.

If this list is empty, then all modules have previously been imported into the data dictionary.
Add

This function enables you to individually select the modules you want to import into your data dictionary.

Select this to add the highlighted module in the Available modules list box to the Contents of data dictionary list box.
Add All

This function enables you to select all available modules for importation into your data dictionary.

Select this to add all the Available modules to the Contents of data dictionary list box.
Remove

This function enables you to deselect individual modules from the import.

Select this to remove the highlighted module in the Contents of data dictionary list box back to the Available modules list box.

When you remove modules from the Contents of the Data Dictionary a warning is displayed, informing you that any existing reports that use tables from these modules cannot be edited or printed. You have the choice to either cancel the Remove or continue.

You can only access this function if there are columns that have already been imported into the data dictionary.
Remove All

This function enables you to deselect all modules from the import.

Select this to remove all modules in the Contents of data dictionary list box and transfer them back to the Available modules list box.

When you remove modules from the Contents of the Data Dictionary a warning is displayed, informing you that any existing reports that use tables from these modules cannot be edited or printed. You have the choice to either cancel the Remove or continue.

[Note]

If you have User-Defined Columns in any of the standard SYSPRO tables, then caution must be exercised when using either the Remove or Remove All functions as these user-defined columns will also be removed. It is recommended that you first use the RW Data Dictionary Columns program to produce a hard copy printout of these user-defined columns.

You can only access this function if there are columns that have already been imported into the data dictionary.
Contents of data dictionary

All the modules listed in this list box are available in the data dictionary and can be imported.

Once a module is removed from the data dictionary, it is removed from the contents of the data dictionary list box and is displayed under the available modules list box.

If you have not imported any modules into your data dictionary, then this list is empty.
Update Single Module

This function is enabled when a module is highlighted under the Contents of data dictionary list box.

Select this to update only the selected module with the latest Standard SYSPRO Data Dictionary Contents.
Before creating the new columns against each table, you can elect to remove any existing columns (for those tables) to be imported Your selections determine which fields must be removed or remain within the data dictionary, before the actual import takes place.
I do not want any columns to be removed

Select this if you want to update existing columns and import new columns to the tables.

No existing columns are deleted.

This is the default selection.
I only want standard SYSPRO columns to be removed

Select this if you want to remove the standard SYSPRO columns but keep any user defined columns.

The user-defined columns to be ignored, but all the SYSPRO standard columns are deleted before being rebuilt.
I want to remove all existing columns

Select this if you want to remove all existing columns from the tables and replace them with only the standard SYSPRO columns.

All the columns are deleted, including any user-defined columns, before being rebuilt.
I want all imported tables to be set to Read only

Select this if you want to prohibit operators from creating reports that change your data in any way, as access to the Data Dictionary is set to Read Only.

Once the files have been imported, the status can be changed as required using the Browse on Data Dictionary Tablesprogram.
Finish This function will start the import of the selected Data Dictionary.

Notes and warnings

Note

  • This Import must be run before you can use the Report Writer. This is so that the report writer data dictionary can be created from the standard data dictionary.

  • The Report Writer module uses its own data dictionary and not the standard data dictionary. Once you have created the report writer data dictionary, you can amend this dictionary as required. You should never amend the standard data dictionary.

Restrictions and limits

  • The maximum size of a numeric field is 15 digits before the decimal and a maximum of 6 digits after the decimal (15.6). This number can be positive or negative.