WebService output > Tab-separated text?

[Martijn van Exel]

Hi all,

I'm receiving output from a webservice formatted as follows:

<?xml version="1.0" encoding="utf-8"?>
<DataSet xmlns="http://tempuri.org/adrloc/levering">
<xs:schema id="Bridgis_Dat aSet" xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="u rn:schemas-
microsoft-com:xml-msdata">
<xs:element name="Bridgis_D ataSet" msdata:IsDataSe t="true">
<xs:complexType >
<xs:choice maxOccurs="unbo unded">
<xs:element name="Bridgis_D ataTable">
<xs:complexType >
<xs:sequence>
<xs:element name="PSTK" type="xs:string " minOccurs="0" />
<xs:element name="STRAAT_NE N" type="xs:string "
minOccurs="0" />
<xs:element name="STRAAT_PT T" type="xs:string "
minOccurs="0" />
<xs:element name="STRAAT_OF F" type="xs:string "
minOccurs="0" />
<xs:element name="HUISNUMME R" type="xs:decima l"
minOccurs="0" />
<xs:element name="TOEVOEGIN G" type="xs:string "
minOccurs="0" />
<xs:element name="PERCEELCO D" type="xs:string "
minOccurs="0" />
<xs:element name="PLAATS_NE N" type="xs:string "
minOccurs="0" />
<xs:element name="PLAATS_PT T" type="xs:string "
minOccurs="0" />
<xs:element name="GEMEENTE" type="xs:string "
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<diffgr:diffgra m xmlns:msdata="u rn:schemas-microsoft-com:xml-msdata"
xmlns:diffgr="u rn:schemas-microsoft-com:xml-diffgram-v1">
<Bridgis_DataSe t xmlns="">
<Bridgis_DataTa ble diffgr:id="Brid gis_DataTable1"
msdata:rowOrder ="0" diffgr:hasChang es="inserted">
<PSTK>3544AA</PSTK>
<STRAAT_NEN>Zan dweg </STRAAT_NEN>
<STRAAT_PTT>ZAN DWG </STRAAT_PTT>
<STRAAT_OFF>Zan dweg
</STRAAT_OFF>
<HUISNUMMER>1 0</HUISNUMMER>
<TOEVOEGING> </TOEVOEGING>
<PERCEELCOD>T </PERCEELCOD>
<PLAATS_NEN>UTR ECHT </PLAATS_NEN>
<PLAATS_PTT>UTR ECHT </PLAATS_PTT>
<GEMEENTE>UTREC HT </GEMEENTE>
</Bridgis_DataTab le>
<Bridgis_DataTa ble diffgr:id="Brid gis_DataTable2"
msdata:rowOrder ="1" diffgr:hasChang es="inserted">
<PSTK>3544AA</PSTK>
<STRAAT_NEN>Zan dweg </STRAAT_NEN>
<STRAAT_PTT>ZAN DWG </STRAAT_PTT>
<STRAAT_OFF>Zan dweg
</STRAAT_OFF>
<HUISNUMMER>9 </HUISNUMMER>
<TOEVOEGING> </TOEVOEGING>
<PERCEELCOD>T </PERCEELCOD>
<PLAATS_NEN>UTR ECHT </PLAATS_NEN>
<PLAATS_PTT>UTR ECHT </PLAATS_PTT>
<GEMEENTE>UTREC HT </GEMEENTE>
</Bridgis_DataTab le>
</Bridgis_DataSet >
</diffgr:diffgram >
</DataSet>

The number of records can be very large. I need to transform this to a tab-
separated text file within an ASP script. At the moment I go about this as
follows (all code below is JScript):

---CODE---
strXML=String(r sXML(0));
oXMLDOM.loadXML (strXML);
oDatanodes=oXML DOM.getElements ByTagName("Brid gis_DataTable") ;
strOut+=WriteRo ws(oDatanodes);
---END---

Where WriteRows is:

---CODE---
function WriteRows(oData Nodes) {
strOut="";
for(i=0;i<oData nodes.length;i+ +) {
nRecords++;
aCh=new Array();
oDatanode=oData nodes.item(i);
nChildren=oData node.childNodes .length;
for(j=0;j<nChil dren;j++) {
oChild=oDatanod e.childNodes.it em(j);
aCh.push(oChild .text);
}
strOut+=aCh.joi n("\t")+"\n";
}
return strOut;
}
---END---

This is a very expensive operation which is not acceptable because the XML
recordsets i get are very large (can be up to 1,000,000 records), so I am
looking to implement a more efficient way to do this. I'm thinking about
XSLT but don't know how I would integrate this into my ASP script. Any
ideas?

Thanks,
Martijn

[Joris Gillis]

> This is a very expensive operation which is not acceptable because the XML

recordsets i get are very large (can be up to 1,000,000 records), so I am
looking to implement a more efficient way to do this. I'm thinking about
XSLT but don't know how I would integrate this into my ASP script. Any
ideas?

Hi,

XSLT seems a bad idea in this case, I doubt if it would more efficient. The fastest way to do it is probably by ignoring the fact that it is XML and handling it as plain text.

regards,
--
Joris Gillis (http://www.ticalc.org/cgi-bin/acct-v...i?userid=38041)
Ceterum censeo XML omnibus esse utendum