New Freature Request

[mskid]

Hello PPl,

I think hostmonitor is great but the import and export functions is limitated. Is there any way to put a new freature request for ODBC connectivity or a simple cvs file for import ??

Thx

[KS-Soft]

Hello mskid,

ODBC connectivity to import/export operations? Interesting idea. However its a problem because HostMonitor supports many different tests those have different parameters, different number of parameters. Probably better use current import file format (<parameter> = <value>)?
On the other hand ODBC and CVS useful when you often change something in the TestList and need to import tests again and again. Do you mean that?

Regards
Alex

[mskid]

2 things about this.

For example,

If I like to import this:

10.0.0.0.1,ping,alert1
10.0.0.0.2,ping,alert1
10.0.0.0.3,ping,alert1
10.0.0.0.4,ping,alert1
10.0.0.0.5,ping,alert1
10.0.0.0.6,ping,alert1
10.0.0.0.7,ping,alert1
10.0.0.0.8,ping,alert1
10.0.0.0.9,ping,alert1
10.0.0.0.10,ping,alert1

Is there anyway to do it today with the import freature ???

Second,
The ODBC freature is great for change with asp pages the current test.This maybe a great freature for a big company that have more that 1000 tests.

What do you think about it ??

Tnx

[KS-Soft]

mskid,

>If I like to import this:
>10.0.0.0.1,ping,alert1
>10.0.0.0.2,ping,alert1

Ping test has more parameters, cvs file can looks like:
ping,10.0.0.0.1,10.0.0.0.1,3000,4,Received,90,alert1
ping,10.0.0.0.2,10.0.0.0.2,3000,4,Received,90,alert1

>Is there anyway to do it today with the import freature ???

Why not. Just file must be in another form:
----------------------------
DefaultAlertProfile = alert1

Method = Ping
Title = 10.0.0.0.1
Host = 10.0.0.0.1
Timeout = 3000
Retries = 4
DisplayMode = Received
MaxLostRatio = 90

Method = Ping
Title = 10.0.0.0.2
Host = 10.0.0.0.2
Timeout = 3000
Retries = 4
DisplayMode = Received
MaxLostRatio = 90
----------------------------

>The ODBC freature is great for change with asp pages the current test.This maybe a great freature for a big company that have more that 1000 tests.

Yes, it has sense. I added your request into "to do" list with medium priority.

Regards
Alex

[jricha34]

In the meanwhile a recommendation for mskid might be to have your normal systems export the data in CSV (I am assuming it is access export or excel export) and then have a perl script parse that output and generate the current text format for host monitor.

[dimmyr]

Alex, do you have an ETA on the CSV export/import feature? It would really be helpfull for adding/modifying thousands of tests at a time using scripts, like jricha34 has proposed.

Thank you much!

[KS-Soft]

Probably better create command line utility that will convert CSV <-> Import File using configurable templates?

Regards
Alex

[Marcus]

I have created a .cmd scripts which reads a tab (or space) seperated file. This file has the following layout:
;-----------------------------------------
; Layout ini file for each line:
;
; [-X] [-I] [-S] [-A] [-F] [-B] servername ip
;
; -X - Create exchange defaults
; -I - Create IIS defaults
; -S - Create SQL defaults
; -A - Create ISA defaults
; -F - Create File and Print server defaults
; -B - Backup Exec services.
;-----------------------------------------

If anyone is interested I can post this script in the forum (but it wil be a large post).

It will generate a .txt file in the exports directory with the default settings defined for tests. Of course these are my defaults and custom settings. So you have to adjust the .cmd file to your own needs.

[ This Message was edited by: Marcus on 2003-01-30 01:41 ]

[dimmyr]

Marcus, shoot. I give you my express permission.

Alex, so you're saying that you are preparing the cmd line utility for translating between text file and CSV?

[KS-Soft]

>Marcus, shoot. I give you my express permission.

Marcus said script is large. I think will be better if Marcus send script to our e-mail address, I will upload it and post link.

>Alex, so you're saying that you are preparing the cmd line utility for translating between text file and CSV?

Not yet. I think it will be implemented in version 4.0, may be sooner.

Regards
Alex

[KS-Soft]

Ok, there is contribution from Marcus at http://www.ks-soft.net/download/users/marcus/deftestcmd.zip
Marcus remind "don't forget it creates the defaults I want. People have to adjust the script for there own needs...."

Regards
Alex

[ This Message was edited by: KS-Soft on 2003-01-31 12:57 ]