{"id":558,"date":"2017-11-26T15:19:18","date_gmt":"2017-11-26T15:19:18","guid":{"rendered":"http:\/\/endrekatona.eu\/tech\/?p=558"},"modified":"2017-11-26T15:28:05","modified_gmt":"2017-11-26T15:28:05","slug":"bulk-editing-the-image-names-in-opm","status":"publish","type":"post","link":"http:\/\/endrekatona.eu\/tech\/2017\/11\/26\/bulk-editing-the-image-names-in-opm\/","title":{"rendered":"Bulk editing the image names in OPM"},"content":{"rendered":"

The\u00a0Bulk edit\u00a0<\/strong>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.<\/p>\n

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.<\/p>\n

Let me lead you through this process using the following example:<\/p>\n

1. Let’s suppose you have a substation where many measured values must be monitored. Let’s name the images of the voltages simply\u00a0Voltage_I02 –> Voltage_I14<\/strong>\u00a0and the images of the currents\u00a0Current_I00\u00a0<\/strong>and\u00a0Current_I01<\/strong>.<\/p>\n

\"\"<\/a>

The initial data model in OPM<\/p><\/div>\n

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).<\/p>\n

2.1. Select the images and go to the bulk editing.<\/p>\n

\"\"<\/a>

Select the images to be changed, and enter the bulk edit tool<\/p><\/div>\n

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.<\/p>\n

\"\"<\/a>

Select one parameter to be “edited” (e.g. Lk_Prep)<\/p><\/div>\n

2.3. Export the list of images into a CSV file using the export function of the Source Data Management.<\/p>\n

\"\"<\/a>

Use the Source data management to export the list into a CSV file<\/p><\/div>\n

3. Open the newly created .CSV file with some kind of table editor (e.g. Microsoft Excel).<\/p>\n

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.<\/p>\n

\"\"<\/a>

Delete the unnecessary columns<\/p><\/div>\n

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\u00a0SIG\u00a0<\/strong>level, you should clear the content of the\u00a0LNK\u00a0<\/strong>column.<\/p>\n

\"\"<\/a>

Clear the content (excep the headers) of the table after the column you want to change<\/p><\/div>\n

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”.<\/p>\n

\"\"<\/a>

Type in the new names into the NEWNAME column. (use some formula to generate them)<\/p><\/div>\n

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.<\/p>\n

\"\"<\/a>

Change commas with semicolons<\/p><\/div>\n

4. Now you are ready to import your source data into the OPM.<\/p>\n

4.1. Simply choose\u00a0Tools–>Source data management–>Import\u00a0<\/em>from the menu.<\/p>\n

\"\"<\/a>

Import your new source data<\/p><\/div>\n

4.2. Check the checkbox to get a change report, before your OPM data-model is changed.<\/p>\n

\"\"<\/a>

A change-report can be of great help<\/p><\/div>\n

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.<\/p>\n

\"\"<\/a>

Check the change-report carefully<\/p><\/div>\n

4.4. If everything seems to be all right, hit the\u00a0Import\u00a0<\/em>button… and there you have your renamed images.<\/p>\n

\"\"<\/a>

Name changing procedure complete<\/p><\/div>\n