Converting logs to a word or excel spreadsheet

[loewentech]

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.

[KS-Soft]

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

[Wooltown]

ODBC is available for Excel files, so taht could be a solution !


/Sven

[gogol]

So how could you send sql queries to an excel file ?
Is there a way to define a table ?
Could you give an exemple ?

[KS-Soft]

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.

Is there a way to define a table ?

HostMonitor does not create tables. Use Excel or some DBMS.

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

[Marcus]

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.