I recently finished manually digitalizing my 1,500 movies. I ended up going the automatic route with DVDpedia but for some reason it only ends up returning info for like a little over half the movies? The files are the movie name followed by the year in (). Like 21 (2008) and it can't find anything about the movie?
Also is there a way then to find the movie info manually and link the movie with combining two movie infos? Since I already have the file in it, it would be nice not to have to search for them all the time.
Auto import DVD files
Re: Auto import DVD files
If a movie does not have a unique number of some sort, DVDpedia uses the title to run the search, it's most likely the date in the title that is confusing the search on the remaining movies. Open one of the movies and move the date to the release field and remove it from the title, then use the gear button on the bottom right of that window to run a search to get more information. The results of the search will appear in a drawer, select the correct result.
There is no merge but it's planed for the next version. One way to get more info for a movie is to add a unique number like the IMDb number to the IMDb field. Then if you run get more info at IMDb it will use the number instead of the title to get the movie information, but adding the IMDb number can be time consuming as you have to run the search in Safari. The only quick way to remove the year would be to take advantage of the SQL backend to run some SQL commands, with the program named Terminal you could do the following:
sqlite3 /Users/fa/Library/Application\ Support/DVDpedia/Database.pediadata
update zEntry set zTitle = rtrim(ztitle, '(0123456789)') where zTitle like '%(%)';
.exit
This will remove all the dates from the right side of the title that include parenthesis. You have to be careful with titles that also have numbers on the right side of their title like "21 (2008)", it's going to remove the entire title for that. Not sure how to tell it to stop after the opening parenthesis. So better to take care of those special cases in DVDpedia first and remove the parenthesis and then the SQL will skip movies titles without "()".
In fact it's a good idea to make a backup of your data file before running any SQL commands. You will find it in your home folder at ~/Library/Application Support/DVDpedia/Database.pediadata, make a copy of that file.
There is no merge but it's planed for the next version. One way to get more info for a movie is to add a unique number like the IMDb number to the IMDb field. Then if you run get more info at IMDb it will use the number instead of the title to get the movie information, but adding the IMDb number can be time consuming as you have to run the search in Safari. The only quick way to remove the year would be to take advantage of the SQL backend to run some SQL commands, with the program named Terminal you could do the following:
sqlite3 /Users/fa/Library/Application\ Support/DVDpedia/Database.pediadata
update zEntry set zTitle = rtrim(ztitle, '(0123456789)') where zTitle like '%(%)';
.exit
This will remove all the dates from the right side of the title that include parenthesis. You have to be careful with titles that also have numbers on the right side of their title like "21 (2008)", it's going to remove the entire title for that. Not sure how to tell it to stop after the opening parenthesis. So better to take care of those special cases in DVDpedia first and remove the parenthesis and then the SQL will skip movies titles without "()".
In fact it's a good idea to make a backup of your data file before running any SQL commands. You will find it in your home folder at ~/Library/Application Support/DVDpedia/Database.pediadata, make a copy of that file.