Index: /trunk/MagicSoft/Mars/Changelog
===================================================================
--- /trunk/MagicSoft/Mars/Changelog	(revision 7399)
+++ /trunk/MagicSoft/Mars/Changelog	(revision 7400)
@@ -18,4 +18,10 @@
 
                                                  -*-*- END OF LINE -*-*-
+ 2005/11/14 Daniela Dorner
+
+   * datacenter/macros/insertsequence.C:
+     - added possibility to set source name in sequence file
+
+
 
  2005/11/14 Thomas Bretz
Index: /trunk/MagicSoft/Mars/datacenter/macros/insertsequence.C
===================================================================
--- /trunk/MagicSoft/Mars/datacenter/macros/insertsequence.C	(revision 7399)
+++ /trunk/MagicSoft/Mars/datacenter/macros/insertsequence.C	(revision 7400)
@@ -84,5 +84,5 @@
     if (dummy)
     {
-        cout << query << endl;
+        cout << "Q:" << query << endl;
         return 0;
     }
@@ -90,5 +90,8 @@
     res=serv.Query(query);
     if (!res)
+    {
+        cout << "Error in query " << query << endl;
         return -1;
+    }
 
     delete res;
@@ -122,7 +125,6 @@
     cout << endl;
 
-    TString sequnum=filename;
-    sequnum=sequnum.Remove(0,30);
-    sequnum=sequnum.Remove(8);
+    TString sequnum;
+    sequnum=sequ.GetValue("Sequence", "");
     Int_t seq=atoi(sequnum.Data());
 
@@ -135,4 +137,7 @@
         return 0;
     }
+
+    TString sourcename = sequ.GetValue("Source", "");
+    Int_t sourcekey = QueryNameKEY(serv, dummy, "Source", sourcename.Data());
 
     TString query="SELECT max(fRunNumber), min(fRunStart), ";
@@ -143,5 +148,5 @@
 
     cout << "runs: " << runs << endl;
-    cout << "q: " << query << endl;
+    cout << "q1: " << query << endl;
 
     TSQLResult *res = serv.Query(query);
@@ -166,5 +171,5 @@
     query +=Form("fL2TriggerTableKEY FROM RunData WHERE fRunNumber=%d", seq);
 
-    cout << "q: " << query << endl;
+    cout << "q2: " << query << endl;
 
     res = serv.Query(query);
@@ -185,23 +190,31 @@
     delete res;
 
-    cout << "seq: "       << seq       << endl;
-    cout << " lastrun   " << lastrun   << endl;
-    cout << " startime  " << starttime << endl;
-    cout << " uptime    " << uptime    << endl;
-    cout << " zdmin     " << zdmin     << endl;
-    cout << " zdmax     " << zdmax     << endl;
-    cout << " azmin     " << azmin     << endl;
-    cout << " azmax     " << azmax     << endl;
-    cout << " numevts   " << numevts   << endl;
-    cout << " keys:"                   <<  endl;
-    cout << " project   " << project   << endl;
-    cout << " source    " << source    << endl;
-    cout << " hv        " << hv        << endl;
-    cout << " delay     " << delay     << endl;
-    cout << " dt        " << dt        << endl;
-    cout << " testflag  " << testflag  << endl;
-    cout << " lightcond " << lightcond << endl;
-    cout << " l1tt      " << l1tt      << endl;
-    cout << " l2tt      " << l2tt      << endl;
+    cout << "seq: "       << seq        << endl;
+    cout << "  lastrun   " << lastrun   << endl;
+    cout << "  startime  " << starttime << endl;
+    cout << "  uptime    " << uptime    << endl;
+    cout << "  zdmin     " << zdmin     << endl;
+    cout << "  zdmax     " << zdmax     << endl;
+    cout << "  azmin     " << azmin     << endl;
+    cout << "  azmax     " << azmax     << endl;
+    cout << "  numevts   " << numevts   << endl;
+    cout << " keys:"                    <<  endl;
+    cout << "  project   " << project   << endl;
+    cout << "  source1   " << source    << " (from db -> run "  << seq << ") " << endl;
+    cout << "  source2   " << sourcekey << " (from sequ file) " << endl;
+    if (!(atoi(source.Data())==sourcekey))
+    {
+        cout << "new source name: " << sourcename << " -> inserting..." << endl;
+        sourcekey = QueryNameKEY(serv, dummy, "Source", sourcename.Data(), kFALSE);
+        source=Form("%d",sourcekey);
+    }
+    cout << "  source    " << source    << endl;
+    cout << "  hv        " << hv        << endl;
+    cout << "  delay     " << delay     << endl;
+    cout << "  dt        " << dt        << endl;
+    cout << "  testflag  " << testflag  << endl;
+    cout << "  lightcond " << lightcond << endl;
+    cout << "  l1tt      " << l1tt      << endl;
+    cout << "  l2tt      " << l2tt      << endl;
 
     TString query1="INSERT Sequences SET fManuallyChangedKEY=2, ";