def inputs(request): c = {} c.update(csrf(request)) errors=[] if request.method == 'POST': author=request.POST.get('author','') date=request.POST.get('date','') system1_food=request.POST.get('sys1','') system2_food=request.POST.get('sys2','') system3_food=request.POST.get('sys3','') system4_food=request.POST.get('sys4','') makeup_added=request.POST.get('makeup','') temp=request.POST.get('temp','') ph=request.POST.get('ph','') do=request.POST.get('do','') humidity=request.POST.get('humid','') note=request.POST.get('note','') if not date: errors.append('Enter a date') if not system1_food: system1_food = 0 if not system2_food: system2_food = 0 if not system3_food: system3_food = 0 if not system4_food: system4_food = 0 if not makeup_added: makeup_added = 0 if not temp: temp = -1 if not ph: ph = -1 if not do: do = -1 if not humidity: humidity = -1 if not errors: l = Log(date=date, author=author, system1_food=system1_food, system2_food=system2_food, system3_food=system3_food, system4_food=system4_food, makeup_added=makeup_added, temp=temp, ph=ph, do=do, humidity=humidity, note=note) l.save() return HttpResponseRedirect('thanks/') c.update({'errors':errors}) return render_to_response('input.html',c)
def importx(request): book = xlrd.open_workbook("/home/seth/Downloads/op.xls") sheet = book.sheets()[0] for i in xrange(6,sheet.nrows): date = datetime.datetime(*xlrd.xldate_as_tuple(sheet.col(0)[i].value,book.datemode)) name = sheet.col(1)[i].value sys1 = convert_zero(sheet.col(2)[i].value) sys2 = convert_zero(sheet.col(3)[i].value) sys3 = convert_zero(sheet.col(4)[i].value) sys4 = convert_zero(sheet.col(5)[i].value) makeup = str(sheet.col(6)[i].value) temp = convert(sheet.col(7)[i].value) ph = convert(sheet.col(8)[i].value) do = convert(sheet.col(9)[i].value) hum = convert(sheet.col(10)[i].value) if type(hum) is float: hum = hum * 100 note = '' try: note = str(sheet.col(11)[i].value) except: note='' l = Log(date=date, author=name, system1_food=sys1, system2_food=sys2, system3_food=sys3, system4_food=sys4, makeup_added=makeup, temp=temp, ph=ph, do=do, humidity=hum, note=note) l.save()