Changeset 18064

Timestamp:

01/04/15 04:53:27 (10 years ago)

Author:

Daniela Dorner

Message:

added new years

File:

• trunk/DataCheck/DataCheck/InfoForMWL.sh (modified) (4 diffs)

trunk/DataCheck/DataCheck/InfoForMWL.sh

@@ -25 +25 @@
    #query=$query" CONCAT('#') as Comments"
    #query=$query" CONCAT('# ', Timediff(Max(fRunStop), Min(fRunStart)), ' ontime: ', Convert(Sum(Time_to_sec(Timediff(fRunStop, fRunStart)))/60./60., decimal(2,1))) AS Comments"
-   query=$query" CONCAT('# ontime: ', Convert(Sum(fOntime)/3600, decimal(2,1)), 'h') AS Comments"
+   query=$query" IF (ISNULL(Sum(fOnTime)), CONCAT('#'), CONCAT('# ontime: ', Convert(Sum(fOntime)/3600, decimal(2,1)), 'h')) AS Comments"
    query=$query" FROM RunInfo "
    query=$query" WHERE fSourceKEY="$sourcekey
@@ -39 +39 @@
 }
 
+##mrk501
+#sourcekey=2
+#file="Mrk501_FACT_observations_2014.txt"
+#start=20140101 
+#stop=20141030
+#get_table
+#exit
 
 #mrk421
@@ -58 +65 @@
 get_table
 
+file="Mrk421_FACT_observations_2013_2014.txt"
+start=20131001
+stop=20140930
+get_table
+
+file="Mrk421_FACT_observations_2014_2015.txt"
+start=20141001
+stop=20150930
+get_table
+
 
 #mrk501
@@ -67 +84 @@
 get_table
 
-file="Mrk501_FACT_observations_2011_2012.txt"
-start=20120501 #really started at 19.5.2012
+file="Mrk501_FACT_observations_2012.txt"
+start=20120501 
 stop=20121030
 get_table
 
-file="Mrk501_FACT_observations_2012_2013.txt"
+file="Mrk501_FACT_observations_2013.txt"
 start=20130101 
 stop=20131030
 get_table
 
+file="Mrk501_FACT_observations_2014.txt"
+start=20140101 
+stop=20141030
+get_table
+
+file="Mrk501_FACT_observations_2015.txt"
+start=20150101 
+stop=20151030
+get_table
+