Index: trunk/DataCheck/Tools/fill_r750.sh
===================================================================
--- trunk/DataCheck/Tools/fill_r750.sh	(revision 19481)
+++ trunk/DataCheck/Tools/fill_r750.sh	(revision 19495)
@@ -5,5 +5,5 @@
 dbname=factdata
 # fill only corrected R750
-short="yes" # comment line to fill also reference values
+#short="yes" # comment line to fill also reference values
 
 # setup for zd- and th-correction: 
@@ -121,5 +121,8 @@
        254.6 #87
        251.5 #88
-       249.0 #89
+       249.4 #89
+       251.9 #90
+       249.4 #91
+       240.0 #92 (current period)
        )
 
@@ -129,4 +132,5 @@
 for (( i=0; i < ${#rates[@]} ; i++)) 
 do
+   echo "Filling P"$i
    if [ "${rates[$i]}" = "0.0" ]
    then 
@@ -136,24 +140,30 @@
    fi
    query="UPDATE RunInfo SET fR750Ref="$rate" WHERE fPeriod="$i
-   #echo $query
-   mysql --defaults-file=$sqlpw -u operator -h 10.0.100.21 $dbname -s -e "$query" 
+   echo "  "$query
+   mysql --defaults-file=$sqlpw -s -e "$query" 
 done
 
+echo "Filling split periods..."
 # several periods are split: 
 #   update the values for those
 # 71b
 query="UPDATE RunInfo SET fR750Ref=250.0 WHERE fPeriod=71 AND fNight>20170726"
+   echo "  "$query
 mysql --defaults-file=$sqlpw -s -e "$query" 
 # 69b
 query="UPDATE RunInfo SET fR750Ref=253.0 WHERE fPeriod=69 AND fNight>20170524"
+   echo "  "$query
 mysql --defaults-file=$sqlpw -s -e "$query" 
 # 60a
 query="UPDATE RunInfo SET fR750Ref=239.3 WHERE fPeriod=60 AND fNight<20170901"
+   echo "  "$query
 mysql --defaults-file=$sqlpw -s -e "$query" 
 # 46a
 query="UPDATE RunInfo SET fR750Ref=271 WHERE fPeriod=46 AND fNight<20150716"
+   echo "  "$query
 mysql --defaults-file=$sqlpw -s -e "$query" 
 # 24b
 query="UPDATE RunInfo SET fR750Ref=286.2 WHERE fPeriod=24 AND fNight>20131003"
+   echo "  "$query
 mysql --defaults-file=$sqlpw -s -e "$query" 
 
