Color coding the Helpdesk incident grids

matzebru · 08-14-2007, 12:53 PM

Hi,

We've implemented the original John Doyle customization of color coding the incident grid per Altiris KB article 34253. We format the grid table to also include the "Due" column (workitem_due_on) and our workers want to know if it's possible to also color code the Due cell of an incident that is due on the current day as well as the Due cell of incidents that are overdue.

Anyone have a good idea on how to do this?

Thanks

knwilson · 09-18-2007, 07:57 PM

Quote:

Originally Posted by matzebru

Hi,

We've implemented the original John Doyle customization of color coding the incident grid per Altiris KB article 34253. We format the grid table to also include the "Due" column (workitem_due_on) and our workers want to know if it's possible to also color code the Due cell of an incident that is due on the current day as well as the Due cell of incidents that are overdue.

Anyone have a good idea on how to do this?

Thanks

We have been trying to get this working as well, but to no avail. Did you ever get this figured out? If so, could you please share?

Thanks,
Kevin

matzebru · 09-19-2007, 09:26 AM

As far as color coding the Due cell of an incident that is due on the current day as well as the Due cell of incidents that are overdue - No, I have no idea how to do that. Was hoping I'd get a reply from some of the smarties here but no bites so far

jdoyle · 09-21-2007, 09:58 PM

I see that this little mod is causing some grief. The original brief that i was given was to colour the priority field, but obviously people want to take this further. I'll post the code you need here, so just keep watching this thread

knwilson · 10-04-2007, 05:13 PM

Any updates John? You got me all excited for this.. :-)

john_quinn75013 · 05-07-2008, 05:20 PM

I'm interested in this as well.

I found a posting today out on the Symantec Forums. It is called:

How to make PAST DUE Incidents change color

In this posting, John Doyle did post some updated code to color code the columns and such. It is much easier to follow and use because now you can use color names rather than having to figure out the actual numeric code. Excellent work John.

The code however, doesn't address how to target the Due column specifically. I was able to come up with this:

Code:

 
sb.AppendFormat("else if({0}.Cell(0, 0, nPos) == '{1}') {{ {2}",grid,TryString("Due"),vbCrLf)
sb.AppendFormat(" if({0}.Cell(0, nCol, nPos) == '{1}') {2}",grid,TryString("5/1/2008 12:00:00 AM"),vbCrLf) 
sb.AppendFormat(" {{ {0}.Cell(7, nCol, nPos) = {1}; {0}.Cell(6, nCol, nPos) = {2}; {0}.Cell(13, nCol, nPos) = true;}}}} {3}",grid,ColorTranslator.ToWin32(Color.Black),ColorTranslator.ToWin32(Color.Magenta),vbCrLf)

This works perfectly against the incidents that have this specific due date and time. Of course we would want this to be automatic. I know in my case I would like to perhaps use the traffic light approach, where Green = due 1 day out, Yellow = due today, and Red = past due.

The ultimate question is how to do that.

JMoreno28 · 05-19-2008, 08:34 PM

Hi,

Let me start of by saying I'm pretty new to all of this and have been trying to implement the "John Doyle customization of color coding the incident grid per Altiris KB article 34253" but for some reason have been unsucessful. I dont know what I did wrong was there anything that I'm missing?

caleywoods · 05-20-2008, 08:54 AM

Quote:

Originally Posted by john_quinn75013

I'm interested in this as well.

I found a posting today out on the Symantec Forums. It is called:

How to make PAST DUE Incidents change color

In this posting, John Doyle did post some updated code to color code the columns and such. It is much easier to follow and use because now you can use color names rather than having to figure out the actual numeric code. Excellent work John.

The code however, doesn't address how to target the Due column specifically. I was able to come up with this:

Code:

 
sb.AppendFormat("else if({0}.Cell(0, 0, nPos) == '{1}') {{ {2}",grid,TryString("Due"),vbCrLf)
sb.AppendFormat(" if({0}.Cell(0, nCol, nPos) == '{1}') {2}",grid,TryString("5/1/2008 12:00:00 AM"),vbCrLf) 
sb.AppendFormat(" {{ {0}.Cell(7, nCol, nPos) = {1}; {0}.Cell(6, nCol, nPos) = {2}; {0}.Cell(13, nCol, nPos) = true;}}}} {3}",grid,ColorTranslator.ToWin32(Color.Black),ColorTranslator.ToWin32(Color.Magenta),vbCrLf)

This works perfectly against the incidents that have this specific due date and time. Of course we would want this to be automatic. I know in my case I would like to perhaps use the traffic light approach, where Green = due 1 day out, Yellow = due today, and Red = past due.

The ultimate question is how to do that.

Where is this code posted, into one of the ascx files?

dominique · 05-21-2008, 06:40 PM

Quote:

Originally Posted by matzebru

Hi,

We've implemented the original John Doyle customization of color coding the incident grid per Altiris KB article 34253. We format the grid table to also include the "Due" column (workitem_due_on) and our workers want to know if it's possible to also color code the Due cell of an incident that is due on the current day as well as the Due cell of incidents that are overdue.

Anyone have a good idea on how to do this?

Thanks

This is for the Grid but do we have another KB for other colors:
- Banner ...
- Flyout Menu
- Dashboard
etc...

Thanks

john_quinn75013 · 06-09-2008, 12:35 PM

Quote:

Originally Posted by caleywoods

Where is this code posted, into one of the ascx files?

Caley, yes that is correct. It is part of the subWorkItemTable.ascx file.

Remember to follow the best practices to do customization to the helpdesk.

john_quinn75013 · 06-10-2008, 10:15 AM

Quote:

Originally Posted by dominique

This is for the Grid but do we have another KB for other colors:
- Banner ...
- Flyout Menu
- Dashboard
etc...

Thanks

Dominique, to color code the other things that you are looking for, I think those are tied to the Style sheets in the css directory.

Think I saw something about this in the Altiris Forums.

dominique · 06-10-2008, 12:08 PM

Excellent let me look for them...

tomattack · 07-18-2008, 08:44 AM

I found a programme where you can create your color using slidebars on the RGB colors. the programme translate it to the weird numbers :-)
http://www.msaccessprogrammer.com/whatisthis
you only need access.

Tom

lsattan · 09-04-2008, 05:56 PM

I have followed the article to get the color coding to work for the priority field and I would like to add the additional code for the overdue tickets but can someone tell me where exactly it needs to be added. I have the "custsubworkitemtable.ascx" file, I assume it goes in there where I entered the code for the priority field but where in that file? Please help! Thanks!

MarkWarmack · 05-13-2009, 05:46 PM

I know this is an older post but did anyone discover how to color code the workitem_due_on (DUE) field.
I was able to follow KB 34253 and it works great but our HelpDesk is wanting to do a color highlight as items get closer to the Due date/time. Like within 8 hours, turn green, 4 hours yellow and 1 hour till due, change to red.

Anyone?
Thanks!

westynwo · 05-18-2009, 10:39 AM

Does anyone know which file to edit so that guests can view the same colour codings on the incident table as workers?

fasrook · 11-01-2009, 11:02 PM

Quote:

Originally Posted by tomattack

I found a programme where you can create your color using slidebars on the RGB colors. the programme translate it to the weird numbers :-)
msaccessprogrammer.com/whatisthis
you only need access.

Tom

This works great!
Direct link for anybody who cares: msaccessprogrammer.com/colortranslator2000.mdb