Peter, If you look at loading up the XML file in IE then you also get an error if you scroll down to the botto of the document. e.g. "tag 'item' does not match the start tag 'detail'. Error "
I've just loaded it up with a hex editor to see if I can find out the rogue data but don't see anything untoward. I'll keep looking. All you should need is: cFile="c:\temp\filename.xml" Xmltocursor(cFile, "curXML",512) Dave Crozier -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Peter Hart Sent: 24 April 2009 08:51 To: ProFox Email List Subject: RE: SIW System Information for Windows Hi All For those who have come across SIW by Gabriel Topala. The reporting functions allow for an XML file to be saved. Try as I may I cannot get the XMLToCursor function working in VFP 9. Any ideas where I may be going wrong. The help file gives "XMLTOCURSOR(eExpression | cXMLFile [, cCursorName [, nFlags ]])" So I am trying XMLToCursor("C:\SIWAudit\VDU105.xml",TempCursor,n) where n is 1 of the flags, trying each flag in turn. I have been able to extract the data by saving the reports as CSV but this necessitates quite a bit of work checking the data as a comma delimited section can have commas in it i.e. "Trademark Gigabyte 12,09,08","" I am trying to import the reports from a large no. of computers so as to concatenate the data, so for example I can list all the Windows Licence No's, by Computer. Another use is that when I get a request for a computer repair I can see what Motherboard, Memory etc. Is fitted. I tried using WMI to get the information direct from the registries but have been unable to come up with an Algorithm to extract the Licence No's which are Encrypted. Anyway it is easier to get the branch managers to collect the SIW report files weekly and email them direct to me. Cheers Peter --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/a900d54b76704c6790dce1a644ad9...@develop ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
