Using "My Movies" movie collection management software as source for movie meta data?

  Thread Rating:
  • 1 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
bramblepants Offline
Member
Posts: 99
Joined: Oct 2008
Reputation: 0
Question  Using "My Movies" movie collection management software as source for movie meta data?
Post: #1
Hi everyone,

I'm a long standing user of MyMovies on my Vista media center and have just discovered XBMC. Am loving the interface and all the skinning options but miss the Collection Management and WebService of MyMovies....

I have just over 700 movies in my collection, all added using the MyMovies collection management software which pulls the info from the MyMovies webservice and stores it in a SQL database - which developers are allowed to access on a read only basis. The advantage of the WebService is it stores a direct copy of information as it appears on the front/back of the DVD/Bluray disk and is a lot more reliable, compared than from IMDB etc..

My question is, and am going on a lot of presumptions - after XBMC scrapes whatever website you ask it to, it stores the information in an SQL database as well. How hard would it be to tell XBMC to look up the cells in the stored MyMovies database, rather than the one it normally uses?

Obviously things will be stored in different locations, but I'm hoping that can be changed as well.

What I'd like to be left with is the excellent backend of MyMovies, but the front end of XBMC with its better effects, fanart and interface etc...

Anyone know if this would be possible and suggest a good place to start? I'm not at home at the moment, but will have a look at both databases and see how similar they are...

Cheers,

Bramble
find quote
Gamester17 Offline
Team-XBMC Forum Moderator
Posts: 10,523
Joined: Sep 2003
Reputation: 10
Location: Sweden
Post: #2
bramblepants Wrote:My question is, and am going on a lot of presumptions - after XBMC scrapes whatever website you ask it to, it stores the information in an SQL database as well. How hard would it be to tell XBMC to look up the cells in the stored MyMovies database, rather than the one it normally uses?
I believe that a much easier approach would be to write a python script (or computer software) that export the meta data information from MyMovies database into XML formatted NFO files that are compatible with the XBMC standard, as then XBMC will simply be able to import (scrape) the meta data information from those XML formatted NFO files into XBMC's own SQL database without any modification needed to be done to XBMC.

Begin by reading this to understand the concept of XML formatted NFO files (a XBMC concept):
http://wiki.xbmc.org/?title=Import_-_Exp..._nfo_Files

For the computer software concept see billyad2000's "XBMC Media Companion" and "XBMC-DB" tools:
http://forum.xbmc.org/showthread.php?tid=33961
and
http://forum.xbmc.org/showthread.php?tid=31511

"DVDProfiler" python script does something similar:
http://forum.xbmc.org/showthread.php?tid=22520

This is also a relative discussion:
http://forum.xbmc.org/showthread.php?tid=38153

More information about XBMC databases and library mode can be found in the wiki:
http://wiki.xbmc.org/?title=Category:Library

Happy coding! Big Grin

Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.
find quote
ultrabrutal Offline
Posting Freak
Posts: 952
Joined: Feb 2005
Reputation: 0
Location: South of Heaven
Post: #3
http://trac.xbmc.org/ticket/4997
find quote
bramblepants Offline
Member
Posts: 99
Joined: Oct 2008
Reputation: 0
Post: #4
Great! Thanks for both of your replies. Looks like I've got some reading, or waiting to do! Smile
find quote
ultrabrutal Offline
Posting Freak
Posts: 952
Joined: Feb 2005
Reputation: 0
Location: South of Heaven
Post: #5
my patch won't be merged until after a stable point release if it is accepted
find quote
Swwethip1 Offline
Senior Member
Posts: 106
Joined: Sep 2008
Reputation: 0
Post: #6
Is it possible to use mymovies database from within xbmc (rather then using imdb)..

I came across THIS

This is a WHS version, but it will allow you to use just the MM database

I find the MM database to be almost rock solid !!
find quote
tfittsy Offline
Junior Member
Posts: 6
Joined: Sep 2008
Reputation: 0
Post: #7
I run MyMovies on my Vista Media Center. It does a very good job of keeping track of all my DVD rips and it has an easy way to edit them. Could someone make something to convert that library to the format for xbmc and grab the images as well? It doesn't seem like it should be too complicated since they're both SQL. Or how about just a tool to edit the library? I've got family guy and scrubs coming up as signing time for kids and some foreign language shows. I don't know how to fix them!
find quote
iansilv Offline
Junior Member
Posts: 17
Joined: Oct 2008
Reputation: 0
Post: #8
any updates on this- does it work now?
find quote
althekiller Offline
Retired Team-Kodi Member
Posts: 5,002
Joined: May 2004
Reputation: 12
Post: #9
Ticket #4997 was applied in r16178. Which provides support for mymovies formatted xml .nfo files. This was AFTER Atlantis final however.
find quote
nugentgl Offline
Donor
Posts: 194
Joined: Nov 2008
Reputation: 0
Post: #10
althekiller - so how does it work? Will XBMC automatically use the mymovies.xml file if it is located in the folder that houses the movie or do I need to configure something somewhere? BTW - I am using the latest SVN 16215 (courtesy of ikons) so it should have this patch.

I too am a convert from VMC to XBMC with hundreds of movies already setup using My Movies.
find quote
shdwkeeper Offline
Junior Member
Posts: 11
Joined: Oct 2008
Reputation: 0
Post: #11
Any info on this?


nugentgl Wrote:althekiller - so how does it work? Will XBMC automatically use the mymovies.xml file if it is located in the folder that houses the movie or do I need to configure something somewhere? BTW - I am using the latest SVN 16215 (courtesy of ikons) so it should have this patch.

I too am a convert from VMC to XBMC with hundreds of movies already setup using My Movies.
find quote
shdwkeeper Offline
Junior Member
Posts: 11
Joined: Oct 2008
Reputation: 0
Post: #12
althekiller Wrote:Ticket #4997 was applied in r16178. Which provides support for mymovies formatted xml .nfo files. This was AFTER Atlantis final however.

So if I'm using XBMC for the Mac how do I get this to work. Do I install these files somewhere or copy them somewhere. Please provide instructions.

Thanks.
find quote
ultrabrutal Offline
Posting Freak
Posts: 952
Joined: Feb 2005
Reputation: 0
Location: South of Heaven
Post: #13
XBMC will pickup the mymovies.xml istead of the nfo file which it did before. Ofcourse if you have no mymovies.xml it will use the nfo as normally.
find quote
spiff Offline
Retired Developer
Posts: 12,386
Joined: Nov 2003
Post: #14
i assume you will follow up and deliver patches for trailers and the other stuff that was missing?
find quote
shdwkeeper Offline
Junior Member
Posts: 11
Joined: Oct 2008
Reputation: 0
Post: #15
ultrabrutal Wrote:XBMC will pickup the mymovies.xml istead of the nfo file which it did before. Ofcourse if you have no mymovies.xml it will use the nfo as normally.

What files do I need and where do I put them to get this to work? I have the latest version of XBMC for the Mac and it doesn't pick these .xml files up.

Can we get instructions on what to do here please.
find quote
Post Reply