xsl if node has value [Archive]

View Full Version : xsl if node has value

werD

08-02-2005, 05:42 AM

Hello i have a node that may or may not have a value i want to write out that value if it does and not if it doesnt
here is my page so far i bolded the area in question

<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<html>
<head>
<script language="javascript">
function termed(){
alert("This is a Termed Client");
}
function hra(){
alert("This is an HRA Client");
}
function fsa(){
alert("This is an FSA Client");
}
function lfsa(){
alert("This is an LFSA Client");
}
</script>
</head>
<body>
<h2>ClientList</h2>
<table border="1">
<tr bgcolor="#9acd32">
<th align="left">Company</th>
<th align="left">Control</th>
<th align="left">Company</th>
<th align="left">Control</th>
</tr>
<xsl:for-each select="clientlist/Table/line">
<tr>
<xsl:for-each select="Cell">
<td><a onclick="<xsl:if test="script"><xsl:value-of select="script" /></xsl:if>" href="{@HRef}">
<xsl:value-of select="Data"/></a></td>
</xsl:for-each>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>

Thanks

hemebond

08-02-2005, 08:32 AM

<a href="{@HRef}">
<xsl:attribute name="onclick">
<xsl:if test="script">
<xsl:value-of select="script"/>
</xsl:if>
</xsl:attribute>
</a>Try that. I haven't tested it, and I haven't used xsl:if before.

werD

08-02-2005, 03:18 PM

Worked perfectly
final

<xsl:for-each select="clientlist/Table/line">
<tr>
<xsl:for-each select="Cell">
<td><a href="{@HRef}">
<xsl:attribute name="onclick">
<xsl:if test="script">
<xsl:value-of select="script" />
</xsl:if>
</xsl:attribute>
<xsl:value-of select="Data"/></a></td>
</xsl:for-each>
</tr>
</xsl:for-each>

Thanks

werD

08-03-2005, 03:21 AM

ok this did not work..

this only checks to see if the node exists it doesnt check to see if it has a value is there anyway to modify the above code to check to see if the existing node has a value(text inside of it)

hemebond

08-03-2005, 03:43 AM

Could I have some XML data to work with please?

werD

08-03-2005, 06:53 AM

<xsl:if test="Node=''">
well check if the node has a blank value.. here is my current issue though

