New Freature Request

mskid · Post by **mskid** » Wed Aug 07, 2002 10:35 am

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 · Post by **KS-Soft** » Wed Aug 07, 2002 4:28 pm

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 · Post by **mskid** » Wed Aug 07, 2002 4:47 pm

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 · Post by **KS-Soft** » Thu Aug 08, 2002 2:53 pm

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 · Post by **jricha34** » Mon Aug 12, 2002 10:13 am

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 · Post by **dimmyr** » Wed Jan 29, 2003 10:21 am

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 · Post by **KS-Soft** » Thu Jan 30, 2003 12:12 am

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

Regards
Alex

Marcus · Post by **Marcus** » Thu Jan 30, 2003 2:40 am

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.

<font size=-1>[ This Message was edited by: Marcus on 2003-01-30 01:41 ]</font>

dimmyr · Post by **dimmyr** » Thu Jan 30, 2003 11:20 am

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 · Post by **KS-Soft** » Thu Jan 30, 2003 8:41 pm

>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 · Post by **KS-Soft** » Fri Jan 31, 2003 1:57 pm

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

Regards
Alex

<font size=-1>[ This Message was edited by: KS-Soft on 2003-01-31 12:57 ]</font>