Hi Dave I will send the necessary file to your email address. Just remind me what it is.
Got this back by return from Gabriel Yes, the old version of SIW has this bug. It was fixed. You can check the generated XML with Internet Explorer or with SIWViewer http://www.gtopala.com/siw-tools/siw-viewer.html (C# source code is available). -- Thanks, Gabriel Topala www.gtopala.com I tried with the new version. The file opens in IE no problem but it still doesn't work with XMLToCursor. What do you think. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dave Crozier Sent: 24 April 2009 15:46 To: 'ProFox Email List' Subject: RE: SIW System Information for Windows Peter, The download version is the "pay for" version so I can't test it out unfortunately. Dave -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Peter Hart Sent: 24 April 2009 15:13 To: ProFox Email List Subject: RE: SIW System Information for Windows Hi Dave Got this back from Gabriel Please download the updated version of SIW from http://www.gtopala.com/download/regnow/siw.exe The XML Report bug is fixed. -- Thanks, Gabriel Topala www.gtopala.com Now no errors but nothing in the Cursor but a single field "Page" no records. I will pass on your email. Cheeeers Peter P.S. not a spelling mistake just my way of saying I owe you a few beers -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dave Crozier Sent: 24 April 2009 14:45 To: 'ProFox Email List' Subject: RE: SIW System Information for Windows Damn, I just hate the way that Outlook reformats lines in a post.....but just discovered that when I click the forward button on a message it is magically formatted the correct way. Anyone out there know why or have a solution ....I know, I know....Thunderbird, well lets say a solution within Outlook shall we. Dave Crozier -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dave Crozier Sent: 24 April 2009 14:39 To: 'ProFox Email List' Subject: RE: SIW System Information for Windows 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/a57fa4cf19531343a2ee11b57db8e3af04c...@server.peterhartcomputers.local ** 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.
