XML Transform

[JimmyDoe]

I am attempting to import xml from the attached document, I have tried modifying the msdso_attrib.xsl in the examples documentation but nothing I try is working, i keep getting the XML/XSL not enough information error. Please, if anyone could help me out here i'd be eternally grateful.

Import fields are: member, memberID, corporationName, coporationID

<api version="2">

<currentTime>2011-03-21 20:40:58</currentTime>

<result>

	<rowset name="member" key="memberID" columns="name,memberID,corporationName,corporationID">

		<row name="Max Whetter" memberID="170553280" corporationName="Example Corporation 1" corporationID="1000170"/>

		<row name="James Sneed" memberID="657002663" corporationName="Example Corporation 2" corporationID="1539549525"/>

		<row name="William Galloway" memberID="718677258" corporationName="Example Corporation 3" corporationID="803866321"/>

	</rowset>

</result>

</api>

[comment]

Try the attached. Note that this will import your data as a flat file - while it looks like it should it be imported twice, into two tables (Members and Corporations).

api.zip

[JimmyDoe]

That did exactly what I needed. Just had to have a template to work from and can manipulate the multi table data later. Thanks so much.