Batch Generation
The batch generation will generate standard objects like grids, forms, templates and screens based on the database tables.
'Batch Generate Repository Objects' Dialog
With this dialog you define and configure the objects from different object types, which you want to generate by batch generation.
Clickpath
Open Integrate > Data > Datasources > button Batch Generate.
Source Type: Define whether a 'Database' or 'BusinessEntity' is used as source type.
'BusinessEntity': If the value 'BusinessEntity' is selected the Business Entity Source Options area appears.
'Database': If the value 'Database' is selected the Database Source Options area appears.
Business Entity Source Options: This area is only displayed if the value 'BusinessEntity' was selected in the field Definition Source Type.
Business Entity: Defines the Business Entity that is used as the source.
Exclude Suffix List: Defines a list of suffixes to be excluded when creating the name based on the business entity class. Default is the following comma separated list of suffixes: 'BusinessEntity,Entity,BE'.
Database Source Options: This area is only displayed if the value 'Database' was selected in the field Definition Source Type.
Database: Defines the Database that is used as the source.
Data Access Database: If the field is empty, the same database as defined in field Database is used. Only relevant if there is a connection to Oracle or SQL databases.
Table: Defines which tables of the selected database are used as the source. The values are entered as a comma-separated list in the CAN-DO pattern or an asterisk * can be used.
Product code: Mandatory. Defines the product for which the new modules and objects will be created.
Module: Default value is '&1module'. This naming pattern is used to create a module for each previously defined table, which is then given the same name as the table in question with the addition of 'module'. Thereby the variable '&1' is used to insert the table name from the database into the object name. If all objects are to be created within the same module, an existing module must be selected.
Entity name pattern: Defines according to which pattern the name for entities are generated. Default value is '&1entity'.
Thereby the variable '&1' is used to insert the table name from the database into the object name.
Objects to Generate: Defines the object types of which objects are to be created.
Datasource: If the checkbox is activated the Generate Datasources area is displayed.
DynSelects: If the checkbox is activated the Generate Dynselect area is displayed.
Grids: If the checkbox is activated the Generate Grids area is displayed.
Forms: If the checkbox is activated the Generate Forms area is displayed.
Generate Datasources: In this area objects of type 'Datasource' are generated according to the following settings.
Data source name pattern: Defines the pattern with which the names are generated. Default value is '&1DSO'.
Thereby the variable '&1' is used to insert the table name from the database into the object name.
Generate DynSelects: In this area objects of type 'SwatSelect' are generated according to the following settings.
DynSelects name pattern: Defines the pattern with which the names are generated. Default value is '&1Select'.
Thereby the variable '&1' is used to insert the table name from the database into the object name.
Generate Grids: In this area objects of type 'SwatGrid' are generated according to the following settings.
Grid name pattern: Defines the pattern with which the names are generated. Default value is '&1Grid'.
Thereby the variable '&1' is used to insert the table name from the database into the object name.
Grid fieldslist pattern: Defines which fields of the datasource are displayed. The values are entered as a comma-separated list in the CAN-DO pattern or an asterisk * can be used. Default value is '!*Hdl,*', which means exclude ('!') every field ('*...') that ends with 'Hdl' and display all other fields ('...,*').
Grid title pattern: Defines the pattern with which the titles are generated. Default value is 'List of &1'.
Thereby the variable '&1' is used to insert the table name from the database into the object name.
Generate Forms: In this area objects of the type 'SwatForm' are generated according to the following settings.
Form name pattern: Defines the pattern with which the names are generated. Default value is '&1Form'.
Thereby the variable '&1' is used to insert the table name from the database into the object name.
Form fieldslist pattern: Defines which fields of the datasource are displayed. The values are entered as a comma-separated list in the CAN-DO pattern or an asterisk * can be used. Default value is '!*Hdl,*', which means exclude ('!') every field ('*...*') that ends with 'Hdl' and display all other fields ('...,*').
Form title pattern: Defines the pattern with which the titles are generated. Default value is 'Details of &1'.
Thereby the variable '&1' is used to insert the table name from the database into the object name.
Screens to Generate: Defines the type of screens to be created.
Search Screens: If the checkbox is activated the Generate Search Screens area is displayed.
Maintenance Screens: If the checkbox is activated the Generate Maintenance Screens area is displayed.
Create Dialogs: If the checkbox is activated the Create Dialogs area is displayed.
Generate Search screens: In this area search screens are generated according to the following settings.
Search screen template: Defines the template according to which the screens are created.
Search screen name pattern: Defines the pattern with which the names are generated. Default value is 'SearchScreen'.
Search screen title pattern: Defines the pattern with which the titles are generated. Default value is 'Search for &1'.
Thereby the variable '&1' is used to insert the table name from the database into the object name.
Search screen launch function name: Defines the pattern with which the launch menu function for the screens are generated. Default value is 'LaunchSearchScreen'.
Icon: Defines an icon displayed to the left of each title.
Add to Main Menu: Defines the menu to which the screens are added.
Generate maintenance screens: In this area maintenance screens are generated according to the following settings.
Maintenance screen template: Defines the template according to which the screens are created.
Maintenance screen name pattern: Defines the pattern with which the names are generated. Default value is 'MaintenanceScreen'.
Maintenance screen title pattern: Defines the pattern with which the titles are generated. Default value is '&1 Maintenance'.
Thereby the variable '&1' is used to insert the table name from the database into the object name.
Maintenance screen launch function name: Defines the pattern with which the launch menu function for the screens are generated. Default value is 'LaunchScreen'.
Icon: Defines an icon displayed to the left of each title.
Create Dialogs: In this area create dialogs are generated according to the following settings.
Create dialog template: Defines the template according to which the dialogs are created.
Create dialog name pattern: Defines the pattern with which the names are generated. Default value is 'CreateDialog'.
Create dialog title pattern: Defines the pattern with which the titles are generated. Default value is 'Create new &1'.
Thereby the variable '&1' is used to insert the table name from the database into the object name.
Create dialog launch function name: Defines the pattern with which the launch menu function for the dialogs are generated. Default value is 'LaunchDialog'.
Icon: Defines an icon displayed to the left of each title.