Facility Control

Hi Guys!

I know there are guys our there that will help me, please help, I need it!

I am a Graphics Designer/Operator and I've been tasked to create a scoring app For Netball, Rugby and Football that will read data from CSV, Excel, Xml or even just have the Dialog boxes on the scoring app to enter data such as player name and number, officials names, coaches names, add stats via stat buttons, add goals etc. Much the same as the Example Chris Kaptein from Bamboo Shoots has developed for Hockey.

I hope I made sense.

Cheers guys

Hi Dennis.
We can certainly help you with some specifics. Writing the overall application is up to you though.

If you're looking for some example code to get going, here is an example that reads up to 15 columns of data from a CSV file called "CSV Reader Data.csv":

It might look a little bit intimidating but most of what you're seeing in the XML is creating a bunch of "col.x" parameters to hold all of the values being read-in. The script that does everything is located in the button task.

<abs contexttype="opengear" style="">
   <meta>
      <params>
         <param access="1" maxlength="0" name="Column 1" oid="cols.1" precision="0" stateless="true" type="STRING_ARRAY" value="" widget="label">
            <value>
            </value>
         </param>
         <param access="1" maxlength="0" name="Column 2" oid="cols.2" precision="0" stateless="true" type="STRING_ARRAY" value="" widget="label">
            <value>
            </value>
         </param>
         <param access="1" maxlength="0" name="Column 3" oid="cols.3" precision="0" stateless="true" type="STRING_ARRAY" value="" widget="label">
            <value>
            </value>
         </param>
         <param access="1" maxlength="0" name="Column 4" oid="cols.4" precision="0" stateless="true" type="STRING_ARRAY" value="" widget="label">
            <value>
            </value>
         </param>
         <param access="1" maxlength="0" name="Column 5" oid="cols.5" precision="0" stateless="true" type="STRING_ARRAY" value="" widget="label">
            <value>
            </value>
         </param>
         <param access="1" maxlength="0" name="Column 6" oid="cols.6" precision="0" stateless="true" type="STRING_ARRAY" value="" widget="label">
            <value>
            </value>
         </param>
         <param access="1" maxlength="0" name="Column 7" oid="cols.7" precision="0" stateless="true" type="STRING_ARRAY" value="" widget="label">
            <value>
            </value>
         </param>
         <param access="1" maxlength="0" name="Column 8" oid="cols.8" precision="0" stateless="true" type="STRING_ARRAY" value="" widget="label">
            <value>
            </value>
         </param>
         <param access="1" maxlength="0" name="Column 9" oid="cols.9" precision="0" stateless="true" type="STRING_ARRAY" value="" widget="label">
            <value>
            </value>
         </param>
         <param access="1" maxlength="0" name="Column 10" oid="cols.10" precision="0" stateless="true" type="STRING_ARRAY" value="" widget="label">
            <value>
            </value>
         </param>
         <param access="1" maxlength="0" name="Column 11" oid="cols.11" precision="0" stateless="true" type="STRING_ARRAY" value="" widget="label">
            <value>
            </value>
         </param>
         <param access="1" maxlength="0" name="Column 12" oid="cols.12" precision="0" stateless="true" type="STRING_ARRAY" value="" widget="label">
            <value>
            </value>
         </param>
         <param access="1" maxlength="0" name="Column 13" oid="cols.13" precision="0" stateless="true" type="STRING_ARRAY" value="" widget="label">
            <value>
            </value>
         </param>
         <param access="1" maxlength="0" name="Column 14" oid="cols.14" precision="0" stateless="true" type="STRING_ARRAY" value="" widget="label">
            <value>
            </value>
         </param>
         <param access="1" maxlength="0" name="Column 15" oid="cols.15" precision="0" stateless="true" type="STRING_ARRAY" value="" widget="label">
            <value>
            </value>
         </param>
         <param access="1" maxlength="0" name="Column 16" oid="cols.16" precision="0" stateless="true" type="STRING_ARRAY" value="" widget="label">
            <value>
            </value>
         </param>
         <param access="1" maxlength="0" name="Column 0" oid="cols.0" precision="0" stateless="true" type="STRING_ARRAY" value="" widget="label">
            <value>
            </value>
         </param>
         <param access="1" constrainttype="STRING_CHOICE" name="table" oid="table" precision="0" type="INT16" value="-1" widget="table">
            <constraint>cols.0</constraint>
            <constraint>cols.1</constraint>
            <constraint>cols.2</constraint>
            <constraint>cols.3</constraint>
            <constraint>cols.4</constraint>
            <constraint>cols.5</constraint>
            <constraint>cols.6</constraint>
            <constraint>cols.7</constraint>
            <constraint>cols.8</constraint>
            <constraint>cols.9</constraint>
            <constraint>cols.10</constraint>
            <constraint>cols.11</constraint>
            <constraint>cols.12</constraint>
            <constraint>cols.13</constraint>
            <constraint>cols.14</constraint>
            <constraint>cols.15</constraint>
            <constraint>cols.16</constraint>
         </param>
      </params>
   </meta>
   <param bottom="5" expand="true" left="6" oid="table" right="8" showlabel="false" top="104"/>
   <button buttontype="push" height="84" left="5" name="Read" top="7" width="186">
      <task tasktype="ogscript">function processCSV(fileContent)
{
   if (fileContent == null)
   {
      ogscript.debug("CAN'T LOAD FILE");
      return;
   }
   
   var rows = fileContent.split('\n');
   var dataByColumn = []; //It is more efficient if we only call "SET" on the parameters once
   
   for (var r = 0; r &lt; rows.length; r++)
   {
      var cols = rows[r].trim().split(',');
      for (var c = 0; c &lt; cols.length; c++)
      {
         if (c &gt;= dataByColumn.length)
         {
            dataByColumn.push([]); //Add a new column if it wasn't already created
         }
         dataByColumn[c][r] = cols[c].trim(); //Push the cell's value into the array of column data at row "r"
      }
   }
   
   
   //Now that we have collected all of the data for each column into an array, we can call setAllValues for the array parameter
   for (var c = 0; c &lt; dataByColumn.length; c++)
   {
      params.setAllValues('cols.' + c, dataByColumn[c]); //Set all of the values in the column
   }
}

ogscript.asyncPost('CSV Reader Data.csv', null, processCSV);

</task>
   </button>
</abs>

#DashBoard

Hi James

Thank you so much for your reply! I am finding it a bit tough getting hold of the tutorial that will guide me in the right direction of where to use the script you have provided for me. I am a noob to dashboard so EVERYTHING seems greek to me. If you could recommend a tutorial?

Once again, thank you for the assistance.

Cheers
#DashBoard

Hi Dennis.
We're a little lacking in end-to-end sports scoreboard tutorials and examples. You can look at the examples on DashBoard U or read through the panels posted by Chris Kaptein to try to learn a little more but you're unlikely to find a step-by-step guide for your exact use.

Your best bet is probably to pepper us with questions as you work your way through this and, most importantly, play around a bit in Panel Builder.

What we often provide in the forum are little chunks of code. Examples that demonstrate a concept that you can incorporate into your panel and learn how to extend it.

It sounds like you're looking for a place to start so let me provide you with some recommended steps: [LIST=1]