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()
