[INUG-Users] Reading the excel sheet using impact

Thu Oct 9 09:15:53 EDT 2008

I dont know how often the .xls changes, but you also have the option of 
taking the data out of excel and writing it to a db that you are already 
hitting. 

Our impact is hooked up to a massive cdb, so thats generally what we do. 
In fact we have a front, end where users can load their .xls through a web 
page into our db  (so that they are the ones responsible for keeping up 
with changes). 

 We have actually set up a portal to the db so that users can enter data 
into the db and get event processing updated without us being involved. As 
much as possible, we move processing out of the rules file domain and into 
the impact domain. Thus we change things in 1 place.  We have change 
control for things like updating rules file on a production box, but we 
dont for merely updating a db row. So this architecture also speeds up 
configuration changes.  For instance, if we are already processing an 
enterprise oid, and you want to add 40 more specific traps for that, no 
change is needed and no rules file update is needed. You just go to the 
portal and add the specific traps.  You can also specifiy what actions are 
to take place when the event arrives (removing the requirement to do 
things via automation)  and which webtop bucket the event is supposed to 
go to.   If you need a document to be retrieved via a menu item, you add 
the document name to the event via the portal and your done. Events can be 
marked as in prod or not via the portal and  in maintenance or not via the 
portal.  Y in X logic per event can be set up via the portal. 
Notifications (email and or paging) per event (per specific trap) can be 
set up via the portal.  You can specify wether an event is to appear in 
webtop in front of users or not  (everything can be setup for it to appear 
but we have a field that determines wether an event will actually appear 
in front of users or not). The list goes on and on.  Its very cool.

Impact is the central nervous system and brain of our architecture. 

Sorry to run on , but, "Yes!",  I'm proud of our architecture! 

brad "I got 12 hours of sleep last night and drank too much coffee this 
morning" bueche

"Yulei Liu" <netcool at gmail.com> 
Sent by: users-bounces at netcoolusers.org
10/08/2008 07:45 PM

Please respond to
users at netcoolusers.org

To
users at netcoolusers.org
cc

Subject
Re: [INUG-Users] Reading the excel sheet using impact

flat file won't work, it has a strict format requirement, csv would
work but it is not an option according to the OP.

I think ODBC datasource is the only way as mentioned earlier by Michael.

On Wed, Oct 8, 2008 at 10:11 PM, Novica Ninic
<novica.ninic at ibis-instruments.com> wrote:
> Flat file DSA?
>
> -----Original Message-----
> From: users-bounces at netcoolusers.org 
[mailto:users-bounces at netcoolusers.org]
> On Behalf Of Michael Troitzsch
> Sent: Wednesday, October 08, 2008 1:07 PM
> To: users at netcoolusers.org
> Subject: Re: [INUG-Users] Reading the excel sheet using impact
>
> Hi,
>
> never done this myself - but you should be able to define an odbc-data
> source with an Excel-Sheet as the data source. Then you should be able 
to
> use the odbc-DSA in Impact to access the sheet.
>
> HTH,
> Michael
>
>
> Michael Troitzsch
>
> DICOS GmbH Kommunikationssysteme
> Alsfelder Strasse 11
> D-64289 Darmstadt
>
> Tel: +49 6151 82787 31
> Mobil: +49 160 7825 915
> Fax: +49 6151 82787 59
>
> DICOS GmbH Kommunikationssysteme, Alsfelder Strasse 11, 64289 Darmstadt
> Sitz der Gesellschaft: Darmstadt, Amtsgericht Darmstadt HRB 7024,
> Geschäftsführer: Dr. Winfried Geyer, Stephan Hesse, Waldemar Wiesner
>
> -----Ursprüngliche Nachricht-----
> Von: users-bounces at netcoolusers.org 
[mailto:users-bounces at netcoolusers.org]
> Im Auftrag von ashish nagar
> Gesendet: Mittwoch, 8. Oktober 2008 11:40
> An: users at netcoolusers.org
> Betreff: [INUG-Users] Reading the excel sheet using impact
>
> Hi All,
>
> We have a small confusion. We are suppose to read the excel sheet using
> impact. We dont know if any one has come to this problem before. We 
cannot
> convert the file into .csv file as many people uses them to edit. Can 
anyone
> please let us know is there any other possible way of reading the excel
> sheets.
>
> Thanks and Regards
> Ashish Nagar
> _______________________________________________
> Sent by the netcoolusers.org "users" mailing list
> Post: users at netcoolusers.org
> Unsubscribe: users-unsubscribe at netcoolusers.org
> Search: http://netcoolusers.org/Search
>
> _______________________________________________
> Sent by the netcoolusers.org "users" mailing list
> Post: users at netcoolusers.org
> Unsubscribe: users-unsubscribe at netcoolusers.org
> Search: http://netcoolusers.org/Search
>
> __________ NOD32 3502 (20081007) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
>
> _______________________________________________
> Sent by the netcoolusers.org "users" mailing list
> Post: users at netcoolusers.org
> Unsubscribe: users-unsubscribe at netcoolusers.org
> Search: http://netcoolusers.org/Search
>

-- 
Yulei Liu

_______________________________________________
Sent by the netcoolusers.org "users" mailing list
Post: users at netcoolusers.org
Unsubscribe: users-unsubscribe at netcoolusers.org
Search: http://netcoolusers.org/Search

ForwardSourceID:NT00059A5A 