Peter, Just for some more info, the sections are badly formed Example </page> <page Title="Applications" H1="Name" > <item Name="7-Zip File Manager" > <detail Title="7-Zip File Manager" H1="Property" H2="Value" > <item Property="Original Filename" Value="7zFM.exe" /> <item Property="Internal Name" Value="7zFM" /> <item Property="File Version" Value="4.65 (4.65.0.0)" /> <item Property="Product Version" Value="4.65 (4.65.0.0)" /> <item Property="Company Name" Value="Igor Pavlov" /> <item Property="File Description" Value="7-Zip File Manager" /> <item Property="Copyright" Value="Copyright (c) 1999-2009 Igor Pavlov" /> <item Property="Product Name" Value="7-Zip" /> <item Property="File Name" Value="7zFM.exe" /> <item Property="File Path" Value="C:\Program Files\7-Zip\" /> <item Property="File Attributes" Value="Archive" /> <item Property="Creation Time" Value="2009-02-03, 07:10:08" /> <item Property="Last Write Time" Value="2009-02-03, 07:10:08" /> <item Property="File Size" Value="388096 Bytes (379.0 KBytes)" /> </item> <<<-=====LOOK HERE </detail> <item Name="Absolute Color Picker" > <detail Title="Absolute Color Picker" H1="Property" H2="Value" > <item Property="Internal Name" Value="SofInfinity Dpt." /> <item Property="File Version" Value="3.0.2.20 (3.0.2.20)" /> <item Property="Product Version" Value="3.0.2.20 (3.0.2.20)" /> <item Property="Company Name" Value="Eltima Software" />
In the page section titled "Applications" the </item> and </detail> tags are in fact the wrong way round. All the <item Property=....> tags are correctly terminated and the </item> terminator belongs to the <item Name.....> node which is before the <detail Title=....> node The same error continues within the various sections for <hardware> and <software> etc... Dave Crozier -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Peter Hart Sent: 24 April 2009 13:51 To: ProFox Email List Subject: RE: SIW System Information for Windows Hi Dave I tried what you suggested and got the error: XML parse error: The character '>' was expected. Line 31, Position 3. --Typical usage: Different errors with different Files So, wait to hear what Gabriel has to say. Cheers Peter -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dave Crozier Sent: 24 April 2009 13:31 To: 'ProFox Email List' Subject: RE: SIW System Information for Windows Peter, The tags in the file are not formed correctly in that they are not matched up. Drop them a like at SIW and let them know, it is definitely a format error. Dave -----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/75bf4b190db141ec9d181773dd8da...@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.
