在Django Admin中将csv数据导入数据库

在Django Admin中将csv数据导入数据库

经过长时间的搜索，我找到了答案：使用标准表单在管理员内部创建视图

形成：

class DataInput(forms.Form):    file = forms.FileField()    place = forms.ModelChoiceField(queryset=Place.objects.all())    def save(self):        records = csv.reader(self.cleaned_data["file"])        for line in records: input_data = Data() input_data.place = self.cleaned_data["place"] input_data.time = datetime.strptime(line[1], "%m/%d/%y %H:%M:%S") input_data.data_1 = line[2] input_data.data_2 = line[3] input_data.data_3 = line[4] input_data.save()

风景：

@staff_member_requireddef import(request):    if request.method == "POST":        form = DataInput(request.POST, request.FILES)        if form.is_valid(): form.save() success = True context = {"form": form, "success": success} return render_to_response("imported.html", context, context_instance=RequestContext(request))    else:        form = DataInput()     context = {"form": form}        return render_to_response("imported.html", context,        context_instance=RequestContext(request))