<releases>
<release id="1" status="Accepted">
    <images>
        <image height="600" type="primary" uri="" uri150="" width="600"/>
        <image height="600" type="secondary" uri="" uri150="" width="600"/>
        <image height="600" type="secondary" uri="" uri150="" width="600"/>
        <image height="600" type="secondary" uri="" uri150="" width="600"/>
    </images>
    <artists>
        <artist>
            <id>1</id>
            <name>Artists name</name>
            <anv/>
            <join>,</join>
            <role/>
            <tracks/>
        </artist>
    </artists>
    <title>Release Title</title>
    <labels>
        <label catno="catno01" name="name"/>
    </labels>
    <extraartists>
        <artist>
            <id>25235</id>
            <name>Artist Name</name>
            <anv/>
            <join/>
            <role>Artist Role</role>
            <tracks/>
        </artist>
    </extraartists>
    <genres>
        <genre>Genre1</genre>
    </genres>
    <styles>
        <style>style1</style>
    </styles>
     <styles>
        <style>style2</style>
    </styles>
     <styles>
        <style>style3</style>
    </styles>
    <country>Country</country>
    <released>1999-03-00</released>
    <notes>blah blah blah
</notes>
<data_quality>Correct</data_quality>
<tracklist>
    <track>
        <position>A</position>
        <title>Title1</title>
        <duration>4:45</duration>
    </track>
    <track>
        <position>B1</position>
        <title>Title2</title>
        <duration>6:11</duration>
    </track>
    <track>
        <position>B2</position>
        <title>title3</title>
        <duration>2:49</duration>
    </track>
    <track>
        <position>C1</position>
        <title>title4</title>
        <duration>5:38</duration>
    </track>
    <track>
        <position>C2</position>
        <title>title5</title>
        <duration>4:52</duration>
    </track>
    <track>
        <position>D</position>
        <title>title6</title>
        <duration>5:16</duration>
    </track>
</tracklist>
<companies>
    <company>
        <id>32463246</id>
        <name>Company1</name>
        <catno/>
        <entity_type>23</entity_type>
        <entity_type_name>Recorded At</entity_type_name>
        <resource_url>http://someurl.com</resource_url>
    </company>
    <company>
        <id>2323523</id>
        <name>company2</name>
        <catno/>
        <entity_type>17</entity_type>
        <entity_type_name>blah blah</entity_type_name>
        <resource_url>http://someotherurl.com</resource_url>
    </company>
</companies>
</release>
</releases>

def release = new File('release.txt')
def track = new File('tracks.txt')

releases = new XmlSlurper().parse("../data/disk1a.xml")
releases.release.each
        {
             def releaseid = ${it.@id}
            println("$releaseid")
            release.append ("Release,${it.@id},${it.title},${it.artists.artist.name},${it.genres.genre},${it.country}, ${it.released}n")
            //println ("${it.@id} id  ${it.title} album ${it.artists.artist.name} artist ${it.genres.genre} genre ${it.released} release date")
           it.styles.each
                    {

                        release.append("style,${it.style}n")
                    }
            it.tracklist.track.each
                    {
                        //track.append("${it.@id}  ${it.title}  ${it.duration}n")
                        //println("${it.@id}  ${it.title}  ${it.duration}")
                        release.append("tracks,${it.@id}, ${it.title},${it.duration}n")
                    }

            it.companies.company.each
                    {
                        release.append("company,${it.id},${it.name},${it.resource_url}n")
                    }
        }