March 21, 201114 yr Newbies 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>
March 22, 201114 yr 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
March 22, 201114 yr Author Newbies 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.
Create an account or sign in to comment