DVDpedia - Global change

Any trouble you encounter with the Pedias, here's the place to ask for help.
Post Reply
dvlkyrie
Junior Member
Junior Member
Posts: 3
Joined: Sat Aug 06, 2011 12:18 pm

DVDpedia - Global change

Post by dvlkyrie »

Hi,
Terrific (and vital) program.

Is there any way to globally change names in the "Director" and "Starring" fields? Many sites such as IMDB incorrectly list the names of Asian actors, ie; Yun-Fat Chow instead of Chow Yun-Fat.

Thanks much,

Tim
User avatar
Conor
Top Dog
Posts: 5346
Joined: Sat Jul 03, 2004 12:58 pm
Contact:

Re: DVDpedia - Global change

Post by Conor »

Hi Tim,

Thank you for the feedback, we don't have a find and replace yet in the current version. Also already in the upcoming version you will be able to use the multiple edit feature to edit the example you gave by first deleting that actor and re-adding them to a selection of movies. In the meantime the way to do find and replace is to access the open standard SQL database directly. This can be done with a program called Terminal in your /Applications/Utilities folder. First make a backup of your database file by making a duplicate as SQL is very powerful and can allow you to replace a lot of text by mistake. The file is located in your home folder at ~/Library/Application\ Support/DVDpedia/Database.dvdpd. The command you would use are the following one on each line:

Code: Select all

sqlite3 ~/Library/Application\ Support/DVDpedia/Database.dvdpd
update zEntry set zStarring = replace(zStarring, 'Chow Yun-Fat', 'Yun-Fat Chow');
update zCredit set zName = replace(zName, 'Chow Yun-Fat', 'Yun-Fat Chow');
.exit
Repeat the two middle lines the update the starring and any credit names with any other names that you would want to update. I apologize it's a bit more technical with the current version.
dvlkyrie
Junior Member
Junior Member
Posts: 3
Joined: Sat Aug 06, 2011 12:18 pm

Re: DVDpedia - Global change

Post by dvlkyrie »

Thanks Conor,

I'll try it after I find a quart or so of courage.

Tim
Post Reply