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: