Hi all,
as my collection is growing more and more i´m trying to put my collection on my NAS. The collection itself is not the problem but the movie trailers i linked to each entry.
So here´s my question: Is there a way to just change the path of the links - As far as i know it is a sql-database but i don´t know the syntax?
The link is actual:
/Users/MyName/Movies/trailer/13 geister.mov
The link should be:
/Volumes/DVDPedia/trailer/13 geister.mov
Would appreciate your help.
Thanks
Daniel
kaerf75
Re: kaerf75
Quit DVDpedia and make a copy of the Database.dvdpd file as backup before you start (this file is located inside the data folder at ~/Library/Application Support/DVDpedia). Then launch the Terminal program from your utilities folder and type:
sqlite3 ~/Library/Application\ Support/DVDpedia/Database.dvdpd
You will now have a prompt that reads sqlite> and you can send any SQL statement to view and modify the database. To update the links type (change the actual URLs as necessary to fit your situation):
update ZLINK Set ZURL = replace(ZURL, 'file:///Users/MyName/Movies/trailer/', 'file:///Volumes/DVDPedia/trailer/');
To close the file type:
.exit
Quit Terminal, launch DVDpedia and the links will have changed.
sqlite3 ~/Library/Application\ Support/DVDpedia/Database.dvdpd
You will now have a prompt that reads sqlite> and you can send any SQL statement to view and modify the database. To update the links type (change the actual URLs as necessary to fit your situation):
update ZLINK Set ZURL = replace(ZURL, 'file:///Users/MyName/Movies/trailer/', 'file:///Volumes/DVDPedia/trailer/');
To close the file type:
.exit
Quit Terminal, launch DVDpedia and the links will have changed.
Re: kaerf75
Hi Nora,
THANK YOU VERY MUCH!!!
THANK YOU VERY MUCH!!!