Re: HPSM Todo list_some fields not showing data (651 Views)
Reply
Regular Advisor
MariamElkomos
Posts: 162
Registered: ‎04-07-2013
Message 1 of 21 (717 Views)
Accepted Solution

HPSM Todo list_some fields not showing data

Hello,

 

some of the Todo list fields are empty, records are not being populated. is there a way by which I can link todo table with incidents or problems to fill such fields. actually I have searched for that and found that there is no link done at the first place to make the existing working fields work as they are.

 

so why some fields are working and some are not? and how to fix that?

 

thanks a lot

 

Please use plain text.
Honored Contributor
Vadim Gorda
Posts: 5,685
Registered: ‎11-10-2008
Message 2 of 21 (716 Views)

Re: HPSM Todo list_some fields not showing data

Hello,

There is a table TodoMap which saves all mappig of the fields from specific tables to the Todo table.

 

Search for the records in that table and fix or add required mapping.

Please use plain text.
Regular Advisor
MariamElkomos
Posts: 162
Registered: ‎04-07-2013
Message 3 of 21 (710 Views)

Re: HPSM Todo list_some fields not showing data

Hello Vadim,

 

I have done that already and it does not show how it is mapped with incidents or interactions.

 

Please see attachment.

Please use plain text.
Honored Contributor
Vadim Gorda
Posts: 5,685
Registered: ‎11-10-2008
Message 4 of 21 (707 Views)

Re: HPSM Todo list_some fields not showing data

Please use plain text.
Regular Advisor
MariamElkomos
Posts: 162
Registered: ‎04-07-2013
Message 5 of 21 (701 Views)

Re: HPSM Todo list_some fields not showing data

It does not work, dont know why.

will keep trying
Please use plain text.
Regular Advisor
MariamElkomos
Posts: 162
Registered: ‎04-07-2013
Message 6 of 21 (691 Views)

Re: HPSM Todo list_some fields not showing data

Capture.PNG

Please use plain text.
Valued Contributor
fljme
Posts: 86
Registered: ‎11-22-2012
Message 7 of 21 (688 Views)

Re: HPSM Todo list_some fields not showing data

Use Database manager to open Todomap table.

Please use plain text.
Honored Contributor
Vadim Gorda
Posts: 5,685
Registered: ‎11-10-2008
Message 8 of 21 (685 Views)

Re: HPSM Todo list_some fields not showing data

Hello,

Please post the existant records from the TodoMap table for the objects which are not working properly.

 

Use database manager for that as it was written in the previous post. For accessing database manager type db in the SM command line. In the opened window search for the TodoMap table and then check the existant records in it.

Please use plain text.
Regular Advisor
MariamElkomos
Posts: 162
Registered: ‎04-07-2013
Message 9 of 21 (683 Views)

Re: HPSM Todo list_some fields not showing data

thank you both for that, I reached there.
but still the fields not populated yet,do I have to refresh it someway?
Please use plain text.
Honored Contributor
Vadim Gorda
Posts: 5,685
Registered: ‎11-10-2008
Message 10 of 21 (681 Views)

Re: HPSM Todo list_some fields not showing data

You have to check if the right named fields are mapped from your tables (probsummary,incidents ...) to the correct fields in the Todo table (actrually the fields which are set in the columns on the Todo form).

 

You just have to check for mistypes and probable modifications which could have changed the fields in which the data is stored.

Please use plain text.
Honored Contributor
Vadim Gorda
Posts: 5,685
Registered: ‎11-10-2008
Message 11 of 21 (680 Views)

Re: HPSM Todo list_some fields not showing data

First of all check what is set in the mapping for the fields which does not have data.

Please use plain text.
Regular Advisor
MariamElkomos
Posts: 162
Registered: ‎04-07-2013
Message 12 of 21 (674 Views)

Re: HPSM Todo list_some fields not showing data

I made sure nothing wrong with the fields names.
Please use plain text.
Valued Contributor
fljme
Posts: 86
Registered: ‎11-22-2012
Message 13 of 21 (671 Views)

Re: HPSM Todo list_some fields not showing data

Give snapshots of dbdict: Todo, db: Todomap of using table.
And say few fields whitch not showing data.

Please use plain text.
Honored Contributor
Vadim Gorda
Posts: 5,685
Registered: ‎11-10-2008
Message 14 of 21 (669 Views)

Re: HPSM Todo list_some fields not showing data

Just to make sure that we are talking about the same problem can you clarify the quotes below:

 

Records are populated in Todo list without a problem.

For some records some data is missing (like for some records columns in the Todo are empty but for some the same columns are filled out).

Data in some columns is missing based on objects (for example column 3 is empty for all Interactions, but for Incidents is filled out).

Please use plain text.
Regular Advisor
MariamElkomos
Posts: 162
Registered: ‎04-07-2013
Message 15 of 21 (663 Views)

Re: HPSM Todo list_some fields not showing data

todo.PNGtodo.PNGincidents.PNG

Please use plain text.
Valued Contributor
fljme
Posts: 86
Registered: ‎11-22-2012
Message 16 of 21 (660 Views)

Re: HPSM Todo list_some fields not showing data

OK, now open some test incident.

Go to RAD Debagger and:

d contact.cisco.no in $L.file

if Value is NULL

contact.cisco.no in $L.file="111"

 

And save incident, now u can see this number(111) in Todo?

 

 

Please use plain text.
Honored Contributor
Vadim Gorda
Posts: 5,685
Registered: ‎11-10-2008
Message 17 of 21 (657 Views)

Re: HPSM Todo list_some fields not showing data

Input on the Todo form  is correct for that columns?

Please use plain text.
Regular Advisor
MariamElkomos
Posts: 162
Registered: ‎04-07-2013
Message 18 of 21 (655 Views)

Re: HPSM Todo list_some fields not showing data

Yes, fileds are now populated for the new ticket, thank you.

but what about the old ones?
Please use plain text.
Valued Contributor
fljme
Posts: 86
Registered: ‎11-22-2012
Message 19 of 21 (653 Views)

Re: HPSM Todo list_some fields not showing data

[ Edited ]

Old record go to Todo table only after save incident/interactions and etc. Triggers works.

Please use plain text.
Honored Contributor
Vadim Gorda
Posts: 5,685
Registered: ‎11-10-2008
Message 20 of 21 (651 Views)

Re: HPSM Todo list_some fields not showing data

You would not get that fields filled out for the old records unless you run mass update or something like that. Or a short script which will go trough all that records and populate that fields to the Todo table.

 

If you have added your fields to mapping later, the old records in the Todo are not updated automatically.

Please use plain text.
Regular Advisor
MariamElkomos
Posts: 162
Registered: ‎04-07-2013
Message 21 of 21 (623 Views)

Re: HPSM Todo list_some fields not showing data

thank you so much,

 

really appreciate your help

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation