Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: Plugins Page: 1 2  Previous   Next
Import From MyMovies.xml
Author Message
DVD Profiler Desktop and Mobile RegistrantAdrian Wright
Registered: April 9, 2007
United Kingdom Posts: 52
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Good afternoon,

I have an XML file from mymovies which I would like to import back into DVDProfiler. I would like to bring across the Purchased and Watched Fields and would appreciate any assistance you kind users could give please   

Thank you in advance
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,100
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Adrian Wright:
Quote:
I have an XML file from mymovies which I would like to import back into DVDProfiler. I would like to bring across the Purchased and Watched Fields and would appreciate any assistance you kind users could give please 

It's been done before so it should work again!

Read this thread carefully, if I understood you correctly the provided XSL should fit your needs[1].
Simply install BulkEdit (see top of this forum) and import the new XML.

Tipp: to get a hang of it work with a few titles at first and do the whole mass again when everything works as expected.

cya, Mithi

PS Just realized you are from the UK, so some fine-tuning regarding the ID is needed because of you locality. If the majority of your collection is "UK" I would simply put the according number to every <ID>.

[1] Just saw that back then Purchase-Info was not needed/included. No problem, just provide a sample of how those informations look in mymovies-XML.
Mithi's little XSLT tinkering - the power of XML          Store and find Alternative Covers
The DVD Profiler Wiki - DVDProKB:Community - recent additions: 'Workaround for "Paste and Append Crew"-problem' and 'Making mass changes'
 Last edited: by Mithi
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 4,706
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Did you ever get this done?
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
 Last edited: by mediadogg
DVD Profiler Desktop and Mobile RegistrantAdrian Wright
Registered: April 9, 2007
United Kingdom Posts: 52
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Hi,

I have not attempted this yet as I do not have access to a windows machine at the moment. Once my Surface Pro 3 is delivered, would it be ok to seek assistance and help then please?

Thanking you both in advance

Regards


Adrian
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,100
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Adrian Wright:
Quote:
would it be ok to seek assistance and help then please?

Absolutely.

We will drag you in even if you are kicking and screaming 
Mithi's little XSLT tinkering - the power of XML          Store and find Alternative Covers
The DVD Profiler Wiki - DVDProKB:Community - recent additions: 'Workaround for "Paste and Append Crew"-problem' and 'Making mass changes'
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 4,706
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Yup, what Mithi said ...
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
DVD Profiler Desktop and Mobile RegistrantAdrian Wright
Registered: April 9, 2007
United Kingdom Posts: 52
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Good morning Gents,

I have today tried to look at this and cannot for the life of me understand what I am supposed to do 

I have a 40.2mb XML file from MyMovies which does not import into the bulkedit program as it states it is an invalid format. Any help you could give would be appreciated. There are around 1250 profiles in this xml file and I would like to be able to import this into DVDP with the watched, purchased from and date data intact if at all possible.

Sorry for being a pain, I hope one of you kind guys can assist please     

Thank you once again in advance
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,100
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Adrian Wright:
Quote:
I have today tried to look at this and cannot for the life of me understand what I am supposed to do 

Yeah, XML/XSLT can look a bit intimidating if you are into it.
Quote:
I have a 40.2mb XML file from MyMovies which does not import into the bulkedit program as it states it is an invalid format.

You would have to transform this file into the XML-Format DVD Profiler uses first.

Easiest way: zip the whole thing (text compresses quite nicely), press and mail me the thing. I'll take a look at it, shouldn't be too hard as this was done before.

cya, Mithi
Mithi's little XSLT tinkering - the power of XML          Store and find Alternative Covers
The DVD Profiler Wiki - DVDProKB:Community - recent additions: 'Workaround for "Paste and Append Crew"-problem' and 'Making mass changes'
DVD Profiler Desktop and Mobile RegistrantAdrian Wright
Registered: April 9, 2007
United Kingdom Posts: 52
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Thank you very Mithi, I am so grateful     

I have sent you the email containing the XML as requested.

Kindest Regards


Adrian
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,100
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Small update: it's still going forward, quite some work already done, but as so often the case life interferes with hobby 

On a different note, the MyMovies-XML seems like a good showcase how not to structure an XML.
First off, the data is split into 3 sections:
<Collection>
  <DiscTitles>
  <Movies>
  <TVSeries>
</Collection>
I think the basic idea was(!) to have all disc related data in the first section and from there link to the movie or TVseries related data in the according section. But somehow they didn't really go trough with it which now leaves you e.g. with a "Watched" event in the <DiscTitle> while the linked <Movie> claims to be unwatched.
Some other data is duplicated too, sometime synced, sometimes not.
So to not lose my sanity I generally used the <DiscTitles>-Section and will incorporate single bits of information from the other sections if and where really necessary.

And I hope there is a special place in Hell reserved for whoever came up with the idea to store dates in this horrid format: "2/24/2013 8:12:32 PM"
I thought for 5 minutes how to parse this in XSLT, and then decided to give the 40MB-XML a nice search-and-replace to have the dates to fixed width.

