An example of bulk changing Catalogue record details would be:
- EQ has been placed in the GMD field for all Electrical Equipment resources.
- After careful consideration it is decided that the GMD field should be EQE (Equipment – Electrical) so they can be brought into line with the Equipment – Mechanical that have a GMD of EQM.
- So, the GMD of EQE – Equipment, Electrical has been added to the GMD table via Utilities > Setup > GMD… and you are ready to bulk change the records…
Steps for bulk edit of GMD info… (ALWAYS backup before doing ANY Bulk Update)
-
- Load LibCode Suite and go into Utilities then go into Update.
- Select Catalogue from dropdown menu and select Update.
- If backup HAS been done click Yes to pass backup warning message.
- Set Selection Criteria Field (GMD) / Low Value is EQ / High Value is EQ.
- Click Apply and check that ALL the records displayed in the data display table are actually the records you want to change…
- If you are confident that you do want to change all the records displayed then set the Replacement Field as GMD and choose Replacement Value as EQE Equipment – Electrical.
- Click Replace.
- Check the number of records about to be changed and if you are happy to make the change click Yes to do the job… (otherwise click No or Cancel to try setting criteria again)
These steps would change the GMD on all EQ records to EQE (even if there are thousands of records to be changed).