Color coding the Helpdesk incident grids

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

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

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

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.

Uh.

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?

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

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

Thanks

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.

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.

Excellent let me look for them...

Color codes : numbers

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

where do I add the overdue code?

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!

workitem_due_on (DUE) color coding

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!

Guest Customisations

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

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