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.