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.

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

Yup, what Mithi said ...

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

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

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 [email protected]>
<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>

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.

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.