Search results matching tag 'CSV and TSV output targets'

FORMAT WITH CSV

mahel — Thu, 21 Feb 2008 15:55:13 GMT

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	0	0	35	8	19	7	35
Madrid	0	0	24	5	21	5	4
Inca	0	0	62	13	52	13	77
Manacor	0	0	34	12	56	11	60
Felanitx	0	0	33	5	29	5	21
Menorca	0	0	38	6	26	6	17
Ibiza	0	0	63	12	53	12	39
Las Palmas Prevención	0	0	0	0	0	0	0
Alcudia	0	0	4	1	3	1	2

For made the columns the output is -o:CSV -filemode:0 (there are diferents selects for each center) but i don't know how made the rows.

A litte Help please.

Thanks.

Select for two different files to make a relation

LogParser User : Smart — Fri, 26 Jan 2007 11:54:00 GMT

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 No, Text

FROM FILE1.TSV,FILE2.TSV

WHERE FILE1.No = FILE2.No

Thanks for help!

Output to CSV RESOLVE_SID(SID) as Username

LogParser User : MelRayUS — Fri, 17 Nov 2006 13:50:00 GMT

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(SID) as Username INTO D:\sys.csv FROM D:\sys.evt" -i:EVT -o:CSV

The above command completes, but does not resolve the SID to username.

Any ideas?

RE: COMCSVOutputContextClassClass object into SQL Input

LogParser User : DEinspanjer — Tue, 23 May 2006 18:50:00 GMT

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.

RE: COMCSVOutputContextClassClass object into SQL Input

LogParser User : SpellBound — Tue, 23 May 2006 07:39:00 GMT

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

RE: COMCSVOutputContextClassClass object into SQL Input

LogParser User : DEinspanjer — Mon, 22 May 2006 20:39:00 GMT

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.

COMCSVOutputContextClassClass object into SQL Input

LogParser User : SpellBound — Mon, 22 May 2006 03:38:00 GMT

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 in advance.

SpellBound

RE: IIS to CSV with Text Qualifier

LogParser User : tecknick — Thu, 27 Apr 2006 23:51:00 GMT

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

RE: IIS to CSV with Text Qualifier

LogParser User : DEinspanjer — Thu, 27 Apr 2006 14:51:00 GMT

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.

IIS to CSV with Text Qualifier

LogParser User : tecknick — Thu, 27 Apr 2006 00:32:00 GMT

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 in advance.

Tecknick