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 2  Previous   Next
XML Export file problem
Author Message
DVD Profiler Unlimited RegistrantStar ContributorTomGaines
Registered Sept. 24, 2001
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,005
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
I just tried to parse the new XML export file with MSXML and get this error:

Semicolon expected
<Studio>A&M Films</Studio>


Shouldn't it be
<Studio>A&amp;M Films</Studio>
?


DVD Profiler Unlimited Registrantdvdoug
As seen on Slashdot...
Registered: March 13, 2007
Posts: 55
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
I knew the new XML format sounded too good to be true...
Doug

DougWeb.org - my personal site.
TWSNBN.com
Unofficial DVD Profiler Resource Centre - serving hundreds of users every month!
DVD Profiler Wiki
DVD Profiler Unlimited RegistrantStar ContributorTomGaines
Registered Sept. 24, 2001
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,005
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Another thing I am not quite sure about.
The new BoxSet tag.
It seems, that now instead of listing the childs of a profile, the child profile now gets the reference to the parent. So far so good. But what is listed under the tag "Contents"?
It seems that there is always only one tag "Content" inside it. Probably one child (where is the rest?). But sometimes it isn't even the child, but the parent profile itself.


DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Superior Rating
Germany Posts: 2,217
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting TomGaines:
Quote:
I just tried to parse the new XML export file with MSXML and get this error:

Me too!
It's seems to affect only studios, everythink else looks fine on first glance.
As soon as I throw all Studios away [1] xsltproc parses the file without further trouble.

cya, Mithi

[1] grep -v '<Studio>' collection.xml > collection-new.xml
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
DVD Profiler Unlimited RegistrantStar ContributorTomGaines
Registered Sept. 24, 2001
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,005
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Yes, as far as I can tell, it only affects studios. I had about 30 studios to fix (24 of those were A&E  ).
Now I do not have any parsing errors.


Invelos Software, Inc. RepresentativeKen Cole
Invelos Software
Registered: March 10, 2007
United States Posts: 4,282
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
It seems a fix to a late-breaking bug has broken encoding of some fields. 

I plan to put out a 3.0.1 very soon, with the first beta in about a week.
Invelos Software, Inc. Representative
DVD Profiler Unlimited RegistrantStar ContributorTomGaines
Registered Sept. 24, 2001
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,005
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Is it on purpose that the local currency/decimal seperator is used in the XML?


DVD Profiler Unlimited RegistrantStar ContributorTomGaines
Registered Sept. 24, 2001
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,005
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Beside the currency decimal seperator problem (which is an important issue, if someone wants to exchange XML collections internationally), I noticed a few other things:

- CurrencyID and CurrencyName is not exported anymore. This is important to differenciate between for example US, Canadian and Austrialian dollar.
- The currency symbol is still one string with the value. That should be seperated.
- Email address and phone number of users are not exported anymore
- Purchase place type and website of retailers is not exported anymore


DVD Profiler Unlimited RegistrantStar ContributorTomGaines
Registered Sept. 24, 2001
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,005
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Collection number is missing.


DVD Profiler Unlimited Registrantgoodguy
Sita Sings the Blues
Registered: March 14, 2007
Reputation: Superior Rating
Germany Posts: 1,029
Posted:
PM this userDirect link to this postReply with quote
The new comment field for "Watched" events is not exported.
Matthias
DVD Profiler Unlimited RegistrantFredLooks
phpDVDProfilerDude D5/7/2
Registered: March 13, 2007
Canada Posts: 350
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
In DVDP 2.x, the overview field had all non-printable characters (including CR and LF) encoded as &#xxx;
In DVDP 3.0, the non-printables are left as 8-bit characters. I'm just wondering if this is intentional (it definitely screws up the XML parser that I'm using, but I'm not enough of an XML guru to know if there is a right and a wrong here; it could simply be two different ways of doing things (that would be my guess)
-fred
DVD Profiler Unlimited Registrantgoodguy
Sita Sings the Blues
Registered: March 14, 2007
Reputation: Superior Rating
Germany Posts: 1,029
Posted:
PM this userDirect link to this postReply with quote
Usually, you tell the parser how it should handle whitespace in certain tags (preserve, collapse, replace).
Matthias
 Last edited: by goodguy
DVD Profiler Unlimited Registrantgoodguy
Sita Sings the Blues
Registered: March 14, 2007
Reputation: Superior Rating
Germany Posts: 1,029
Posted:
PM this userDirect link to this postReply with quote
Also not exported: FeatureOther from the Features group.
Matthias
DVD Profiler Unlimited Registrantgoodguy
Sita Sings the Blues
Registered: March 14, 2007
Reputation: Superior Rating
Germany Posts: 1,029
Posted:
PM this userDirect link to this postReply with quote
More missing fields, from the Discs/Disc group:

LabelSideA
LabelSideB
DualSided (may have been dropped due to DescriptionSideA/B)
Flipper (may have been dropped since it doesn't appear in the UI either)
Matthias
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Superior Rating
Germany Posts: 2,217
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting FredLooks:
Quote:
(it definitely screws up the XML parser that I'm using,

It shouldn't, the XML is correctly[1] marked as
<?xml version="1.0" encoding="windows-1252"?>

cya, Mithi

[1] Well, apart from the & in Studios of course 
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
DVD Profiler Unlimited RegistrantFredLooks
phpDVDProfilerDude D5/7/2
Registered: March 13, 2007
Canada Posts: 350
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Mithi:
Quote:
Quoting FredLooks:
Quote:
(it definitely screws up the XML parser that I'm using,

It shouldn't, the XML is correctly[1] marked as
<?xml version="1.0" encoding="windows-1252"?>

cya, Mithi

[1] Well, apart from the & in Studios of course 


Correct, of course. I should have said that it definitely screws up the parsing methodology that I'm using 
XML_OPTION_SKIP_WHITE in the php parser elides the newlines. Now if I could easily determine why the parser is un-encoding the xml primitives (&lt; etc.) then I'd understand how the parsing is working (I think )
-fred
    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1 2  Previous   Next