On Wed, 8 Jun 2011 12:55:52 +0200 Sigurd Mytting sigurd@mytting.no wrote:
Hi!
Due to organizational changes I need to update names of about 250 locations and change organization on about 800 devices, is there any way to do this without removing/adding them all?
With the new SeedDB, you cannot change the names of locations, but you can move rooms from one location to another in bulk (edit rooms, check the checkboxes for a set of rooms and click the "Move" button).
The same thing can be done for devices whose organization you wish to change: Edit IP Devices, check the devices you wish to move to another organization and click the "Move" button.
My first thought is SQL, is that the way to go? If so, there is 375 tables in the database, hints on what to update would be appreciated!
If you really need to _rename_ 250 locations, it won't be any easier with SQL, unless your renames have a common pattern. The locations are stored in the table called "location".
Beware that if you have any maintence tasks planned in NAV for any of these locations, these will likely not be updated when you rename.