The XML format that Excel is expecting, in order to automagically map a schema and import, is:
<record>
<id>001</id>
<Headline>New Item</Headline>
<Owner>smith</Owner>
</record>
But the XML output from another application (ClearQuest) uses this format:
<exportedResults creationTime="Thu Aug 15 16:47:19 GMT 2013">
<providerInfo name="ClearQuest" version="6.0.0.0"/>
<queryInfo name="All Items" recordType="Defect"/>
<columnNames>
<columnName>id</columnName>
<columnName>Headline</columnName>
<columnName>Owner</columnName>
</columnNames>
<records>
<record>
<field name="id">001</field>
<field name="headline">New Item</field>
<field name="owner">smith</field>
</record>
</records>
</exportedResults>
If I have to implement a custom import script in VBA, I can certainly do that. But I was wondering if anyone has seen this format and solved the import problem already?
Thanks for looking and your comments.
Bookmarks