def bulk_upload_contacts_to_update(request): """ bulk upload contacts from an excel file """ if request.method == 'POST': contactsform = ExcelTestUploadForm(request.POST, request.FILES) message = '' if contactsform.is_valid(): import ipdb ipdb.set_trace() if contactsform.is_valid() \ and request.FILES.get('excel_file', None): fields = [ 'number', 'name', 'province', 'commune', 'colline', 'language', 'county', 'village', 'birthdate', 'group', 'gender', ] #message = handle_excel_file_test(request.FILES['excel_file' # ], contactsform.cleaned_data['assign_to_group' # ], fields) message = handle_excel_file_update(request.FILES['excel_file'], fields) print("AVANT LA VARIABLE MESSAGE") print(message) print("APRES LA VARIABLE MESSAGE") return render_to_response( 'ureport/bulk_contact_upload_update.html', { 'contactsform': contactsform, 'message': message }, context_instance=RequestContext(request)) contactsform = ExcelTestUploadForm() return render_to_response('ureport/bulk_contact_upload_update.html', {'contactsform': contactsform}, context_instance=RequestContext(request))
def bulk_upload_contacts_to_update(request): """ bulk upload contacts from an excel file """ if request.method == 'POST': contactsform = ExcelTestUploadForm(request.POST, request.FILES) message='' if contactsform.is_valid(): import ipdb; ipdb.set_trace() if contactsform.is_valid() \ and request.FILES.get('excel_file', None): fields = [ 'number', 'name', 'province', 'commune', 'colline', 'language', 'county', 'village', 'birthdate', 'group', 'gender', ] #message = handle_excel_file_test(request.FILES['excel_file' # ], contactsform.cleaned_data['assign_to_group' # ], fields) message = handle_excel_file_update(request.FILES['excel_file'], fields) print("AVANT LA VARIABLE MESSAGE") print(message) print("APRES LA VARIABLE MESSAGE") return render_to_response('ureport/bulk_contact_upload_update.html' , {'contactsform': contactsform, 'message' : message}, context_instance=RequestContext(request)) contactsform = ExcelTestUploadForm() return render_to_response('ureport/bulk_contact_upload_update.html', {'contactsform': contactsform}, context_instance=RequestContext(request))
def ureporters(request): access = get_access(request) print request.method message = '' if request.method == 'POST' and request.FILES: contactsform = ExcelTestUploadForm(request.POST, request.FILES) if contactsform.is_valid() and contactsform.good_file(): new_file = contactsform.cleaned_data fields = [ 'number', 'name', 'province', 'commune', 'colline', 'language', 'county', 'village', 'birthdate', 'group', 'gender', ] message = handle_excel_file_update(new_file['excel_file'], fields) print(message) messages.success(request, message) return HttpResponseRedirect("/reporter") else: return HttpResponse( content='The form is not valid. Resfresh this page') columns = [ ('Identifier', True, 'connection_pk', SimpleSorter()), ('Modile', True, 'mobile', SimpleSorter()), ( 'Age', True, 'age', SimpleSorter(), ), ( 'Gender', True, 'gender', SimpleSorter(), ), ( 'Language', True, 'language', SimpleSorter(), ), ( 'Province', True, 'province', SimpleSorter(), ), ( 'Group(s)', True, 'group', SimpleSorter(), ), ( 'Polls ', True, 'questions', SimpleSorter(), ), ( 'Responses ', True, 'responses', SimpleSorter(), ), ( 'Messages Sent', True, 'incoming', SimpleSorter(), ), # ('caregiver', True, 'is_caregiver', SimpleSorter(),), # ('join date', True, 'autoreg_join_date', SimpleSorter(),), # ('quit date', True, 'quit_date', SimpleSorter(),), ] queryset = get_contacts2(request=request) if access is not None: groups = ",".join(list(access.groups.values_list('name', flat=True))) queryset = queryset.filter(group__icontains=groups) return generic( request, model=UreportContact, queryset=get_contacts2, contactsform=ExcelTestUploadForm, message=message, results_title='uReporters', filter_forms=[ UreporterSearchForm, GenderFilterForm, AgeFilterForm, MultipleDistictFilterForm, FilterGroupsForm, FilterByGroupForm, FilterByLocationForm ], action_forms=[ MassTextForm, AssignGroupForm, BlacklistForm, AssignToNewPollForm, RemoveGroupForm, TemplateMessage, ExportToExcelForm ], objects_per_page=25, base_template='ureport/ureporters_base.html', partial_base='ureport/partials/contacts/partial_base.html', partial_row='ureport/partials/contacts/partial_row.html', paginator_template='ureport/partials/new_pagination.html', paginator_func=ureport_paginate, columns=columns, )
def ureporters(request): access = get_access(request) print request.method message='' if request.method == 'POST' and request.FILES: contactsform = ExcelTestUploadForm(request.POST, request.FILES) if contactsform.is_valid() and contactsform.good_file() : new_file = contactsform.cleaned_data fields = [ 'number', 'name', 'province', 'commune', 'colline', 'language', 'county', 'village', 'birthdate', 'group', 'gender', ] message = handle_excel_file_update(new_file['excel_file'], fields) print(message) messages.success(request, message ) return HttpResponseRedirect("/reporter") else: return HttpResponse(content='The form is not valid. Resfresh this page') columns = [ ('Identifier', True, 'connection_pk', SimpleSorter()), ('Modile', True, 'mobile', SimpleSorter()), ('Age', True, 'age', SimpleSorter(),), ('Gender', True, 'gender', SimpleSorter(),), ('Language', True, 'language',SimpleSorter(),), ('Province', True, 'province', SimpleSorter(),), ('Group(s)', True, 'group', SimpleSorter(),), ('Polls ', True, 'questions', SimpleSorter(),), ('Responses ', True, 'responses', SimpleSorter(),), ('Messages Sent', True, 'incoming', SimpleSorter(),), # ('caregiver', True, 'is_caregiver', SimpleSorter(),), # ('join date', True, 'autoreg_join_date', SimpleSorter(),), # ('quit date', True, 'quit_date', SimpleSorter(),), ] queryset = get_contacts2(request=request) if access is not None: groups = ",".join(list(access.groups.values_list('name', flat=True))) queryset = queryset.filter(group__icontains=groups) return generic(request, model=UreportContact, queryset=get_contacts2, contactsform=ExcelTestUploadForm, message=message, results_title='uReporters', filter_forms=[ UreporterSearchForm, GenderFilterForm, AgeFilterForm, MultipleDistictFilterForm, FilterGroupsForm, FilterByGroupForm, FilterByLocationForm ], action_forms=[MassTextForm, AssignGroupForm, BlacklistForm, AssignToNewPollForm,RemoveGroupForm,TemplateMessage , ExportToExcelForm], objects_per_page=25, base_template='ureport/ureporters_base.html', partial_base='ureport/partials/contacts/partial_base.html', partial_row='ureport/partials/contacts/partial_row.html', paginator_template='ureport/partials/new_pagination.html', paginator_func=ureport_paginate, columns=columns, )