Search results matching tag 'XML input format'

Invalid Character

cci — Sun, 07 Jun 2009 10:46:50 GMT

I am trying to use LP to output a webservice response to csv. It has worked on several occasions, but in one case I get an error message that there is an invalid character in the text output. What would LP consider an invalid character?

Asking LogParser to do the impossible

LogParser User : StanL — Wed, 14 Feb 2007 12:41:00 GMT

Generating an xsd validation file is easily accomplished in .NET with a DataSet Object. You can use XMLExport in Access 2003 but that is specific to Access Tables; then there is SQLXMLOLEDB which only worls with SQL Server.

Prior to .NET, the MsPersit provider permitted creating .xml files from either disconnected or fabricated recordsets. The xsdtest.xml [attached] is persisted from a fabricated recordset. Microsoft has an xsd.exe utility that will output an xsd file for an xml file, but hiccups badly if passed the xsdtest.xml - that is because persisted recordsets have their own schema embedded.

cSQL = "SELECT * into c:\temp\xsdtest1.xml FROM c:\temp\xsdtest.xml"
oLog = CreateObject("MSUtil.LogQuery")
oLog.maxParseErrors = 100
oInput = CreateObject("MSUtil.LogQuery.XMLInputFormat")
oOut = CreateObject("MSUtil.LogQuery.XMLOutputFormat.1")
oOut.structure=4
oOut.rootName="Input"
oOut.schematype=1
oOut.filemode=1
oLog.ExecuteBatch(cSQL, oInput, oOut)

will output xsdtest1.xml which can be parsed by xsd.exe - but the results do not reflect the 'fields' [xsdtest.xsd]. I've played around with the output settings, and admit it gets over my Pooh Brain... but the goal is [hopefully] admirable - 'for any database structure persisted as a recordset, create a basic xsd validation file w/out .NET i.e. VB. VBA or scripting code.

Hope this makes sense Stan

RE: xml schema files | persisted recordset xml

LogParser User : DEinspanjer — Fri, 05 Jan 2007 10:53:00 GMT

Um.. you are welcome to..

RE: xml schema files | persisted recordset xml

LogParser User : StanL — Tue, 02 Jan 2007 19:39:00 GMT

Oh, I see that it does after all. I have no problem with persisted XML Recordsets, but could use some help clarifying a query for an xsd schema. I would like to post a sample xsd and querystring w/output. Stan

xml schema files | persisted recordset xml

LogParser User : StanL — Mon, 01 Jan 2007 23:48:00 GMT

Can LogParser handle thgese types of input?

Stan

MetaBase output

LogParser User : TPJ — Thu, 16 Nov 2006 09:48:00 GMT

I need some help getting the right info out af the metabase

It has to look the original IIS

http://www.fumle.com/IIS.JPG

But i need the Homedir, Logdir, but i cant the info in the way i want it.
When i do it, it gets look like this

http://www.fumle.com/Metabase.JPG

but i want it en equal rows, how to do this ?
Anybody that can write me an query that return the right info and put into to an database

I would appreciate this very much

RE: XML Input Format Parameters

LogParser User : DEinspanjer — Fri, 03 Nov 2006 16:25:00 GMT

:/ Now that I see more of what you are trying to do, I have to go back to my original statement that LP isn't well designed for this type of XML input.
However, you can easily use a straight XSL solution to get the output you are looking for.
Here is an example XSL that you can invoke using msxsl:
msxsl AUDIT_02242003_07.xml audit_xml_to_csv.xsl prog_id='AU0001N' -o output.csv

RE: XML Input Format Parameters

LogParser User : VBProEd — Fri, 03 Nov 2006 14:07:00 GMT

Select /HDR/USR_ID/@v AS UserID, /HDR/WK_STATION_ID/@v AS WorkStationID, /HDR/TRANS_ID/@v AS TransID, /HDR/FETCH_DTM/@v AS DateTime from c:\Audit_Log\AUDIT_02242003_07.xml where /HDR/ONLINE_PROG_ID/@v = 'AU0001N'

(12 rows affected)

Query time : 00:00:01.4110379

Display time : 99ms

I have also attached my sample XML file to this post. This query can find 12 rows yet no data ever appears in the window matching the where clause.

RE: XML Input Format Parameters

LogParser User : DEinspanjer — Thu, 02 Nov 2006 23:26:00 GMT

can't tell you without the query you used and maybe some longer sample data.

RE: XML Input Format Parameters

LogParser User : VBProEd — Thu, 02 Nov 2006 16:53:00 GMT

[QUOTE User="LogParser User : VBProEd"]Quote: I'm very happy to hear you were able to figure out a query that gives you the data you need. Just so you know, the @ symbol is actually an indicator that the word after it (v in this case) is an attri...[/QUOTE]

Maybe I responded too quickly. When I selected the USR_ID in the query and used it in the WHERE clause, it would show up in the results window. However, as soon as I entered additional select values, no data would appear in the results window. Where did I go wrong?