Erinevused

Siin näed erinevusi valitud versiooni ja hetkel kehtiva lehekülje vahel.

--- osport:rogainmanager:eng [2014/08/13 14:14]
taksoft [Before event]
+++ osport:rogainmanager:eng [2016/03/01 18:34] (Hetkel kehtiv)
@@ Rida 123: / Rida 123: @@
 ...\\
 ''
+    * Assigne bib numbers to teams
+       * manually
+       * or use scripts
+          * ''update team set number=id;'' -- team number as database sequence number
+          * ''update team set number=entryId;'' -- team number as entry system ID
     * Check Data (Edit menu)
        * Select check file %%(*%%.rmchk files from Common folder) and select what to check. Program will generate report if there are errors.
@@ Rida 142: / Rida 147: @@
 **//\\ //**
 ====== During event ======
+===== After start =====
+  * Mark started participants-- (Tools menu -- **Load started**)
+    * Select CSV file with started chip numbers. File format is:\\  ''StationNR; ChipNumber; Time (HH:MM.SS,kk)'' \\ Time is optional.\\ You may use SI Config or SIBackupReader program to read out started SI cards from check stations.
+    * Program will mark all started members as Started
+  * To mark all teams (and runners) as started run script in __DB editor__:
+''
+update runner set started=true;
+''
+  * Use __DB editor__ to get "not started runners" report (open script NotStartedRunnersList.sql)
+    * Change not started  Teams statuses to DNS
+===== SPORTident readout =====
   * Start program and select event
-  * Start Server service (mark “Server” checkbox on Server sub form)\\ {{ROM_image007.jpg?120x106}}
+  * Start **Server service** (mark “Server” checkbox on Server sub form)\\ {{ROM_image007.jpg?120x106}}
   * Start program [[osport:sireadouteng|SIReadout.exe]]
+    * Usually you need more than one computer for reading data from chips (moste teams arrive in last 30 minutes).
+    * Copy files from SIReadout folder to readout computers. Computers had to be in the same network. One computer is server (with RogainManager). You need to type Server IP aadress into SIReadout. By default pot 6001 is used for data (you need to allow data traffic for this port on the Server).
+    * Use local printer (attached to readout computer) and select Windows printer driver and proper layout file. I suggest to use fast thermal shop POS printers to printout results sheets for runners. Standard laser/inkjet printer are not fast enough for single printouts.
+===== Change team results (status) =====
   *  Edit results and team status  - select Edit Controls from menu (F5)\\ {{ROM_image009.jpg?263x200}}
     * Type team number and press ENTER
@@ Rida 164: / Rida 188: @@
         * DNS -- Team not started
     * If Calc. Team result is checked then after submitting result program will over calculates team results and points.
-  * Mark started participants-- (Tools menu -- **Load started**)
-    * Select CSV file with started chip numbers. File format is:\\  StationNR; ChipNumber; Time (HH:MM.SS,kk)\\Time is optional.\\ You may use SI Config or SIBackupReader program to read out started SI cards from check stations.
+  * View team results (during event)
-    * Program will mark all started members as Started
+    * To view Team total results select “Results” tab. To recalculate team result, press **Calculate Team** button.
-    * Use DB editor for making not started runners report (NotStartedRunnersList.sql)
+    * To view Team visited controls select from View menu **Team controls** (CTRL+T)
-    * Change not started  Teams statuses to DNS
+    * To view Team controls and status -- select from View menu **Team Result** (CTRL+R)
-*
+    * To view and edit member controls select runner row and then from View menu **Runner controls** (CTRL+U)
 ====== After event ======
@@ Rida 196: / Rida 223: @@
 ====== Comments and hints ======
+===== Database Editor =====
+Rogain Manager using built in SQL database engine.
+<note important>Do not change database if you do not know what you are doing!!</note>
+It's possible to make changes into database using SQL commands - from main menu choose Tools-> DB Editor.
+There are some reports and scripts in program Common folder.
+Right click on editors shows database tables and columns.
+Supported SQL commands : http://www.componentace.com/help/absdb_manual/absdbmanual_content.htm
+If program gives errors on start up (table or column yyyy is missing) update your database using UpdateSQl_to_XX.sql scripts and restart program.
 © Tak-Soft 2008/2014

Tak-Soft juhendid

Kasutaja tarvikud

Lehe tööriistad

Erinevused

Lehekülje tarvikud