Convert the photogrammetry data to module conditions ---------------------------------------------------- Get the photogrammetry data from the https://edms.cern.ch/document/856161 https://edms.cern.ch/document/857679 Then the nominal positions are added to these files and the difference is calculated at the position of the pins: TT_A_Balconies_new.xls TT_C_Balconies_new.xls These two files are then converted to a text file with the offsets of the pins: photogrammetry.txt And finally this is then converted to a conditions xml file: python makeModuleConditions.py This creates an xml file with the module conditions (Modules.xml). Mapping from production database to conditions database ------------------------------------------------------- Get the TTmapping.xsl from http://www.physik.uzh.ch/~olafs/TTmapping/ Copy and paste the last spreadsheet to a txt file and call it TTmapping.xml Get the metrology data from the production database --------------------------------------------------- Copy and paste the metrology data from Zurich to alignment_ProdDB.xml: http://lhcb.physik.uzh.ch/tt/database/make_xml/survey_to_xml.php (user=ST-prod passwd=db4all) Convert the module ID from production database to conditions database --------------------------------------------------------------------- Convert the names in the production dbase to the names in the conditions dbase. python prodDBCnv.py alignment_ProdDB.xml Sensors.xml TTmapping.xml