Batch edit to change path

For our purpose, which is to edit the volume_table, we don't need much knowledge of sql queries, just to edit the right fields of the right volume_table records.

I assume we are in the right conditions:

- the media files folder tree registered in the catalog has been moved to a new empty drive  (no files of the destination drive already present in the catalog before the move). - - The old drive reference in Windows will disappear completely and be replaced by the new references (drive letter and serial).

- There will not be different items in the volume_table referring to the same letter drive or same serial number.

- You have used the Windows commands to find the serials and to translate them from hexadecimal to decimal.

If you look at the media_table, you'll see that all your media refer to the volume_id, the one assigned by the database given when the first item has been recorded in the database. Now, all the media in the old drive are no longer pointing to that volume, but to a new one. The reconnect function works first to find the new location, and when found, it replaces the old volume_id with the new one. In our case, the first thought for a sql language user is to issue a query to replace all serial and letter old references with the new references. That can be a replacement of hundred of thousands of edited records.

As a matter of fact, the intelligent database structure with the volume_table makes it much easier and faster. We are cheating by keeping the old assigned volume_id and we change its Windows references, serial and letter (also the description and type, but that's not so crucial).

In practice, once you have opened your catalog, you select the volume_table on the left, and on the right of the volume_table line, you click on the 2nd icon to 'edit...'

There you can edit directly the record of the old volume_id for the description, serial and letter drive.