DSC Adapter

Input

Proprietary XLS file from MTA

Output

This is example XML produced by the adapter

    <fileHeader>

        <vehicle>
            <vehicle-id>0</vehicle-id>
        </vehicle>
        <component-IP>0.0.0.0</component-ip>

        <file-identifier>9</file-identifier>
        <updated-datetime>2011-06-01T04:59:00-04:00</updated-datetime>
        <file-size>0</file-size>
    </fileheader>
 <destinations>
        <destination>

            <messageID>
                <msgID>4630</msgid>
            </messageid>

            <metadata>
                <updated>2011-07-05T16:56:06-04:00</updated>
            </metadata>

            <messageText>PIER 6 BROOKLYN BRIDGE PARK VIA 5 AV</messagetext>
            <routeID>

                <route-id>0</route-id>
                <route-name>B63</route-name>
            </routeid>
        </destination>
        <destination>
            <messageID>
                <msgID>4631</msgid>
            </messageid>
            <metadata>
                <updated>2011-07-05T16:56:06-04:00</updated>
            </metadata>
            <messageText>BAY RIDGE SHORE RD VIA 5 AV</messagetext>
            <routeID>
                <route-id>0</route-id>
                <route-name>B63</route-name>
            </routeid>
        </destination>
        <destination>
            <messageID>
                <msgID>12</msgid>
            </messageid>
            <metadata>
                <updated>2011-07-05T16:56:06-04:00</updated>
            </metadata>
            <messageText>NOT IN SERVICE</messagetext>
        </destination>
    </destinations>

    <defaults>
        <distance-before>
            <m>0</m>
        </distance-before>
        <time-before>0</time-before>
    </defaults>
 </ns2:ccannouncementinfo>