The Bulk edit tool is probably the mostly used instrument in OPM, no TOOLBOXer can live without it. Though powerful when it comes to managing image parameters, it still has an unpleasant weakness: image names cannot be edited with it.
We all know those situations when in the middle of the commissioning phase the client comes with some special change requests, like making a global change in the image naming system. Though making these image name changes inside OPM can be only done one by one, there is a way to do quick, bulk edit style changes, if that change can be described with some kind of algorithm.
Let me lead you through this process using the following example:
1. Let’s suppose you have a substation where many measured values must be monitored. Let’s name the images of the voltages simply Voltage_I02 –> Voltage_I14 and the images of the currents Current_I00 and Current_I01.
2. Now, let’s suppose that at the end of the engineering phase, the client comes to you, and asks, that you make a global change in the image naming system. For example, he wants that the images are named in German not in English. Instead of doing this change one by one (in the actual example it wouldn’t take so much time, but this is not the case if you have thousands of images), let’s export the images, that must be changed, into a CSV file (as a matter of fact OPM will create a semicolon separated values file).
2.1. Select the images and go to the bulk editing.
2.2. Select one parameter to be “edited”. It is not important, which parameter you take, as this is only necessary to open the bulk editing.
2.3. Export the list of images into a CSV file using the export function of the Source Data Management.
3. Open the newly created .CSV file with some kind of table editor (e.g. Microsoft Excel).
3.1. Delete the unnecessary columns. The only columns that should remain in the table are the columns FUNC, the names of the defined levels, and the columns NEWNAME and DEFAULT.
3.2 Clear all content from the table after the column you want to change. E.g.: if you want to change the image names at SIG level, you should clear the content of the LNK column.
3.3. Generate the new image names in the column NEWNAME. In this particular example I have copy-pasted the old names into the NEWNAME column and replaced the text “Voltage” with “Spannung” and “Current” with “Strom”.
3.4 Save this new document as a CSV file. Remember: OPM works with semicolon separated values, so you will have to change manually the commas with semicolons.
4. Now you are ready to import your source data into the OPM.
4.1. Simply choose Tools–>Source data management–>Import from the menu.
4.2. Check the checkbox to get a change report, before your OPM data-model is changed.
4.3. Hit the import button, and check your change report. Only accept it, if it contains exactly those changes you wanted. Be careful, you may damage the result of several week’s work.
4.4. If everything seems to be all right, hit the Import button… and there you have your renamed images.