Programmers - change iTunes .xml based on Traktor Collection .xml???

[Patch]

So I've noticed that Play Count in iTunes doesn't get updated when I play tracks in Traktor.

Obviously.

But, is there a way that we can update the iTunes Library xml, based on the Traktor Collection xml?

I'm guessing this could be done in an Excel spreadsheet that does a vlookup on imported iTunes/Traktor xml's held in separate worksheets in tle xls workbook?

I assume the .mp3 filename is the same in both the iTunes/traktor xml, so, could you copy the Play Count field from Traktors xml to the Play Count field in the iTunes xml?

You'd need to run the vlookup/macro in the spreadsheet regularly in order to have your iTunes Play Counts reflect the actual plays in traktor - but even if you only ran it once a week/once a month, at least then you'd have data to work with in Smart playlists based on Play Count value...

Feasible?

[robdquick]

Using excel 2010, I can get the traktor collection.nml to open in excel, and it displays the filepath/name and the playcount, so we could easily read from that.

I cannot get the itunes library.xml to open in excel at all though....

[Patch]

Well that sucks... Can you change the itunes library xml to .txt and open it as text (tab delimited) (?) in excel?

[robdquick]

It opens, but not all of it is displayed, gave me a 'file not fully opened' error on opening (I have over 18000 files in my library).

Also, I can't find any reference to play count anywhere in it, just the info below:

<key>Track ID</key><integer>20527</integer>
<key>Name</key><string>Dance Dance Dance</string>
<key>Artist</key><string>Chic</string>
<key>Album</key><string>100 Hits 70s</string>
<key>Kind</key><string>MPEG audio file</string>
<key>Size</key><integer>5286039</integer>
<key>Total Time</key><integer>219924</integer>
<key>Track Number</key><integer>2</integer>
<key>BPM</key><integer>123</integer>
<key>Date Modified</key><date>2014-07-05T12:57:21Z</date>
<key>Date Added</key><date>2012-06-09T08:48:55Z</date>
<key>Bit Rate</key><integer>192</integer>
<key>Sample Rate</key><integer>44100</integer>
<key>Comments</key><string>Fm - 4A</string>
<key>Persistent ID</key><string>2BEC93A89A988DD6</string>
<key>Track Type</key><string>File</string>
<key>Location</key><string>file://localhost/C:/Users/Rob/Music/Audio Tracks/Albums/100 70's Hits/CD1/02) Chic - Dance Dance Dance.mp3</string>
<key>File Folder Count</key><integer>5</integer>
<key>Library Folder Count</key><integer>1</integer>

[Patch]

Hmmm.... Interesting...

[Patch]

Looks like it SHOULD look like this:

<key>Play Count</key><integer>1337</integer>

Have you ever played that track in iTunes? I imagine there will be no <key>Play Count</key> if the playcount is 0. TBH, none of my tunes get played in iTunes, only Traktor (hence this thread).

Got the above info from this site - some interesting information on iTunes xmls:

http://apple.stackexchange.com/quest...es-play-counts

[robdquick]

Good spot. Looks like I had never played that track in iTunes. Did a search for <key>Play and came across one that had been played:

<key>Track ID</key><integer>25659</integer>
<key>Name</key><string>Amazed</string>
<key>Artist</key><string>Lonestar</string>
<key>Album</key><string>American Anthems By BSBT RG</string>
<key>Genre</key><string>pop / rock</string>
<key>Kind</key><string>MPEG audio file</string>
<key>Size</key><integer>9659303</integer>
<key>Total Time</key><integer>241057</integer>
<key>Track Number</key><integer>17</integer>
<key>Year</key><integer>2010</integer>
<key>BPM</key><integer>140</integer>
<key>Date Modified</key><date>2014-07-05T12:42:07Z</date>
<key>Date Added</key><date>2012-06-09T08:50:15Z</date>
<key>Bit Rate</key><integer>320</integer>
<key>Sample Rate</key><integer>44100</integer>
<key>Comments</key><string>Ab - 4B</string>
<key>Play Count</key><integer>1</integer>
<key>Play Date</key><integer>3489210276</integer>
<key>Play Date UTC</key><date>2014-07-26T08:04:36Z</date>
<key>Persistent ID</key><string>5313C54258090DE4</string>
<key>Track Type</key><string>File</string>
<key>Location</key><string>file://localhost/C:/Users/Rob/Music/Audio%20Tracks/Albums/American%20Anthems/CD1/17.%20Lonestar%20-%20Amazed.mp3</string>
<key>File Folder Count</key><integer>5</integer>
<key>Library Folder Count</key><integer>1</integer>

So yes, theoretically you could do some fancy excel stuff to update the playcount from the traktor collection to the iTunes library file. Excel is not my strong point though, so I'm probably not going to be much help....

[Nicky H]

It can be done but Traktor displays the path differently so you'd have to do some fancy excel programming.

It has <LOCATION DIR="/:folder/:folder/:" some other suff & then VOLUME="C:"></LOCATION> or whatever in the same tag.

I don't know anything about excel but it would be easy enough to do in just about any other language that can parse xml.

[Patch]

We're making good progress here, fellas! I'm terrible with software, so hopefully someone will chime in with some good ideas...

[Patch]

We just need to find SOMETHING in each xml that is labelled the same for the vlookup to work...