Hi! iIt's the fisrt time that I use log Parser and I have to made a CSV file this format: ** STATISTICS FOR DAY IN MONTH ** DAYS: 30/06/2007 29/06/2007 28/06/2007 27/06/2007 CENTRES Access Visits Access Visits Access Visits Accesos Lanzarote 0 0 32 7 39 6 38 Las Palmas 0 0 75 15 71 17 103 Tenerife...

Hello, can anybody give me an answer to this: I have two Tab seperated files FILE1.TSV (Field1, Field2, ...) and FILE2.TSV (Field1, Field2). Field1 in File 1 is a Number and Related to this number a Text in File 2 should be selected. So I want to relate the two Files in one SELECT Statement like SELECT...

I am trying to establish a procedure to extract information from the event logs to use in an analysis tool called Sawmill. I can get this command to work without the RESOLVE_SID(SID) as Username, but I would like to get usernames included. C:\Program Files\Log Parser 2.2>logparser "SELECT *, RESOLVE_SID...

If you are calling ExecuteBatch passing in a CSV Output object, then it is writing a file somewhere. That CSVOutput object is not useful outside the ExecuteBatch call. You will want to construct a CSVInput object and a query pointing at the file you wrote out in part one.

I process the file in 2 parts 1. I process IISW3C Format and convert it to CSV. 2. Now in the CSV Ouput I got (not a physical file), I want the same object to be passed as an input to SQL output class. is that possible ? SpellBound

I'm sorry but your question doesn't make sense to me. Are you trying to read a CSV file and output the data to a SQL output format? If so, you want to use the CSV input format object not the output format object.

I have struck while doing some programming using Logparser. I successfully did many of automations using logparser but was not able to convert COMCSVOutputContextClassClass output as input to SQLOutput class. Can any one give a clue on how to produce CSV output object as input to SQL Output class. Thanks...

Thanks Daniel That did the trick. I just looked through the chm documentation and found it. I was previously looking under comand prompt help and could not find anything. Thanks a bunch. Tecknick

If by Text Qualifier you mean enclosing the fields in double quotes, then the -oDQuotes: ON parameter should do the trick. If it is something else, all I could suggest is using String transformation functions such as STRCAT to construct your desired string.

Hi I am using the following command line to convert an IIS log to a CSV file : C:\Program Files\Log Parser 2.2>LogParser "SELECT * INTO test.csv FROM ex060427.log" -o:CSV This works fine however I would like a Text Qualifier around certain columns. Any suggestions on how this can be achieved? Thanks...