<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div><br></div><div>Hi Naomi,</div><div><br></div><div> I don’t think there is an easy way so I’ll just summarize the hard way via example:</div><div><br></div><div><span style="font-family: Monaco; font-size: 10px;">% svn cat <a href="https://halldsvn.jlab.org/repos/trunk/controls/epics/app/hvCaenApp/src/tt.db">https://halldsvn.jlab.org/repos/trunk/controls/epics/app/hvCaenApp/src/tt.db</a> > tt.db</span></div><div><span style="font-family: Monaco; font-size: 10px;">% sqlite3 tt.db</span></div><div style="margin: 0px; font-size: 10px; font-family: Monaco;"><div style="margin: 0px;"><br></div><div style="margin: 0px;">SQLite version 3.7.13 2012-07-17 17:46:21</div><div style="margin: 0px;">Enter ".help" for instructions</div><div style="margin: 0px;">Enter SQL statements terminated with a ";"</div></div><div><div style="margin: 0px; font-size: 10px; font-family: Monaco;">sqlite> SELECT ring,straw FROM Crate,Module,Channel,CDC WHERE</div><div style="margin: 0px; font-size: 10px; font-family: Monaco;"> ...> Crate.crateid=Module.crateid</div><div style="margin: 0px; font-size: 10px; font-family: Monaco;"> ...> AND Module.moduleid=Channel.Moduleid</div><div style="margin: 0px; font-size: 10px; font-family: Monaco;"> ...> AND Channel.chanid=CDC.adc_chanid</div><div style="margin: 0px; font-size: 10px; font-family: Monaco;"> ...> AND rocid=26 AND slot=3 AND channel=12;</div><div style="margin: 0px; font-size: 10px; font-family: Monaco;">4|49</div><div style="margin: 0px; font-size: 10px; font-family: Monaco;">sqlite>.q</div></div><div style="margin: 0px; font-size: 10px; font-family: Monaco;">%</div><div><br></div><div>In the line “4|49”, the first number printed (4) is the ring and the second (49) is the straw. Change the</div><div>values in the last line to select another rocid, slot, channel.</div><div><br></div><div>Regards,</div><div>-Dave</div><br><div><div>On Dec 3, 2014, at 2:18 PM, Naomi Jarvis <<a href="mailto:nsj@cmu.edu">nsj@cmu.edu</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div apple-content-edited="true"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; border-spacing: 0px; font-size: inherit;"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; border-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-stroke-width: 0px; font-size: inherit;"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; border-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-stroke-width: 0px; font-size: inherit;"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br></div></span></div></span></span></div><div>Hi, </div><div><br></div><div>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. :-)</div><div><br></div><div>See <a href="https://halldweb1.jlab.org/wiki/index.php/CDC_bad_channels">https://halldweb1.jlab.org/wiki/index.php/CDC_bad_channels</a></div><div><br></div><div>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.</div><div><br></div><div>Thanks</div><div><br></div><div>Naomi.</div></div>_______________________________________________<br>Halld-tracking-hw mailing list<br><a href="mailto:Halld-tracking-hw@jlab.org">Halld-tracking-hw@jlab.org</a><br>https://mailman.jlab.org/mailman/listinfo/halld-tracking-hw</blockquote></div><br></body></html>