Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

OSM Database Tools

Tag - Change name/number

  • Last UpdatedSep 10, 2024
  • 2 minute read

Changing tag names in batch

Important: Be aware that this operation MUST not be done in production mode. The database must be in upgrade mode with no users connected. During operation, some triggers will be disabled and re-enabled. There is no way to reverse the operation. Therefore, no data recovery is possible.

This is an option for changing tag names (sometimes called numbers). With this tool, the administrator can change tag names in batch to update tag names with new names. The new names will be reflected in all places that the tag names appear in the web application.

TXT file

You will need to prepare a text file in .txt format with a list of old tag names and new tag names.

The old tag name and new tag name values must be separated with pipe-character (|) and should be formatted as one tag per line.

Text file format

<old tag>|<new tag>

<old tag>|<new tag>

When you perform the operation, the old and new tag names will be automatically converted to uppercase.

Example

Example of content in a text file and resulting values.

Before

0000-df-81L0190-AC21-0|81L0190

0000-df-81L0191-AC21-0|81L0191

0050-oh-61L1396|FS70X-061L1396

0050-oh-61L1397|FS70X-061L1397

After

0000-DF-81L0190-AC21-0|81L0190

0000-DF-81L0191-AC21-0|81L0191

0050-OH-61L1396|FS70X-061L1396

0050-OH-61L1397|FS70X-061L1397

Change tag names

  1. Select Tag - Change name/number radio button on left side of screen.

  2. Click Select file and browse to the location of the prepared TXT file.

  3. Enter the site code.

  4. Click Update tag names to perform the operation.

    When successful, a message is returned at the bottom of the screen.

Log file

A log file is created in the same Windows folder as the source text file.

If an existing tag name in the text file is not found, the row will report failed update because the tag does not exit.

If a new tag name already exists, the row will report failed update because the new tag name already exists.

In This Topic
TitleResults for “How to create a CRG?”Also Available in