Re: HPSM Todo list_some fields not showing data (773 Views)
Reply
Regular Advisor
MariamElkomos
Posts: 165
Registered: ‎04-07-2013
Message 1 of 21 (839 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

 

Honored Contributor
Vadim Gorda
Posts: 5,761
Registered: ‎11-10-2008
Message 2 of 21 (838 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.

Regular Advisor
MariamElkomos
Posts: 165
Registered: ‎04-07-2013
Message 3 of 21 (832 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.

Honored Contributor
Vadim Gorda
Posts: 5,761
Registered: ‎11-10-2008
Message 4 of 21 (829 Views)

Re: HPSM Todo list_some fields not showing data

Regular Advisor
MariamElkomos
Posts: 165
Registered: ‎04-07-2013
Message 5 of 21 (823 Views)

Re: HPSM Todo list_some fields not showing data

It does not work, dont know why.

will keep trying
Regular Advisor
MariamElkomos
Posts: 165
Registered: ‎04-07-2013
Message 6 of 21 (813 Views)

Re: HPSM Todo list_some fields not showing data

Capture.PNG

Valued Contributor
fljme
Posts: 86
Registered: ‎11-22-2012
Message 7 of 21 (810 Views)

Re: HPSM Todo list_some fields not showing data

Use Database manager to open Todomap table.

Honored Contributor
Vadim Gorda
Posts: 5,761
Registered: ‎11-10-2008
Message 8 of 21 (807 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.

Regular Advisor
MariamElkomos
Posts: 165
Registered: ‎04-07-2013
Message 9 of 21 (805 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?
Honored Contributor
Vadim Gorda
Posts: 5,761
Registered: ‎11-10-2008
Message 10 of 21 (803 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.

Honored Contributor
Vadim Gorda
Posts: 5,761
Registered: ‎11-10-2008
Message 11 of 21 (802 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.

Regular Advisor
MariamElkomos
Posts: 165
Registered: ‎04-07-2013
Message 12 of 21 (796 Views)

Re: HPSM Todo list_some fields not showing data

I made sure nothing wrong with the fields names.
Valued Contributor
fljme
Posts: 86
Registered: ‎11-22-2012
Message 13 of 21 (793 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.

Honored Contributor
Vadim Gorda
Posts: 5,761
Registered: ‎11-10-2008
Message 14 of 21 (791 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).

Regular Advisor
MariamElkomos
Posts: 165
Registered: ‎04-07-2013
Message 15 of 21 (785 Views)

Re: HPSM Todo list_some fields not showing data

todo.PNGtodo.PNGincidents.PNG

Valued Contributor
fljme
Posts: 86
Registered: ‎11-22-2012
Message 16 of 21 (782 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?

 

 

Honored Contributor
Vadim Gorda
Posts: 5,761
Registered: ‎11-10-2008
Message 17 of 21 (779 Views)

Re: HPSM Todo list_some fields not showing data

Input on the Todo form  is correct for that columns?

Regular Advisor
MariamElkomos
Posts: 165
Registered: ‎04-07-2013
Message 18 of 21 (777 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?
Valued Contributor
fljme
Posts: 86
Registered: ‎11-22-2012
Message 19 of 21 (775 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.

Honored Contributor
Vadim Gorda
Posts: 5,761
Registered: ‎11-10-2008
Message 20 of 21 (773 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.

Regular Advisor
MariamElkomos
Posts: 165
Registered: ‎04-07-2013
Message 21 of 21 (745 Views)

Re: HPSM Todo list_some fields not showing data

thank you so much,

 

really appreciate your help

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.