Recommended procedure for moving video files to new location

All about the program

Recommended procedure for moving video files to new location

Postby Shark » 09 Dec 2015, 07:08

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!
Shark
 
Posts: 2
Joined: 04 Oct 2014, 16:23

Re: Recommended procedure for moving video files to new location

Postby admin » 11 Dec 2015, 16:42

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.
User avatar
admin
Site Admin
 
Posts: 398
Joined: 03 Jun 2014, 19:14

Re: Recommended procedure for moving video files to new location

Postby Shark » 11 Dec 2015, 23:02

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!
Shark
 
Posts: 2
Joined: 04 Oct 2014, 16:23

Re: Recommended procedure for moving video files to new location

Postby admin » 07 Jan 2016, 12:02

You can try tools for SQL Lite databases.
User avatar
admin
Site Admin
 
Posts: 398
Joined: 03 Jun 2014, 19:14

Re: Recommended procedure for moving video files to new location

Postby Orthos » 02 Nov 2016, 10:48

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
Orthos
 
Posts: 3
Joined: 01 Nov 2016, 23:17

Re: Recommended procedure for moving video files to new location

Postby marsthechemist » 08 Aug 2017, 15:33

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');
marsthechemist
 
Posts: 1
Joined: 08 Aug 2017, 15:14


Return to Videonizer

Who is online

Users browsing this forum: No registered users and 1 guest