Erinevused

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

--- osport:rogainmanager:eng [2014/08/13 14:25]
taksoft [During event]
+++ osport:rogainmanager:eng [2014/08/13 14:59]
taksoft [Change team results (status)]
@@ 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 148: / Rida 153: @@
     * 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
-    * Use DB editor for making not started runners report (open script NotStartedRunnersList.sql)
+  * 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
@@ Rida 179: / Rida 188: @@
         * DNS -- Team not started
     * If Calc. Team result is checked then after submitting result program will over calculates team results and points.
+  * View team results (during event)
+    * To view Team total results select “Results” tab. To recalculate team result, press **Calculate Team** button.
+    * To view Team visited controls select from View menu **Team controls** (CTRL+T)
+    * 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)
@@ Rida 207: / 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