def index(request): context = RequestContext(request, {}) export_form = DataExportForm(request.POST) if export_form.is_valid(): context = RequestContext(request, {'form': export_form}) return render_to_response('libraryuse/home.html', context)
def export(request): context = RequestContext(request, {}) export_form = None if request.method == 'POST': export_form = DataExportForm(request.POST) #i suspect because the dates are not actaully coming through if export_form.is_valid(): response = HttpResponse(content_type='text/csv') response['Content-Disposition'] = 'attachment; filename="libraryuse.csv"' writer = csv.writer(response) start_date = export_form.cleaned_data['start_date'] end_date = export_form.cleaned_data['end_date'] #visits = LibraryVisit.objects.all() visits = LibraryVisit.objects.filter(visit_time__range=[start_date, end_date]) writer.writerow(['visit_time', 'term_number', 'location', 'prsn_c_type', \ 'prsn_e_type', 'emjo_c_clsf', 'dprt_c', \ 'edprt_n', 'dvsn_i', 'dvsn_n', \ 'empe_c_fclt_rank', 'prsn_c_type_hc', \ 'prsn_e_type_hc', 'emjo8hc_c_clsf', 'dprt8hc_c', \ 'dprt8hc_n', 'dvsn8hc_i', 'dvsn8hc_n', \ 'acca_i', 'acpr_n', 'acpl_n', \ 'stdn_e_clas', 'stdn_f_ungr', 'stdn_f_cmps_on']) for v in visits: writer.writerow([v.visit_time, v.term_number, v.location, \ v.prsn_c_type, v.prsn_e_type, v.emjo_c_clsf, \ v.dprt_c, v.dprt_n, v.dvsn_i, v.dvsn_n, \ v.empe_c_fclt_rank, v.prsn_c_type_hc, \ v.prsn_e_type_hc, v.emjo8hc_c_clsf, v.dprt8hc_c, \ v.dprt8hc_n, v.dvsn8hc_i, v.dvsn8hc_n, v.acca_i, \ v.acpr_n, v.acpl_n, v.stdn_e_clas, v.stdn_f_ungr, \ v.stdn_f_cmps_on]) return response else: export_form = DataExportForm() return render_to_response('libraryuse/export.html', context)