DVDpedia: Changing suffix of linked movie files

[udo]

I have some movies in .webm format. To play these I can’t use the play-button, but instead have to go to detail view and click the link there.

Now I learned that I can just change the suffix to .mkv without having to do anything else to the file. Easy to do that in Finder.

Could I edit the db to change every occurrence of ".webm" to: ".mkv"?

[FineWine]

I doubt it as each entry of .webm is preceded with the the film title.

Conor could properly give you an outside script to do it.

[udo]

I should have been clearer. I'm asking if I could do a rename to the SQL directly.

(Edit:) Found this:

https://www.bruji.com/forum/viewtopic.p ... 70&p=17096

[FineWine]

Thanks for explaining it more and for finding that quite old post of March 2011.

search and replace in entire database

So I suppose in your case the sqlite3 script would read:

Code: Select all

sqlite3 ~/Library/Application\ Support/DVDpedia/Database.dvdpd
update zlink set zURL = replace(zURL, '.webm', '.mkv');
.exit

One thing I do not like about DVDpedia is when you drag and drop a digital media file into the Links > URL secion, like mkv or mp4, it moves that file from its current location into a QuickTime folder within /Application Support/DVDpedia.

I have all my digital media on an external disk:

e.g.
file:///Volumes/Media/DOWNLOADED Movies:TV Series/Movies/Operation Fortune, Ruse de guerre/Operation Fortune, Ruse de guerre.mp4

So I have to copy and paste the path only into Links > URL

by going:

Finder > highlight file > right click Copy Path

For those of you who want to attempt this sort of thing, please peruse this page which contains all the correct Tags to all the Fields. https://www.bruji.com/howto/creating_te ... /tags.html

Anyway good luck with your renaming. Let us all know how you go.

[udo]

One thing I do not like about DVDpedia is when you drag and drop a digital media file into the Links > URL secion, like mkv or mp4, it moves that file from its current location into a QuickTime folder within /Application Support/DVDpedia.

You can switch that off:

[udo]

So I suppose in your case the sqlite3 script would read:

Code: Select all

sqlite3 ~/Library/Application\ Support/DVDpedia/Database.dvdpd
update zlink set zURL = replace(zURL, '.webm', '.mkv');
.exit

Thanks a lot, that worked great!

[FineWine]

One thing I do not like about DVDpedia is when you drag and drop a digital media file into the Links > URL secion, like mkv or mp4, it moves that file from its current location into a QuickTime folder within /Application Support/DVDpedia.

You can switch that off:

Oh Dear - DOH !

Been using the pedia's for years and totally forgot about that Preference switch.

Thanks