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: Desktop Technical Support Page: 1  Previous   Next
Export XML File on Vista and import on MAC
Author Message
DVD Profiler Unlimited Registrantvdlattre
Registered: June 11, 2007
Posts: 3
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Hello,

I am looking for some support as I tried to export my entire DVD collection from DVDProfiler on my Vista PC using the export functionlity to an XML file.
I use DVDPedia on my Macintosh which has the functionality to import XML format files.

My problem is that the XML file created lost all the accents and replace those with funny caracters !!!
Most of my DVD are french with french summary and french names with accents.... You can imagine the kind of text and title I got after the import process ????

Does anybody knows how to export to XML format with accent and copy the file to Macintosh keeping the accents

thanks in advance for your support and help

Vincent
DVD Profiler Desktop and Mobile Registrantlmoelleb
Beer Profiler now!
Registered: March 14, 2007
Denmark Posts: 630
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
This again comes down to DVD Profiler not being a Unicode application

Here is one way you can fix it:

1: Open the file in Notepad on the Windows system (or another text iditor, Notepad can be a bit slow with big files)
2: In the first line, locate the text "windows-1252". Replace this with "ISO-8859-1"
3: Search replace the euro sign € with: €
4: Save the file. It should now load correctly on any computer.

Alternative way:
1: Open the file in Notepad on the Windows system (Again you can use another text editor if it supports encodings, but then you are on your own figuring out how to do it)
2: In the first line, locate the text "windows-1252". Replace this with "UTF-8"
3: Select "Save as" and in the dialog change the encoding to "UTF-8" before saving.
4: It should now load correctly on most computers, but I can't promise the mac is one of them (for the technical inclined: Notepad writes a BOM - Byte Order Mark - when saving, and this is not valid for the 1.0 XML standard - but many readers will load it anyway).
Regards
Lars
 Last edited: by lmoelleb
DVD Profiler Desktop and Mobile Registrantlmoelleb
Beer Profiler now!
Registered: March 14, 2007
Denmark Posts: 630
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Oops, I was a bit too fast blaming only DVD Profiler's lack of Unicode support.

The problem also arrises due to the incompetence of either Apple or whoever wrote the XML reader used by DVDPedia. "windows-1252" is a standard registered codepage name, and there is no excuse not supporting it by default on a modern OS. Until UTF-8 finally takes over Windows 1252 will remain one of the most used codepages in the world.
Regards
Lars
DVD Profiler Unlimited RegistrantStar Contributorsnarbo
Registered: March 13, 2007
United Kingdom Posts: 1,242
Posted:
PM this userDirect link to this postReply with quote
Microsoft cutting corners again...using their own standard instead of using the "World Standard" you will find the problem with most MS apps. as well, Word, Excel, Acces etc.

Steve
DVD Profiler Unlimited Registrantvdlattre
Registered: June 11, 2007
Posts: 3
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Hello...

I edited the DVDProfiler XML generated file directly on my Mac and changed as suggested "windows-1252" with "UTF-8" on the first line.
I then imported again with DVDPedia and I got all accents... YES... Thanks very much it worked perfectly...

Now I just have another problem..... DVDProfiler export XML file is NOT exporting the all field....
I am missing the sorting Title field... Any idea how to include this missing field into the XML file

Best Regards and many thanks
Vincent
DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
Registered: May 1, 2002
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 6,741
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
If you do a full export it should be there, it's just not "near" the title.

E.g. House M.D. season 1:

Quote:

