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

Resource ID Change MOD000365 New from S 39.5.15 / DB 39.5.6 up to DB 39.5.12

Description for versions DB 39.5.12


From DB 39.5.7

The function of the resource ID change is currently not available for MSSQL.

Access path

  • PM Administration Special Functions Resource ID Change

Information

  • In this module, resource IDs can be changed system wide.

Procedure

  • Select the required resource from the listbox on the Resource field.
  • Enter the new person ID in the New resource field.
  • Now, you have the option to
    • either carry out the ID change immediately
      • To do so, click on the Assign Stakeholder button.
    • or have a preview displayed first and then carry out the change.
      • To do so, click on the Preview button.
        • All data tables of the PLANTA project database are displayed, and the number of records to be changed in the respective table is displayed opposite of each table.
        • After you have checked the preview in the preview field, click on the Start button.
  • Subsequently, the list of data tables is displayed again with a specification of the number of changed records per table.

Details

  • The ID (code) of the resource is changed in both the master data and all resource assignments of the entire PLANTA project database.
  • The auto commit to the database is automatically switched on and off during the change process.

Adjustment

  • In order to include further data tables/data items in the person ID change, you have to make the following adjustments:
    • Open module 000365 Change Resource ID in the customizer.
    • Open data area 000468.
    • Open data field configuration of data field 101039.
    • Extend the existing data field configuration by the required data tables/data items
      • They must be created as a new line according to the <DT-ID> <DI-IDs> schema (see existing entries)
        • Here you have to make sure not to insert unnecessary line breaks and to stay within the triple quotation marks.

Up to DB 39.5.7

The resource ID change function is currently not available for MSSQL.

Access path

  • PM Administration Special Functions Resource ID Change

Information

  • In this module, resource IDs can be changed system wide.

Procedure

  • Select the required resource from the listbox.
  • Enter the new resource ID in the New resource field.
    • No code which is already used for a user (DT511), a person (DT516), a person resource (DT526), or a resource (DT467) must be entered here.
  • Click on the Preview button.
    • All data tables of the PLANTA project database are displayed, and the number of records to be changed in the respective table is displayed opposite of each table.
  • After you have checked the preview, click on the Start button.
    • The ID (code) of the resource is changed in both the master data and all resource assignments of the entire PLANTA project database.
      • Subsequently, the list with the data tables is displayed again with a specification of the number of changed records for each table.
    • The auto commit to the database is automatically switched on and off during the change process.

Adjustment

  • In order to include further data tables/data items in the person ID change, you have to make the following adjustments:
    • Open module 000365 Change Resource ID in the customizer.
    • Open data area 000468.
    • Open data field configuration of data field 101039.
    • Extend the existing data field configuration by the required data tables/data items
      • They must be created as a new line according to the <DT-ID> <DI-IDs> schema (see existing entries)
        • Here you have to make sure not to insert unnecessary line breaks and to stay within the triple quotation marks.

         PLANTA project









 
  • Suche in Topic-Namen

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