[opennms-discuss] Asset import from CSV

Anyone?

I've upgraded to 1.3.5 with the no change - Asset import from CSV
doesn't update asset descriptions.

This is a showstopper for me, as their appears to be no other mechanism
for entering bulk data. Is it really the case that OpenNMS requires
asset data to be submitted manually for each and every asset?

Regards,
Simon.

Post by Simon Anderson
How can I convince the OpenNMS web interface to display asset data?
OpenNMS 1.3.3 on CentOS 4.4
Importing asset data from a CSV populates the database with the new
asset data but some fields are not populated in the asset description
area of the web interface.
Import/Export works correctly, i.e. I can import the new data and export
it back out cleanly. It's just the web interface which is erroneous.
Regards,
Simon.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
http://www.opennms.org/index.php/Mailing_List_FAQ
opennms-discuss mailing list
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

David Hustace

2007-07-13 13:00:17 UTC

Post by Simon Anderson
I've upgraded to 1.3.5 with the no change - Asset import from CSV
doesn't update asset descriptions.
This is a showstopper for me, as their appears to be no other
mechanism
for entering bulk data.

It appears that you have a DB somewhere containing this information.
You have a couple of options:

1) Write an automation that triggers on the external database looking
for asset information that has changed and actions on updating the
OpenNMS asset table. There's not much documentation on this
capability, it will be available soon.

2) If you are a Java programmer, work with the OGP to improve the
Importer's capabilities to update the Asset table while importing
nodes, interfaces, and services to be monitored.

3) Look for errors in the webapp logs and give us more details about
why it's not working. It's hard to go on nothing much more than it's
broke.

Post by Simon Anderson
Is it really the case that OpenNMS requires
asset data to be submitted manually for each and every asset?

It has to be submitted somewhere manually at some point, right? The
feature was added long ago for those that didn't have anything for
tracking this information and associating it with nodes being
monitored by OpenNMS.

Because it was added long ago, before the days of brozow and his
JUnit testing framework, we don't have Unit tests in the code for
this feature. If you were to find errors in logs and open a bug in
bugzilla, it may be something that can be quickly fixed. The more
detail you provide the better.

David Hustace
The OpenNMS Group, Inc.

John Blake

2007-07-12 13:13:03 UTC

I've haven't messed with the import stuff yet but,
since it's in a postgres dbase, cant you write a script to read the csv
and insert it into the dbase?

-----Original Message-----
From: opennms-discuss-***@lists.sourceforge.net
[mailto:opennms-discuss-***@lists.sourceforge.net] On Behalf Of
Simon Anderson
Sent: Wednesday, July 11, 2007 10:07 PM
To: General OpenNMS Discussion
Subject: Re: [opennms-discuss] Asset import from CSV

Anyone?

I've upgraded to 1.3.5 with the no change - Asset import from CSV
doesn't update asset descriptions.

This is a showstopper for me, as their appears to be no other mechanism
for entering bulk data. Is it really the case that OpenNMS requires
asset data to be submitted manually for each and every asset?

Regards,
Simon.

export

Post by Simon Anderson
it back out cleanly. It's just the web interface which is erroneous.
Regards,
Simon.

------------------------------------------------------------------------
-

Post by Simon Anderson
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
http://www.opennms.org/index.php/Mailing_List_FAQ
opennms-discuss mailing list
To *unsubscribe* or change your subscription options, see the bottom
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

Simon Anderson

2007-07-13 03:04:41 UTC

Data is in database, not in interface, like I said..

Post by John Blake
I've haven't messed with the import stuff yet but,
since it's in a postgres dbase, cant you write a script to read the csv
and insert it into the dbase?
-----Original Message-----
Simon Anderson
Sent: Wednesday, July 11, 2007 10:07 PM
To: General OpenNMS Discussion
Subject: Re: [opennms-discuss] Asset import from CSV
Anyone?
I've upgraded to 1.3.5 with the no change - Asset import from CSV
doesn't update asset descriptions.
This is a showstopper for me, as their appears to be no other mechanism
for entering bulk data. Is it really the case that OpenNMS requires
asset data to be submitted manually for each and every asset?
Regards,
Simon.

export

Post by Simon Anderson
it back out cleanly. It's just the web interface which is erroneous.
Regards,
Simon.

------------------------------------------------------------------------
-

John Blake

2007-07-13 12:39:20 UTC

Explain "not in interface".
You mean you don't see the updated info thru the gui?
Or you cant change the info that's being displayed where the snmp
"system" info is at?

John

