The documentation from version 39.5.17 of PLANTA project can be found in the new PLANTA Online Help.

Automatic Numbers MOD002838

Access path
  • Customizer System Customizer Automatic Numbers

Information

  • In this module, configurations for generating automatic numbers (Ids) are managed. The configurations can also be managed per data table in the Data Dictionary module in which they are recorded. Other than the Data Dictionary module, the Automatic Numbers module, however, does not provide an option to have the automatic number configurations of several or even all data tables displayed at once in order to be able to quickly make necessary changes. Furthermore, the Automatic Numbers module is substantially more performant since not all data items of the data tables are loaded but only DIs for which automatic number generation has been set.

  • Automatic IDs
    • Automatic Ids (automatic numbers) are not entered manually but they are generated by the system according to a particular rule.
    • An automatic ID is only created when all foreign key DIs of the record and, if available, all mandatory data fields are filled with valid values.
  • Manual IDs
    • are allocated by the user.

Procedure

From S 39.5.20

  • Select the database schema of the DI for which the automatic number is to be edited via the listbox.
  • All data tables of the database are displayed with the DIs for which automatic numbers have already been created.
  • Edit the required parameters for automatic numbers.
  • Save.
  • NEW Click on the Restart PLANTA service button so that the changes are applied.
    • Note: If you click on the menu item, all open client connections (sessions) are closed. During restart, new client connections are not possible.

From S 39.5.13 / DB 39.5.5

  • Select the database schema of the DI for which the automatic number is to be edited via the listbox.
  • All data tables of the database are displayed with the DIs for which automatic numbers have already been created.
  • Edit the required parameters for automatic numbers.
  • Save.
  • Click on the Reload system customizing button (either via the Data Dictionary or via the menu items of the same name), so that the change is applied.
  • From DB 39.5.3

  • Select the database schema of the DI for which the automatic number is to be edited via the listbox.
  • All data tables of the database are displayed with the DIs for which automatic numbers have already been created.
  • Edit the required parameters for automatic numbers.
  • Save.
  • NEW Click on the Reload system customizing button (either via the Data Dictionary or via the menu item of the same name), in order for the changes to take effect.
  • Up to DB 39.5.3

  • Select the database of the data item for which the automatic number is to be edited, via the listbox.
  • All data tables of the database are displayed with the DIs for which automatic numbers have been created.
  • Edit the required parameter for automatic numbers.
  • Save.
  • Click on the Restart server button (either via the Data Dictionary or via the menu item of the same name), so that the changes take effect.
  • Details

    • The counter of the automatic numbering is administered separately for each database schema.
    • The structural rules for automatic numbering are managed in the system database.

    Example of numbers implying a sequence

    • The sequence of note lines, e.g. in project notes
      • Since PPMS is not a word processing system, note lines are stored as records in separate data tables.
      • The Project notes data table contains the Notes DT parameter = Y. PPMS automatically assigns and manages a count and position ID number for project note lines. The user cannot see this ID number (although it obviously exists as a data item pos. in the data dictionary and must be allocated (possibly invisible for the user) to the modules with project notes).
      • If lines are inserted, for example, PPMS automatically updates the ID numbers of all notes lines, and hence their sequence, without the user taking note of it.
    • The sequence of data field access in a module
      • Only the visible position of the data field in the option modules is relevant for the user. The sequence is changed by moving the data fields.

             PLANTA project









     
    • Suche in Topic-Namen

    • Suche in Topic-Inhalten
    This site is powered by the TWiki collaboration platform Powered by Perl