Re: Import csv file in admin

If you don't mind me asking, why do use ModelForm and not the ORM
directly? I'm just curious as using just a model (possibly wirh model
validation) seems like easies approach.

Cheers

Jirka

On 27/10/2010, Daniel Roseman <daniel@roseman.org.uk> wrote:
> On Oct 27, 4:27 am, Jorge <aldea.diagu...@gmail.com> wrote:
>> I'm trying to poblate a database with a csv file using the modelform
>> in Admin site. Here's the files:
>>
>> Models.py:
>>
>> class Data(models.Model):
>>         place = models.ForeignKey(Places)
>>         time = models.DateTimeField(blank=True)
>>         data_1 = models.DecimalField(max_digits=3, decimal_places=1,
>> blank=True)
>>         data_2 = models.DecimalField(max_digits=3, decimal_places=1,
>> blank=True)
>>         data_3 = models.DecimalField(max_digits=4, decimal_places=1,
>> blank=True)
>>
>> Forms.py:
>>
>> import csv
>> from datetime import datetime
>>
>> class DataInput(ModelForm):
>>     file = forms.FileField()
>>
>>     class Meta:
>>         model = Data
>>         fields = ("file", "place")
>>
>>     def save(self, commit=True, *args, **kwargs):
>>         form_input = super(DataInput, self).save(commit=False, *args,
>> **kwargs)
>>         self.place = self.cleaned_data['place']
>>         self.file = self.cleaned_data['file']
>>         records = csv.reader(self.file)
>>         for line in records:
>>             self.time = datetime.strptime(line[1], "%m/%d/%y %H:%M:
>> %S")
>>             self.data_1 = float(line[2])
>>             self.data_2 = float(line[3])
>>             self.data_3 = float(line[4])
>>             form_input.save()
>>
>> test.csv (it's only one line for test purposes, the real file has much
>> more lines):
>> 1,5/18/10 11:45:00,1.2,2.7,205.
>>
>> When i put the file got an IntegrityError: datas_data.time may not be
>> NULL ; and the problem is in Forms.py line: form_input.save()
>>
>> What i'm missing?!
>
> You're setting the values on `self` in the form's save method. In
> other words, you're setting them on the *form*, not the instance. You
> should be setting them on `form_instance`.
>
> Also, don't convert the decimals to float. Decimal accepts a string
> value, and converting to float will just introduce possible floating-
> point precision errors.
> --
> DR.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To post to this group, send email to django-users@googlegroups.com.
> To unsubscribe from this group, send email to
> django-users+unsubscribe@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/django-users?hl=en.
>
>

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.