From the mysql console, the ti_time_offsets table can be updated using syntax similar to the following:

Updating Ti Time Offset
load data local infile '/path/ti_time_offsets.csv' into table ti_time_offsets fields terminated by ',' (run, ti_time_offset);

The input file should be CSV format with two columns.  The first column should have the run number and the second the trigger time offset value.

For calibration runs, the offset can be set to 0.

  • No labels