I have a XML file thats needs to be converted into a CSV file
XML looks like this
- <data QueryName="workflow">
- <DataSet DataSetName="workflow">
- <xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
- <s:Schema id="RowsetSchema">
- <s:ElementType name="row" content="eltOnly" rs:updatable="true">
- <s:AttributeType name="c0" rs:name="WF WORK ITEM·REF-1" rs:number="1" rs:nullable="true" rs:write="true">
<s:datatype dt:type="string" dt:maxLength="30" rsrecision="0" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="c1" rs:name="WF WORK ITEM·REF-2" rs:number="2" rs:nullable="true" rs:write="true">
<s:datatype dt:type="string" dt:maxLength="30" rsrecision="0" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="c2" rs:name="WF WORK ITEM·ACT-STS-USER" rs:number="3" rs:nullable="true" rs:write="true">
<s:datatype dt:type="string" dt:maxLength="10" rsrecision="0" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="c3" rs:name="WF WORK ITEM·ACT-STS-DATE" rs:number="4" rs:nullable="true" rs:write="true">
<s:datatype dt:type="dateTime" rs:dbtype="variantdate" dt:maxLength="16" rsrecision="0" rs:fixedlength="true" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="c4" rs:name="WF WORK ITEM·WORK-TYPE" rs:number="5" rs:nullable="true" rs:write="true">
<s:datatype dt:type="string" dt:maxLength="10" rsrecision="0" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="c5" rs:name="WF WORK ITEM·INPUT-REF" rs:number="6" rs:nullable="true" rs:write="true">
<s:datatype dt:type="string" dt:maxLength="20" rsrecision="0" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="c6" rs:name="WF ITEM NOTES·NOTES" rs:number="7" rs:nullable="true" rs:write="true">
<s:datatype dt:type="string" dt:maxLength="1000" rsrecision="0" rs:maybenull="false" />
</s:AttributeType>
<s:extends type="rs:rowbase" />
</s:ElementType>
</s:Schema>
- <rs:data>
- <rs:insert>
<z:row c0="7001570947" c1="7318260410" c2="NDC" c3="2012-06-11T00:00:00" c4="CXSVR" c5="7971945" c6="Standard Test" />
<z:row c0="7001570947" c1="7318260410" c2="NDC" c3="2012-06-11T00:00:00" c4="CXSVR" c5="7971945" c6="This is a test document" />
<z:row c0="7000590604" c1="3315540040" c2="NDC" c3="2012-06-11T00:00:00" c4="CXSVR" c5="7971946" c6="Standard Test - Standard Test" />
</rs:insert>
</rs:data>
</xml>
</DataSet>
</data>
I am new to XML source records and I need some help getting the data from XML to a CSV file
XML looks like this
- <data QueryName="workflow">
- <DataSet DataSetName="workflow">
- <xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
- <s:Schema id="RowsetSchema">
- <s:ElementType name="row" content="eltOnly" rs:updatable="true">
- <s:AttributeType name="c0" rs:name="WF WORK ITEM·REF-1" rs:number="1" rs:nullable="true" rs:write="true">
<s:datatype dt:type="string" dt:maxLength="30" rsrecision="0" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="c1" rs:name="WF WORK ITEM·REF-2" rs:number="2" rs:nullable="true" rs:write="true">
<s:datatype dt:type="string" dt:maxLength="30" rsrecision="0" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="c2" rs:name="WF WORK ITEM·ACT-STS-USER" rs:number="3" rs:nullable="true" rs:write="true">
<s:datatype dt:type="string" dt:maxLength="10" rsrecision="0" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="c3" rs:name="WF WORK ITEM·ACT-STS-DATE" rs:number="4" rs:nullable="true" rs:write="true">
<s:datatype dt:type="dateTime" rs:dbtype="variantdate" dt:maxLength="16" rsrecision="0" rs:fixedlength="true" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="c4" rs:name="WF WORK ITEM·WORK-TYPE" rs:number="5" rs:nullable="true" rs:write="true">
<s:datatype dt:type="string" dt:maxLength="10" rsrecision="0" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="c5" rs:name="WF WORK ITEM·INPUT-REF" rs:number="6" rs:nullable="true" rs:write="true">
<s:datatype dt:type="string" dt:maxLength="20" rsrecision="0" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="c6" rs:name="WF ITEM NOTES·NOTES" rs:number="7" rs:nullable="true" rs:write="true">
<s:datatype dt:type="string" dt:maxLength="1000" rsrecision="0" rs:maybenull="false" />
</s:AttributeType>
<s:extends type="rs:rowbase" />
</s:ElementType>
</s:Schema>
- <rs:data>
- <rs:insert>
<z:row c0="7001570947" c1="7318260410" c2="NDC" c3="2012-06-11T00:00:00" c4="CXSVR" c5="7971945" c6="Standard Test" />
<z:row c0="7001570947" c1="7318260410" c2="NDC" c3="2012-06-11T00:00:00" c4="CXSVR" c5="7971945" c6="This is a test document" />
<z:row c0="7000590604" c1="3315540040" c2="NDC" c3="2012-06-11T00:00:00" c4="CXSVR" c5="7971946" c6="Standard Test - Standard Test" />
</rs:insert>
</rs:data>
</xml>
</DataSet>
</data>
I am new to XML source records and I need some help getting the data from XML to a CSV file