DVDpedia - Global change

[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

[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]

Thanks Conor,

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

Tim