I installed tellico, then added a couple of DVDs to see what the tellico.xml looks like. Here's one dvd entry:
<entry id="0" >
<title>Fool's Gold (Widescreen Edition)</title>
<genre>Action & Adventure</genre>
<studio>Warner Home Video</studio>
<plot>Matthew McConaughey and Kate Hudson go for the gold (and the diamonds emeralds and rubies) as a just-divorced couple who bicker and banter their way through an adventure- and laugh-packed undersea treasure hunt. McConaughey is Finn in love with his ex (Hudson) and in deep with gangster Bigg Bunny. After eight years of searching Finn gets a clue to the whereabouts of the Queen?s Dowry a fabulous fortune that mysteriously disappeared in the Caribbean in 1715. Now all he has to do is get the gold get the girl and get going before Bigg Bunny gets him. Directed by Andy Tennant (Hitch) Fool?s Gold glitters with danger action romance comedy great one-liners ? and a great time to be had by all!Format: DVD MOVIE Genre:Â COMEDY/ROMANTIC COMEDY UPC:Â 085391139997 Manufacturer No:Â 113999</plot>
The pluto_media db to tellico.xml looks like a pretty straight-forward mapping (ok, there are a lot of caveats due to the multi-table and multi-database nature, but I've already worked most of them out on the DVD Profiler sync). Still, there will be a couple of issues:
* Can we use pluto_media.file.PK_File for the tellico entry@id value? That seems to be the ONLY unique identifier on the tellico side. If you want to support adding files independently on both sides, prevention of collision for entry@id might be interesting.
* The only method I see for syncing is via a title match, which can mostly be handled with fuzzy matching (drop punctuation, drop symbols, yada yada) with a fall-back of using the pluto_media.file.Filename if there is not a title attribute. Still there will be some titles that have to be manually matched (duplicates like "The Alamo", and incomplete titles like "Animal House" vs. "National Lampoon's Animal House").
IMO the data still seems a little sparse (see cast in the above DVD). Also while the UI is head and shoulders above pluto-admin, it is still a little primitive. But it is native!