Wednesday, March 24, 2010

How to Manually Add a Movie Title to Boxee

I've started using Boxee and it is really amazing. There's one small but very annoying issue I've come across. When Boxee indexes a movie or TV show, it attempts to go out and find the information about the file from IMDB. This usually works fine, but when it fails, there's no way to manually resolve it. This means that the media that fails to resolve does not appear in the appropriate menu. The ability to manually set this information is apparently coming, but in the meantime, here's how to do it manually.

You will need a way to edit SQLite database files, such as SQLite Database Browser.

The database file you want to edit is located at

Linux: ~/.boxee/UserData/
Mac OS/X: ~/Library/Application Support/BOXEE/UserData/
AppleTV: ~/Library/Application\ Support/BOXEE/UserData/
Windows Vista: C:\Users\\AppData\Roaming\BOXEE\userdata\
Windows XP: C:\Documents and Settings\\Application Data\BOXEE\userdata\

IMPORTANT: Back up the boxee_catalog file before editing!!

You will want to edit the video_files table.

Add a new row to the table. The idVideo value should automatically increment to the next available value, but you may want to verify this.

You do not have to fill in all the fields. These are the fields I used. I didn't really experiment to find out which ones were required.

Start up Boxee, and the new movie appears!


Anonymous said...

Hi Tyler, thanks for the info. Editing the database seems simple enough. However, I'm not sure how to get to the database on my D-Link Boxee. If you could address that question I would appreciate it.

Tyler said...

No idea man, I wrote this before the Boxee box came out and I don't have one. As far as I understand the D-Link version and the downloadable version have gotten pretty out-of-sync. However, the current version of the downloadable software does have the option to manually identify videos, so these steps probably shouldn't be necessary on any version anymore.