-----Original Message-----
From: opennms-discuss-***@lists.sourceforge.net
[mailto:opennms-discuss-***@lists.sourceforge.net] On Behalf Of
Simon Anderson
Sent: Thursday, July 12, 2007 11:05 PM
To: General OpenNMS Discussion
Subject: Re: [opennms-discuss] Asset import from CSV

Data is in database, not in interface, like I said..

Post by John Blake
I've haven't messed with the import stuff yet but,
since it's in a postgres dbase, cant you write a script to read the

csv

Post by John Blake
and insert it into the dbase?
-----Original Message-----
Simon Anderson
Sent: Wednesday, July 11, 2007 10:07 PM
To: General OpenNMS Discussion
Subject: Re: [opennms-discuss] Asset import from CSV
Anyone?
I've upgraded to 1.3.5 with the no change - Asset import from CSV
doesn't update asset descriptions.
This is a showstopper for me, as their appears to be no other

mechanism

Post by John Blake
for entering bulk data. Is it really the case that OpenNMS requires
asset data to be submitted manually for each and every asset?
Regards,
Simon.

description

Post by Simon Anderson
area of the web interface.
Import/Export works correctly, i.e. I can import the new data and

export

Post by Simon Anderson
it back out cleanly. It's just the web interface which is erroneous.
Regards,
Simon.

------------------------------------------------------------------------

------------------------------------------------------------------------

Post by John Blake
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
http://www.opennms.org/index.php/Mailing_List_FAQ
opennms-discuss mailing list
To *unsubscribe* or change your subscription options, see the bottom

Post by John Blake
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

------------------------------------------------------------------------
-

Post by John Blake
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
http://www.opennms.org/index.php/Mailing_List_FAQ
opennms-discuss mailing list
To *unsubscribe* or change your subscription options, see the bottom
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

Danny Willis

2007-07-16 16:15:45 UTC

Man oh man, I'm glad I came across this before I sat down and created a
spreadsheet with all of my asset information.

This does really suck though because I have almost 75 nodes that I have
to enter asset information for. This is going to make my next couple of
days quite long lol.

Although I suppose I could figure out how to insert it using postgres,
but I have never seen the table structure for ONMS so it would take me
almost as long to figure that out as it is going to take to manually
insert the information for every node..

-----Original Message-----
From: opennms-discuss-***@lists.sourceforge.net
[mailto:opennms-discuss-***@lists.sourceforge.net] On Behalf Of John
Blake
Sent: Friday, July 13, 2007 8:39 AM
To: General OpenNMS Discussion
Subject: Re: [opennms-discuss] Asset import from CSV

Explain "not in interface".
You mean you don't see the updated info thru the gui?
Or you cant change the info that's being displayed where the snmp
"system" info is at?

John

-----Original Message-----
From: opennms-discuss-***@lists.sourceforge.net
[mailto:opennms-discuss-***@lists.sourceforge.net] On Behalf Of
Simon Anderson
Sent: Thursday, July 12, 2007 11:05 PM
To: General OpenNMS Discussion
Subject: Re: [opennms-discuss] Asset import from CSV

Data is in database, not in interface, like I said..

Post by John Blake
I've haven't messed with the import stuff yet but,
since it's in a postgres dbase, cant you write a script to read the

csv

mechanism

Post by John Blake
for entering bulk data. Is it really the case that OpenNMS requires
asset data to be submitted manually for each and every asset?
Regards,
Simon.

description

Post by Simon Anderson
area of the web interface.
Import/Export works correctly, i.e. I can import the new data and

export

Post by Simon Anderson
it back out cleanly. It's just the web interface which is erroneous.
Regards,
Simon.

------------------------------------------------------------------------

------------------------------------------------------------------------

------------------------------------------------------------------------
-

Timothy Selivanow

2007-07-16 16:28:59 UTC

Post by Danny Willis
Man oh man, I'm glad I came across this before I sat down and created a
spreadsheet with all of my asset information.
This does really suck though because I have almost 75 nodes that I have
to enter asset information for. This is going to make my next couple of
days quite long lol.
Although I suppose I could figure out how to insert it using postgres,
but I have never seen the table structure for ONMS so it would take me
almost as long to figure that out as it is going to take to manually
insert the information for every node..

http://www.opennms.org/index.php/OpenNMS_database_schema

Not exactly too sure what version of ONMS that is, but the assets table
is what you need anyway and that looks to be the same in 1.2 as 1.3.

There is always pgAdmin3 also.

http://www.pgadmin.org/

Or if you want a web based management tool there is phppgadmin.

http://phppgadmin.sourceforge.net/

--
Timothy Selivanow <***@easystreet.com>
Linux System Administrator
EasyStreet Online Services, Inc. http://www.easystreet.com

