def doImport(request):
""" Import an XLS file
"""
d={
'user': request.user,
}
if request.method=='POST':
form=importUploadForm(request.POST, request.FILES)
if form.is_valid():
d['filename']=handle_uploaded_file(request.FILES['file'])
try:
book=xlrd.open_workbook(d['filename'])
except xlrd.XLRDError, err:
d['error']=err
d['form']=importUploadForm()
return render_to_response('import.template',d)
sheets=book.sheets()
if len(sheets)>1:
d['sheets']=sheets
return render_to_response('import_sheetselection.template', d)
else:
d['sheetnum']=0
return doHeaderSelection(request, d['filename'], book, 0)
d['filename']=handle_uploaded_file(request.FILES['file'])
try:
book=xlrd.open_workbook(d['filename'])
except xlrd.XLRDError, err:
d['error']=err
d['form']=importUploadForm()
return render_to_response('import.template',d)
sheets=book.sheets()
if len(sheets)>1:
d['sheets']=sheets
return render_to_response('import_sheetselection.template', d)
else:
d['sheetnum']=0
return doHeaderSelection(request, d['filename'], book, 0)
else:
d['form']=importUploadForm()
return render_to_response('import.template',d)
################################################################################
def import_makeChanges(request):
d={}
starttime=time.time()
d['request']=request
d['changes']=[]
for ch in sorted(request.POST.keys()):
h,k,v=request.POST[ch].split('___')
if k=='None' and v=='None':
change="Create host %s" % h
else:
change="Setting %s:%s to %s" % (h, k, v)
try:
