def step3(): T.force('xcel2xml_it') response.menu=[['Home',False,URL(r=request,f='index')], ['Upload Excel',False,URL(r=request,f='upload_file')], ['Archivio',False,URL(r=request,f='archive')]] #id_fileexcel=request.vars.idfile riga=int(session.riga) #record=deposit(deposit.archivio.id==id_fileexcel).select(deposit.archivio.ALL) #fileexcel=record[0].file nomefile=session.filename xl = readexcel(nomefile,riga) sheetnames = xl.worksheets() colonne=xl.variables(sheetnames[0]) j=0 tt=[] tt.append(TR(TH('Tipo Immagine',_colspan='8'),TH('Nome Campo'),TH('Cartella'))) tt.append(TR(TD(HR(),_colspan='12'))) while j<3: tt.append(TR('tif',INPUT(_type='radio',_name='scegli_img'+str(j),_value='tif'),\ 'jpg',INPUT(_type='radio',_name='scegli_img'+str(j),_value='jpg'),\ 'psd',INPUT(_type='radio',_name='scegli_img'+str(j),_value='psd'),\ 'eps',INPUT(_type='radio',_name='scegli_img'+str(j),_value='eps'),\ SELECT(_name='campo'+str(j),*[OPTION(col.encode('latin-1'),_value=col) for col in colonne]),\ INPUT(_type='text',_name='folder'+str(j),_value='alte'))) j=j+1 form=FORM(TABLE(*tt),INPUT(_type='submit',_value=T('Submit')),_name='test',) if form.accepts(request.vars,session): session.tipo_img1=form.vars.scegli_img0 session.tipo_img2=form.vars.scegli_img1 session.tipo_img3=form.vars.scegli_img2 session.img1=form.vars.campo0 session.img2=form.vars.campo1 session.img3=form.vars.campo2 session.folder1=form.vars.folder0 session.folder2=form.vars.folder1 session.folder3=form.vars.folder2 redirect(URL(r=request,f='step4') ) elif form.errors: response.flash="form is invalid!" return dict(form=form)
def step2(): T.force('xcel2xml_it') response.menu=[['Home',False,URL(r=request,f='index')], ['Upload Excel',False,URL(r=request,f='upload_file')], ['Archivio',False,URL(r=request,f='archive')]] #import gluon.contrib.simplejson as sj #response.headers['Content-Type']='text/json' id_fileexcel=session.id_fileexcel riga=0 #RESPONSE['Content-type']='text/json' record=deposit(deposit.archivio.id==id_fileexcel).select(deposit.archivio.ALL) fileexcel=record[0].file file_realname=record[0].filename nomefile=dir_excelxml+urllib.unquote(fileexcel) #nomefile_realname=dir_excelxml+urllib.unquote(file_realname) #nomefile=dir_excelxml+fileexcel #riga=int(riga) copia=[] while riga<4: xl = readexcel(nomefile,riga) sheetnames = xl.worksheets() colonne=xl.variables(sheetnames[0]) copia.append(colonne) riga=riga+1 #simboli_col=[A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,Y,X,Z] j=0 tt=[] for col in copia: tt.append(TR(col,INPUT(_type='radio',_name='sceglicol',_value=str(j),_CHECKED=True))) j=j+1 form=FORM(TABLE(TR(TH('Colonne'),TH('Scegli')),*tt),INPUT(_type='submit',_value='Invia')) if form.accepts(request.vars,session): session.filename=nomefile session.file_realname=fileexcel session.riga=form.vars.sceglicol redirect(URL(r=request,f='step3') ) elif form.errors: response.flash="Compilazione errata!" return dict(form=form)