Byron Anderson

2007-07-16 16:31:12 UTC

Danny

I might suggest using Excel to connect to the DB. This will allow you
to see the DB table structure as well as run some nifty reports.

All you need to do in order for this to work is install the ODBC driver
for Postgres on the system with Excel and then establish a connection.

Once I started playing with this I found all sorts of cool ways to do
things.

-------------------------------------------
Byron Anderson
Network Operations Center Manager
EasyStreet Online Services
www.easystreet.com

-----Original Message-----
From: opennms-discuss-***@lists.sourceforge.net
[mailto:opennms-discuss-***@lists.sourceforge.net] On Behalf Of
Danny Willis
Sent: Monday, July 16, 2007 9:16 AM
To: General OpenNMS Discussion
Subject: Re: [opennms-discuss] Asset import from CSV

Man oh man, I'm glad I came across this before I sat down and created a
spreadsheet with all of my asset information.

This does really suck though because I have almost 75 nodes that I have
to enter asset information for. This is going to make my next couple of
days quite long lol.

Although I suppose I could figure out how to insert it using postgres,
but I have never seen the table structure for ONMS so it would take me
almost as long to figure that out as it is going to take to manually
insert the information for every node..

-----Original Message-----
From: opennms-discuss-***@lists.sourceforge.net
[mailto:opennms-discuss-***@lists.sourceforge.net] On Behalf Of John
Blake
Sent: Friday, July 13, 2007 8:39 AM
To: General OpenNMS Discussion
Subject: Re: [opennms-discuss] Asset import from CSV

Explain "not in interface".
You mean you don't see the updated info thru the gui?
Or you cant change the info that's being displayed where the snmp
"system" info is at?

John

-----Original Message-----
From: opennms-discuss-***@lists.sourceforge.net
[mailto:opennms-discuss-***@lists.sourceforge.net] On Behalf Of
Simon Anderson
Sent: Thursday, July 12, 2007 11:05 PM
To: General OpenNMS Discussion
Subject: Re: [opennms-discuss] Asset import from CSV

Data is in database, not in interface, like I said..

Post by John Blake
I've haven't messed with the import stuff yet but,
since it's in a postgres dbase, cant you write a script to read the

csv

mechanism

Post by John Blake
for entering bulk data. Is it really the case that OpenNMS requires
asset data to be submitted manually for each and every asset?
Regards,
Simon.

description

Post by Simon Anderson
area of the web interface.
Import/Export works correctly, i.e. I can import the new data and

export

Post by Simon Anderson
it back out cleanly. It's just the web interface which is erroneous.
Regards,
Simon.

------------------------------------------------------------------------

------------------------------------------------------------------------

Post by John Blake
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

------------------------------------------------------------------------
-

------------------------------------------------------------------------
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of
this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

------------------------------------------------------------------------
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of
this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

------------------------------------------------------------------------
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of
this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

Danny Willis

2007-07-16 17:15:43 UTC

Thanks for this advice. I'm going to check it out now.

-----Original Message-----
From: opennms-discuss-***@lists.sourceforge.net
[mailto:opennms-discuss-***@lists.sourceforge.net] On Behalf Of
Byron Anderson
Sent: Monday, July 16, 2007 12:31 PM
To: General OpenNMS Discussion
Subject: Re: [opennms-discuss] Asset import from CSV

Danny

I might suggest using Excel to connect to the DB. This will allow you
to see the DB table structure as well as run some nifty reports.

All you need to do in order for this to work is install the ODBC driver
for Postgres on the system with Excel and then establish a connection.

Once I started playing with this I found all sorts of cool ways to do
things.

-------------------------------------------
Byron Anderson
Network Operations Center Manager
EasyStreet Online Services
www.easystreet.com

-----Original Message-----
From: opennms-discuss-***@lists.sourceforge.net
[mailto:opennms-discuss-***@lists.sourceforge.net] On Behalf Of
Danny Willis
Sent: Monday, July 16, 2007 9:16 AM
To: General OpenNMS Discussion
Subject: Re: [opennms-discuss] Asset import from CSV

Man oh man, I'm glad I came across this before I sat down and created a
spreadsheet with all of my asset information.

This does really suck though because I have almost 75 nodes that I have
to enter asset information for. This is going to make my next couple of
days quite long lol.

Although I suppose I could figure out how to insert it using postgres,
but I have never seen the table structure for ONMS so it would take me
almost as long to figure that out as it is going to take to manually
insert the information for every node..

