kaerf75

Any trouble you encounter with the Pedias, here's the place to ask for help.
Post Reply
kaerf75
Bruji Friend
Bruji Friend
Posts: 13
Joined: Sun Feb 22, 2009 10:03 am

kaerf75

Post by kaerf75 »

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
User avatar
Nora
Site Admin
Posts: 2155
Joined: Sun Jul 04, 2004 5:03 am
Contact:

Re: kaerf75

Post by Nora »

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.
kaerf75
Bruji Friend
Bruji Friend
Posts: 13
Joined: Sun Feb 22, 2009 10:03 am

Re: kaerf75

Post by kaerf75 »

Hi Nora,

THANK YOU VERY MUCH!!!
Post Reply