66 reputation
213
bio website
location
age
visits member for 2 years, 3 months
seen Aug 26 at 2:14

EAI developer working mainly in Energy and Utilities, Health and Education sectors. Tools of my middleware trade have included webMethods, JavaCAPS, and I'm just about to get my hands dirty in some TIBCO.

Plenty of Oracle and MSSQL thrown about in integration/ETL anger too.

C#.Net is my weapon of choice for all things non-middleware (or at the SOA periphery, where OOTB APIs are non existent, or need a spruce up with something more web-servicey).

I have a history in infrastructure and applications support, which gives me a pretty good sense of the "bigger picture" in terms of how my code plays within the architecture of the wider technical environment, and in terms of how it should play with humans in the support/maintenance sphere when (heaven forbid) my code needs biological assistance.

More recently I've been dabbling in the world of the "front end" on my own time, so am finding my feet in web technologies such as CSS, JS, JQ etc. Am having fun developing (or supporting) sites based on open source CMSs such as WordPress, and learning PHP along the way.


Oct
23
comment Create additional goal indicators on a KPI list
Thanks so much for your help. I wish I could accept more than 1 answer, as this was really helpful to me and was clearly an acceptable answer (I was able to implement it to meet the requirements of my question, with little fuss). But I went with the DataViewWebPart solution, because it seems more elegant (to me) to do the legwork on the server-side, rather than relying on client-side scripting. But not without quite a lot of internal debate, as your answer was the least complex solution that met my requirements. Thanks so much for your input, I do really appreciate your time and effort.
Oct
23
comment Create additional goal indicators on a KPI list
Thanks so much for your help, I really appreciate the input. At this stage we're just working with the one list, but if this changes, I'll be sure to look into this product.
Oct
23
comment Create additional goal indicators on a KPI list
Thanks so much for your help, I learned a lot as a result of your input. Wish I could accept more than 1 answer, as this was really helpful to me.
Oct
23
comment Create additional goal indicators on a KPI list
And the bounty goes to... @ghangas! I'm working through this now... haven't finished, but it seems clear to me that while it's a little more leg work (as I'm not proficient with XSLT at this stage), this is the way I should be doing this. Thanks again.
Oct
22
comment Create additional goal indicators on a KPI list
This looks to me to be the "right" way to do what I'm trying to achieve, OOTB. I'll have a crack at this tomorrow and advise.
Oct
22
comment Create additional goal indicators on a KPI list
Also, say I'd use your lookup mechanism to select which image will be displayed for each of the 4 KPI thresholds (eg in future may have a number of different themed sets of icons from which to choose each status icon). But apparently I'm not able to use lookup values in the calculated column (where I need to check if the "score" column is over a certain "threshold" column, in order to select the correct status icon). Is there a suitable workaround that would make the lookup value available in the calculated column?
Oct
22
comment Create additional goal indicators on a KPI list
FYI had a look at this approach today, and it works and was straightforward, thanks. Am still going to explore the other answers here though, as Stef's adds a bit of "framework" around this approach (if I can get it to work), while @ghangas's looks like the "right" OOTB way to do it.
Oct
22
comment Create additional goal indicators on a KPI list
It seems I'm not (without significant red tape) able to add new web parts to the site, so instead I used a CEWP for the 'Text To HTML' component - which otherwise seems fine. But then the pictures.html file doesn't seem to be working for me; the image is not being rendered. I suspect the .js files are not being loaded. Is there any reason why I couldn't/shouldn't include that js in script tags within the pictures html, to keep it all self-contained (or are these .js files meant to be available in the SP build somewhere already)?
Oct
22
comment Create additional goal indicators on a KPI list
+1 Took me a while to understand what this offered above @Drew-Lanclos's answer (aside from your awesome instructions, thanks!). But now I get it! ;-)
Oct
22
comment Create additional goal indicators on a KPI list
+1 This looks like a very flexible solution, thanks! NB the johnsworkshop write-up is for 2010 - but there's a number of valuable links referenced there for 2007, eg msdn.microsoft.com/en-us/library/cc300164(v=office.12).aspx
Oct
22
comment Create additional goal indicators on a KPI list
+1 Thanks for the suggestion. Will explore this later today.
Oct
21
comment Create additional goal indicators on a KPI list
+1 This looks promising, thanks. I've asked the powers-that-be if they're willing to run a 3rd party control.
Oct
21
comment Create additional goal indicators on a KPI list
@HughWood At this stage, it is 2007 I'm afraid. But it may be that we can hold off on this until 2010+ is available. Thanks for your input.
Oct
21
comment Create additional goal indicators on a KPI list
@rjcup3 Thanks for looking at this mate.
Oct
16
comment Create additional goal indicators on a KPI list
Your help much appreciated mate! ;-) Looking forward to hearing what you come up with. Note, if your findings aren't fruitful, I'd at the least upvote any answer that describes to other people what you've tried (and why you tried it), but that didn't work (and why it didn't work).
Oct
15
comment Create additional goal indicators on a KPI list
@rjcup3 So where should I be looking for the real meat? But am I not interested in the display aspect too, given I'm looking for a mechanism to display the KPIs differently?
Oct
5
comment How to resolve full names from a Person or Group column (that contains multiple entries) in a designer workflow
The +75 spoils go to you, sir ;-) I haven't actually had a chance to implement this as won't be back in the office for a few more days - but everything I've seen so far suggests this approach is perfect. Thanks for your help!
Oct
5
comment How to resolve full names from a Person or Group column (that contains multiple entries) in a designer workflow
@PirateEric Ah OK yes that's already been tried, thanks (and with no luck as per my earlier "Edit: Further info" in my question and as you've suggested it's still DOMAIN\user in the workflow). I assumed the answerer was referring to something within SPD.
Oct
3
comment How to resolve full names from a Person or Group column (that contains multiple entries) in a designer workflow
This sounds promising, thanks for your answer. I'm a competent .Net programmer but no experience programming for SP. I'll do some research into how to implement this (but in the mean time, if you do know already know of any good guides/tutorials, I'd appreciate it - but not expecting you to do my research for me).
Oct
3
comment How to resolve full names from a Person or Group column (that contains multiple entries) in a designer workflow
This bit sounds promising: If you are using SPD in the column list editor you should be able to specify for the people column how you want the column returned and in your workflow. Where do I find the "column list editor"? I can't find this anywhere. I'm not sure I understand the relevance of this code fragment? Can you provide some more context for this code and possibly remove the code that's not specifically relevant to my issue (I'm a competent .Net programmer, but no experience programming with SharePoint yet)?