def xml_from_excel5(excel_file): wb = xlrd.open_workbook(excel_file) sh = wb.sheet_by_index(0) #user = sh.cell(0,1).value user = sys.argv[3] #chamber=sh.cell(10,1).value # chamber=sys.argv[2] # Run=sys.argv[3] location=sys.argv[2] Start=sys.argv[5] Stop=sys.argv[6] Date=str(Start[0:10]) comment=sys.argv[4] Elog=sys.argv[7] File=sys.argv[8] Comment=sys.argv[9] Run = sh.cell(0,1).value root = generateXMLHeader("GEM_VFAT_STRIP_MASKING","GEM VFAT STRIP MASKING", " GEM Chamber",str(Run),str(Start),str(Stop),str(comment),str(location),str(user)) dataSet = generateDataSet(root,Comment,"1","GEM Chamber","") for row in range(2,sh.nrows): sector= sh.row_values(row)[0] depth= sh.row_values(row)[1] position= sh.row_values(row)[2] ch= sh.row_values(row)[3] hot_ch= sh.row_values(row)[4] fit_failed= sh.row_values(row)[5] dead_ch= sh.row_values(row)[6] high_noise= sh.row_values(row)[7] high_eff= sh.row_values(row)[8] generateXMLDataStrips(dataSet,str(sector),str(depth),str(position), str(ch), str(hot_ch),str(fit_failed),str(dead_ch),str(high_noise),str(high_eff)) writeToFile(fileName, tostring(root))
def xml_from_excel2(excel_file): wb = xlrd.open_workbook(excel_file) sh = wb.sheet_by_index(0) tags = [n.replace(" ", "").lower() for n in sh.row_values(0)] Start=str(ObtainDate("Test Start Time(with Date like 2017-01-16):","%Y-%m-%d %H:%M:%S")) #print "Test Start At:" +str(Start) Stop=str(ObtainDate("Test End Time:","%Y-%m-%d %H:%M:%S")) #print "Test Stop At:" +str(Stop) foil=sh.cell(0,1).value Date=sh.cell(1,1).value location=sh.cell(3,1).value #print "Test Done At:"+str(location) comment=raw_input("Make a Comment:") user=sh.cell(6,1).value #print "Test Performed By:"+str(user) humidity = sh.cell(2,1).value Run=db.engine.execute("select nvl(max(run.RUN_NUMBER), 0) + 1 from cms_gem_core_cond.cond_data_sets dat join cms_gem_core_cond.kinds_of_conditions koc on dat.KIND_OF_CONDITION_ID = koc.KIND_OF_CONDITION_ID join CMS_GEM_CORE_CONSTRUCT.PARTS par on par.PART_ID = dat.PART_ID join CMS_GEM_CORE_COND.COND_RUNS run on dat.COND_RUN_ID = run.COND_RUN_ID where koc.IS_RECORD_DELETED = 'F' and par.IS_RECORD_DELETED = 'F' and koc.name = '' and par.SERIAL_NUMBER = '"+foil+"'") Run = [ t for t, in Run ] #print "Number of Time Test Done:" +str(Run) root = generateXMLHeader("FOIL_QC2_FAST_AMB_COND","GEM Foil QC2 Fast Test Ambient Condition","CERN MPT GEM Foil QC2 Fast Test Data",str(Run[0]),Start,Stop,comment,location,user) dataSet = generateDataSet(root,"GEM Foil QC2 Fast Test Data ","1","GEM Foil",foil) generateXMLDatafastamb(dataSet,humidity) writeToFile1(testfile, tostring(root)) root = generateXMLHeader("FOIL_QC2_FAST_TEST","GEM Foil QC2 Fast Test Data","GEM Foil QC2 Fast Test Data",Run[0],Start,Stop,comment,location,user) dataSet = generateDataSet(root,"GEM Foil QC2 Fast Test Data ","1","GEM Foil",foil) for row in range(12,sh.nrows): time=sh.row_values(row)[0] volt=sh.row_values(row)[1] impedence=sh.row_values(row)[2] current=sh.row_values(row)[3] sparks=sh.row_values(row)[4] totalspark=sh.row_values(row)[5] generateXMLDatafast(dataSet,str(times),str(volt),str(impedence),str(current),str(sparks),str(totalsparks)) writeToFile(fileName,tostring(root))
def xml_from_excel5(excel_file): wb = xlrd.open_workbook(excel_file) sh = wb.sheet_by_index(0) #user = sh.cell(0,1).value user = sys.argv[3] #chamber=sh.cell(10,1).value # chamber=sys.argv[2] # Run=sys.argv[3] location = sys.argv[2] Start = sys.argv[5] Stop = sys.argv[6] Date = str(Start[0:10]) comment = sys.argv[4] #Elog=sys.argv[7] #File=sys.argv[8] #Comment=sys.argv[9] Run = sh.cell(0, 1).value root = generateXMLHeader("QC8_GEM_STAND_GEOMETRY_CONF", "GEM STAND GEOMETRY CONFIGURATION QC8", "GEOMETRY STAND CONFIGURATION", str(Run), str(Start), str(Stop), str(comment), str(location), str(user)) dataSet = generateDataSetMultipleParts(root, comment, "1") for row in range(2, sh.nrows): ch_serial = sh.row_values(row)[0] position = sh.row_values(row)[1] flowmeter = sh.row_values(row)[2] generateXMLDataStandGeoConf(dataSet, str(ch_serial), str(position), str(flowmeter)) writeToFile(fileName, tostring(root))
def xml_from_excel3(excel_file): wb = xlrd.open_workbook(excel_file) sh = wb.sheet_by_index(0) user = '' location = '' Start = sh.cell(2, 1).value Stop = str(sh.cell(3, 1).value) comment = '' chamber = sh.cell(1, 1).value Run = sh.cell(0, 1).value root = generateXMLHeader("QC8_GEM_CH_VFAT_EFFICIENCY", "GEM CH VFAT EFFICIENCY QC8", "GEM CH VFAT EFFICIENCY", str(Run), str(Start), str(Stop), str(comment), str(location), str(user)) dataSet = generateDataSet(root, comment, "1", "GEM Chamber", str(chamber)) for row in range(5, sh.nrows): vfat_posn = sh.row_values(row)[0] efficiency = sh.row_values(row)[1] efficiency_error = sh.row_values(row)[2] cluster_size_avg = sh.row_values(row)[3] cluster_size_sigma = sh.row_values(row)[4] percent_masked = sh.row_values(row)[5] generateXMLDataChVfatEfficiency(dataSet, str(vfat_posn), str(efficiency), str(efficiency_error), str(cluster_size_avg), str(cluster_size_sigma), str(percent_masked)) print(str(row - 4) + " / " + str(sh.nrows - 5)) fileName = fname[:-5] + "_Run_" + str(Run) + ".xml" writeToFile(fileName, tostring(root))
def xml_from_csv(csv_file): lines = readFile(csv_file) for i in range(len(lines)): lines[i] = lines[i].split('\n')[0] Run = int(lines[0].split(',')[1]) Start = '2020-03-14 12:00:00' Stop = '2020-03-14 12:00:00' comment = '' location = '' user = '' root = generateXMLHeader("QC8_GEM_MASKED_STRIPS_HOT", "GEM QC8 MASKED STRIPS HOT", "GEM HOT STRIPS QC8", str(Run), str(Start), str(Stop), str(comment), str(location), str(user)) dataSet = generateDataSetMultipleParts(root, comment, "1") for line in range(2, len(lines)): ch_serial_number = str(lines[line].split(',')[0]) gem_number = str(lines[line].split(',')[1]) position = str(lines[line].split(',')[2]) vfat = int(lines[line].split(',')[3]) channel = int(lines[line].split(',')[4]) strip = int(lines[line].split(',')[5]) generateXMLDataQC8DeadStrips(dataSet, str(ch_serial_number), str(gem_number), str(position), str(vfat), str(channel), str(strip)) print(str(line - 1) + " / " + str(len(lines) - 2)) fileName = csv_file[:-4] + ".xml" writeToFile(fileName, tostring(root))
def xml_from_excel5(excel_file): wb = xlrd.open_workbook(excel_file) sh = wb.sheet_by_index(0) #user = sh.cell(0,1).value user = sys.argv[3] #chamber=sh.cell(10,1).value # chamber=sys.argv[2] # Run=sys.argv[3] location = sys.argv[2] Start = sys.argv[5] Stop = sys.argv[6] Date = str(Start[0:10]) comment = sys.argv[4] #Elog=sys.argv[7] #File=sys.argv[8] #Comment=sys.argv[9] Run = sh.cell(0, 1).value root = generateXMLHeader("QC8_GEM_ALIGNMENT", "GEM ALIGNMENT QC8", "GEM ALIGNMENT", str(Run), str(Start), str(Stop), str(comment), str(location), str(user)) dataSet = generateDataSetMultipleParts(root, comment, "1") for row in range(2, sh.nrows): position = sh.row_values(row)[0] dx = sh.row_values(row)[1] dy = sh.row_values(row)[2] dz = sh.row_values(row)[3] rx = sh.row_values(row)[4] ry = sh.row_values(row)[5] rz = sh.row_values(row)[6] generateXMLDataAlignment(dataSet, str(position), str(dx), str(dy), str(dz), str(rx), str(ry), str(rz)) writeToFile(fileName, tostring(root))
def xml_from_excel3(excel_file): wb = xlrd.open_workbook(excel_file) sh = wb.sheet_by_index(0) #user = sh.cell(0,1).value user = sys.argv[3] #chamber=sh.cell(10,1).value # chamber=sys.argv[2] # Run=sys.argv[3] location = sys.argv[2] Start = sys.argv[5] Stop = sys.argv[6] Date = str(Start[0:10]) comment = sys.argv[4] chamber = sys.argv[7] #Elog=sys.argv[7] #File=sys.argv[8] #Comment=sys.argv[9] Run = sh.cell(0, 1).value root = generateXMLHeader("QC8_GEM_CH_VFAT_EFFICIENCY", "GEM CH VFAT EFFICIENCY QC8", "GEM CH VFAT EFFICIENCY", str(Run), str(Start), str(Stop), str(comment), str(location), str(user)) dataSet = generateDataSet(root, comment, "1", "GEM Chamber", chamber) for row in range(3, sh.nrows): vfat_posn = sh.row_values(row)[0] efficiency = sh.row_values(row)[1] efficiency_error = sh.row_values(row)[2] generateXMLDataChVfatEfficiency(dataSet, str(vfat_posn), str(efficiency), str(efficiency_error)) writeToFile(fileName, tostring(root))
def xml_from_excel5(excel_file): wb = xlrd.open_workbook(excel_file) sh = wb.sheet_by_index(0) user = '' location = '' Start = '' Stop = '' comment = '' Run = sh.cell(0, 1).value root = generateXMLHeader("QC8_GEM_MASKED_STRIPS_DEAD", "GEM QC8 MASKED STRIPS DEAD", "GEM DEAD STRIPS QC8", str(Run), str(Start), str(Stop), str(comment), str(location), str(user)) dataSet = generateDataSetMultipleParts(root, comment, "1") for row in range(2, sh.nrows): ch_serial_number = sh.row_values(row)[0] gem_number = sh.row_values(row)[1] position = sh.row_values(row)[2] vfat = sh.row_values(row)[3] channel = sh.row_values(row)[4] strip = sh.row_values(row)[5] generateXMLDataQC8DeadStrips(dataSet, str(ch_serial_number), str(gem_number), str(position), str(vfat), str(channel), str(strip)) print(str(row - 1) + " / " + str(sh.nrows - 2)) writeToFile(fileName, tostring(root))
def xml_from_excel5(excel_file): wb = xlrd.open_workbook(excel_file) sh = wb.sheet_by_index(0) #user = sh.cell(0,1).value user = sys.argv[3] #chamber=sh.cell(10,1).value # chamber=sys.argv[2] # Run=sys.argv[3] location=sys.argv[2] Start=sys.argv[5] Stop=sys.argv[6] Date=str(Start[0:10]) comment=sys.argv[4] #Elog=sys.argv[7] #File=sys.argv[8] #Comment=sys.argv[9] Run = sh.cell(0,1).value root = generateXMLHeader("QC8_GEM_MASKED_STRIPS_HOT","GEM QC8 MASKED STRIPS HOT", "GEM HOT STRIPS QC8",str(Run),str(Start),str(Stop),str(comment),str(location),str(user)) dataSet = generateDataSetMultipleParts(root,comment,"1") for row in range(2,sh.nrows): ch_serial_number= sh.row_values(row)[0] gem_number= sh.row_values(row)[1] position= sh.row_values(row)[2] vfat= sh.row_values(row)[3] channel= sh.row_values(row)[4] strip= sh.row_values(row)[5] generateXMLDataQC8DeadStrips(dataSet,str(ch_serial_number),str(gem_number),str(position), str(vfat), str(channel),str(strip)) writeToFile(fileName,tostring(root))
def xml_from_csv(csv_file): lines = readFile(csv_file) for i in range(len(lines)): lines[i] = lines[i].split('\n')[0] Run = int(lines[0].split(',')[1]) Start = '2020-03-14 12:00:00' Stop = '2020-03-14 12:00:00' comment = '' location = '' user = '' root = generateXMLHeader("QC8_GEM_ALIGNMENT", "GEM ALIGNMENT QC8", "GEM ALIGNMENT", str(Run), str(Start), str(Stop), str(comment), str(location), str(user)) dataSet = generateDataSetMultipleParts(root, comment, "1") for line in range(2, len(lines)): position = str(lines[line].split(',')[0]) dx = float(lines[line].split(',')[1]) dy = float(lines[line].split(',')[2]) dz = float(lines[line].split(',')[3]) rx = float(lines[line].split(',')[4]) ry = float(lines[line].split(',')[5]) rz = float(lines[line].split(',')[6]) generateXMLDataAlignment(dataSet, str(position), str(dx), str(dy), str(dz), str(rx), str(ry), str(rz)) print(str(line - 1) + " / " + str(len(lines) - 2)) fileName = csv_file[:-4] + ".xml" writeToFile(fileName, tostring(root))
def xml_from_excel2(excel_file): wb = xlrd.open_workbook(excel_file) sh = wb.sheet_by_index(0) tags = [n.replace(" ", "").lower() for n in sh.row_values(0)] Start=sys.argv[6] Stop=sys.argv[7] #foil=sh.cell(0,1).value foil=sys.argv[9] Date=sh.cell(1,1).value #location=sh.cell(3,1).value location=sys.argv[3] #comment=raw_input("Make a Comment:") comment=sys.argv[5] Comment=sys.argv[8] #user=sh.cell(6,1).value user=sys.argv[4] Run=sys.argv[2] humidity = sh.cell(2,1).value root = generateXMLHeader("FOIL_QC2_FAST_AMB_COND","GEM Foil QC2 Fast Test Condition","CERN MPT GEM Foil QC2 Fast Test Data",Run,Start,Stop,comment,location,user) dataSet = generateDataSet(root,Comment,"1","GEM Foil",foil) generateXMLDatafastamb(dataSet,humidity) writeToFile1(testfile, tostring(root)) root = generateXMLHeader("FOIL_QC2_FAST_TEST","GEM Foil QC2 Fast Test Data","GEM Foil QC2 Fast Test Data",Run,Start,Stop,comment,location,user) dataSet = generateDataSet(root,Comment,"1","GEM Foil",foil) for row in range(12,sh.nrows): time=sh.row_values(row)[0] volt=sh.row_values(row)[1] impedence=sh.row_values(row)[2] current=sh.row_values(row)[3] sparks=sh.row_values(row)[4] totalspark=sh.row_values(row)[5] generateXMLDatafast(dataSet,str(time),str(volt),str(impedence),str(current),str(sparks),str(totalspark)) writeToFile(fileName,tostring(root))
def xml_from_excel5(excel_file): wb = xlrd.open_workbook(excel_file) sh = wb.sheet_by_index(0) user = sh.cell(0,1).value chamber=sh.cell(10,1).value pre = raw_input("Please Enter Preamplifier Name:") amp = sh.cell(3,1).value coa = sh.cell(4,1).value fine = sh.cell(5,1).value itime = sh.cell(6,1).value dtime = sh.cell(7,1).value disc = sh.cell(26,1).value thrs = sh.cell(27,1).value walk = sh.cell(28,1).value width = sh.cell(29,1).value scal = sh.cell(39,1).value daq = sh.cell(40,1).value pico = sh.cell(32,1).value tred = sh.cell(33,1).value tblack = sh.cell(34,1).value tgreen = sh.cell(35,1).value source = sh.cell(43,1).value hvlt = sh.cell(44,1).value current = sh.cell(45,1).value nbpri = "346" eta = sh.cell(11,1).value gas = sh.cell(12,1).value gfac = sh.cell(13,1).value flow = sh.cell(14,1).value req = sh.cell(15,1).value divi = sh.cell(16,1).value root = generateXMLHeader("QC5_GAIN_STBLTY_CONFIG","GEM Chamber QC5 Gain Stability","CERN Station A GEM Chamber QC5 Gain Stability",Run,Start,Stop,comment,location,user) dataSet = generateDataSet(root,"GEM Chamber QC5 Gain Stability Config","1","GEM Chamber",chamber) generateXMLData5a(dataSet,str(user),pre,str(amp),str(coa), str(fine), str(itime),str(dtime),str(disc),str(thrs),str(walk),str(width),str(scal),str(daq),str(pico),str(tred),str(tblack),str(tgreen),str(source),str(hvlt),str(current),str(nbpri),str(eta),str(gas),str(gfac),str(flow),str(req),str(divi)) writeToFile(fileName, tostring(root)) root = generateXMLHeader("QC5_GAIN_STBLTY_DATA","GEM Chamber QC5 Gain Stability Data","CERN Station A GEM Chamber QC5 Gain Stability",Run,Start,Stop,comment,location,user) dataSet = generateDataSet(root,"GEM Chamber QC5 Gain Stability Data","1","GEM Chamber",chamber) for row in range(6,sh.nrows): if row ==33: break test_time=str(Start[0:10]) humidity=raw_input("Please write Humidity Value:") vmon= sh.row_values(row)[5] imon= sh.row_values(row)[6] time= sh.row_values(row)[21] pressure= sh.row_values(row)[22] temp= sh.row_values(row)[23] s_count= sh.row_values(row)[24] s_error= sh.row_values(row)[25] off_count= sh.row_values(row)[26] off_error= sh.row_values(row)[27] s_current= sh.row_values(row)[28] s_current_error= sh.row_values(row)[29] off_current= sh.row_values(row)[30] off_current_error= sh.row_values(row)[31] generateXMLData5(dataSet,str(test_time),str(temp),str(pressure),str(humidity), str(imon), str(vmon),str(s_count),str(s_error),str(off_count),str(off_error),str(s_current),str(s_current_error),str(off_current)) writeToFile(datafile, tostring(root))
def xml_from_excel3(excel_file): wb = xlrd.open_workbook(excel_file) sh = wb.sheet_by_index(0) #tags = [n.replace(" ", "").lower() for n in sh.row_values(0)] #Start=sys.argv[6]+ " " + sys.argv[7] #Stop=sys.argv[8]+ " " + sys.argv[9] Start=sys.argv[6] Stop=sys.argv[7] #chamber=sh.cell(2,7).value chamber=sys.argv[11] Date=str(Start[0:10]) location = sys.argv[3] user=sys.argv[4] comment = sys.argv[5] Comments=sys.argv[10] Run =sys.argv[2] root = generateXMLHeader("QC3_GAS_LEAK_DATA","GEM Chamber QC3 Gas Leak Data",str(location) + " GEM QC3 Gas Leak Data",Run,Start,Stop,comment,location,user) dataSet = generateDataSet(root,Comments,"1","GEM Chamber",chamber) for row in range(1,sh.nrows): seconds= sh.row_values(row)[1] pre= sh.row_values(row)[2] temp =sh.row_values(row)[3] ambp= sh.row_values(row)[4] increment_hr= sh.row_values(row)[5] temp_k = sh.row_values(row)[6] times = xlrd.xldate_as_tuple(sh.row_values(row)[0], wb.datemode) times=str(times).replace(",",":") times = str(times).replace(")","") times = str(times).replace("("," ") generateXMLData3(dataSet,Date +str(times[9:]),str(seconds),str(pre), str(ambp), str(temp), str(increment_hr), str(temp_k)) writeToFile(fileName, tostring(root)) #test_date=sh.cell(0,7).value test_date=Start avgtemp=sh.cell(32,10).value stdtemp=sh.cell(32,11).value avgpre=sh.cell(33,10).value stdpre=sh.cell(33,11).value initpre = sh.cell(34,10).value finalpre = sh.cell(35,10).value duration = sh.cell(36,10).value leakrate = sh.cell(37,10).value expofitp0=sh.cell(38,10).value expofitp1=sh.cell(39,10).value time_constant=sh.cell(40,10).value elog=sys.argv[8] File=sys.argv[9] #Comments=sys.argv[10] root = generateXMLHeader("QC3_GAS_LEAK_DATA_SUMRY","GEM Chamber QC3 Gas Leak Data Summary",str(location) + " GEM QC3 Gas Leak Data",Run,Start,Stop,comment, location,user) dataSet = generateDataSet(root,Comments,"1","GEM Chamber",chamber) generateXMLData3a(dataSet, str(test_date) ,str(avgtemp),str(stdtemp),str(avgpre),str(stdpre),str(initpre),str(finalpre),str(duration),str(leakrate),str(expofitp0),str(expofitp1),str(elog),str(File),str(Comments),str(time_constant)) writeToFile1(testfile, tostring(root))
def xml_from_excel3(excel_file): wb = xlrd.open_workbook(excel_file) sh = wb.sheet_by_index(0) #tags = [n.replace(" ", "").lower() for n in sh.row_values(0)] Start=str(ObtainDate("Test Start Time(with Date like 2017-01-16):","%Y-%m-%d %H:%M:%S")) #print "Test Start At:" +str(Start) Stop=str(ObtainDate("Test End Time:","%Y-%m-%d %H:%M:%S")) #print "Test End At:" + str(Stop) chamber=sh.cell(2,7).value #print "Chamber is selected:" +str(chamber) #Date=sh.cell(0,7).value Date=str(Start[0:10]) ##print Date location=raw_input("Enter Location:") #print "Test Done At:"+str(location) user=sh.cell(1,7).value #print "Test Done By:" +str(user) comment=raw_input("Make a Comment:") #print "Here what you Comment:" +str(comment) root = generateXMLHeader("QC3_GAS_LEAK_DATA","GEM Chamber QC3 Gas Leak Data","CERN Station A GEM Chamber QC3 Gas Leak Data",Run,Start,Stop,comment,location,user) dataSet = generateDataSet(root,"GEM Chamber QC3 Gas Leak Calib Data","1","GEM Chamber",chamber) for row in range(1,sh.nrows): seconds= sh.row_values(row)[1] pre= sh.row_values(row)[2] temp =sh.row_values(row)[3] ambp= sh.row_values(row)[4] times = xlrd.xldate_as_tuple(sh.row_values(row)[0], wb.datemode) times=str(times).replace(",",":") times = str(times).replace(")","") times = str(times).replace("("," ") generateXMLData3(dataSet,Date +str(times)[9:],str(seconds),str(pre), str(ambp), str(temp)) writeToFile(fileName, tostring(root)) test_date=sh.cell(0,7).value avgtemp=sh.cell(32,7).value stdtemp=sh.cell(32,8).value avgpre=sh.cell(33,7).value stdpre=sh.cell(33,8).value initpre = sh.cell(34,7).value finalpre = sh.cell(35,7).value duration = sh.cell(36,7).value leakrate = sh.cell(37,7).value expofitp0=sh.cell(38,7).value expofitp1=sh.cell(39,7).value expofitR2=sh.cell(40,7).value elog=raw_input("Please Enter the ELOG LINK:") File=raw_input("Please Enter the File Name:") Comments=raw_input("Make a summary Comment:") root = generateXMLHeader("QC3_GAS_LEAK_DATA_SUMMARY","GEM Chamber QC3 Gas Leak Data Summary ","CERN Station A GEM Chamber QC3 Gas Leak Data Summary",Run,Start,Stop,comment, location,user) dataSet = generateDataSet(root,"GEM Chamber QC3 Gas Leak Data Summary","1","GEM Chamber",chamber) generateXMLData3a(dataSet, str(test_date) ,str(avgtemp),str(stdtemp),str(avgpre),str(stdpre),str(initpre),str(finalpre),str(duration),str(leakrate),str(expofitp0),str(expofitp1),str(expofitR2),str(elog),str(File),str(Comments)) writeToFile1(datafile, tostring(root))
def xml_data_generation(excel_file): chamber = sys.argv[2] qc_test = sys.argv[3] qc_result = sys.argv[4] elog_link = sys.argv[5] comment = sys.argv[6] root = generateXMLHeader("QC_RESULT", "GEM Chamber QC Result", "GEM Chamber QC Result", "", "", "", comment, "", "") dataSet = generateDataSet(root, comment, "1", "GEM Chamber", chamber) generateXMLDataQCResult(dataSet, str(qc_test), str(qc_result), str(elog_link), str(comment)) writeToFile(fileName, tostring(root))
def xml_from_excel3(excel_file): wb = xlrd.open_workbook(excel_file) sh = wb.sheet_by_index(0) user = '' location = '' Start = '' Stop = '' comment = '' chamber = sh.cell(1,1).value overall_efficiency = sh.cell(2,1).value error_efficiency = sh.cell(3,1).value Run = sh.cell(0,1).value root = generateXMLHeader("QC8_GEM_QUICK_EFFICIENCY","GEM QUICK EFFICIENCY QC8","GEM QUICK EFFICIENCY",str(Run),str(Start),str(Stop),str(comment),str(location),str(user)) dataSet = generateDataSet(root,comment,"1","GEM Chamber",str(chamber)) generateXMLDataQuickEfficiencyQC8(dataSet,str(overall_efficiency),str(error_efficiency)) fileName=fname[:-5]+"_Run_"+str(Run)+".xml" writeToFile(fileName, tostring(root))
def xml_from_csv(csv_file): lines = readFile(csv_file) for i in range(len(lines)): lines[i] = lines[i].split('\n')[0] Run = int(lines[0].split(',')[1]) chamber = str(lines[1].split(',')[1]) overall_efficiency = float(lines[2].split(',')[1]) error_efficiency = float(lines[3].split(',')[1]) Start = '2020-03-14 12:00:00' Stop = '2020-03-14 12:00:00' comment = '' location = '' user = '' root = generateXMLHeader("QC8_GEM_QUICK_EFFICIENCY","GEM QUICK EFFICIENCY QC8","GEM QUICK EFFICIENCY",str(Run),str(Start),str(Stop),str(comment),str(location),str(user)) dataSet = generateDataSet(root,comment,"1","GEM Chamber",str(chamber)) generateXMLDataQuickEfficiencyQC8(dataSet,str(overall_efficiency),str(error_efficiency)) fileName = csv_file[:-4] + "_Run_" + str(Run) + ".xml" writeToFile(fileName, tostring(root))
def xml_from_excel3(excel_file): wb = xlrd.open_workbook(excel_file) sh = wb.sheet_by_index(0) user = sys.argv[3] #chamber=sh.cell(10,1).value # chamber=sys.argv[2] # Run=sys.argv[3] location=sys.argv[2] Start=sys.argv[5] Stop=sys.argv[6] #Date=str(Start[0:10]) comment=sys.argv[4] chamber = sh.cell(1,1).value#sys.argv[7] overall_efficiency = sh.cell(2,1).value error_efficiency = sh.cell(3,1).value Run = sh.cell(0,1).value root = generateXMLHeader("QC8_GEM_QUICK_EFFICIENCY","GEM QUICK EFFICIENCY QC8","GEM QUICK EFFICIENCY",str(Run),str(Start),str(Stop),str(comment),str(location),str(user)) dataSet = generateDataSet(root,comment,"1","GEM Chamber",str(chamber)) generateXMLDataQuickEfficiencyQC8(dataSet,str(overall_efficiency),str(error_efficiency)) writeToFile(fileName, tostring(root))
def xml_from_excel4(excel_file): wb = xlrd.open_workbook(excel_file) sh = wb.sheet_by_index(0) req = sh.cell(1,16).value pre = sh.cell(5,16).value amp = sh.cell(8,16).value coa = sh.cell(9,16).value fine = sh.cell(10,16).value itime = sh.cell(12,16).value dtime = sh.cell(13,16).value disc = sh.cell(16,16).value thrs = sh.cell(17,16).value scal = sh.cell(20,16).value daq = sh.cell(21,16).value Start=str(ObtainDate("Test Start Time(with Date like 2017-01-16):","%Y-%m-%d %H:%M:%S")) Stop=str(ObtainDate("Test End Time:","%Y-%m-%d %H:%M:%S")) chamber=raw_input("Please Enter a Chamber Name:") Date=str(Start[0:10]) location=raw_input("Enter Location:") user=sh.cell(1,7).value comment=raw_input("Make a Comment:") Run=db.engine.execute("select nvl(max(run.RUN_NUMBER), 0) + 1 from cms_gem_core_cond.cond_data_sets dat join cms_gem_core_cond.kinds_of_conditions koc on dat.KIND_OF_CONDITION_ID = koc.KIND_OF_CONDITION_ID join CMS_GEM_CORE_CONSTRUCT.PARTS par on par.PART_ID = dat.PART_ID join CMS_GEM_CORE_COND.COND_RUNS run on dat.COND_RUN_ID = run.COND_RUN_ID where koc.IS_RECORD_DELETED = 'F' and par.IS_RECORD_DELETED = 'F' and koc.name = '' and par.SERIAL_NUMBER = '"+chamber+"'") Run = [ t for t, in Run ] root = generateXMLHeader("QC4_HVTEST_CONFIG","GEM Chamber QC4 HV TEST Configuration","CERN Station A GEM QC4 HV Test",Run,Start,Stop,comment,location,user) dataSet = generateDataSet(root,"GEM Chamber QC4 HV TEST Configuration","1","GEM Chamber",chamber) generateXMLData4a(dataSet,str(req), str(pre),str(amp),str(coa), str(fine), str(itime),str(dtime),str(disc),str(thrs),str(scal),str(daq)) writeToFile(fileName, tostring(root)) root = generateXMLHeader("QC4_HVTEST_DATA","GEM Chamber QC4 HVTEST Data","CERN Station A GEM QC4 HV Test",Run,Start,Stop,comment,location,user) dataSet = generateDataSet(root,"GEM Chamber QC4 HVTEST Data","1","GEM Chamber",chamber) for row in range(3, sh.nrows): if row == 37: break vset = sh.row_values(row)[0] vmon= sh.row_values(row)[1] iset =sh.row_values(row)[2] imon= sh.row_values(row)[3] rcal =sh.row_values(row)[4] rnorm=sh.row_values(row)[5] count=sh.row_values(row)[6] rate= sh.row_values(row)[7] error=sh.row_values(row)[8] generateXMLData4(dataSet,str(vset), str(vmon),str(iset),str(imon), str(rcal), str(rnorm),str(count),str(rate),str(error)) writeToFile(datafile, tostring(root)) v_max = sh.cell(25,16).value test_date=str(Start[0:10]) v_drift = sh.cell(26,16).value i_max = sh.cell(27,16).value r_euq = sh.cell(28,16).value r_err= sh.cell(29,16).value r_diff = sh.cell(30,16).value spr_signal = sh.cell(31,16).value spr_error = sh.cell(32,16).value Filename= raw_input("Please Enter the FileName:") Elog=raw_input("Please Enter the Elog Link:") Comment=raw_input("Write a Summary Comment:") root = generateXMLHeader("QC4_HVTEST_SUMMARY","GEM Chamber QC4 HVTEST Summary","CERN Station A GEM QC4 HV Test Summary",Run,Start,Stop,Comment,location,user) dataSet = generateDataSet(root,"GEM Chamber QC4 HVTEST Summary","1","GEM Chamber",chamber) generateXMLData4s(dataSet,str(test_time),str(v_max),str(i_max),str(v_drift),str(r_euq), str(r_err), str(r_diff),str(spr_signal),str(Filename),str(Elog),str(Comment)) writeToFile(testfile, tostring(root))
def xml_from_excel3(excel_file): wb = xlrd.open_workbook(excel_file) sh = wb.sheet_by_index(0) user = '' #sys.argv[3] #chamber=sh.cell(10,1).value # chamber=sys.argv[2] # Run=sys.argv[3] location = '' #sys.argv[2] Startdate = sh.cell(2, 1).value #sys.argv[5] Stopdate = sh.cell(3, 1).value #sys.argv[6] Start = datetime.datetime(*xlrd.xldate_as_tuple(Startdate, wb.datemode)) Stop = datetime.datetime(*xlrd.xldate_as_tuple(Stopdate, wb.datemode)) #Date=str(Start[0:10]) comment = '' #sys.argv[4] chamber = sh.cell(1, 1).value #sys.argv[7] #Elog=sys.argv[7] #File=sys.argv[8] #Comment=sys.argv[9] Run = sh.cell(0, 1).value root = generateXMLHeader("QC8_GEM_CH_VFAT_EFFICIENCY", "GEM CH VFAT EFFICIENCY QC8", "GEM CH VFAT EFFICIENCY", str(Run), str(Start), str(Stop), str(comment), str(location), str(user)) dataSet = generateDataSet(root, comment, "1", "GEM Chamber", str(chamber)) for row in range(5, sh.nrows): vfat_posn = sh.row_values(row)[0] efficiency = sh.row_values(row)[1] efficiency_error = sh.row_values(row)[2] cluster_size_avg = sh.row_values(row)[3] cluster_size_sigma = sh.row_values(row)[4] percent_masked = sh.row_values(row)[5] generateXMLDataChVfatEfficiency(dataSet, str(vfat_posn), str(efficiency), str(efficiency_error), str(cluster_size_avg), str(cluster_size_sigma), str(percent_masked)) writeToFile(fileName, tostring(root))
def xml_from_excellong(excel_file): Start = str( ObtainDate("Test Start Time(with Date like 2017-01-16):", "%Y-%m-%d %H:%M:%S")) Stop = str(ObtainDate("Test End Time:", "%Y-%m-%d %H:%M:%S")) comment = raw_input("Comment:") location = raw_input("Location:") user = raw_input("User:"******"Please Enter Chamber Name:") Run = db.engine.execute( "select nvl(max(run.RUN_NUMBER), 0) + 1 from cms_gem_core_cond.cond_data_sets dat join cms_gem_core_cond.kinds_of_conditions koc on dat.KIND_OF_CONDITION_ID = koc.KIND_OF_CONDITION_ID join CMS_GEM_CORE_CONSTRUCT.PARTS par on par.PART_ID = dat.PART_ID join CMS_GEM_CORE_COND.COND_RUNS run on dat.COND_RUN_ID = run.COND_RUN_ID where koc.IS_RECORD_DELETED = 'F' and par.IS_RECORD_DELETED = 'F' and koc.name = '' and par.SERIAL_NUMBER = '" + foil + "'") Run = [t for t, in Run] root = generateXMLHeader("FOIL_QC2_LONG_AMB_COND", "GEM QC2 Long Foil Test Conditions Data", "CERN GEM Foil QC2 Long Test Batch 7", str(Run[0]), Start, Stop, comment, location, user) dataSet = generateDataSet(root, "GEM Foil QC2 Long Test COnditions", "1", "GEM Foil", foil) relhumi = raw_input("Enter the Humidity:") tempreature = raw_input("Enter tempreature") lines = excel_file for line in lines: #print line if line[0] == "#": continue else: inner_list = [elt.strip() for elt in line.split('\t')] root = generateXMLHeader("FOIL_QC2_LONG_TEST", "GEM Foil QC2 Long Test Data", "GEM Foil QC2 Long Test Data", str(Run[0]), Start, Stop, comment, location, user) dataSet = generateDataSet(root, "GEM Foil QC2 Long Test Data ", "1", "GEM Foil", foil) generateXMLDatafast(dataSet, [0], inner_list[1], inner_list[2], inner_list[3], inner_list[4], inner_list[5]) writeToFile(fileName, tostring(root))
def xml_from_csv(csv_file): lines = readFile(csv_file) for i in range(len(lines)): lines[i] = lines[i].split('\n')[0] Run = int(lines[0].split(',')[1]) chamber = str(lines[1].split(',')[1]) Start = str(lines[2].split(',')[1]) Stop = str(lines[3].split(',')[1]) user = '' location = '' comment = '' root = generateXMLHeader("QC8_GEM_CH_VFAT_EFFICIENCY","GEM CH VFAT EFFICIENCY QC8","GEM CH VFAT EFFICIENCY",str(Run),str(Start),str(Stop),str(comment),str(location),str(user)) dataSet = generateDataSet(root,comment,"1","GEM Chamber",str(chamber)) for line in range(5,len(lines)): vfat_posn = int(lines[line].split(',')[0]) efficiency = float(lines[line].split(',')[1]) efficiency_error = float(lines[line].split(',')[2]) cluster_size_avg = float(lines[line].split(',')[3]) cluster_size_sigma = float(lines[line].split(',')[4]) percent_masked = float(lines[line].split(',')[5]) generateXMLDataChVfatEfficiency(dataSet,str(vfat_posn),str(efficiency), str(efficiency_error),str(cluster_size_avg),str(cluster_size_sigma), str(percent_masked)) print(str(line-4)+" / "+str(len(lines)-5)) fileName = csv_file[:-4] + "_Run_" + str(Run) + ".xml" writeToFile(fileName, tostring(root))
def xml_from_excel4(excel_file): wb = xlrd.open_workbook(excel_file) sh = wb.sheet_by_index(0) req = sh.cell(1,16).value pre = sh.cell(5,16).value amp = sh.cell(8,16).value coa = sh.cell(9,16).value fine = sh.cell(10,16).value itime = sh.cell(12,16).value dtime = sh.cell(13,16).value disc = sh.cell(16,16).value thrs = sh.cell(17,16).value scal = sh.cell(20,16).value daq = sh.cell(21,16).value root = generateXMLHeader("QC6_HVTEST_CONFIG","GEM Chamber QC6 HV TEST Configuration","CERN Station A GEM QC6 HV Test",Run,Start,Stop,comment,location,user) dataSet = generateDataSet(root,"GEM Chamber QC6 HV TEST Configuration","1","GEM Chamber",chamber) generateXMLData4a(dataSet,str(req), str(pre),str(amp),str(coa), str(fine), str(itime),str(dtime),str(disc),str(thrs),str(scal),str(daq)) writeToFile(fileName, tostring(root)) root = generateXMLHeader("QC6_HVTEST_DATA","GEM Chamber QC6 HVTEST Data","CERN Station A GEM QC6 HV Test",Run,Start,Stop,comment,location,user) dataSet = generateDataSet(root,"GEM Chamber QC6 HVTEST Data","1","GEM Chamber",chamber) for row in range(3, sh.nrows): if row == 37: break vset = sh.row_values(row)[0] vmon= sh.row_values(row)[1] iset =sh.row_values(row)[2] imon= sh.row_values(row)[3] rcal =sh.row_values(row)[4] rnorm=sh.row_values(row)[5] count=sh.row_values(row)[6] rate= sh.row_values(row)[7] error=sh.row_values(row)[8] generateXMLData4(dataSet,str(vset), str(vmon),str(iset),str(imon), str(rcal), str(rnorm),str(count),str(rate),str(error)) writeToFile(datafile, tostring(root)) v_max = sh.cell(25,16).value test_time="2016-11-07" v_drift = sh.cell(26,16).value i_max = sh.cell(27,16).value r_euq = sh.cell(28,16).value r_err= sh.cell(29,16).value r_diff = sh.cell(30,16).value spr_signal = sh.cell(31,16).value spr_error = sh.cell(32,16).value Filename= raw_input("Please Enter the FileName:") Elog=raw_input("Please Enter the Elog Link:") Comment=raw_input("Please Enter the comment:") root = generateXMLHeader("QC6_HVTEST_DATA_SUMMARY","GEM Chamber QC6 HVTEST Data Summary","CERN Station A GEM QC6 HV Test Summary",Run,Start,Stop,comment,location,user) dataSet = generateDataSet(root,"GEM Chamber QC6 HVTEST Data Summary","1","GEM Chamber",chamber) generateXMLData4s(dataSet,str(test_time),str(v_max),str(i_max),str(v_drift),str(r_euq), str(r_err), str(r_diff),str(spr_signal),str(Filename),str(Elog),str(Comment)) writeToFile(testfile, tostring(root))
def xml_from_excel4(excel_file): wb = xlrd.open_workbook(excel_file) sh = wb.sheet_by_index(0) req = sh.cell(1,16).value pre = sh.cell(5,16).value amp = sh.cell(8,16).value coa = sh.cell(9,16).value fine = sh.cell(10,16).value itime = sh.cell(12,16).value dtime = sh.cell(13,16).value disc = sh.cell(16,16).value thrs = sh.cell(17,16).value scal = sh.cell(20,16).value daq = sh.cell(21,16).value Start=sys.argv[7] Stop=sys.argv[8] chamber=sys.argv[2] Date=str(Start[0:10]) location=sys.argv[4] #user=sh.cell(1,7).value user=sys.argv[5] comment=sys.argv[6] Comment=sys.argv[11] Run=sys.argv[3] root = generateXMLHeader("QC4_HVTEST_CONFIG","GEM Chamber QC4 HVTEST Configuration",str(location) + " GEM QC4 HV Test",Run,Start,Stop,comment,location,user) dataSet = generateDataSet(root,Comment,"1","GEM Chamber",chamber) generateXMLData4a(dataSet,str(req), str(pre),str(amp),str(coa), str(fine), str(itime),str(dtime),str(disc),str(thrs),str(scal),str(daq)) writeToFile(fileName, tostring(root)) root = generateXMLHeader("QC4_HVTEST_DATA","GEM Chamber QC4 HVTEST Data",str(location) + " GEM QC4 HV Test",Run,Start,Stop,comment,location,user) dataSet = generateDataSet(root,Comment,"1","GEM Chamber",chamber) for row in range(3, sh.nrows): if sh.row_values(row)[0]=='': break vset = sh.row_values(row)[0] vmon= sh.row_values(row)[1] iset =sh.row_values(row)[2] imon= sh.row_values(row)[3] rcal =sh.row_values(row)[4] rnorm=sh.row_values(row)[5] count=sh.row_values(row)[6] rate= sh.row_values(row)[7] error=sh.row_values(row)[8] generateXMLData4(dataSet,str(vset), str(vmon),str(iset),str(imon), str(rcal), str(rnorm),str(count),str(rate),str(error)) writeToFile(datafile, tostring(root)) v_max = sh.cell(25,16).value test_date=Start v_drift = sh.cell(26,16).value i_max = sh.cell(27,16).value r_euq = sh.cell(28,16).value r_err= sh.cell(29,16).value r_diff = sh.cell(30,16).value spr_signal = sh.cell(31,16).value spr_error = sh.cell(32,16).value Filename= sys.argv[10] Elog=sys.argv[9] #Comment=sys.argv[11] root = generateXMLHeader("QC4_HVTEST_SUMRY","GEM Chamber QC4 HVTEST Summary",str(location) + " GEM QC4 HV Test",Run,Start,Stop,comment,location,user) dataSet = generateDataSet(root,Comment,"1","GEM Chamber",chamber) generateXMLData4s(dataSet,test_date,str(v_max),str(i_max),str(v_drift),str(r_euq), str(r_err), str(r_diff),str(spr_signal),str(Filename),str(Elog),str(Comment),str(spr_error)) writeToFile(testfile, tostring(root))
def xml_from_excel5(excel_file): #wb = xlrd.open_workbook(excel_file) #sh = wb.sheet_by_index(0) user = sys.argv[3] location = sys.argv[2] Start = sys.argv[5] Stop = sys.argv[6] Run = sys.argv[7] ch1 = sys.argv[8] ch2 = sys.argv[9] ch3 = sys.argv[10] ch4 = sys.argv[11] ch5 = sys.argv[12] ch6 = sys.argv[13] ch7 = sys.argv[14] ch8 = sys.argv[15] ch9 = sys.argv[16] ch10 = sys.argv[17] ch11 = sys.argv[18] ch12 = sys.argv[19] ch13 = sys.argv[20] ch14 = sys.argv[21] ch15 = sys.argv[22] ch16 = sys.argv[23] ch17 = sys.argv[24] ch18 = sys.argv[25] ch19 = sys.argv[26] ch20 = sys.argv[27] ch21 = sys.argv[28] ch22 = sys.argv[29] ch23 = sys.argv[30] ch24 = sys.argv[31] ch25 = sys.argv[32] ch26 = sys.argv[33] ch27 = sys.argv[34] ch28 = sys.argv[35] ch29 = sys.argv[36] ch30 = sys.argv[37] flip2 = sys.argv[38] flip4 = sys.argv[39] flip6 = sys.argv[40] flip8 = sys.argv[41] flip10 = sys.argv[42] flip12 = sys.argv[43] flip14 = sys.argv[44] flip16 = sys.argv[45] flip18 = sys.argv[46] flip20 = sys.argv[47] flip22 = sys.argv[48] flip24 = sys.argv[49] flip26 = sys.argv[50] flip28 = sys.argv[51] flip30 = sys.argv[52] flow2 = sys.argv[53] flow4 = sys.argv[54] flow6 = sys.argv[55] flow8 = sys.argv[56] flow10 = sys.argv[57] flow12 = sys.argv[58] flow14 = sys.argv[59] flow16 = sys.argv[60] flow18 = sys.argv[61] flow20 = sys.argv[62] flow22 = sys.argv[63] flow24 = sys.argv[64] flow26 = sys.argv[65] flow28 = sys.argv[66] flow30 = sys.argv[67] comment = sys.argv[4] #type = "S" chamberCheck = "select" root = generateXMLHeader("QC8_GEM_STAND_GEOMETRY_CONF", "GEM STAND GEOMETRY CONFIGURATION QC8", "GEOMETRY STAND CONFIGURATION", str(Run), str(Start), str(Stop), str(comment), str(location), str(user)) dataSet = generateDataSetMultipleParts(root, comment, "1") if chamberCheck != str(ch1): type = "L" if "-L" in str(ch1) else "S" generateXMLDataStandGeoConf(dataSet, str(ch1), '1/1/B', str(flow2), '11201', type, str(flip2), '2', '2') if chamberCheck != str(ch2): type = "L" if "-L" in str(ch2) else "S" generateXMLDataStandGeoConf(dataSet, str(ch2), '1/1/T', str(flow2), '11101', type, str(flip2), '2', '3') if chamberCheck != str(ch3): type = "L" if "-L" in str(ch3) else "S" generateXMLDataStandGeoConf(dataSet, str(ch3), '2/1/B', str(flow4), '11203', type, str(flip4), '2', '4') if chamberCheck != str(ch4): type = "L" if "-L" in str(ch4) else "S" generateXMLDataStandGeoConf(dataSet, str(ch4), '2/1/T', str(flow4), '11103', type, str(flip4), '2', '5') if chamberCheck != str(ch5): type = "L" if "-L" in str(ch5) else "S" generateXMLDataStandGeoConf(dataSet, str(ch5), '3/1/B', str(flow6), '11205', type, str(flip6), '2', '6') if chamberCheck != str(ch6): type = "L" if "-L" in str(ch6) else "S" generateXMLDataStandGeoConf(dataSet, str(ch6), '3/1/T', str(flow6), '11105', type, str(flip6), '2', '7') if chamberCheck != str(ch7): type = "L" if "-L" in str(ch7) else "S" generateXMLDataStandGeoConf(dataSet, str(ch7), '4/1/B', str(flow8), '11207', type, str(flip8), '2', '8') if chamberCheck != str(ch8): type = "L" if "-L" in str(ch8) else "S" generateXMLDataStandGeoConf(dataSet, str(ch8), '4/1/T', str(flow8), '11107', type, str(flip8), '2', '9') if chamberCheck != str(ch9): type = "L" if "-L" in str(ch9) else "S" generateXMLDataStandGeoConf(dataSet, str(ch9), '5/1/B', str(flow10), '11209', type, str(flip10), '2', '10') if chamberCheck != str(ch10): type = "L" if "-L" in str(ch10) else "S" generateXMLDataStandGeoConf(dataSet, str(ch10), '5/1/T', str(flow10), '11109', type, str(flip10), '2', '11') if chamberCheck != str(ch11): type = "L" if "-L" in str(ch11) else "S" generateXMLDataStandGeoConf(dataSet, str(ch11), '1/2/B', str(flow12), '11211', type, str(flip12), '4', '2') if chamberCheck != str(ch12): type = "L" if "-L" in str(ch12) else "S" generateXMLDataStandGeoConf(dataSet, str(ch12), '1/2/T', str(flow12), '11111', type, str(flip12), '4', '3') if chamberCheck != str(ch13): type = "L" if "-L" in str(ch13) else "S" generateXMLDataStandGeoConf(dataSet, str(ch13), '2/2/B', str(flow14), '11213', type, str(flip14), '4', '4') if chamberCheck != str(ch14): type = "L" if "-L" in str(ch14) else "S" generateXMLDataStandGeoConf(dataSet, str(ch14), '2/2/T', str(flow14), '11113', type, str(flip14), '4', '5') if chamberCheck != str(ch15): type = "L" if "-L" in str(ch15) else "S" generateXMLDataStandGeoConf(dataSet, str(ch15), '3/2/B', str(flow16), '11215', type, str(flip16), '4', '6') if chamberCheck != str(ch16): type = "L" if "-L" in str(ch16) else "S" generateXMLDataStandGeoConf(dataSet, str(ch16), '3/2/T', str(flow16), '11115', type, str(flip16), '4', '7') if chamberCheck != str(ch17): type = "L" if "-L" in str(ch17) else "S" generateXMLDataStandGeoConf(dataSet, str(ch17), '4/2/B', str(flow18), '11217', type, str(flip18), '4', '8') if chamberCheck != str(ch18): type = "L" if "-L" in str(ch18) else "S" generateXMLDataStandGeoConf(dataSet, str(ch18), '4/2/T', str(flow18), '11117', type, str(flip18), '4', '9') if chamberCheck != str(ch19): type = "L" if "-L" in str(ch19) else "S" generateXMLDataStandGeoConf(dataSet, str(ch19), '5/2/B', str(flow20), '11219', type, str(flip20), '4', '10') if chamberCheck != str(ch20): type = "L" if "-L" in str(ch20) else "S" generateXMLDataStandGeoConf(dataSet, str(ch20), '5/2/T', str(flow20), '11119', type, str(flip20), '4', '11') if chamberCheck != str(ch21): type = "L" if "-L" in str(ch21) else "S" generateXMLDataStandGeoConf(dataSet, str(ch21), '1/3/B', str(flow22), '11221', type, str(flip22), '6', '2') if chamberCheck != str(ch22): type = "L" if "-L" in str(ch22) else "S" generateXMLDataStandGeoConf(dataSet, str(ch22), '1/3/T', str(flow22), '11121', type, str(flip22), '6', '3') if chamberCheck != str(ch23): type = "L" if "-L" in str(ch23) else "S" generateXMLDataStandGeoConf(dataSet, str(ch23), '2/3/B', str(flow24), '11223', type, str(flip24), '6', '4') if chamberCheck != str(ch24): type = "L" if "-L" in str(ch24) else "S" generateXMLDataStandGeoConf(dataSet, str(ch24), '2/3/T', str(flow24), '11123', type, str(flip24), '6', '5') if chamberCheck != str(ch25): type = "L" if "-L" in str(ch25) else "S" generateXMLDataStandGeoConf(dataSet, str(ch25), '3/3/B', str(flow26), '11225', type, str(flip26), '6', '6') if chamberCheck != str(ch26): type = "L" if "-L" in str(ch26) else "S" generateXMLDataStandGeoConf(dataSet, str(ch26), '3/3/T', str(flow26), '11125', type, str(flip26), '6', '7') if chamberCheck != str(ch27): type = "L" if "-L" in str(ch27) else "S" generateXMLDataStandGeoConf(dataSet, str(ch27), '4/3/B', str(flow28), '11227', type, str(flip28), '6', '8') if chamberCheck != str(ch28): type = "L" if "-L" in str(ch28) else "S" generateXMLDataStandGeoConf(dataSet, str(ch28), '4/3/T', str(flow28), '11127', type, str(flip28), '6', '9') if chamberCheck != str(ch29): type = "L" if "-L" in str(ch29) else "S" generateXMLDataStandGeoConf(dataSet, str(ch29), '5/3/B', str(flow30), '11229', type, str(flip30), '6', '10') if chamberCheck != str(ch30): type = "L" if "-L" in str(ch30) else "S" generateXMLDataStandGeoConf(dataSet, str(ch30), '5/3/T', str(flow30), '11129', type, str(flip30), '6', '11') writeToFile(fileName, tostring(root))
def xml_from_excel4(excel_file): wb = xlrd.open_workbook(excel_file) sh = wb.sheet_by_index(0) req = sh.cell(1, 33).value # pre = sh.cell(5,16).value # amp = sh.cell(8,16).value # coa = sh.cell(9,16).value # fine = sh.cell(10,16).value # itime = sh.cell(12,16).value # dtime = sh.cell(13,16).value # disc = sh.cell(16,16).value # thrs = sh.cell(17,16).value # scal = sh.cell(20,16).value # daq = sh.cell(21,16).value Start = sys.argv[7] Stop = sys.argv[8] chamber = sys.argv[2] Date = str(Start[0:10]) location = sys.argv[4] #user=sh.cell(1,7).value user = sys.argv[5] comment = sys.argv[6] Comment = sys.argv[11] Run = sys.argv[3] root = generateXMLHeader("QC6_HVTEST_CONFIG", "GEM Chamber QC6 HVTEST Config", str(location) + " GEM QC6 HV Test", Run, Start, Stop, comment, location, user) dataSet = generateDataSet(root, Comment, "1", "GEM Chamber", chamber) generateXMLData6a(dataSet, str(req)) writeToFile(fileName, tostring(root)) root = generateXMLHeader("QC6_HVTEST_DATA", "GEM Chamber QC6 HVTEST Data", str(location) + " GEM QC6 HV Test", Run, Start, Stop, comment, location, user) dataSet = generateDataSet(root, Comment, "1", "GEM Chamber", chamber) for row in range(2, sh.nrows): if sh.row_values(row)[0] == '': break vmon_equ_vlt = sh.row_values(row)[0] imon_equ_ua = sh.row_values(row)[1] vmon_g3b_vlt = sh.row_values(row)[3] imon_g3b_ua = sh.row_values(row)[4] vmon_g3t_vlt = sh.row_values(row)[6] imon_g3t_ua = sh.row_values(row)[7] vmon_g2b_vlt = sh.row_values(row)[9] imon_g2b_ua = sh.row_values(row)[10] vmon_g2t_vlt = sh.row_values(row)[12] imon_g2t_ua = sh.row_values(row)[13] vmon_g1b_vlt = sh.row_values(row)[15] imon_g1b_ua = sh.row_values(row)[16] vmon_g1t_vlt = sh.row_values(row)[18] imon_g1t_ua = sh.row_values(row)[19] vmon_drift_vlt = sh.row_values(row)[21] imon_drift_ua = sh.row_values(row)[22] generateXMLData6b( dataSet, str(vmon_equ_vlt), str(imon_equ_ua), str(vmon_g3b_vlt), str(imon_g3b_ua), str(vmon_g3t_vlt), str(imon_g3t_ua), str(vmon_g2b_vlt), str(imon_g2b_ua), str(vmon_g2t_vlt), str(imon_g2t_ua), str(vmon_g1b_vlt), str(imon_g1b_ua), str(vmon_g1t_vlt), str(imon_g1t_ua), str(vmon_drift_vlt), str(imon_drift_ua)) writeToFile(datafile, tostring(root)) test_date = Start Filename = sys.argv[10] Elog = sys.argv[9] Comment = sys.argv[11] root = generateXMLHeader("QC6_HVTEST_SUMRY", "GEM Chamber QC6 HVTEST Summary", str(location) + " GEM QC6 HV Test", Run, Start, Stop, comment, location, user) dataSet = generateDataSet(root, Comment, "1", "GEM Chamber", chamber) generateXMLData6c(dataSet, test_date, str(Filename), str(Elog), str(Comment)) writeToFile(testfile, tostring(root))
def xml_from_excel5(excel_file): wb = xlrd.open_workbook(excel_file) sh = wb.sheet_by_index(0) #user = sh.cell(0,1).value user = sys.argv[5] #chamber=sh.cell(10,1).value chamber = sys.argv[2] Run = sys.argv[3] location = sys.argv[4] Start = sys.argv[7] Stop = sys.argv[8] Date = str(Start[0:10]) comment = sys.argv[6] Elog = sys.argv[9] File = sys.argv[10] Comment = sys.argv[11] user_name = sh.cell(1, 1).value amp = sh.cell(4, 1).value coa = sh.cell(5, 1).value fine = sh.cell(6, 1).value itime = sh.cell(8, 1).value dtime = sh.cell(7, 1).value disc = sh.cell(27, 1).value thrs = sh.cell(28, 1).value walk = sh.cell(29, 1).value width = sh.cell(30, 1).value scal = sh.cell(40, 1).value daq = sh.cell(41, 1).value pico = sh.cell(33, 1).value #tred = sh.cell(34,1).value #tblack = sh.cell(35,1).value #tgreen = sh.cell(36,1).value source = sh.cell(44, 1).value hvlt = sh.cell(45, 1).value current = sh.cell(46, 1).value activity_bq = sh.cell(47, 1).value filter_status = sh.cell(48, 1).value collimator_status = sh.cell(49, 1).value nbpri = sh.cell(23, 5).value eta = sh.cell(12, 1).value gas = sh.cell(13, 1).value gfac = sh.cell(14, 1).value flow = sh.cell(15, 1).value req = sh.cell(16, 1).value divi = sh.cell(17, 1).value avtemp = sh.cell(47, 5).value error_temp = sh.cell(48, 5).value amb = sh.cell(49, 5).value error_amb = sh.cell(50, 5).value expo1 = sh.cell(51, 5).value expo2 = sh.cell(52, 5).value p5p0 = sh.cell(47, 8).value p5t0 = sh.cell(48, 8).value root = generateXMLHeader("QC5_EFF_GAIN_CONFIG", "GEM Chamber QC5 Effective Gain Config", str(location) + " GEM Chamber QC5 Effective Gain", Run, Start, Stop, comment, location, user) dataSet = generateDataSet(root, Comment, "1", "GEM Chamber", chamber) generateXMLData5a(dataSet, str(user_name), str(amp), str(coa), str(fine), str(itime), str(dtime), str(disc), str(thrs), str(walk), str(width), str(scal), str(daq), str(pico), str(source), str(hvlt), str(current), str(nbpri), str(eta), str(gas), str(gfac), str(flow), str(req), str(divi), str(activity_bq), str(filter_status), str(collimator_status)) writeToFile(fileName, tostring(root)) root = generateXMLHeader("QC5_EFF_GAIN_DATA", "GEM Chamber QC5 Effective Gain Data", str(location) + " GEM Chamber QC5 Effective Gain", Run, Start, Stop, comment, location, user) dataSet = generateDataSet(root, Comment, "1", "GEM Chamber", chamber) #for row in range(5,21): for row in range(29, 45): #test_time= sh.row_values(row-24)[7] test_time = xlrd.xldate_as_tuple( sh.row_values(row - 24)[7], wb.datemode) test_time = str(test_time).replace(",", ":") test_time = str(test_time).replace(")", "") test_time = str(test_time).replace("(", " ") pressure = sh.row_values(row - 24)[8] temp = sh.row_values(row - 24)[9] vmon = sh.row_values(row)[5] imon = sh.row_values(row)[4] vdrift = sh.row_values(row)[6] rate = sh.row_values(row)[7] rate_error = sh.row_values(row)[8] current = sh.row_values(row)[9] current_error = sh.row_values(row)[10] gain = sh.row_values(row)[11] gain_error = sh.row_values(row)[12] generateXMLData5(dataSet, Date + str(test_time[9:]), str(temp), str(pressure), str(imon), str(vmon), str(vdrift), str(rate), str(rate_error), str(current), str(current_error), str(gain), str(gain_error)) writeToFile(datafile, tostring(root)) root = generateXMLHeader("QC5_EFF_GAIN_SUMRY", "GEM Chamber QC5 Effective Gain Summary", str(location) + " GEM Chamber QC5 Effective Gain", Run, Start, Stop, comment, location, user) dataSet = generateDataSet(root, Comment, "1", "GEM Chamber", chamber) generateXMLData5s(dataSet, str(Start), str(avtemp), str(amb), str(expo1), str(expo2), str(File), str(Elog), str(Comment), str(error_temp), str(error_amb), str(p5p0), str(p5t0)) writeToFile(testfile, tostring(root))
def xml_from_excel3(excel_file): wb = xlrd.open_workbook(excel_file) sh = wb.sheet_by_index(0) tags = [n.replace(" ", "").lower() for n in sh.row_values(0)] Start=str(ObtainDate("Test Start Time(with Date like 2017-01-16):","%Y-%m-%d %H:%M:%S")) #print "Test Start At:" +str(Start) Stop=str(ObtainDate("Test End Time:","%Y-%m-%d %H:%M:%S")) #print "Test End At:" + str(Stop) chamber=sh.cell(2,7).value #print "Chamber is selected:" +str(chamber) #Date=sh.cell(0,7).value Date=str(Start[0:10]) ##print Date #location=raw_input("Enter Location:") location = "PLACEHOLDER_LOCATION" #print "Test Done At:"+str(location) user=sh.cell(1,7).value #print "Test Done By:" +str(user) #comment=raw_input("Make a Comment:") comment = "PLACHOLDER_COMMENT" #print "Here what you Comment:" +str(comment) Run=db.engine.execute("select nvl(max(run.RUN_NUMBER), 0) + 1 from cms_gem_core_cond.cond_data_sets dat join cms_gem_core_cond.kinds_of_conditions koc on dat.KIND_OF_CONDITION_ID = koc.KIND_OF_CONDITION_ID join CMS_GEM_CORE_CONSTRUCT.PARTS par on par.PART_ID = dat.PART_ID join CMS_GEM_CORE_COND.COND_RUNS run on dat.COND_RUN_ID = run.COND_RUN_ID where koc.IS_RECORD_DELETED = 'F' and par.IS_RECORD_DELETED = 'F' and koc.name = '' and par.SERIAL_NUMBER = '"+chamber+"'") Run = [ t for t, in Run ] #print "Number of Time Test Perform:"+str(Run[0]) root = generateXMLHeader("QC3_GAS_LEAK_CALIB","GEM Chamber QC3 Gas Leak Calib Data","CERN Station A GEM Chamber QC3 Gas Leak Calibration",str(Run[0]),Start,Stop,comment,location,user) dataSet = generateDataSet(root,"GEM Chamber QC3 Gas Leak Calib Data","1","GEM Chamber",chamber) for row in range(1,sh.nrows): seconds= sh.row_values(row)[1] pre= sh.row_values(row)[2] temp =sh.row_values(row)[3] ambp= sh.row_values(row)[4] #times=datetime.strftime(sh.row_values(row)[0], '%H:%M:%S') times = xlrd.xldate_as_tuple(sh.row_values(row)[0], wb.datemode) ##print times[3:] times=str(times).replace(",",":") times = str(times).replace(")","") times = str(times).replace("("," ") ##print times generateXMLData3(dataSet,Date +str(times[9:]),str(seconds),str(pre), str(ambp), str(temp)) writeToFile(fileName, tostring(root)) test_date=sh.cell(0,7).value avgtemp=sh.cell(32,7).value stdtemp=sh.cell(32,8).value avgpre=sh.cell(33,7).value stdpre=sh.cell(33,8).value initpre = sh.cell(34,7).value finalpre = sh.cell(35,7).value duration = sh.cell(36,7).value leakrate = sh.cell(37,7).value expofitp0=sh.cell(38,7).value expofitp1=sh.cell(39,7).value expofitR2=sh.cell(40,7).value #elog=raw_input("Please Enter the ELOG LINK:") #File=raw_input("Please Enter the File Name:") #Comments=raw_input("Make a Summary Comment:") elog="PLACEHOLDER_ELOG" File="PLACEHOLDER_FILE" Comments="PLACHOLDER_COMMENTS" root = generateXMLHeader("QC3_GAS_LEAK_CalIB_SUMMARY","GEM Chamber QC3 Gas Leak Calib Summary ","CERN Station A GEM Chamber QC3 Gas Leak Calib Summary",str(Run[0]),Start,Stop,comment, location,user) dataSet = generateDataSet(root,"GEM Chamber QC3 Gas Leak Calib Summary","1","GEM Chamber",chamber) generateXMLData3a(dataSet, str(test_date) ,str(avgtemp),str(stdtemp),str(avgpre),str(stdpre),str(initpre),str(finalpre),str(duration),str(leakrate),str(expofitp0),str(expofitp1),str(expofitR2),str(elog),str(File),str(Comments)) writeToFile1(testfile, tostring(root))