Ejemplo n.º 1
0
 def save(self, commit=False, *args, **kwargs):
     records = csv.reader(self.cleaned_data["file"])
     for line in records:
         f = Facility()
         f.id = line[0]
         f.type = line[2]
         f.name = line[3]
         f.address = line[4]
         f.latitude = line[5]
         f.longitude = line[6]
         f.save()
Ejemplo n.º 2
0
 def save(self, commit=False, *args, **kwargs):
     records = csv.reader(self.cleaned_data["file"])
     for line in records:
         f = Facility()
         f.id = line[0]
         f.type = line[2]
         f.name = line[3]
         f.address = line[4]
         f.latitude = line[5]
         f.longitude = line[6]
         f.save()
Ejemplo n.º 3
0
def load(request):
    """Load documents from uploaded file."""
    form = FacilityImportForm
    if request.method == 'POST':
        # Accept the uploaded document data.
        file_data = None
        form = FacilityImportForm(request.POST, request.FILES)
        if form.is_valid():
            uploaded_file = request.FILES['file']
            if uploaded_file.multiple_chunks():
                file_data = open(uploaded_file.temporary_file_path(), 'r')
            else:
                file_data = uploaded_file.read()

        if file_data:
            f = StringIO.StringIO(file_data)
            reader = csv.DictReader(f)
            for row in reader:
                try:
                    data = {}
                    data['name'] = row['name']
                    data['address'] = row['address']
                    data['latest_score'] = row['score']
                    location = row['location']
                    parts = location.split("\n")
                    city_zip = parts[1].split(" ")
                    data['city'] = city_zip[0]
                    data['zip_code'] = city_zip[1]
                    lat_lng = parts[2].strip('()').split(", ")
                    if len(lat_lng) > 1:
                        data['latitude'] = lat_lng[0]
                        data['longitude'] = lat_lng[1]
                    facilities = Facility.objects.filter(
                        name=data['name'], address=data['address'])
                    facility = Facility()
                    if facilities:
                        facility = facilities[0]
                    for (key, value) in data.items():
                        setattr(facility, key, value)
                    facility.save()
                except:
                    pass
            # create a load object for the timestamp
            l = Load.objects.create()
            l.save()

    context = {
        'import_file_form': form,
    }
    return render_to_response('admin/inspections/load_data_form.html',
                              context,
                              context_instance=RequestContext(request))
Ejemplo n.º 4
0
def load(request):
    """Load documents from uploaded file."""
    form = FacilityImportForm
    if request.method == 'POST':
        # Accept the uploaded document data.
        file_data = None
        form = FacilityImportForm(request.POST, request.FILES)
        if form.is_valid():
            uploaded_file = request.FILES['file']
            if uploaded_file.multiple_chunks():
                file_data = open(uploaded_file.temporary_file_path(), 'r')
            else:
                file_data = uploaded_file.read()

        if file_data:
            f = StringIO.StringIO(file_data)
            reader = csv.DictReader(f)
            for row in reader:
                try:
                    data = {}
                    data['name'] = row['name']
                    data['address'] = row['address']
                    data['latest_score'] = row['score']
                    location = row['location']
                    parts = location.split("\n")
                    city_zip = parts[1].split(" ")
                    data['city'] = city_zip[0]
                    data['zip_code'] = city_zip[1]
                    lat_lng = parts[2].strip('()').split(", ")
                    if len(lat_lng) > 1:
                        data['latitude'] = lat_lng[0]
                        data['longitude'] = lat_lng[1]
                    facilities = Facility.objects.filter(name=data['name'],
                                                    address=data['address'])
                    facility = Facility()
                    if facilities:
                        facility = facilities[0]
                    for (key, value) in data.items():
                        setattr(facility, key, value)
                    facility.save()
                except:
                    pass
            # create a load object for the timestamp
            l = Load.objects.create()
            l.save()

    context = {'import_file_form': form, }
    return render_to_response('admin/inspections/load_data_form.html',
                              context,
                              context_instance=RequestContext(request))