ca, Mithi
Mithi's little XSLT tinkering - the power of XML          Store and find Alternative Covers
The DVD Profiler Wiki - DVDProKB:Community - recent additions: 'Workaround for "Paste and Append Crew"-problem' and 'Making mass changes'
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 4,706
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
I'm waiting in the wings to address any issues if you decide to use BulkEdit for the XML import. It is supposed to work for DVDP format XML, which Mithi knows very well indeed.

Sorry I didn't comment earlier. I missed seeing the post until today.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantSallieKr
Registered: October 13, 2014
United States Posts: 14
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
First, a brief intro since I'm new here. I've been playing with/programming computers since about 1979- mostly as a hobby. I never understood C... I've programmed in several assembly and scripting languages (various editors, Rexx for OS/2, PHP, etc). My husband and I have been collecting DVDs since the first player came onto the market at $500!!!

I haven't tried BulkEdit yet, but I plan to soon!

I wish I had found this thread when I first decided to try DVD Profiler about a month ago! I too was using MyMovies on my desktop and various Android devices, but there were some things I didn't like- especially that even though I installed MM to D:, the database is on C: and I could find no way to move it. I exported MM to XML (about 4400 titles). I then used the FirstObject XML (free!) editor and wrote a script to extract only the barcodes, split into files containing 100 barcodes each. I'd originally wanted to convert the MM XML to DVDP XML (which could be done using FirstObject's scripting language), but that was taking me too long to figure out. After importing into DVDP, due to the "Child Profiles", I'm now seeing 6362 titles with (originally) about 200 unrecognized barcodes- which I'm working on contributing to the database.

I agree that the MM format is weird (date, etc) - and takes up a LOT of disk space- in my case 6.68G as opposed to 1.77G for DVDP, including "High Quality" selected for the DVD covers. I have no idea why they chose to have the separate "Movies", "TV Series", etc. sections in the XML. All of the key fields are in the "Titles" section with links to the "Movies" etc sections. When exporting to XML, you get a pop-up selection list of what to export. I de-selected everything but "Titles". This resulted in a 51k XML file with this format (I deleted/truncated unnecessary data):

<!--This file is created by My Movies (http://www.mymovies.dk) as an export of a user collection, and may only be used for personal purpososes by the exporting user. If you would like to use the data contained in the file for other purposes, please contact support@mymovies.dk.-->
<Collection>
  <DiscTitles>
    <DiscTitle>
      <ConnectedTVSeriesID>
      </ConnectedTVSeriesID>
      <ConnectedMovieID>d7157a2f-c6e0-4cad-a208-42e58514cbcd</ConnectedMovieID>
      <MediaType>Movie</MediaType>
      <CoverType SlipCover="False">
      </CoverType>
      <Type BluRay3D="False" MasteredIn4K="False">DVD</Type>
      <Barcode>031398791126</Barcode>
      <Country>United States</Country>
      <LocalTitle>"O"</LocalTitle>
      <OriginalTitle>"O"</OriginalTitle>
      <SortTitle>O</SortTitle>
      <Edition>2-Disc Deluxe Edition</Edition>
      <IMDB>tt0184791</IMDB>
      <Rating>6</Rating>
      <AspectRatio>1.85:1</AspectRatio>
      <VideoStandard>NTSC</VideoStandard>
      <ProductionYear>2001</ProductionYear>
      <ReleaseDate>2/19/2002</ReleaseDate>
      <RunningTime>95</RunningTime>
      <TagLine />
      <Description><![CDATA[Hot young stars...]]></Description>
      <ExtraFeatures NotPresent="False"><![CDATA[Disc One:...
]]></ExtraFeatures>
      <ParentalRating Adult="False" TV="False">
        <Value>6</Value>
        <Description>Rated R... </Description>
      </ParentalRating>
      <LocalTrailer>
        <URL>
        </URL>
      </LocalTrailer>
      <Covers>
        <Front>Covers\16b7419f-66ad-4cc8-a627-7332c43ddda3.jpg</Front>
        <Back>Covers\260666ae-7d0c-4d95-b810-a5313446b212.jpg</Back>
      </Covers>
      <Categories />
      <Genres>
        <Genre>Suspense/Thriller</Genre>
        <Genre>Drama</Genre>
      </Genres>
      <AudioTracks>
        <AudioTrack Language="English" Type="Dolby Digital" Channels="5.1" />
      </AudioTracks>
      <Subtitles NotPresent="False">
        <Subtitle Language="English" />
        <Subtitle Language="Spanish" />
      </Subtitles>
      <Studios>
        <Studio>Chickie The Cop Production</Studio>
        <Studio>Daniel Fried Productions</Studio>
      </Studios>
      <Discs>
        <Disc BonusDisc="False" DigitalCopy="False">
          <DoubleSided>False</DoubleSided>
          <Name>Feature</Name>
          <LocationSideA>
          </LocationSideA>
          <LocationTypeSideA>3</LocationTypeSideA>
          <LocationSideB>
          </LocationSideB>
          <LocationTypeSideB>-1</LocationTypeSideB>
          <ChangerSlot>
          </ChangerSlot>
          <MobileLocationSideAPrimary>
          </MobileLocationSideAPrimary>
          <MobileLocationSideASecondary>
          </MobileLocationSideASecondary>
          <MobileLocationSideBPrimary>
          </MobileLocationSideBPrimary>
          <MobileLocationSideBSecondary>
          </MobileLocationSideBSecondary>
        </Disc>
        <Disc BonusDisc="False" DigitalCopy="False">
          <DoubleSided>False</DoubleSided>
          <Name>Bonus Features</Name>
          <LocationSideA>
          </LocationSideA>
          <LocationTypeSideA>3</LocationTypeSideA>
          <LocationSideB>
          </LocationSideB>
          <LocationTypeSideB>-1</LocationTypeSideB>
          <ChangerSlot>
          </ChangerSlot>
          <MobileLocationSideAPrimary>
          </MobileLocationSideAPrimary>
          <MobileLocationSideASecondary>
          </MobileLocationSideASecondary>
          <MobileLocationSideBPrimary>
          </MobileLocationSideBPrimary>
          <MobileLocationSideBSecondary>
          </MobileLocationSideBSecondary>
        </Disc>
      </Discs>
      <Persons ActorsComplete="False">
        <Person>
          <Name>Mekhi Phifer</Name>
          <Type>Actor</Type>
          <Role>Odin James</Role>
        </Person>
        <Person>
          <Name>Tim Blake Nelson</Name>
          <Type>Director</Type>
          <Role>
          </Role>
        </Person>
      </Persons>
      <PersonalData Group="Owned" CollectionNumber="3700" Watched="False" Online="False" Personal="False" Added="7/28/2012 10:32:01 PM" LentTo="" LentDue="1/1/1753 12:00:00 AM" Rating="-1" Location="" Purchased="1/1/1753 12:00:00 AM" PurchasePrice="-1" PurchaseCurrency="" ValuePer="1/1/1753 12:00:00 AM" ValuePerAmount="-1" ValuePerCurrency="" PurchasePlace="" Condition="" Notes="" Tags="" PersonalTitle="" PersonalSortTitle="" Categories="" ExcludeOnlineCollection="False" ExcludeMobileSoftware="False" InvisibleToFriends="False">
        <WatchedEvents />
        <DiscLocations>
          <Disc Name="Feature" />
          <Disc Name="Bonus Features" />
        </DiscLocations>
      </PersonalData>
    </DiscTitle>
  </DiscTitles>
</Collection>
DVD Profiler Unlimited RegistrantSallieKr
Registered: October 13, 2014
United States Posts: 14
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I forgot to mention that, probably, the unusual format for MyMovies data is due to "Collection Management" being just a part of a whole suite of software (none of which I've used). It ties in to the other modules for ripping discs and playing them on a home theater system.
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 4,706
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
It appears that you do not have personal data. If that is true, you don't even need BulkEdit. If you can create a simple list of UPCs as a text file, DVD Profiler will import them directly using the "Add DVD" with the "Multiple" option.

The only other twist is that DVDP actually uses an expanded notion of UPC called "Profile ID". It is UPC.Locality, where Locality is a number representing a country - the country where the DVD was marketed (and therefore has a rating consistent with that country). The Locality for US is "0", and is not needed, by convention. So if you only have US titles, all you need is a text file with the UPCs, one per line. And that's it!

But if you have watched data, Location / Slot, Notes, Purchase info or other such personal data, then an XML conversion can be used with BulkEdit to preserve that information. All you need is the personal info and the UPC - the movie data is NOT needed, as that will be downloaded from Invelos. If you try to import it, it will be overwritten, and therefore a waste of time to process the data.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantSallieKr
Registered: October 13, 2014
United States Posts: 14
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Correct. I really didn't have that much personal data, as I didn't keep up with even the watched date. As I said, I did manage to extract just the UPCs from the MM data and import into DVDP- all 4400+ titles, which ended up being 6363 profiles in DVDP. I was just trying to help with the other user who wanted to keep the personal data.

BTW- I just started checking out some of your plugins. Very impressive! I've only installed the Contribution Assistant and tried it on a couple of DVDs so far. I'll remember to donate after I've had a chance to use it a bit 
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 4,706
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Quoting SallieKr:
Quote:
Correct. I really didn't have that much personal data, as I didn't keep up with even the watched date. As I said, I did manage to extract just the UPCs from the MM data and import into DVDP- all 4400+ titles, which ended up being 6363 profiles in DVDP. I was just trying to help with the other user who wanted to keep the personal data.

BTW- I just started checking out some of your plugins. Very impressive! I've only installed the Contribution Assistant and tried it on a couple of DVDs so far. I'll remember to donate after I've had a chance to use it a bit 

Thanks for the update. Guess I didn't read carefully. And further thanks for your kind words and intentions. Much appreciated.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
    Invelos Forums->DVD Profiler: Plugins Page: 1 2  Previous   Next