Want a perfect Boxee database ... I did it

[je_dryst03]

Do you have any software for this kind of database?....

[Vincent81]

You can try XBNE, video DataBase Editor :
http://forum.boxee.tv/showthread.php?t=17012

[TylerK]

I wrote a blog post on this subject. It's less comprehensive, but has screenshots.
http://www.tylerkrpata.com/2010/03/h...-title-to.html

[gmacman]

This thread is just fantastic info, many thanks to the various contributors.

I do have one question, once I've made the changes to the database will a rescan by Boxee override the changes I've made. I would assume the manual adds it won't (can't see how since it never got them in there in the first place). However, what about manual changes to thumbnails or the strTitle field or anything like that?

To be more detailed let me give an example, if I choose to change the strTitle field in the database for the 1965 movie The Great Race with "The Great Race" (a Boxee scan correctly added this movie however it shows up as "the great race", yes all lower case). So if I fix this will a rescan later just put it back to the lower case one?

[BuddyLee]

I stumbled over an amazing discovery ...
I download tons of anime and their file name formats are kinda dodgy so that it isnt recognised for the most part.

But example i downloaded the dragon ball z remastered series and there are multiple seasons known to imdb.

the file names i download are in this format ...
[DBNL]Dragonball_Z_-_001_-_The_new_Threat_[DR][x264][F26CC67E]

so i checked imdb and realised that season 1 ended at ep ep 30 something ... so inside the dragon ball z folder i created i made a folder saying season 1 and put the s1 eps in there.

Did a scan and now my dbz shows up in the correct folders.

Maybe a start but i think i am beginning to get the hang of it. Just make sure the name of the show in the corresponding folder is the same if its a series. Also try to add season folders.

[skitzes]

Thanks to all the contributors to this thread, it was very helpful in getting my new Boxee setup organized the way I want it.

Maybe 10% of the artwork changes I've made don't seem to be making it into Boxee, as Boxee is still showing the old artwork even though the database has been updated to point to different posters. Does anyone have any idea why this is happening and how I might fix it? Is it somehow refusing to release the old art for those movies from a cache somewhere?

Thanks again to the devs and community, I'm loving Boxee and just want to tweak it a bit more and it will be perfect for my tastes!

[Thrax]

I just wanted to thank you very much for posting this tutorial. Within about 20 minutes of downloading the SQLite DB utility I had resolved all of the issues with artwork and descriptions that were driving me insane.

[jaytyler]

Thanks to everybody that's contributed to this thread - it really helps.

I'm looking to mark all my TV Shows (local) as being watched in the new beta - does anybody know what field I need to change? I've looked through the whole database for 40 minutes now and I'm not getting anywhere!

[Strawp]

This just changed in the latest version.

There used to be just one "watched" table in the boxee catalog database, now there is a database for each Boxee user and a "watched" table in each.

Drill down through the ~/.boxee/ folder to find them.

You would need to create a script which inserted the path to each video you want to mark as watched in the table under your username.

[jaytyler]

Thanks, I'll have a look. I did find an empty watched table - I didn't realize there where multiple databases