I've got an XML file called goldbach.xml
.
It contains slots (1 or 2 per hour) with several spots (a spot is a short video or an advertising)
From that file, I need to extract the following information:
<slot>
<starttimeUTC>1519189200000</starttimeUTC>
<durationAbsolute>7000</durationAbsolute>
<materialName>01 07 LILLYDOO 2018 dm DE KINO WM</materialName>
</slot>
The goldbach.xml
file looks like
<xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ProgramDataExchange>
<header>
<channel>KINO</channel>
<channelID>KINO</channelID>
<versionInternal>2018-02-14T10:42:14.543</versionInternal>
<versionExternal>2018-02-14T10:42:14.543</versionExternal>
<dateFrom>2018-02-21</dateFrom>
<dateTo>2018-02-21</dateTo>
</header>
<broadcastDay>
<txDay></txDay>
<slot>
<starttimeUTC>1519189200000</starttimeUTC>
<duration>7800000</duration>
<slotID>574813</slotID>
<slotTypeID>1</slotTypeID>
<program>
<programName>9 Rota</programName>
</program>
<interruption>
<interruptionID>565290</interruptionID>
<position>-1</position>
<break>
<breakID>565290</breakID>
<spot>
<durationAbsolute>7000</durationAbsolute>
<materialName>01 07 LILLYDOO 2018 WM</materialName>
</spot>
<!-- ... -->
</break>
<!-- ... -->
</interruption>
<!-- ... -->
</slot>
<!-- ... -->
</broadcastDay>
<!-- ... -->
</ProgramDataExchange>