----- Original Message -----
Sent: Friday, June 20, 2003 6:50 AM
Subject: RE: Witango-Talk: text files as
data sources?
Atrix,
I've
done this with Tango 4, but not yet with Witango 5. I build tango log
analysis into my tango debugging toolset. There's a few hurdles to overcome.
First you have to copy the .log file to a .txt file before analyzing it for 2
reasons, the MS Text ODBC driver looks for files with the .txt extension, and
the .log file is locked by the witango server. Also, don't you run R:Tango? It
will only talk to an RBase database, not a Text datasource. You'll need to run
Witango5 instead of R:Tango5.
Copy
witango.log to witangolog.txt (or some other name)
Create a datasource using the MS Text ODBC driver that points to the
log directory
Create a schema.ini file in the log directory. The one I use with T4 is
shown below, it will be a little different with W5.
Before you do any current analysis, take a fresh copy of witango.log
into witangolog.txt
A
more robust solution would be to periodically copy the data from
witangolog.txt and insert it into an database. Database engines have better
better searching capabilities than the text driver. But even with the text
driver you can do stuff like:
select distinct userref from tangolog.txt where logtime >
[currentTime-variableTimeout]
-
this will give you all the userreferences of currently active users which you
can use to check their user scope variables (that's one of the functions I use
occasionally in debugging an app)
The
schema.ini file for a tango 4 log format looks like this:
[tangolog.txt]
ColNameHeader=False
Format=TabDelimited
MaxScanRows=25
CharacterSet=OEM
Col1=LOGDATE
Char Width 10
Col2=LOGTIME Char Width 10
Col3=CLIENTIP Char Width
25
Col4=USERREF Char Width 32
Col5=THREADID Integer
Col6=THREADS
Integer
Col7=ELAPSED Integer
Col8=THREADINFO Char Width
255
Col9=THREADDATA Char Width 255
Col10=POSITION Char Width
255
Col11=APPFILE Char Width 255
Col12=SERVER Char Width
255
Col13=ARGUMENTS LongChar
Dave
Shelley
-----Original
Message-----
From: Atrix Wolfe
[mailto:[EMAIL PROTECTED]
Sent: Friday, June 20, 2003 1:15
AM
To: [EMAIL PROTECTED]
Subject: Witango-Talk:
text files as data sources?
hello,
I faintly remember hearing somewhere you
can take a text file and make it a datasource somehow and interact with
it? Im looking to do this with witango log files so that we dont have
to go through it manualy looking for errors, or other
information.
It seems strange that something would be able
to look at a txt file and find a structure to it and break the data into
columns and such but who knows! Am i nuts or is this possible?
Thanks!!
Atrix
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