<?xml version="1.0" encoding="windows-1252"?>
<!--DVD Profiler Collection Export-->
<Collection>
  <DVD>
    <ProfileTimestamp>2008-06-13T06:42:00.000Z</ProfileTimestamp>
    <ID>5050582420760.4</ID>
    <MediaTypes>
      <DVD>True</DVD>
      <HDDVD>False</HDDVD>
      <BluRay>False</BluRay>
    </MediaTypes>
    <UPC>5-050582-420760</UPC>
    <CollectionNumber/>
    <CollectionType>Owned</CollectionType>
    <Title>Dr. House: Season 1</Title>
    <DistTrait/>
    <OriginalTitle>House M.D.: Season 1</OriginalTitle>
    <CountryOfOrigin>United States</CountryOfOrigin>
    <ProductionYear>2004</ProductionYear>
    <Released>2006-02-27</Released>
    <RunningTime>0</RunningTime>
    <RatingSystem>Film</RatingSystem>
    <Rating>15</Rating>
    <RatingAge>15</RatingAge>
    <RatingVariant>0</RatingVariant>
    <CaseType>Slip Case</CaseType>
    <Genres>
      <Genre>Drama</Genre>
      <Genre>Television</Genre>
    </Genres>
    <Regions>
      <Region>2</Region>
    </Regions>
    <Format>
      <FormatAspectRatio>1.33</FormatAspectRatio>
      <FormatVideoStandard>PAL</FormatVideoStandard>
      <FormatLetterBox>False</FormatLetterBox>
      <FormatPanAndScan>True</FormatPanAndScan>
      <FormatFullFrame>False</FormatFullFrame>
      <Format16X9>False</Format16X9>
      <FormatDualSided>False</FormatDualSided>
      <FormatDualLayered>False</FormatDualLayered>
    </Format>
    <Features>
      <FeatureSceneAccess>False</FeatureSceneAccess>
      <FeatureCommentary>False</FeatureCommentary>
      <FeatureTrailer>False</FeatureTrailer>
      <FeaturePhotoGallery>False</FeaturePhotoGallery>
      <FeatureDeletedScenes>False</FeatureDeletedScenes>
      <FeatureMakingOf>True</FeatureMakingOf>
      <FeatureProductionNotes>False</FeatureProductionNotes>
      <FeatureGame>False</FeatureGame>
      <FeatureDVDROMContent>False</FeatureDVDROMContent>
      <FeatureMultiAngle>False</FeatureMultiAngle>
      <FeatureMusicVideos>False</FeatureMusicVideos>
      <FeatureInterviews>True</FeatureInterviews>
      <FeatureStoryboardComparisons>False</FeatureStoryboardComparisons>
      <FeatureOuttakes>False</FeatureOuttakes>
      <FeatureClosedCaptioned>False</FeatureClosedCaptioned>
      <FeatureTHXCertified>False</FeatureTHXCertified>
      <OtherFeatures>Casting tapes with Hugh Laurie</OtherFeatures>
    </Features>
    <Studios>
      <Studio>Universal Network Television</Studio>
      <Studio>Heel &amp; Toe</Studio>
      <Studio>Shore Z Prods.</Studio>
    </Studios>
    <MediaCompanies/>
    <Audio>
      <AudioTrack>
        <AudioContent>English</AudioContent>
        <AudioFormat>Dolby Digital 5.1</AudioFormat>
      </AudioTrack>
    </Audio>
    <Subtitles/>
    <SRP DenominationType="GBP" DenominationDesc="Great Britain (Pound)" FormattedValue="£49,99">49.99</SRP>
    <Actors/>
    <Credits/>
    <Overview>Go deeper into the medical mysteries of &apos;House&apos;, TV&apos;s most compelling new drama. Hugh Laurie stars as the brilliant but sarcastic Dr. Gregory House, a maverick physician who is devoid of bedside manner. While his behaviour can border on antisocial, Dr. House thrives on the challenge of solving medical puzzles that other doctors give up on. Together with his handpicked team of young medical experts, he&apos;ll do whatever it takes in the race against the clock to solve the case.

Episode List:
1. Pilot
2. Paternity
3. Occam&apos;s Razor
4. Maternity
5. Damned If You Do
6. The Socratic Method
7. Fidelity
8. Poison
9. DNR
10. Histories
11. Detox
12. Sports Medicine
13. Cursed
14. Control
15. Mob Rules
16. Heavy
17. Role Model
18. Babies &amp; Bathwater
19. Kids
20. Love Hurts
21. Three Stories
22. Honeymoon</Overview>
    <EasterEggs/>
    <Discs/>
    <SortTitle>Dr. House S1</SortTitle>
    <LastEdited>2009-01-09T20:04:28.000Z</LastEdited>
    <WishPriority>0</WishPriority>
    <PurchaseInfo>
      <PurchasePrice DenominationType="EUR" DenominationDesc="Europe (Euro)" FormattedValue="€0,00">0</PurchasePrice>
      <PurchasePlace/>
      <PurchasePlaceType/>
      <PurchasePlaceWebsite/>
      <PurchaseDate>2009-01-09</PurchaseDate>
    </PurchaseInfo>
    <Review Film="0" Video="0" Audio="0" Extras="0"/>
    <Events/>
    <BoxSet>
      <Parent/>
      <Contents>
        <Content>I30042475D3C5B230.4</Content>
        <Content>I4AF3B64F9C968236.4</Content>
        <Content>I4FD9F93A6B161114.4</Content>
        <Content>I531A9E8C1A61D0C9.4</Content>
        <Content>IAF7A24CB50F897DB.4</Content>
        <Content>IFCE54FD759FFBC5A.4</Content>
      </Contents>
    </BoxSet>
    <LoanInfo>
      <Loaned>False</Loaned>
    </LoanInfo>
    <Notes>02:47:50 168
02:48:24 168
02:48:06 168
02:49:09 169
02:49:13 169
01:24:35 85
-------------------
15:27:17 927
-------------------
</Notes>
    <Tags>
      <Tag Name="ungesehen" FullName="ungesehen"/>
      <Tag Name="Box-Set" FullName="Box-Set"/>
      <Tag Name="Serienbox" FullName="Box-Set/Serienbox"/>
      <Tag Name="Season-Box" FullName="Box-Set/Serienbox/Season-Box"/>
      <Tag Name="nie gesehen" FullName="ungesehen/nie gesehen"/>
      <Tag Name="Cast bearbeitet" FullName="Profil bearbeitet/Cast bearbeitet"/>
      <Tag Name="Crew bearbeitet" FullName="Profil bearbeitet/Crew bearbeitet"/>
      <Tag Name="Profil bearbeitet" FullName="Profil bearbeitet"/>
      <Tag Name="Kauf-Item" FullName="Kauf-Item"/>
    </Tags>
    <Locks>
      <Entire>False</Entire>
      <Covers>False</Covers>
      <Title>True</Title>
      <MediaType>False</MediaType>
      <Overview>False</Overview>
      <Regions>False</Regions>
      <Genres>False</Genres>
      <SRP>True</SRP>
      <Studios>False</Studios>
      <DiscInformation>True</DiscInformation>
      <Cast>True</Cast>
      <Crew>True</Crew>
      <Features>False</Features>
      <AudioTracks>False</AudioTracks>
      <Subtitles>False</Subtitles>
      <EasterEggs>False</EasterEggs>
      <RunningTime>True</RunningTime>
      <ReleaseDate>False</ReleaseDate>
      <ProductionYear>False</ProductionYear>
      <CaseType>False</CaseType>
      <VideoFormats>False</VideoFormats>
      <Rating>False</Rating>
    </Locks>
  </DVD>
</Collection>
Karsten
DVD Collectors Online

 Last edited: by DJ Doena
DVD Profiler Desktop and Mobile Registrantlmoelleb
Beer Profiler now!
Registered: March 14, 2007
Denmark Posts: 630
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting snarbo:
Quote:
Microsoft cutting corners again...using their own standard instead of using the "World Standard" you will find the problem with most MS apps. as well, Word, Excel, Acces etc.

Steve


Microsoft did not ask Ken to use the codepage "windows-1252". They have deprecated it a long time ago and recommends utf-8 in streams and utf-16 in memory like everyone else.  I do not know why Microsoft are to be blamed for this?

While obviously a deprecated codepage (also on Windows systems) the fact unfortunately remain that it is one of the most used codepages in the world. Supporting it is quite simple (it has a unicode mapping available from www.unicode.org and "windows-1252" is registered with IANA).

So yes, any modern OS should load this just fine. Failure to recognize the registered header of one of the most used codepages (even if we can all agree it is not an ideal codepage) can be either incompetence or malice. Per Hanlon's razor, I assume incompetence.
Regards
Lars
 Last edited: by lmoelleb
DVD Profiler Unlimited Registrantvdlattre
Registered: June 11, 2007
Posts: 3
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Yes you are right... I found the field.... DVDProfiler is exporting the sorting title field...
I did not look carefully in the entire file.

I guess the problem is with DVDPedia import, as this field is not copied nor imported
I will post a support request on the DVDPedia web site

Best Regards
and many thanks
Vincent
    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next