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