<xsl:for-each select="clientlist/Table">
<script language="javascript">
var control=document.board.pn.value
Function checknum()
<xsl:if test="line/Cell/Data/@Type='Number'">
if (control=="<xsl:value-of select="line/Cell/Data/>">);
document.href="<xsl:value-of select="line/Cell/@HRef/>";
</xsl:if>
return false;
</script>
</xsl:for-each>

Heres is a line of the xml

<Table>
<line Height="76.5">
<Cell StyleID="s32" HRef="site">
<Data Type="String">Lutheran Heritage Foundation</Data>
<script/>
</Cell>
<Cell StyleID="s35" HRef="site">
<Data Type="Number">63819</Data>
<script/>
</Cell>
<Cell StyleID="s51" HRef="site">
<Data Type="String">WYETH (Formerly known as American Home Products)</Data>
<script/>
</Cell>
<Cell StyleID="s35" HRef="http://www.site.com">
<Data Type="Number">9300</Data>
<script/>
</Cell>
</line>
<!--Alot more lines--!>
</Table>

im attemppting to write out a large javascript file from the above xml for each line where the number is the data type i want to write a new line of javascript code I am doing a similar loop through the same xml file on this page but it is to create a table I now need the javascript

hemebond

08-03-2005, 07:10 AM

Okay, this is getting a little messier. Are you able to paste or attach all your code/files? Attaching would be best.

werD

08-03-2005, 07:52 AM

i think i just fixed that part but.. ..i get no errors when i run the page it loads quite fast, but when i type a number in the box that is well on down the list like in the z's ..it takes somewhere around 3 seconds to run the javascript? I thought this javascript would be loaded before the body of the page.. I actually wrote a version of this javascript before manually with all 500 clients and it runs very fast.. Is this xml related?.. when I view source on the page i cant see the generated HTML.. i can only see the xml sheet... which i dont really want people to see..

heres my full xsl code..maybe you can see where my error is

<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<html>
<head>
<script language="javascript">
function termed(){
alert("This is a Termed Client");
}
function hra(){
alert("This is an HRA Client");
}
function fsa(){
alert("This is an FSA Client");
}
function lfsa(){
alert("This is an LFSA Client");
}
function benny(){
alert("This is a Benny Card Client");
}
function chase(){
alert("This is a Chase Card Client");
}
function flex(){
alert("This is a Flex Card Client");
}
function bookmark(){
return true;
}
</script>
<xsl:for-each select="clientlist/Table">
<script language="javascript">
function checknum(){
<xsl:for-each select="line/Cell">

<xsl:if test="Data/@Type='Number'">
if (document.board.pn.value=="<xsl:value-of select="Data"/>")
return <xsl:value-of select="script"/>();
window.location="<xsl:value-of select="@HRef"/>";
</xsl:if>

</xsl:for-each>
return false;
}
</script></xsl:for-each>
</head>
<body>
<form name="board" method="post" onsubmit="checknum();">
<input type="text" name="pn"/><input type="submit"/></form>
<h2>ClientList</h2>
<table border="1">
<tr bgcolor="#9acd32">
<th align="left">Company</th>
<th align="left">Control</th>
<th align="left">Company</th>
<th align="left">Control</th>
</tr>
<xsl:for-each select="clientlist/Table/line">
<tr>
<xsl:for-each select="Cell">
<td>
<xsl:if test="NamedCell">
<a><xsl:attribute name="name"><xsl:value-of select="NamedCell/@Name"/></xsl:attribute></a>
</xsl:if>
<xsl:choose>
<xsl:when test="Data=''">
<xsl:value-of select="Data"/>.
</xsl:when>
<xsl:otherwise>
<xsl:choose>
<xsl:when test="script=''">
<a href="{@HRef}">
<xsl:attribute name="onclick">fsa();</xsl:attribute><xsl:value-of select="Data"/></a>
</xsl:when>
<xsl:otherwise>
<a href="{@HRef}">
<xsl:attribute name="onclick"><xsl:value-of select="script"/>();</xsl:attribute><xsl:value-of select="Data"/></a>
</xsl:otherwise>
</xsl:choose>
</xsl:otherwise>
</xsl:choose>

</td>
</xsl:for-each>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>

Ive attached a copy of the sheet as well

hemebond

08-03-2005, 08:28 AM

It would be much better if you attached both the XSL and XML files.

werD

08-03-2005, 08:39 AM

ive attched aa portion of the xml to my last post the full file is too large

hemebond

08-03-2005, 09:17 AM

Okay, I've cleaned it up a little, but I'm having a bit of trouble figuring out what you what the script to actually do.

Also, your XML is designed incorrectly. You're not getting any benefit over standard HTML. Your XML tells me almost nothing about the data.

Give me as much detail as possible, and I'll have another look tomorrow morning.

werD

08-03-2005, 04:26 PM

ok.. Thanks for all your help so far..

The idea of the xml was to make the client list more easily updated by my other staff members. The xml is generated off an excel table and builds the hyperlinks to all our clients.. The rest off the staff wanted something to where they wouldnt have to write in the javascript for new clients or changed clients. How could I do this xml better. This was the qickest way I could generate the xml and quickly manipulate it to make it usable.
NamedCell is for letter bookmarks
excel table
-each line has four cells two data and two string
-the data is layed out string,number,string,number
-excel table
the xml has style for cell class(currently unused in script)
and a node in each cell to call the javascript alert.. This way staff only has to type in "fsa" or "termed"
What would a better way to write thj xml consist of? I am really new to xml but have been using asp and db recordsets for a while now so my xml logic may be all backwards.

Thanks again for your help

werD

08-03-2005, 07:13 PM

Ok.. Ive looked at this xml a little harder.. I guess excel is just not the way i need it generated.. but I think i can use an xsl to parse the initial xml output a little better. Would this be a more appropriate output?

<Table>
<line>
<Cell Style="style1" HRef="longurl">
<Name>Acf Industries</Name>
<Control>10029</Control>
<Type>fsa</Type>
</Cell>
<Cell Style="style1" HRef="longurl">
<Name>Another Company</Name>
<Control>10038</Control>
<Type>fsa</Type>
</Cell>
<line>
</Table>

hemebond

08-03-2005, 11:14 PM

Can you tell me what the data is though? I should be able to look at the XML and understand what the data is based on the tags around it.

You have a clientlist element, but no clients. You have table, line and cell elements, but they're all presentational. What's the relationship between clients that are on the same 'line'? Is the style attribute purely presentational? Does the type element specify the type of company/client? What are the numbers in the last 'cell'? Some sort of internal company/client ID?

Try to think about data, structure, style and behaviour as completely seperate layers. Once we've got the data sorted, we'll use XSL to create the structure. After that we use CSS to add the style. Then Javascript to add behaviour. All these are seperate layers, we should be able to apply them without even touching the others.

See what I'm getting at?

werD

08-03-2005, 11:31 PM

I do and Thanks again for your help
the clientlist element is only there in case i wanted to add certain opening statements and such i was just trying to be ready for the future
The page is laid out in two columns
http://12.202.21.191/xml/client/clientlist.xml
by alphabet
1 2
A M
B N
C O
D P
E Q
F R
G S
H T
I U
J V
K W
L XYZ

each line has four cells two of the cells contain info for one client in column 1 the other two are for column 2 the out put is similar to this

column 1 column2
Co. A #1 Co. M #20

The style attribute was intended to change the color of the specific font color or cell background for that hyperlink each script type is color coded with a diff color ie.. FSA is Blue

hemebond

08-04-2005, 12:14 AM

What's the relationship between clients that are on the same 'line'? Does the type element specify the type of company/client? What are the numbers in the last 'cell'? Some sort of internal company/client ID?Can you tell me these?

werD

08-04-2005, 12:24 AM

clients on the same line are to be displayed on the same row on the page

line

first cell in row
Data type String Company Name company name starts with "A"
second cell in row
Data Type Number Internal Control Number same company as above.. it starts with "A"
Third cell in row
Data type String Company Name company name starts with "M"
fourth cell in row
Data Type Number Internal Control Number same company as above.. it starts with "M"

end line

i assume by this

What are the numbers in the last 'cell'? Some sort of internal company/client ID?

you are referencing this

<Cell StyleID="s35" HRef="url">
<Data Type="Number">21087</Data>
<script>fsa</script>
</Cell>

Yes this is an internal control number that our apps and csr's reference the company by

it is what should be typed in form box to pull up the client info

thanks again
Drew

hemebond

08-04-2005, 12:36 AM

clients on the same line are to be displayed on the same row on the pageWhy? What does it mean when 2 clients are on the same line? What kind of relationship does this represent?

werD

08-04-2005, 01:00 AM

a visual relationship for the table layout is all that it is.

line = two columns in one so people can look at two columns at once

rather than going all the way down the page i didnt know a better way to take one completely alphabetical list and display two columns of identical length that sor them by order of letters this was an easier alternative as any other apps that ever need to use it will be looking up only by Data type=Number

They dont do anything for anything else but make it easier to look at.. It doesnt matter what order they go in alohabetically in the list...

are you saying that i should remove the node line all together ... as i said before this was an excel table of names and numbers with hyperlinks on them.. so this is where line comes in.. it was really more of visual representation for me to leave it in so i could follow the order of the page a bit better

werD

08-04-2005, 01:11 AM

I have the excel that generated this and can modify it to be one solid list of cells..
Do you know of away i could sort those to be viewed side by side and add the bookmarks in

hemebond

08-04-2005, 02:38 AM

Here's what I have so far. I still don't know what you want the script to do.

werD

08-04-2005, 05:01 AM

that code will not load.. it just gives me the xml output on the screen i notice it says application/xml in the stylesheet reference I am currently on an xp pro x64 system with IIS 6.0 installed i also have msxml 4.0 with sp2 do i not have something loaded or is there something im missing

hemebond

08-04-2005, 05:40 AM

I've no idea what's wrong with IE. Nothing I tried made any difference. Look at it in Firefox.

werD

08-04-2005, 02:27 PM

Well damn.. our entire company uses IE5 or higher i am about the only one in the building w/firefox installed..
That looks good except it should be layed out this way
ACF Industries 21087 Main Line Health 10080
AERA ENERGY 10167 Maryland Park and Plan Commision 10030

werD

08-04-2005, 09:00 PM

thanks again for your help..

Is there any way you can help me to rewrite this javascript to work with this
I have this so far as my javascript

<script language="javascript">
function termed(){
alert("This is a Termed Client");
}
function hra(){
alert("This is an HRA Client");
}
function fsa(){
alert("This is an FSA Client");
}
function lfsa(){
alert("This is an LFSA Client");
}
function benny(){
alert("This is a Benny Card Client");
}
function chase(){
alert("This is a Chase Card Client");
}
function flex(){
alert("This is a Flex Card Client");
}
function bookmark(){
return true;
}
</script>

<xsl:for-each select="list">
<script language="javascript">
function checknum(){
<xsl:for-each select="line/Cell">

<xsl:if test="Control">
if (document.board.pn.value=="<xsl:value-of select="Control"/>"){
if(confirm("You are about to view a <xsl:value-of select="product"/> Client")){
document.location.href="<xsl:value-of select="link"/>";
}
}

</xsl:if>

</xsl:for-each>
return false;
}

</script>

Thanks again for the xml suggestions here is the layout i decided on

<?xml version="1.0" encoding="iso-8859-1"?>
<?xml-stylesheet type="text/xsl" href="client.xsl"?>
<list>
<line>
<Cell>
<Client>ACF Industries</Client>
<product>fsa</product>
<link>url</link>
<Control>21087</Control>
</Cell>
<Cell>
<Client>Main Line Health</Client>
<product>fsa</product>
<link>url</link>
<Control>10080</Control>
</Cell>
</line>
</list>

hemebond

08-05-2005, 12:40 AM

You still haven't told me exactly what the script is suppose to do.

Here's an update anyway. This is getting really fun now. I'm working on that two-column layout now. You shouldn't compromise your data just for a specific layout. What happens if you decide you want 3 columns? You going to change all your data again? Any automated processes you've got going then have to be updated as well.Got it. See, you don't need to compromise your data. This has been really fun. Just waiting for you to tell me what the script needs to do.

werD

08-10-2005, 05:06 PM

OK the sample you've given me is damn close to awesome! Thanks alot for the help..

Here is my overall goal..
This page is a client list which will navigate CSR's to the proper client page if they either hit the number or if they click on the link..

I would like to use a three-frame frameset for this
top frame real small {has a legend with a color code for each type of client}
middle frame {still kindof small- this frame would house the form}
bottom frame{displays two columns side-by-side which show the client data}

So.. the person on the phones gets a call.. they look up that person and find out they work for client "64989" They can do one of two things type the control number in the box or click the link on the table..

I would like for the javascript to do three things for each..
1. A confirm box pops up and says you are about to view an "Active(or termed) FSA(or HSA or LFSA or HRA) (if a card client write what type of card)
2. Change the background color of the middle frame to match the legend from above
3. Direct the user to the link supplied in the xml..
---
I have changed the xml to something similar to this

<?xml version="1.0" encoding="ISO-8859-1"?>
<list>
<line>
<Cell>
<Client>ACF Industries</Client>
<product>fsa</product>
<Card>No</Card>
<Active>Yes</Active>
<link>url</link>
<Control>21087</Control>
<NamedCell>A</NamedCell>
</Cell>
<Cell>
<Client>Main Line Health</Client>
<product>fsa</product>
<Card>No</Card>
<Active>Yes</Active>
<link>url</link>
<Control>10080</Control>
<NamedCell>M</NamedCell>
</Cell>
</line>
<line>
<Cell>
<Client>AERA ENERGY</Client>
<product>fsa</product>
<Card>No</Card>
<Active>Yes</Active>
<link>url</link>
<Control>10167</Control>
</Cell>
<Cell>
<Client>Maryland Nat Capital Park and Planning Comm.</Client>
<product>fsa</product>
<Card>Chase</Card>
<Active>Yes</Active>
<link>url</link>
<Control>10030</Control>
</Cell>
</line>

you can view what i came up with at this link(after 4:00 Eastern Time)
http://12.202.21.191/test/clientlist.htm

The way I have done this poses several problems though..
1. If I add a client I have to add a whole new row with a blank cell or completely rearrange the xml
-I would be happy to do something different if it could alphabetize my list and make two columns

Again I thank you for all your help and sorry about the delayed response I have been working on this like crazy!

hemebond

08-10-2005, 10:58 PM

I have changed the xml to something similar to this
...
The way I have done this poses several problems though..
1. If I add a client I have to add a whole new row with a blank cell or completely rearrange the xml
-I would be happy to do something different if it could alphabetize my list and make two columnsI'm sorry werD, but if you won't take my advice there's not a lot of point in me continuing to give it. I've already explained why your XML schema is bad, and given you a 90% working system for this. I'm not really sure why you want to start all over again like this. To be perfectly honest, it sounds like your whole system needs a rethink.

werD

08-11-2005, 12:46 AM

The system you gave me looked good but didnt do anything i need really...
Here is the correct example of what i meant to post as the xml file

<list>

<Cell>
<Client>ACF Industries</Client>
<product>fsa</product>
<Card>No</Card>
<Active>Yes</Active>
<link>http://lou1-web01/robohelp/shpsmate/shpsmate v3/ACF Industries 21087/ACF_Industries_21087.htm</link>
<Control>21087</Control>
<NamedCell>A</NamedCell>
</Cell>
<Cell>
<Client>Main Line Health</Client>
<product>fsa</product>
<Card>No</Card>
<Active>Yes</Active>
<link>http://lou1-web01/robohelp/shpsmate/shpsmate v3/Main Line Health 10080/Main_Line_Health_10080.htm</link>
<Control>10080</Control>
<NamedCell>M</NamedCell>
</Cell>

I didnt want to stack two tables on top of each other and use a form to give an alert at all...

here's a fully working version og what i was talking about if you would like to look..
http://12.202.21.191/alpha/clientlist.htm
I did take your suggestions and used apply-templates rather than building the table from each record i used xsl:sort by name..

sorry if this sounded harsh but i kinda got worked up looking around fopr what i was trying to do
I found it on another post forum..

<xsl:apply-templates select="Cell" >
<xsl:sort select="Client" order="ascending" />
</xsl:apply-templates>

hemebond

08-11-2005, 02:02 AM

The system you gave me looked good but didnt do anything i need really...You didn't tell me what you wanted the script to do, so all I had to go on was what you originally posted.

Now, I have a tendency to piss people off, so I'm going to say this a politely as possible. Your current system/solution is not appropriate, efficient (judging from the source code available from the site) or working and the data you just posted is only marginally better than your original.

werD

08-11-2005, 02:16 AM

hmm.
This copnfuses me
What would be a better way to arrange this xml then the way i have it? I followed the basic layout of the xml you gave me.

here is the xsl page i settled on for the table there were just so many different things that determine the color coding I had to break it all down into ifs and whens.. some fsa clients have a benny card some fsa clients with benny cards are termed some have lfsa and benny card its

<style type="text/css">

.fsa:link { color: white; text-decoration: underline}
.fsa:visited { color: white; text-decoration: underline}
.fsa:hover{color:white;}
.Chase:link { color: green; text-decoration: underline}
.Chase:visited { color: green; text-decoration: underline}
.Chase:hover{color:white;}
.Benny:link { color: blue; text-decoration: underline}
.Benny:visited { color: blue; text-decoration: underline}
.Benny:hover{color:white;}
.Flex:link { color: yellow; text-decoration: underline}
.Flex:visited { color: yellow; text-decoration: underline}
.Flex:hover{color:white;}
.lfsa:link { color: yellow; text-decoration: underline}
.lfsa:visited { color: yellow; text-decoration: underline}
.lfsa:hover{color:white;}
.Termed:link { color: black; text-decoration: underline}
.Termed:visited { color: black; text-decoration: underline}
.Termed:hover{color:white;}
.HRA:link { color: red; text-decoration: underline}
.HRA:visited { color: red; text-decoration: underline}
.HRA:hover{color:white;}
</style>
</HEAD>
<BODY onLoad="start()">

<DIV id="floatLayer" style="position: absolute; height:200px; width:150px; left:2px; top:1px;z-index: 100">Hello I am a floating Layer Waiting to be filled with nifty stuff</DIV>
<table bgcolor="#9D9FB5" border="1">
<xsl:apply-templates select="Cell" >
<xsl:sort select="Client" order="ascending" />
</xsl:apply-templates>
</table>

</BODY>
</HTML>
</xsl:template>

<xsl:template match="Cell">
<tr><td>
<xsl:if test="NamedCell">
<a><xsl:attribute name="name"><xsl:value-of select="NamedCell"/></xsl:attribute></a>
</xsl:if>
<xsl:choose>
<xsl:when test="Client=''">
<xsl:value-of select="Client"/>.
</xsl:when>
<xsl:otherwise>
<xsl:choose>
<xsl:when test="Active='Yes'">
<xsl:if test="Card='No'">
<a href="javascript:checknum({Control});"><xsl:attribute name="class"><xsl:value-of select="product"/></xsl:attribute><xsl:value-of select="Client"/></a>
</xsl:if>
<xsl:if test="Card!='No'">
<a href="javascript:checknum({Control});"><xsl:attribute name="class"><xsl:value-of select="Card"/></xsl:attribute><xsl:value-of select="Client"/></a>
</xsl:if>
</xsl:when>
<xsl:otherwise>
<a href="javascript:checknum({Control});"><xsl:attribute name="class">Termed</xsl:attribute><xsl:value-of select="Client"/></a>
</xsl:otherwise>
</xsl:choose>
</xsl:otherwise>
</xsl:choose>
</td><td>
<xsl:choose>
<xsl:when test="Control=''">
<xsl:value-of select="Control"/>.
</xsl:when>
<xsl:otherwise>
<xsl:choose>
<xsl:when test="Active='Yes'">
<xsl:if test="Card='No'">
<a href="javascript:checknum({Control});"><xsl:attribute name="class"><xsl:value-of select="product"/></xsl:attribute><xsl:value-of select="Control"/></a>
</xsl:if>
<xsl:if test="Card!='No'">
<a href="javascript:checknum({Control});"><xsl:attribute name="class"><xsl:value-of select="Card"/></xsl:attribute><xsl:value-of select="Control"/></a>
</xsl:if>
</xsl:when>
<xsl:otherwise>
<a href="javascript:checknum({Control});"><xsl:attribute name="class">Termed</xsl:attribute><xsl:value-of select="Control"/></a>
</xsl:otherwise>
</xsl:choose>
</xsl:otherwise>
</xsl:choose>
</td></tr>
</xsl:template>

</xsl:transform>

hemebond

08-11-2005, 03:02 AM

Do you have a database? Server-side scripting?

werD

08-11-2005, 03:25 AM

I have about 800 databases of different information on this server and about 1000 people that access it at peak time .. Im trying to convert some basic things to xml so i can still have some dynamics but not rely so much on the server to do the load.. this is why im trying to learn some more xml and xsl I would like to learn how to do it efficiently though and not just to do it.. Do you have any suggestions?

hemebond

08-11-2005, 04:03 AM

Well, you could start by telling me what was so wrong with my submission that you couldn't use any of it.

werD

08-11-2005, 04:15 AM

to be quite honest i didnt understand it at all... i didnt realize that multiple templates could be applied and as you can probably see im still not to on top of it as for the position count to place in seperate columns i gave up on that as it wasnt scalable enough to fit the bill.. which you pointed out and as i liook at it i will probably end up changing it a few more times before im through

im still open to any suggestions you may have on how to make this more efficient

hemebond

08-11-2005, 05:32 AM

<xsl:apply-templates select="client[position() <= count(//client) div 2]"/>

...

<xsl:apply-templates select="client[position() > count(//client) div 2]"/>
That divides the data into 2 groups.

Okay, I have a 2-column layout with a search box that prompts the user with a message for that client. Here's what I'm thinking now.

This is unnecessarily complicated.

Is there a reason you don't just have a table with all details for each client? Do the users really need colour codes? A text box that does the same thing as clicking a link? There's an awful lot of code here for a simple client look-up.

werD

08-11-2005, 09:17 PM

Ahh.. but the problem.. is people are stupid.. The system that this goes in is basically our CSR's bible.. the system they use to find the definitive answer to everything.. If it were up to me i would give one form with two boxes to build a query for each db and grab the data that i need right then.. But once again people are stupid.. We have to have this system laid out in such a simple layout for the end user so that we can assure that the proper info is given out.. And by creating the list in this manner we basically leave them no excuses or "no room for error".. Either its right from the system or your fired.. lol
The initial table i had basically did that it was like so..
Clientname/type </td> Control </td> picture of card "if have a card"
and each client would be black or white for "Active or Not"
The problem was people didn't read the info.. they would just type in the number and go straight to the client info then go directly to the info and tell them something completely wrong.. This has been what they have decided would be a better option..
Must Have
Basic Table Color Code for product
A popup that reminds them of what type of client they will be viewing whether clicked or typed
-----------
The Call center managers love the color code. They are gung ho about it. Any thing that assures the CSRs dont have to think makes them extremely happy..
The whole idea of it is to have the system(me) do all of the work that way the end user doesn't have to do anything but read whats on the screen :)..
Thank you again for all your help

hemebond

08-11-2005, 10:46 PM

Your Call Centre manager needs to be told that a prompt will not correct this behaviour. It really won't. If it did, spyware wouldn't be such a problem because people would read the warnings shown by the browser and click 'cancel' instead of blindly clicking the 'ok' or enter button.

If this is really important information, it should be very prominent on the clients page (what the table links go to).

werD

08-12-2005, 04:09 AM

Yes, the info is everywhere inside the client but they tend to look for the exact place of the data and and skip over the titles or headings.Trust me I said months ago "how could they not realize that they're applying that data incorrectly its just about everywhere" And i actually started here on the phones and never made such silly mistakes..sigh as you said since people dont read the prompts i color code the middle frame as well, But to put it plain and simple If they don't read the prompts that we tell them to read then we dont really need them on our team. Our tools and business rely on a constant communication of material from Client to Us to Participant but the nature of the calls we receive are generally something completely not related to the information we take in and process.. They are generally Elligibility or cost questions or things of that nature

The idea is simple the workers do as they are told and the process runs smoothly.. If we leave any room for Human error.. Human error will occur..

Also the client breakdown is a little more rate, enrollment and elligibility info than we'll say Card related material as this is generally handled through a third party provider such as Chase or Bennet we try to remind people that it could be a card issue as often as possible as well