Programmers - change iTunes .xml based on Traktor Collection .xml???
Page 1 of 2 12 LastLast
Results 1 to 10 of 13
  1. #1
    Tech Guru Patch's Avatar
    Join Date
    Dec 2008
    Location
    Bristol, UK
    Posts
    6,467

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

    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?
    DJ'ing: 2x1200MK2, DJM 850, Dicers, F1, Zomo MC-1000, Sony MDR-v700, i7 Win 10 HP Envy
    Production: Ableton Live 8 and a mouse, Sennheiser HD400, Sony VAIO

    Click HERE to D/L Free Tracks from Soundcloud!!!
    https://www.facebook.com/Patchdj

  2. #2
    Tech Guru robdquick's Avatar
    Join Date
    Aug 2011
    Location
    Bristol, UK
    Posts
    590

    Default

    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....
    Mobile DJ. 2 x Denon SC2900, Denon MC-6000 MK2, Wharfedale Titan 15a Powered Speakers, Titan A15 Subs, HP laptop. Shed load of lights!! Maschine Mikro MK2, Xone:K2.

    2nd Generation Mobile DJ
    2G on Twitter | 2G on Facebook
    | RobDQuick On Soundcloud


  3. #3
    Tech Guru Patch's Avatar
    Join Date
    Dec 2008
    Location
    Bristol, UK
    Posts
    6,467

    Default

    Well that sucks... Can you change the itunes library xml to .txt and open it as text (tab delimited) (?) in excel?
    DJ'ing: 2x1200MK2, DJM 850, Dicers, F1, Zomo MC-1000, Sony MDR-v700, i7 Win 10 HP Envy
    Production: Ableton Live 8 and a mouse, Sennheiser HD400, Sony VAIO

    Click HERE to D/L Free Tracks from Soundcloud!!!
    https://www.facebook.com/Patchdj

  4. #4
    Tech Guru robdquick's Avatar
    Join Date
    Aug 2011
    Location
    Bristol, UK
    Posts
    590

    Default

    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>
    Mobile DJ. 2 x Denon SC2900, Denon MC-6000 MK2, Wharfedale Titan 15a Powered Speakers, Titan A15 Subs, HP laptop. Shed load of lights!! Maschine Mikro MK2, Xone:K2.

    2nd Generation Mobile DJ
    2G on Twitter | 2G on Facebook
    | RobDQuick On Soundcloud


  5. #5
    Tech Guru Patch's Avatar
    Join Date
    Dec 2008
    Location
    Bristol, UK
    Posts
    6,467

    Default

    Hmmm.... Interesting...
    DJ'ing: 2x1200MK2, DJM 850, Dicers, F1, Zomo MC-1000, Sony MDR-v700, i7 Win 10 HP Envy
    Production: Ableton Live 8 and a mouse, Sennheiser HD400, Sony VAIO

    Click HERE to D/L Free Tracks from Soundcloud!!!
    https://www.facebook.com/Patchdj

  6. #6
    Tech Guru Patch's Avatar
    Join Date
    Dec 2008
    Location
    Bristol, UK
    Posts
    6,467

    Default

    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
    DJ'ing: 2x1200MK2, DJM 850, Dicers, F1, Zomo MC-1000, Sony MDR-v700, i7 Win 10 HP Envy
    Production: Ableton Live 8 and a mouse, Sennheiser HD400, Sony VAIO

    Click HERE to D/L Free Tracks from Soundcloud!!!
    https://www.facebook.com/Patchdj

  7. #7
    Tech Guru robdquick's Avatar
    Join Date
    Aug 2011
    Location
    Bristol, UK
    Posts
    590

    Default

    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....
    Mobile DJ. 2 x Denon SC2900, Denon MC-6000 MK2, Wharfedale Titan 15a Powered Speakers, Titan A15 Subs, HP laptop. Shed load of lights!! Maschine Mikro MK2, Xone:K2.

    2nd Generation Mobile DJ
    2G on Twitter | 2G on Facebook
    | RobDQuick On Soundcloud


  8. #8
    Tech Guru Nicky H's Avatar
    Join Date
    Jan 2009
    Location
    Leeds UK
    Posts
    2,490

    Default

    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.
    SC | MC

  9. #9
    Tech Guru Patch's Avatar
    Join Date
    Dec 2008
    Location
    Bristol, UK
    Posts
    6,467

    Default

    We're making good progress here, fellas! I'm terrible with software, so hopefully someone will chime in with some good ideas...
    DJ'ing: 2x1200MK2, DJM 850, Dicers, F1, Zomo MC-1000, Sony MDR-v700, i7 Win 10 HP Envy
    Production: Ableton Live 8 and a mouse, Sennheiser HD400, Sony VAIO

    Click HERE to D/L Free Tracks from Soundcloud!!!
    https://www.facebook.com/Patchdj

  10. #10
    Tech Guru Patch's Avatar
    Join Date
    Dec 2008
    Location
    Bristol, UK
    Posts
    6,467

    Default

    We just need to find SOMETHING in each xml that is labelled the same for the vlookup to work...
    DJ'ing: 2x1200MK2, DJM 850, Dicers, F1, Zomo MC-1000, Sony MDR-v700, i7 Win 10 HP Envy
    Production: Ableton Live 8 and a mouse, Sennheiser HD400, Sony VAIO

    Click HERE to D/L Free Tracks from Soundcloud!!!
    https://www.facebook.com/Patchdj

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •