Facility Control

Good evening,
I'm trying to find a creative solution to an issue. I have rosters with players at 0 or 00, and those values are reserved in XPression for the groups. So we've assigned those players to 90 / 99 respectively in our excel spreadsheets. We also pull stat data from StatCrew using datalinq keys. Does anybody have a creative solution to do the following:

If I assign a jersey number 90 or 99 in Dashboard, it needs to pull StatCrew data for player zero (0/00) and the excel information for 90/99.

I think I have at least part of it working where Dashboard can assign the data key the value based on the jersey number entered. How can I accomplish part 2?

Thanks!
Brian

Hi Brian.
I'm not very familiar with StatCrew data but can try to point you in the right direction if you can give me a few more details.

In your application, I'm not entirely certain what you're looking to have DashBoard do vs. what you're looking to have XPression do or what your data actually looks like.

Can you explain a bit more about what you mean by having DashBoard "pull" the information from StatCrew/Excel and what you want DashBoard to do with the data after it pulls it?

Cheers.

James

#DashBoard

Hi James,
StatCrew is just XML-formatted data that I pull into XPression. Hopefully this makes sense:

1. User enters in a player jersey in Dashboard. However, if that player wears 0 or 00, they are entering in 90 or 99. Dashboard needs to send 0 or 00 to the XPression Data Key
(I think I have this part working)
2. Dashboard also needs to send 90 or 99 - maybe to a different data key? - to get spreadsheet data as well.

I'm thinking this may be more of an XPression question than a Dashboard one now. But if you think of anything, let me know.

Thanks,
Brian

#DashBoard

So something along these lines?

<abs contexttype="opengear">
   <meta>
      <params>
         <param access="1" maxlength="0" name="User Input" oid="params.userinput" stateless="true" type="STRING" value="" widget="default"/>
         <param access="1" maxlength="0" name="XPression Key" oid="params.xpressionkey" stateless="true" type="STRING" value="" widget="label"/>
         <param access="1" maxlength="0" name="Excel Key" oid="params.excelkey" stateless="true" type="STRING" value="" widget="label"/>
      </params>
   </meta>
   <param expand="true" height="91" left="12" oid="params.userinput" runtasksonload="true" showlabel="false" style="size:Big;txt-align:center;" top="12" width="266">
      <task tasktype="ogscript">var userInputValue = params.getValue('params.userinput', 0);
if (userInputValue  ==  '90')
{
    params.setValue('params.xpressionkey', 0, '0');
   params.setValue('params.excelkey', 0, '90');
}
else if (userInputValue  ==  '99')
{
   params.setValue('params.xpressionkey', 0, '00');
   params.setValue('params.excelkey', 0, '99');
}
else
{
   params.setValue('params.xpressionkey', 0, userInputValue);
   params.setValue('params.excelkey', 0, userInputValue);    
}</task>
   </param>
   <simplegrid height="171" hspace="5" left="12" rows="1" top="116" width="388">
      <param expand="true" oid="params.xpressionkey" showlabel="false" style="size:Biggest;txt-align:center;font:bold;bg#dark;bdr:etched;"/>
      <param expand="true" oid="params.excelkey" showlabel="false" style="size:Biggest;txt-align:center;font:bold;bg#dark;bdr:etched;"/>
   </simplegrid>
   <button buttontype="push" height="97" left="281" name="Go!" top="11" width="111"/>
</abs>

#DashBoard

I got it working. Unfortunately Excel won't give me the 00, but Xpression and Dashboard are working properly. I have a different question I'll post in a new topic.
#DashBoard