View previous topic :: View next topic |
Author |
Message |
loewentech
Joined: 03 Apr 2003 Posts: 1 Location: Loewen Ent.
|
Posted: Fri Apr 04, 2003 8:56 am Post subject: |
|
|
Since the logs are created and inserted into the host systems c: drive and the host folder on the network, it would be excellent for HostMonitor to export the logs to a spreadsheet for easy comparison and analysis. |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12806 Location: USA
|
Posted: Fri Apr 04, 2003 12:01 pm Post subject: |
|
|
word or excel spreadsheet? I don't think it will be implemented. HostMonitor supports more standard ODBC data source.
Probably we can implement HTML<->DBF<->TXT<->CSV converter into new Log analyzer.
Regards
Alex |
|
Back to top |
|
|
Wooltown
Joined: 22 May 2002 Posts: 115 Location: Sweden
|
Posted: Tue Apr 08, 2003 9:31 am Post subject: |
|
|
ODBC is available for Excel files, so taht could be a solution !
/Sven
|
|
Back to top |
|
|
gogol Guest
|
Posted: Mon Feb 02, 2004 7:46 am Post subject: oh yeah ??? |
|
|
So how could you send sql queries to an excel file ?
Is there a way to define a table ?
Could you give an exemple ? |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12806 Location: USA
|
Posted: Mon Feb 02, 2004 8:31 pm Post subject: |
|
|
Quote: | So how could you send sql queries to an excel file ? |
First you should setup ODBC data source for exel files.
If you want to log all data to that table, use "ODBC log" option that is located on Advanced Logging page in the Options dialog.
If you want to log some specific data, you may use "SQL Query" action.
Quote: | Is there a way to define a table ? |
HostMonitor does not create tables. Use Excel or some DBMS.
Quote: | Could you give an exemple ? |
Example of SQL Query? No problem:
Insert into hmlog (eventtime, testname, status, reply) VALUES (%DateTime%, '%TestName%', '%Status%', '%Reply%')
Regards
Alex |
|
Back to top |
|
|
Marcus
Joined: 18 Nov 2002 Posts: 367
|
Posted: Tue Feb 03, 2004 11:47 am Post subject: |
|
|
Quote: | So how could you send sql queries to an excel file |
Don't forget that excel is limited to 65535 entries. If you have a lot of tests and/or want to log all items, you better use a database. |
|
Back to top |
|
|
|