Page 1 of 1

Recommended procedure for moving video files to new location

Posted: 09 Dec 2015, 07:08
by Shark
I would like to move about 800 video files from a local hard drive to a NAS. Please recommend the procedure for bulk re-indexing all files in the new location. I can see how to change each database entry individually, but not how to change the file path as a bulk operation. Thanks!

Re: Recommended procedure for moving video files to new location

Posted: 11 Dec 2015, 16:42
by admin
Hello.
Currently there is no bulk procedure to do that.
The main idea was to "add and forgot".

I can add your request to wishlist.

Re: Recommended procedure for moving video files to new location

Posted: 11 Dec 2015, 23:02
by Shark
Yes, please add the ability to bulk re-index in a new location to the product wish list.
Is there are work around with the existing design? For example, can I open the database file in Microsoft Access and do a FIND and REPLACE on the file path?
Thanks!

Re: Recommended procedure for moving video files to new location

Posted: 07 Jan 2016, 12:02
by admin
You can try tools for SQL Lite databases.

Re: Recommended procedure for moving video files to new location

Posted: 02 Nov 2016, 10:48
by Orthos
I searched this forum to find a quick way to change the paths of several files. I´d like to see this feature, too. :)

Thank you,
Orthos

Re: Recommended procedure for moving video files to new location

Posted: 08 Aug 2017, 15:33
by marsthechemist
I suggest the following solution:

Get a database editor that supports SQL Lite. I'm using the "SQLite Manager" add-on for Firefox, but there are other applications like SQLiteSpy.
Load your Videonizer database and execute the following SQL statements:

UPDATE item SET path = REPLACE(path, '<oldpath>', '<newpath>');
UPDATE photo SET path = REPLACE(path, '<oldpath>', '<newpath>');
UPDATE screenlist SET path = REPLACE(path, '<oldpath>', '<newpath>');
UPDATE screenshot SET path = REPLACE(path, '<oldpath>', '<newpath>');


Set <oldpath> and <newpath> accordingly, e.g. UPDATE item SET path = REPLACE(path, 'T:\Clips', 'D:\Data\Clips');

Re: Recommended procedure for moving video files to new location

Posted: 16 Apr 2018, 19:06
by admin
Videonizer 4.1.0.0 is released.
From now on you can manage files physically right in the program.

Re: Recommended procedure for moving video files to new location

Posted: 10 Sep 2018, 06:29
by Shark
Thanks for adding the move feature. It should make it easier to manage video files from within Videonizer.

I finally figured out how to change the path of multiple files using an SQLite shell. I used "DB Browser for SQLite".
The syntax for this shell is slightly different than the command-line statements that marsthechemist so graciously posted above.

Using the "item" field as an example, enter the follow lines in the "Execute SQL" window:

UPDATE
item
SET
path = REPLACE(path, '<oldpath>', '<newpath>')

Then I changed the field name in line 2 from item to: photo, screenlist and finally screenshot and executed the commands again. It is a 4 step process.

That worked! Videonizer now points to all video files in their new location.

Thanks for the help.