Ejemplo n.º 1
0
            continue


        (fhdr,numbered_findings,fob) = AuditParser("\n".join(findings)).parse()
        (fdhdr,numbered_finding_details,fdob) = AuditParser(d1+'\n\n'+d2).parse(fob)

        exd_observations = []
        exd_observations.append(fdhdr)
        exd_observations.extend(numbered_finding_details)

        #Check for numeric matches - code matched as Cond3
        if( numbered_findings and numbered_finding_details and len(numbered_findings) == len(numbered_finding_details)):
            numbered_findings[0] = fhdr + "\n" + numbered_findings[0]
            numbered_finding_details[0] = fdhdr + "\n" + numbered_finding_details[0]
            for i in range(len(numbered_findings)):
                ar.write_row(rx+1,id,cat,FINDING_TYPE, numbered_findings[i] , numbered_finding_details[i],cause,"Cond3: Numeric match")
        elif numbered_findings and (not numbered_finding_details or len(numbered_findings) != len(numbered_finding_details)):
            numbered_findings[0] = fhdr + "\n" + numbered_findings[0]
            for find in numbered_findings:
                ar.write_row(rx+1,id,cat,FINDING_TYPE,fhdr + find,u"".join(exd_observations),cause,"Cond2.1")
        elif not numbered_findings:
            ar.write_row(rx+1,id,cat,FINDING_TYPE,fhdr,u"".join(exd_observations),cause,"Cond1")
        else:
            #Cond4 - no such match. Dump findings and finding details and notify
            ar.write_row(rx+1,id,cat,FINDING_TYPE,finding,(d1 + "\n" + d2),cause,"Cond4: Neelansha Please look at it!")

        if fob and not fdob:
            ar.write_row(rx+1,id,cat,OBSERV_TYPE,fob,d1 + "\n" + d2,cause,"Cond5.1 observ")
        elif fob and fdob:
            ar.write_row(rx+1,id,cat,OBSERV_TYPE,fob,fdob,cause,"Cond5 observ")
Ejemplo n.º 2
0
            findingdetail2 = sheet.cell_value(rowx=rx,colx=6) #Column G, row=rx
            id = sheet.cell_value(rowx=rx,colx=1) #Column B, row=rx
            cat = sheet.cell_value(rowx=rx,colx=2), #Column C, row=rx
            cause = sheet.cell_value(rowx=rx,colx=8), #Column I

            findings = finding.strip().splitlines();  #strip all extra whitespaces and new lines

            d1 = findingdetail1.strip()  #remove leading whitespace
            d2 = findingdetail2.strip()  #remove leading whitespace

            if d1.lower() == 'n/a' or d1.strip() == '' : d1 = ''
            if d2.lower() == 'n/a'or d2.strip() == '' : d2 = ''
        except:
            logging.exception("Error reading, row: " + str(rx))
            #try to write row back
            ar.write_row(rx+1,id,"ERROR","ERROR",finding,unicode(findingdetail1)+"\n" + unicode(findingdetail2),cause,"Cond4: Neelansha Madam. Please look" + str(sys.exc_info()))
            logging.exception(unicode(findingdetail1)+"\n" + unicode(findingdetail2))
            continue


        (fhdr,numbered_findings,fob) = AuditParser("\n".join(findings)).parse()
        (fdhdr,numbered_finding_details,fdob) = AuditParser(d1+'\n\n'+d2).parse(fob)

        exd_observations = []
        exd_observations.append(fdhdr)
        exd_observations.extend(numbered_finding_details)

        #Check for numeric matches - code matched as Cond3
        if( numbered_findings and numbered_finding_details and len(numbered_findings) == len(numbered_finding_details)):
            numbered_findings[0] = fhdr + "\n" + numbered_findings[0]
            numbered_finding_details[0] = fdhdr + "\n" + numbered_finding_details[0]