[Halld] Updated Translation Table

[David Lawrence]

Hi Richard,

  Documentation is scarce. The SQLite file itself is maintained in the subversion repository along with all of the
related software here:

https://halldsvn.jlab.org/repos/trunk/online/packages/TranslationTable/


You may want to look at the hd_tt_tool.py script and the halld_tt.py python module it uses. The script that
converts from SQLite DB to tt.xml is  tt_db2xml.py.


There is a wiki page that needs some updating but gives you some introduction here:

https://halldweb.jlab.org/wiki/index.php/Translation_Table

Regards,
-David

-------------------------------------------------------------
David Lawrence Ph.D.
Staff Scientist, Thomas Jefferson National Accelerator Facility
Newport News, VA
davidl at jlab.org
(757) 269-5567 W
(757) 746-6697 C


On Jan 4, 2019, at 2:12 PM, Richard Jones <rjones30 at gmail.com> wrote:

Hello David,

What is this thing you call "the SQLite DB"? I know of a SQLite export of the CCDB, and I have heard of a SQLite export of RCDB that might be possible. Is this a third SQLite DB?

It sounds like you are describing a re-formatting of the TT xml file contents as a relational database table, and then exporting this table to SQLite? I have never heard of or worked with this relDB rendering of the TT document. As someone who updates the TT record in ccdb from time to time, it sounds like I need to know what you are talking about here. The xml document is the only thing I have ever worked with. Is there a HOWTO on this?

-Richard Jones

On Fri, Jan 4, 2019 at 1:52 PM David Lawrence <davidl at jlab.org<mailto:davidl at jlab.org>> wrote:
Hi All,

  This is a head’s up that I just added a new translation table entry to the CCDB that includes
all of the DIRC channels as provided by Justin. This is significant for a couple of reasons.
One of them being that the DIRC increases the channel count from ~23k to ~37k.

The other is that the procedure used to produce the XML file is somewhat new. It was generated
from the SQLite DB file that has been updated to include run range information. The DB file
was first updated by mining data from the CCDB, then the DIRC channels were added, then
the XML file was generated and inserted into the CCDB. Note that ALL future changes to the TT
should be done in the SQLite DB first and the XML then generated from that. Please contact me
if you need help with this.

Both Justin and I have done some testing and it seems the new TT does not break anything.
It is marked as valid only for runs >=60000 in the CCDB so people generally will not be
affected by it until they start processing files from the upcoming RunPeriod-2019-01 data set.

Thanks to Justin for doing a lot of the heavy lifting on getting all of the DIRC channels into the tt.db


Regards,
-David

-------------------------------------------------------------
David Lawrence Ph.D.
Staff Scientist, Thomas Jefferson National Accelerator Facility
Newport News, VA
davidl at jlab.org<mailto:davidl at jlab.org>
(757) 269-5567 W
(757) 746-6697 C



_______________________________________________
Halld mailing list
Halld at jlab.org<mailto:Halld at jlab.org>
https://urldefense.proofpoint.com/v2/url?u=https-3A__na01.safelinks.protection.outlook.com_-3Furl-3Dhttps-253A-252F-252Fmailman.jlab.org-252Fmailman-252Flistinfo-252Fhalld-26amp-3Bdata-3D02-257C01-257Crichard.t.jones-2540uconn.edu-257Cac29ab0e983643a6c7fc08d67275c837-257C17f1a87e2a254eaab9df9d439034b080-257C0-257C0-257C636822247531818362-26amp-3Bsdata-3DR2SZNOYc9Ab0VhYvZm-252Bs-252Flpt9AIFkNElJE2YbRVI33w-253D-26amp-3Breserved-3D0&d=DwIGaQ&c=lz9TcOasaINaaC3U7FbMev2lsutwpI4--09aP8Lu18s&r=Mwj7jqW_Gg8VvugDHdwA5w&m=AMHaHVpNK9AMqCwwEEzS0dRZA3qxPkCPf2QX9FLJVug&s=TDN5i17J-7AiTpQKjSMfOx983ZnF2dC7legVu2wi0NA&e= <https://urldefense.proofpoint.com/v2/url?u=https-3A__na01.safelinks.protection.outlook.com_-3Furl-3Dhttps-253A-252F-252Fmailman.jlab.org-252Fmailman-252Flistinfo-252Fhalld-26amp-3Bdata-3D02-257C01-257Crichard.t.jones-2540uconn.edu-257Cac29ab0e983643a6c7fc08d67275c837-257C17f1a87e2a254eaab9df9d439034b080-257C0-257C0-257C636822247531818362-26amp-3Bsdata-3DR2SZNOYc9Ab0VhYvZm-252Bs-252Flpt9AIFkNElJE2YbRVI33w-253D-26amp-3Breserved-3D0&d=DwMFaQ&c=lz9TcOasaINaaC3U7FbMev2lsutwpI4--09aP8Lu18s&r=DSufUSddsl3c0GGnbiwkxA&m=my-Vz4fNIQy_JwevEcaz1nSaYFPcDWkKnu7bF7hpNAg&s=y7zvz_eOunfB4eROu7kAkPws_D5qDm2rlLo0CzM85oo&e=>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/halld/attachments/20190104/21ed9070/attachment-0001.html>