#Anexe1

import xlwt
from os import chdir, fsync
from datetime import datetime 
import time

chdir("C:\Documents and Settings\opid00.ESRF\Desktop")
source=open("results.txt", "r")

book = xlwt.Workbook(encoding="utf-8")
dst1 = book.add_sheet("dst1", cell_overwrite_ok=True)


dst1.write(0, 0, "conputer name")
dst1.write(0, 1, "located")
dst1.write(0, 2, "date")

def filtrer(src, dst1):
    
    list1=['marccddp3','marccddp0','marccddp8','marccddp7','marccddp12','mar345dp112','frelondp1','frelondp2','frelondp3','frelondp4','',
           'mpxdp1','dectrisdp300w','isg-prince1','isg-prince2','isg-pco1','isg-pco2','isg-pco2k1','isg-pco2k2','pcvantec2000','inelpool','',
           'isg-xmap1','isg-xmap2','isg-xmap3','isg-xmap4','isg-xmap0','uwodpagilent1','uwo_dpscope','uwodplecroy1','ldp1','ldp2','',
           'isg-dp1','isg-dp10','wdp1','isg-dp20','icedp1','wdplaue','lapdp1','isg-tmp1','isg-tmp2','isg-tmp3','',
           'isg-tmp4','isg-tmp5','isg-tmp6']

    i=0
    
    for n in list1:
        i = i+1
        dst1.write(i, 0, n)
        
        # Reading line
        followingline = source.readline().rstrip('\n\r')
        
        chaine = "marccddp3"
        chaine1 = "marccddp0"
        chaine2 = "marccddp8" 
        chaine3 = "marccddp7" 
        chaine4 = "marccddp12" 
        chaine5 = "mar345dp112" 
        chaine6 = "frelondp1" 
        chaine7 = "frelondp2" 
        chaine8 = "frelondp3"
        chaine9 = "frelondp4"
    
        chaine10 = "mpxdp1" 
        chaine11 = "dectrisdp300w"
        chaine12 = "isg-prince1"
        chaine13 = "isg-prince2"
        chaine14 = "isg-pco1"
        chaine15 = "isg-pco2"
        chaine16 = "isg-pco2k1"
        chaine17 = "isg-pco2k2"
        chaine18 = "pcvantec2000"
        chaine19 = "inelpool"
    
        chaine20 = "isg-xmap1"
        chaine21 = "isg-xmap2"
        chaine22 = "isg-xmap3"
        chaine23 = "isg-xmap4"
        chaine24 = "isg-xmap0"
        chaine25 = "uwodpagilent1"
        chaine26 = "uwo_dpscope"
        chaine27 = "uwodplecroy1"
        chaine28 = "ldp1"
        chaine29 = "ldp2"
    
        chaine30 = "isg-dp1"
        chaine31 = "isg-dp10"
        chaine32 = "wdp1"
        chaine33 = "isg-dp20"
        chaine34 = "icedp1"
        chaine35 = "wdplaue"
        chaine36 = "lapdp1"
        chaine37 = "isg-tmp1"
        chaine38 = "isg-tmp2"
        chaine39 = "isg-tmp3"
    
        chaine40 = "isg-tmp4"
        chaine41 = "isg-tmp5"
        chaine42 = "isg-tmp6"
        
        for ligne in source:
            
            
            if chaine in ligne:
                dst1.write(1,1, ligne[9:])
                dst1.write(1,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine1 in ligne:
                dst1.write(2,1,ligne[9:])
                dst1.write(2,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine2 in ligne:
                dst1.write(3,1,ligne[9:])
                dst1.write(3,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))
                
            if chaine3 in ligne:
                dst1.write(4,1,ligne[9:])
                dst1.write(4,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))
                
            if chaine4 in ligne:
                dst1.write(5,1,ligne[10:])
                dst1.write(5,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))
                
            if chaine5 in ligne:
                dst1.write(6,1,ligne[11:])
                dst1.write(6,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine6 in ligne:
                dst1.write(7,1,ligne[9:])
                dst1.write(7,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))
                
            if chaine7 in ligne:
                dst1.write(8,1,ligne[9:])
                dst1.write(8,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))
                
            if chaine8 in ligne:
                dst1.write(9,1,ligne[9:])
                dst1.write(9,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine9 in ligne:
                dst1.write(10,1,ligne[9:])
                dst1.write(10,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))
            
            if chaine10 in ligne:
                dst1.write(12,1,ligne[6:])
                dst1.write(12,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))
                
            if chaine11 in ligne:
                dst1.write(13,1,ligne[13:])
                dst1.write(13,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine12 in ligne:
                dst1.write(14,1,ligne[11:])
                dst1.write(14,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine13 in ligne:
                dst1.write(15,1,ligne[11:])
                dst1.write(15,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine14 in ligne:
                dst1.write(16,1,ligne[8:])
                dst1.write(16,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine15 in ligne:
                dst1.write(17,1,ligne[8:])
                dst1.write(17,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine16 in ligne:
                dst1.write(18,1,ligne[10:])
                dst1.write(18,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine17 in ligne:
                dst1.write(19,1,ligne[10:])
                dst1.write(19,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine18 in ligne:
                dst1.write(20,1,ligne[12:])
                dst1.write(20,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine19 in ligne:
                dst1.write(21,1,ligne[8:])
                dst1.write(21,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine20 in ligne:
                dst1.write(23,1,ligne[9:])
                dst1.write(23,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))
                                    
            if chaine21 in ligne:
                dst1.write(24,1,ligne[9:])
                dst1.write(24,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine22 in ligne:
                dst1.write(25,1,ligne[9:])
                dst1.write(25,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine23 in ligne:
                dst1.write(26,1,ligne[9:])
                dst1.write(26,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))
                
            if chaine24 in ligne:
                dst1.write(27,1,ligne[9:])
                dst1.write(27,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine25 in ligne:
                dst1.write(28,1,ligne[13:])
                dst1.write(28,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine26 in ligne:
                dst1.write(29,1,ligne[11:])
                dst1.write(29,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))
                                    
            if chaine27 in ligne:
                dst1.write(30,1,ligne[12:])
                dst1.write(30,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine28 in ligne:
                dst1.write(31,1,ligne[4:])
                dst1.write(31,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine29 in ligne:
                dst1.write(32,1,ligne[4:])
                dst1.write(32,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine30 in ligne:
                dst1.write(34,1,ligne[7:])
                dst1.write(34,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine31 in ligne:
                dst1.write(35,1,ligne[8:])
                dst1.write(35,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))
                                    
            if chaine32 in ligne:
                dst1.write(36,1,ligne[4:])
                dst1.write(36,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine33 in ligne:
                dst1.write(37,1,ligne[8:])
                dst1.write(37,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine34 in ligne:
                dst1.write(38,1,ligne[6:])
                dst1.write(38,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine35 in ligne:
                dst1.write(39,1,ligne[7:])
                dst1.write(39,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine36 in ligne:
                dst1.write(40,1,ligne[6:])
                dst1.write(40,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))
                
            if chaine37 in ligne:
                dst1.write(41,1,ligne[8:])
                dst1.write(41,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine38 in ligne:
                dst1.write(42,1,ligne[8:])
                dst1.write(42,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine39 in ligne:
                dst1.write(43,1,ligne[8:])
                dst1.write(43,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine40 in ligne:
                dst1.write(45,1,ligne[8:])
                dst1.write(45,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine41 in ligne:
                dst1.write(46,1,ligne[8:])
                dst1.write(46,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))

            if chaine42 in ligne:
                dst1.write(47,1,ligne[8:])
                dst1.write(47,2,datetime.now().strftime("%d/%m/%Y %H:%M:%S"))
    
    book.save("history.xls")


# Call processing function
filtrer(source, dst1)

# Close the file source
source.close()