RE: Witango-Talk: text files as data sources?

[Ben Johansen]

Hey,   You can still do it in R:Tango. I have been done it in a Stored Procedure using the LOAD AS ASCII   Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Authorized MDaemon Mail Server Reseller http://www.pcforge.com/AltN.htm -----Original Message----- From: Atrix Wolfe [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 9:17 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: text files as data sources?   yeah thats correct, im on R:Tango 5, shucks! (:   Scott's suggestion w/ file reads and <@array> might work, im gonna play with it and see what i can get out of it. ----- Original Message ----- From: David Shelley To: [EMAIL PROTECTED] 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 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf