Index: trunk/DataCheck/Monitoring/FillVisibilities.sh
===================================================================
--- trunk/DataCheck/Monitoring/FillVisibilities.sh	(revision 18864)
+++ trunk/DataCheck/Monitoring/FillVisibilities.sh	(revision 18864)
@@ -0,0 +1,111 @@
+#!/bin/bash
+
+
+source `dirname $0`/../Sourcefile.sh
+printprocesslog "INFO starting $0"
+
+query="DELETE FROM ToOcalendar.Data"
+sendquery >> /dev/null
+
+echo "fill visibilities for 2017/8"
+printprocesslog "INFOG fill visibilities for 2017/8"
+
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20170430 20170612 XMM-Mrk421
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20171103 20171213 XMM-Mrk421
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20180430 20180430 XMM-Mrk421
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20170110 20170404 XMM-Mrk501
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20170711 20171006 XMM-Mrk501
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20180110 20180403 XMM-Mrk501
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20170101 20181231 XMM-1959
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20170101 20181231 INTEGRAL-1959
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20170421 20170629 INTEGRAL-Mrk421
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20171024 20171228 INTEGRAL-Mrk421
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20180421 20180629 INTEGRAL-Mrk421
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20181024 20181229 INTEGRAL-Mrk421
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20170101 20170421 INTEGRAL-Mrk501
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20170619 20171025 INTEGRAL-Mrk501
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20171220 20180421 INTEGRAL-Mrk501
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20180620 20181025 INTEGRAL-Mrk501
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20181220 20181230 INTEGRAL-Mrk501
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20170101 20181231 Swift-Mrk501
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20170101 20181231 Swift-1959
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20170101 20170714 Swift-Mrk421
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20171003 20180714 Swift-Mrk421
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20181003 20190714 Swift-Mrk421
+
+echo "fill visibility warnings for Swift"
+printprocesslog "INFO fill visibility warnings for Swift"
+
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20170101 20170104 Swift-Mrk421 x
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20170510 20170706 Swift-Mrk421 x
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20171111 20180105 Swift-Mrk421 x
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20180510 20180706 Swift-Mrk421 x
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20190510 20190707 Swift-Mrk421 x
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20181112 20190105 Swift-Mrk421 x
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20170131 20170404 Swift-Mrk501 x
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20170804 20171007 Swift-Mrk501 x
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20180201 20180404 Swift-Mrk501 x
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20180804 20181007 Swift-Mrk501 x
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20170321 20170522 Swift-1959 x
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20170923 20171124 Swift-1959 x
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20180321 20180523 Swift-1959 x
+/users/fact/SW.automatic.processing/DataCheck/Monitoring/ToOVisibility.sh 20180924 20181124 Swift-1959 x
+
+
+finish
+
+# Visibilities 1.1.2017 - 31.12.2018
+# 
+#XMM-Newton:
+# Mrk 421: 30.4.2017 - 12.6.2017
+#          3.11.2017 - 13.12.2017
+#          30.4.2018
+# Mrk 501: 10.1.2017 - 4.4.2017
+#          11.7.2017 - 6.10.2017
+#          10.1.2018 - 3.4.2018
+# 1959:    all the time
+#
+#INTEGRAL: 
+# Mrk 421: 21.4.2017 - 29.6.2017
+#          24.10.2017 - 28.12.2017
+#          21.4.2018 - 29.6.2018
+#          24.10.2018 - 29.12.2018
+# Mrk 501: 1.1.2017 - 21.4.2017
+#          19.6.2017 - 25.10.2017
+#          20.12.2017 - 21.4.2018
+#          20.6.2018 - 25.10.2018
+#          20.12.2018 - 30.12.2018
+# 1959:    all the time
+# 
+# NuSTAR
+# sun aspect angle violations
+# 421
+#  2017-07-27/08:00 through 2017-09-20/18:00
+#  2018-07-27/14:00 through 2018-09-21/00:00
+# 501: none
+# 1959: none
+#
+#Swift: 
+# warning '4-8h from the sun' -> marked as ( )
+# Mrk 421: 1.1.2017 - 14.7.2017
+#             warning: 1.-4.1.2017
+#             warning: 10.5.-6.7.2017
+#          3.10.2017 - 14.7.2018
+#             warning: 11.11.2017 - 5.1.2018
+#             warning: 10.5.-6.7.2018
+#          3.10.2017 - 14.7.2019
+#             warning: 12.11.2018 - 5.1.2019
+#             warning: 10.5.2019 - 7.7.2019
+# Mrk 501: all the time
+#             warning: 31.1.2017 - 4.4.2017
+#             warning: 4.8.2017 - 7.10.2017
+#             warning: 1.2.2018 - 4.4.2018
+#             warning: 4.8.2018 - 7.10.2018
+# 1959:    all the time
+#             warning: 21.3.2017 - 22.5.2017 
+#             warning: 23.9.2017 - 24.11.2017
+#             warning: 21.3.2018 - 23.5.2018
+#             warning: 24.9.2018 - 24.11.2018
+# 
+#
+
Index: trunk/DataCheck/Monitoring/ToOVisibility.sh
===================================================================
--- trunk/DataCheck/Monitoring/ToOVisibility.sh	(revision 18864)
+++ trunk/DataCheck/Monitoring/ToOVisibility.sh	(revision 18864)
@@ -0,0 +1,54 @@
+#!/bin/bash
+
+
+source `dirname $0`/../Sourcefile.sh
+printprocesslog "INFO starting $0"
+
+startdate=$1 
+stopdate=$2
+name=$3
+
+if [ "$1" = "" ] || [ "$2" = "" ] || [ "$3" = "" ] 
+then
+   echo "input missing"
+   finish
+fi
+
+if [ $startdate -gt $stopdate ]
+then
+   echo "start > stop -> exit" 
+   finish
+fi
+
+if [ "$4" = "x" ]
+then 
+   printprocesslog "setting ( ) for "$name" from "$startdate" to "$stopdate
+fi
+
+
+
+for (( i=0; i < 1000 ; i++))
+do 
+   date=`date --date="${startdate} ${i}days" +%Y%m%d`
+   if [ $date -gt $stopdate ]
+   then
+      break
+   fi
+   y=`echo $date | cut -c 1-4`
+   m=`echo $date | cut -c 5-6`
+   d=`echo $date | cut -c 7-8`
+
+   if [ "$4" = "x" ]
+   then 
+      query="UPDATE ToOcalendar.Data SET x=1 WHERE y="$y" AND m="$m"-1 AND d="$d" AND u='"$name"'"
+      printprocesslog "INFO update x for "$date" and "$name
+   else
+      query="INSERT ToOcalendar.Data SET y="$y", m="$m"-1, d="$d", u='"$name"'"
+      printprocesslog "INFO insert for "$date" and "$name
+   fi
+   sendquery >> /dev/null
+   #echo $query
+done
+
+finish
+