View previous topic :: View next topic |
Author |
Message |
mskid
Joined: 25 Jun 2002 Posts: 3
|
Posted: Wed Aug 07, 2002 10:35 am Post subject: |
|
|
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 |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12801 Location: USA
|
Posted: Wed Aug 07, 2002 4:28 pm Post subject: |
|
|
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 |
|
Back to top |
|
|
mskid
Joined: 25 Jun 2002 Posts: 3
|
Posted: Wed Aug 07, 2002 4:47 pm Post subject: |
|
|
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 |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12801 Location: USA
|
Posted: Thu Aug 08, 2002 2:53 pm Post subject: |
|
|
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 |
|
Back to top |
|
|
jricha34
Joined: 07 Jul 2002 Posts: 59 Location: USA
|
Posted: Mon Aug 12, 2002 10:13 am Post subject: |
|
|
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. |
|
Back to top |
|
|
dimmyr
Joined: 28 Dec 2002 Posts: 35 Location: Detroit, MI
|
Posted: Wed Jan 29, 2003 10:21 am Post subject: |
|
|
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! |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12801 Location: USA
|
Posted: Thu Jan 30, 2003 12:12 am Post subject: |
|
|
Probably better create command line utility that will convert CSV <-> Import File using configurable templates?
Regards
Alex |
|
Back to top |
|
|
Marcus
Joined: 18 Nov 2002 Posts: 367
|
Posted: Thu Jan 30, 2003 2:40 am Post subject: |
|
|
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 ] |
|
Back to top |
|
|
dimmyr
Joined: 28 Dec 2002 Posts: 35 Location: Detroit, MI
|
Posted: Thu Jan 30, 2003 11:20 am Post subject: |
|
|
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? |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12801 Location: USA
|
Posted: Thu Jan 30, 2003 8:41 pm Post subject: |
|
|
>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 |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12801 Location: USA
|
Posted: Fri Jan 31, 2003 1:57 pm Post subject: |
|
|
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 ] |
|
Back to top |
|
|
|