Want a perfect Boxee database ... I did it

**jpga13** · February 21st, 2010, 06:35 PM

Everything works well except adding files that can't be found already by Boxee. DO we need to manually assign a BoxeeId to the files?

**vdubeau** · February 21st, 2010, 09:38 PM

Originally Posted by jpga13

Everything works well except adding files that can't be found already by Boxee. DO we need to manually assign a BoxeeId to the files?

You only need the BoxeeID for TV shows and for the setting the video as watched. Two things that could be wrong are that the path to your video is wrong or the volume/drive is not in the media_folders table.

Other things to look for when adding are as follows:

idFile = 1
idFolder = 0
iDropped = 0

The 0's must be entered and not left blank.

Also for movies make sure that iSeason and iEpisode are both set to -1.

**jpga13** · February 22nd, 2010, 05:46 PM

Originally Posted by vdubeau

You only need the BoxeeID for TV shows and for the setting the video as watched. Two things that could be wrong are that the path to your video is wrong or the volume/drive is not in the media_folders table.

Other things to look for when adding are as follows:

idFile = 1
idFolder = 0
iDropped = 0

The 0's must be entered and not left blank.

Also for movies make sure that iSeason and iEpisode are both set to -1.

Thanks for the tips!

The last issue is a Tv Series for my kid. I added a few episodes manually to the database using the SQL app but they still did not show. Then I went to the part of the database for Series and created a new series. The thumbnail for the Series showed up on Boxee but the actual shows are not connected to it. Is there any way to connect these? Any idea why this one Tv Series won't show up at all?

I fixed all my tv shows and movies so they are now perfect and this is my last hurdle.

Thanks for any help.

**vdubeau** · February 22nd, 2010, 06:42 PM

Originally Posted by jpga13

Thanks for the tips!

The last issue is a Tv Series for my kid. I added a few episodes manually to the database using the SQL app but they still did not show. Then I went to the part of the database for Series and created a new series. The thumbnail for the Series showed up on Boxee but the actual shows are not connected to it. Is there any way to connect these? Any idea why this one Tv Series won't show up at all?

I fixed all my tv shows and movies so they are now perfect and this is my last hurdle.

Thanks for any help.

Without seeing the db entries it's hard but I'll give you some things to check for.

Make sure that the seasons table is connected to the series table using the the idSeries field.
Make sure you have a BoxeeID that connects the shows in the video_files table to the series table.
In the video_files table, make sure you have the season (iSeason) and episode (iEpisode) specified.

Hope this helps. If you have any more questions, feel free.

**jpga13** · February 22nd, 2010, 06:45 PM

Originally Posted by vdubeau

Without seeing the db entries it's hard but I'll give you some things to check for.

Make sure that the seasons table is connected to the series table using the the idSeries field.
Make sure you have a BoxeeID that connects the shows in the video_files table to the series table.
In the video_files table, make sure you have the season (iSeason) and episode (iEpisode) specified.

Hope this helps. If you have any more questions, feel free.

Do I make my own BoxeeID or can I find it somewhere?

**vdubeau** · February 22nd, 2010, 06:55 PM

Since I haven't programmed in C since the stone age

, reading the Boxee source is tough. Boxee uses a 6 digit number but I'm not sure how it's generated.

I would just create a string, perhaps something to do with the show title (ie., Home Improvement could be HOMIMP). If the Title is short like Cheers come up with something that will help you to avoid confusion.

**jpga13** · February 22nd, 2010, 09:25 PM

Originally Posted by vdubeau

Since I haven't programmed in C since the stone age

, reading the Boxee source is tough. Boxee uses a 6 digit number but I'm not sure how it's generated.

I would just create a string, perhaps something to do with the show title (ie., Home Improvement could be HOMIMP). If the Title is short like Cheers come up with something that will help you to avoid confusion.

I'm a little closer but it's still not finding the actual tv shows inside the folder. Now instead of saying invalid data it says there is nothing where it is looking.

Edit: I kept playing with it and it finally worked. I had to make a numerical BoxeeiD and that seemed to do it along with all the other tips you gave. Many thanks! I now have a perfect database!

**Chromagnum** · February 25th, 2010, 01:39 PM

Originally Posted by lateforaa

Movies/TV Shows with no thumbnails

Sometimes IMDB or THETVDB don't have a thumbnail for the media. This is simple to solve. Open up Google and do an image search; poster MOVIE TITLE, so for example; poster Animal House. Click on the poster you want to use, then select the See Full Size Image link at the top. This will give you the URL to the image you want to use. Now we need to tell Boxee to use that image instead.

Open the Boxee database with the SQLite Database Browser.
Click on the Browse Database tab.
From the Table dropdown select video_files.
Now you will see a list of all your video files. This is where all of your duplicates are.
Click on the magnifying glass and a new window opens.
From the first drop down select "strPath" and on the second drop down select "contains".
Now enter part of the name; i.e. Animal and click search.
When you select the Animal house record it will take you to it.
Close the search window and go over to the strCover column.
Double click on it, delete what is entered, paste the URL and click Apply.
Save your database and reopen Boxee, it will download the image you specificed.

I can easily change or add thumbnail but thats only for a movie. However, what about tv show? the strCover gives me an image path for the preview while in that "play section", but I still don't know how to add cover for the front menu of the tv shows section (the one where all of various tv shows being list it). Can you help me with this? Thanks.

Edit to add:
Got it. For the tv shows turns out to be in the Browse Data>Table: series.

**JustCallMeCloud** · March 13th, 2010, 03:31 AM

Alright, this drove me crazy. SO I have ubuntu and I spent hours trying to compile the source code multiple times. After screwing up multiple times and going no where I noticed that you can install it simply through Synaptic.

sudo apt-get install sqlbrowser

Just wanted to make sure people don't suffer like I did. :P

**maximusfacq** · March 15th, 2010, 11:27 PM

@lateforaa

I pulled a copy of my DB to my Windows machine from my ATV, edited it, deleted the existing one, copied the edited one back to the ATV, restarted the ATV, and logged into Boxee.

None of the changes I made are showing. Specifically, I simply added coverart for about 20+ titles that it was missing or the existing link was broken. I also changed the Titile of one film that was properly identified, but the strTitle field was just incorrect.

Is there something I am missing here? I even tried to run another pass at it with the Indexer, thinking that having it read the DB might make the changes active, but, that didn't work either. >.<

Thoughts?