• Main INDEX
  • Monthly INDEX
  • PREV
  • NEXT

    User name X. Zheng

    Log entry time 15:31:04 on March20,2006

    Entry number 167605

    This entry is a followup to: 167578

    keyword=Compton logbook entries 13093-13128

    I have updated the database for runs 13093-13128 using a reference run 13092. I have also started offline analysis for these runs. On the Compton logbook they are commented as "EPICS variables recovered using ref run 13092".

    Several variables were lost. In the recovered log entries, the run stop time is either the one that is not lost, or is guessed from the time when the raw data file was saved. The run start time is guessed from the stop time of the previous run. All other variables are identical to run 13092, including the HWP status...


    For example, the MYSQL commands for run 13119 are the following:

    delete from General_informations where id_run = '13119';
    delete from Acquisition where id_run = '13119';
    delete from Electron_beam where id_run = '13119';
    delete from Electron_detector where id_run = '13119';
    delete from Photon_beam where id_run = '13119';
    delete from Photon_detector where id_run = '13119';
    delete from Comments where id_run = '13119';


    insert into Electron_beam values ('13119','501071 ','121.907 ','121.881 ','0 ','0 ','-7500 ','2900 ','8.01694e-06 ','8.01694e-06 ','-0.03830
    19 ','6.75618e-12 ','1.11844 ','1.67033 ','2.02686 ','1.70208 ','-0.767466 ','-0.474214 ','-0.729472 ','-0.665438 ','-1.33977 ','-0.327948 '
    ,'0 ','7.48582e+06 ','0 ','0 ','0 ','0 ') ;
    insert into Electron_detector values ('13119','BEAM ','2','1','0.0653116 ','4.49551 ','OFF ','0 ','ON ','80 ','60 ','60 ','60 ','60 ') ;
    insert into Photon_beam values ('13119','ON','21','20.3389 ','1 ','0.0219573 ','0.000710523 ','0.00111058 ','8.274E-07 ','206.231 ','514.286
    ','187.096 ','-674.597 ','-67.9065 ','-1.06818 ','-0.670207 ') ;
    insert into General_informations values ('13119','',' ','5','2','2006/03/19','07:57?','','2645.98 ','6.71587 ','OUT','76.4291 ') ;
    insert into Photon_detector values ('13119','7.5 ','7.8 ','7.8 ','7 ','6.3 ','5.6 ','7.3 ','6.5 ','6.5 ','5.7 ','6.4 ','5.9 ','1523 ','2.5 '
    ,'7.7 ','5.6 ','5.9 ','5.9 ','7.5 ','5.9 ','7.2 ','6.3 ','6.5 ','6 ','7 ','7 ','7.9 ','0','(2*CONV("100000000000010000000000000100",2,10))',
    '28.7951 ','28.8683 ','28.7524 ','28.8622 ','28.85 ','28.8012 ','27.1837 ','27.1837 ','29.3078 ','29.7168 ','29.8266 ','24.6139 ') ;

    insert into Comments values ('13119','EPICS variables recovered using ref run 13092',' ') ;