[Halld-tracking-hw] bad fadc channels

[David Lawrence]

Hi Naomi,

  I don’t think there is an easy way so I’ll just summarize the hard way via example:

% svn cat https://halldsvn.jlab.org/repos/trunk/controls/epics/app/hvCaenApp/src/tt.db > tt.db
% sqlite3 tt.db

SQLite version 3.7.13 2012-07-17 17:46:21
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> SELECT ring,straw FROM Crate,Module,Channel,CDC WHERE
   ...> Crate.crateid=Module.crateid
   ...> AND Module.moduleid=Channel.Moduleid
   ...> AND Channel.chanid=CDC.adc_chanid
   ...> AND rocid=26 AND slot=3 AND channel=12;
4|49
sqlite>.q
%

In the line “4|49”, the first number printed (4) is the ring and the second (49) is the straw. Change the
values in the last line to select another rocid, slot, channel.

Regards,
-Dave

On Dec 3, 2014, at 2:18 PM, Naomi Jarvis <nsj at cmu.edu> wrote:

> 
> Hi, 
> 
> We have a few CDC fadc modules that have bits missing (unless someone already got to these?) - they are in roc 26 slot 3, roc 27, slot 16 and roc 28 slot 15 for run 1286.    I'll bet the FDC has more.  :-)
> 
> See https://halldweb1.jlab.org/wiki/index.php/CDC_bad_channels
> 
> Can anyone tell me if there's an easy way to translate roc, slot, channel to ring and straw, please?    Like the visual browser in reverse.
> 
> Thanks
> 
> Naomi.
> _______________________________________________
> Halld-tracking-hw mailing list
> Halld-tracking-hw at jlab.org
> https://mailman.jlab.org/mailman/listinfo/halld-tracking-hw

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mailman.jlab.org/pipermail/halld-tracking-hw/attachments/20141203/940cc807/attachment.html