def import_school_submit(request):
if request.method == 'POST':
f=request.FILES['file']
district_id=request.POST.get('district_id')
count_success=0
try:
# --- THIS FAILS ON SING COLUMN CVS ---
# dialect = csv.Sniffer().sniff(f.read(1024), delimiters=";,\t",quotechar='\n')
# f.seek(0)
# r=csv.reader(f,dialect)
r=csv.reader(f,delimiter='\t', quotechar='|', quoting=csv.QUOTE_MINIMAL)
for i,line in enumerate(r):
exist=validate_school_cvs_line(line,district_id)
school_name=line[SCHOOL_CSV_COL_NAME]
school_code=line[SCHOOL_CSV_COL_CODE]
school = School()
school.name=school_name
school.code=school_code
school.district_id=district_id
school.save()
count_success=count_success+1
# commit when all lines imported
db.transaction.commit()
# success information
message={"success": True,
"message":"Success! %s school(s) imported." % (count_success),
"count_success":count_success
}
except Exception as e:
db.transaction.rollback()
# failure information
message={'success': False,'error':'Import error: %s. At cvs line: %s, Nothing impored.' % (e,count_success+1)}
return HttpResponse(json.dumps(message))
def school_submit(request):
if not request.user.is_authenticated:
raise Http404
try:
if request.POST.get("id"):
d = School(request.POST["id"])
else:
d = School()
d.name = request.POST["name"]
d.district_id = request.POST["district_id"]
d.save()
except Exception as e:
db.transaction.rollback()
return HttpResponse(json.dumps({"success": False, "error": "%s" % e}))
return HttpResponse(json.dumps({"success": True}))
def school_submit(request):
if not request.user.is_authenticated:
raise Http404
try:
if request.POST.get('id'):
d=School(request.POST['id'])
else:
d=School()
d.name=request.POST['name']
d.code=request.POST['code']
d.district_id=request.POST['district_id']
d.save()
except Exception as e:
db.transaction.rollback()
return HttpResponse(json.dumps({'success': False,'error':'%s' % e}))
return HttpResponse(json.dumps({'success': True}))
