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)
