>><?xml version="1.0" encoding="utf-8" ?> >>- <Report p1:schemaLocation="PayRegExtract http://99.99.9.999/ReportServer?%2fTotalCompensation%2fPayRegExtract&rs% >>3aCommand=Render&rs%3aFormat=XML&rs%3aSessionID=eo4karztrbozd545bjfj0orz&rc%3aSchema=True" >>Name="PayRegExtract" xmlns:p1="http://www.w3.org/2001/XMLSchema-instance" xmlns="PayRegExtract"> >>- <table1> >>- <Detail_Collection> >> <Detail PP ...... >> <Detail PP ...... >> <Detail PP ...... >> </Detail_Collection> >> </table1> >></Report> >>>>
>>- <Report p1:schemaLocation="PayRegExtract http://99.99.9.999/ReportServer?%2fTotalCompensation%2fPayRegExtract&rs% >>3aCommand=Render&rs%3aFormat=XML&rs%3aSessionID=eo4karztrbozd545bjfj0orz&rc%3aSchema=True" >>Name="PayRegExtract" xmlns:p1="http://www.w3.org/2001/XMLSchema-instance" xmlns="PayRegExtract"> >>>>
>></Report>
>>
>>>lnLines = ALINES(laXML, FILETOSTR("your file with full path to it.XML") >FOR lnFor = 1 TO lnLines > ? laXML[lnFor] >NEXT >>But why you need to remove something in it?
LOCAL oxml as XMLAdapter oxml = NEWOBJECT("xmladapter") oxml.LoadXML("C:\test2\PayRegExtract.xml")and it gave me following error:
XML Error: XML Parse error: Invalid at top level of the document. Line 1, Position 1 C:\test\PayRegExtract.xmlThen I tried
SELECT * from xfer_payroll INTO CURSOR crsparse readwrite SELECT crsparse XMLTOCURSOR("C:\test2\PayRegExtract.xml","crsparse",512) browseand the cursor shows Detail_Collection column only
<?xml version="1.0"?> <table1> <Detail_Collection> <Detail PP=" ... ... </Detail_Collection> </table1>and that works like a charm. So I was think of removing the offending tags programatically and running the xml through West Wind XML tools. I'm not very savy with XML, how would I correct the XMLAdapter issue (how is it that used, couldn't understand examples) or XMLTOCURSOR issue? The file is 1.5mb.