tFileInputXML: java and perl, different result

[berntk]

Hi!

 

I was playing around with extracting data from a xml-file, namely the iTunes Music Libaray.xml, which is where iTunes stores information about tracks in the iTunes-libarary.

So I tried the tFileInputXML component and some xPath-queries to extract some data that was of interest.

 

First something about the xml-file:

 

One problem for me with the iTunes Music Libarary.xml file is that it uses key-value pairs where the values are 'interger' or 'string' instead of tags 'Track ID' with a value resulting in a more complex query.

This is an example what the file can look like:

 

Code:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
	<key>Major Version</key><integer>1</integer>
	<key>Minor Version</key><integer>1</integer>
	<key>Application Version</key><string>7.2</string>
	<key>Features</key><integer>1</integer>
	<key>Show Content Ratings</key><true/>
	<key>Music Folder</key><string>file://localhost/D:/music/</string>
	<key>Library Persistent ID</key><string>E2F1C84137ADF1F9</string>
	<key>Tracks</key>
	<dict>
		<key>192</key>
		<dict>
			<key>Track ID</key><integer>192</integer>
			<key>Name</key><string>03 Dear Can</string>
			<key>Artist</key><string>!!!</string>
			<key>Album</key><string>Louden Up Now</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>6655016</integer>
			<key>Total Time</key><integer>277185</integer>
			<key>Track Number</key><integer>3</integer>
			<key>Track Count</key><integer>10</integer>
			<key>Date Modified</key><date>2007-04-27T11:33:26Z</date>
			<key>Date Added</key><date>2007-05-24T08:47:41Z</date>
			<key>Bit Rate</key><integer>192</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>EB130C0FFAD7A62C</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/D:/music/!!!-Louden%20Up%20Now/03%20Dear%20Can.mp3</string>
			<key>File Folder Count</key><integer>3</integer>
			<key>Library Folder Count</key><integer>1</integer>
		</dict>
		<key>192</key>
		<dict>
		...
		</dict>
...
	</dict>
...
</dict>
</plist>

 

[url=http://www.xml.com/pub/a/2004/11/03/itunes.html]And here is a good page that describes the file iTunes Music Libray.xml

 

 

Now to my problem (or if it's a bug):

 

This was my first try with JasperETL (and for some reason I started a Java-project).

And because there was quite awhile since I played around with xPath I had problems to understand why my quieries didn't return the result that I expected.

It was when I tested a Perl-project with same queries and got the result that I expected that suspicions that this might be a bug arose.

 

But still I'm not sure. Mainly because I'm not sure if my queries are correct.

 

In the properties for tFileInputXML I have:

Loop:

Code:

[code]"/plist/dict/dict/dict"

Mapping:

id:

Code:

[code]"./key[contains(.,'Track ID')]//following-sibling::node()[1]"

 

play_count:

Code:

[code]"./key[contains(.,'Play Count')]/following-sibling::node()[1]"

 

 

'id' returned the result that i expected.

'play_count' works as long as there is a Key with value 'Play Count'

 

The error I get is that if there is no key 'Play Count', the play_count get the same value as the last time the was a key 'Play Count'.

That is for 'Java'.

 

But whe I run the same query in 'Perl' the play_count result is an empty string as I expect it to be.

 

So all of this ends up in my questions:

Is this a bug or is my xPath query incorrect?

And if it's a bug, where do I register it?

 

And of course when i tested the Perl-project i realised that 'Perl' was a lot faster than 'Java'.

 

Best Regards

Bernt

[mdahlman]

Hi Bernt,

 

It smells like a bug... but I'm not sure yet. I'll take a look. In the meantime, please enter a bug in the JasperETL Project.

 

Regards,

Matt

JasperSoft