Sewer Utilities - Change ID

The Change ID dialog box allows the user to change the ID for any selected data element.

• Desired Element Type - From the drop down box, select the InfoSewer data element for which an ID change is to occur.

• Old ID - Enter the current ID.

• New ID - Enter the new ID value.

• Apply - Click apply to make the ID change.

• Set Rows - Specify the number of rows for mass editing (twenty is the default).

Performing a Large Change ID

To perform a mass edit, use the DB Editor and open the database where the subject ID's are stored.  Highlight and copy the ID's into the Windows clipboard and paste the values into a third-party software like Microsoft Excel.  Next to each ID, enter the new value for the ID - Using excel functions like "mid" and "concatenate" to help you in the mass edit.  Once you have the old and new ID's, determine how many rows are being used in Excel.  Highlight all old and new ID's in Excel and use Ctrl+C to copy the highlighted area.

Go back to InfoSewer, use the Set Rows command to make the rows the same as those in the Windows clipboard.  Once this is done, highlight the first cell in the Change ID dialog box and use the Ctrl+V function to paste the values from the clipboard.  You have now greatly reduced your time from having to edit each ID individually.  Click Apply to change the ID's and then Close to close the dialog box.