-----Original Message-----
From: opennms-discuss-***@lists.sourceforge.net
[mailto:opennms-discuss-***@lists.sourceforge.net] On Behalf Of John
Blake
Sent: Friday, July 13, 2007 8:39 AM
To: General OpenNMS Discussion
Subject: Re: [opennms-discuss] Asset import from CSV

Explain "not in interface".
You mean you don't see the updated info thru the gui?
Or you cant change the info that's being displayed where the snmp
"system" info is at?

John

-----Original Message-----
From: opennms-discuss-***@lists.sourceforge.net
[mailto:opennms-discuss-***@lists.sourceforge.net] On Behalf Of
Simon Anderson
Sent: Thursday, July 12, 2007 11:05 PM
To: General OpenNMS Discussion
Subject: Re: [opennms-discuss] Asset import from CSV

Data is in database, not in interface, like I said..

Post by John Blake
I've haven't messed with the import stuff yet but,
since it's in a postgres dbase, cant you write a script to read the

csv

mechanism

Post by John Blake
for entering bulk data. Is it really the case that OpenNMS requires
asset data to be submitted manually for each and every asset?
Regards,
Simon.

description

Post by Simon Anderson
area of the web interface.
Import/Export works correctly, i.e. I can import the new data and

export

Post by Simon Anderson
it back out cleanly. It's just the web interface which is erroneous.
Regards,
Simon.

------------------------------------------------------------------------

------------------------------------------------------------------------

------------------------------------------------------------------------
-

Byron Anderson

2007-07-16 16:32:53 UTC

Oh, you will also need to allow connections by making a configuration
change on the OpenNMS system also, sorry I forgot to mention that.

-------------------------------------------
Byron Anderson
Network Operations Center Manager
EasyStreet Online Services
www.easystreet.com

-----Original Message-----
From: opennms-discuss-***@lists.sourceforge.net
[mailto:opennms-discuss-***@lists.sourceforge.net] On Behalf Of
Byron Anderson
Sent: Monday, July 16, 2007 9:31 AM
To: General OpenNMS Discussion
Subject: Re: [opennms-discuss] Asset import from CSV

Danny

I might suggest using Excel to connect to the DB. This will allow you
to see the DB table structure as well as run some nifty reports.

All you need to do in order for this to work is install the ODBC driver
for Postgres on the system with Excel and then establish a connection.

Once I started playing with this I found all sorts of cool ways to do
things.

-------------------------------------------
Byron Anderson
Network Operations Center Manager
EasyStreet Online Services
www.easystreet.com

-----Original Message-----
From: opennms-discuss-***@lists.sourceforge.net
[mailto:opennms-discuss-***@lists.sourceforge.net] On Behalf Of
Danny Willis
Sent: Monday, July 16, 2007 9:16 AM
To: General OpenNMS Discussion
Subject: Re: [opennms-discuss] Asset import from CSV

Man oh man, I'm glad I came across this before I sat down and created a
spreadsheet with all of my asset information.

This does really suck though because I have almost 75 nodes that I have
to enter asset information for. This is going to make my next couple of
days quite long lol.

Although I suppose I could figure out how to insert it using postgres,
but I have never seen the table structure for ONMS so it would take me
almost as long to figure that out as it is going to take to manually
insert the information for every node..

-----Original Message-----
From: opennms-discuss-***@lists.sourceforge.net
[mailto:opennms-discuss-***@lists.sourceforge.net] On Behalf Of John
Blake
Sent: Friday, July 13, 2007 8:39 AM
To: General OpenNMS Discussion
Subject: Re: [opennms-discuss] Asset import from CSV

Explain "not in interface".
You mean you don't see the updated info thru the gui?
Or you cant change the info that's being displayed where the snmp
"system" info is at?

John

-----Original Message-----
From: opennms-discuss-***@lists.sourceforge.net
[mailto:opennms-discuss-***@lists.sourceforge.net] On Behalf Of
Simon Anderson
Sent: Thursday, July 12, 2007 11:05 PM
To: General OpenNMS Discussion
Subject: Re: [opennms-discuss] Asset import from CSV

Data is in database, not in interface, like I said..

Post by John Blake
I've haven't messed with the import stuff yet but,
since it's in a postgres dbase, cant you write a script to read the

csv

mechanism

Post by John Blake
for entering bulk data. Is it really the case that OpenNMS requires
asset data to be submitted manually for each and every asset?
Regards,
Simon.

description

Post by Simon Anderson
area of the web interface.
Import/Export works correctly, i.e. I can import the new data and

export

Post by Simon Anderson
it back out cleanly. It's just the web interface which is erroneous.
Regards,
Simon.

------------------------------------------------------------------------