LinqToXml help needed for weird iTunes Export XML code

Question

Itunes is giving me an export xml structure that I’m not used to work with (see xml code):

<?xml version="1.0" encoding="UTF-8"?>
<plist version="1.0">
<dict>
    <dict>
        <key>68768</key>
        <dict>
            <key>Track ID</key><integer>68768</integer>
            <key>Name</key><string>ABBA Medley</string>
            <key>Artist</key><string>Party All Stars</string>           
            <key>Disc Number</key><integer>1</integer>
            <key>Track Number</key><integer>17</integer>
            <key>Persistent ID</key><string>B121116C66BE0F4B</string>
        </dict>
        <key>68781</key>
        <dict>
            <key>Track ID</key><integer>68781</integer>
            <key>Name</key><string>Afflitto</string>
            <key>Artist</key><string>Fiocco</string>
            <key>Disc Number</key><integer>1</integer>
            <key>Track Number</key><integer>9</integer>
            <key>Persistent ID</key><string>5D09837999591307</string>
        </dict>
        <key>68793</key>
        <dict>
            <key>Track ID</key><integer>68793</integer>
            <key>Name</key><string>Agadou</string>
            <key>Artist</key><string>Saradossa Band</string>
            <key>Disc Number</key><integer>1</integer>
            <key>Track Number</key><integer>4</integer>
            <key>Persistent ID</key><string>4DFFF3C3498C02B4</string>
        </dict>
    </dict>
</dict>
</plist>

My goal is to get following array when possible achieved with LinqToXml in c#:

17  ABBA Medley  B121116C66BE0F4B
9   Afflitto     5D09837999591307
4   Agadou       4DFFF3C3498C02B4

Is this even possible ?
I wrote some basic c# code but a lightning bolt strikes me on the way...

XDocument doc = XDocument.Load(iTunesXmlFile);
var linqtoxml = from node in doc.Descendants("dict") select node; // ooo Boy :(

foreach (var dict in linqtoxml)
{
   // and lightning bolt again...
}

Ps: As obvious, I can't change the xml structure.
Pps: I know, this is a cleanup iTunes XML version, but the basic concept is presented as case study.

I'm not familiar with the iTunes XML, are there always going to be 3 levels of `` nodes? — psubsee2003, Jan 09 '13 at 01:15
The Format really isn't all the weird... the new lines are just off so it looks more confusing than it actually is. It is just a matter of finding the write query. But check out this [question](http://stackoverflow.com/q/5118788/250725). I'm pretty sure it is a duplicate. — psubsee2003, Jan 09 '13 at 01:30

score 0 · Accepted Answer · answered Jan 14 '13 at 10:07

The best solution that I could think of was following :

List<Track> MyTrackList = new List<Track>();

public class Track 
{
    public int TrackNumber { get; set; }
    public string Name { get; set; }
    public string PersistentID { get; set; }
} 

XDocument doc = XDocument.Load(@"thexmlfile.xml");
var linqtoxml = from element in doc.Descendants("plist").Descendants("dict").Descendants("dict").Descendants("dict")
                select element;

foreach (var dict in linqtoxml)
{
    try
    {
        string myTrackNumber = dict.Descendants("key").Where(key => key.Value == "Track Number").Select(x => x.NextNode).SingleOrDefault().ToString(); 
        string myName = dict.Descendants("key").Where(key => key.Value == "Name").Select(x => x.NextNode).SingleOrDefault().ToString();                                 
        string myPersistentID = dict.Descendants("key").Where(key => key.Value == "Persistent ID").Select(x => x.NextNode).SingleOrDefault().ToString();

        MyTrackList.Add(new Track
        {
            TrackNumber = myTrackNumber,
            Name = myName,
            PersistentID = myPersistentID
        });

    }
    catch (Exception)
    {
        // Something wasn't set, so skip the node ...
    }            
}

LinqToXml help needed for weird iTunes Export XML code

1 Answers1