Invelos Forums->DVD Profiler: Desktop Technical Support |
Page:
1 Previous Next
|
Export XML File on Vista and import on MAC |
|
|
|
Author |
Message |
Registered: June 11, 2007 | Posts: 3 |
| Posted: | | | | 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 |
| Registered: March 14, 2007 | Posts: 630 |
| Posted: | | | | 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 |
| Registered: March 14, 2007 | Posts: 630 |
| Posted: | | | | 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 |
| Registered: March 13, 2007 | Posts: 1,242 |
| Posted: | | | | 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 |
| Registered: June 11, 2007 | Posts: 3 |
| Posted: | | | | 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 |
| Registered: March 14, 2007 | Reputation: | Posts: 6,745 |
| Posted: | | | | 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 & 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 'House', TV'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'll do whatever it takes in the race against the clock to solve the case.
Episode List: 1. Pilot 2. Paternity 3. Occam'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 & 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 |
| Registered: March 14, 2007 | Posts: 630 |
| Posted: | | | | 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 |
| Registered: June 11, 2007 | Posts: 3 |
| Posted: | | | | 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
|
|