Re: Import a float field using a script

Thanks for pointing me in the right direction.

I added a simple
try:
y = float(row[6])
except:
y = None
And changed the area_hectares=y, in my script.
Everything works fine now.

Best

> On 16 Oct 2019, at 12:20, Kasper Laudrup <laudrup@stacktrace.dk> wrote:
>
> Hi again,
>
> On 16/10/2019 13.02, 'David Turner' via Django users wrote:
>> Thanks for your response
>
> You're welcome.
>
>> I am using djjango-extensions to run the script. Everything imports fine except the one field. The Category, Region, County and Iso's are foreign keys to the property.
>> The data in the csv for the area_hectares does contain in some cases no data but the format for the data is:
>> 158.9265
>> 70
>> 58.9
>> 150
>> 7200000
>> 665.03
>
> Since no data is represented as an empty string you need to special case handle that so that gets converted to a NoneType instead.
>
> Instead of simply calling float(row[6]) in your import script (which will raise the ValueError exception on empty strings) a solution could be to write a small wrapper function that tests if the input argument is an empty string and returns None in that case, otherwise calls the float type converter as usual.
>
> That function should be trivial to write, but that's not the only solution of course.
>
> Thinking about, I'm not 100% sure that a nullable field in Django can be created with a NoneType (that will then set the type to Null), but I'm fairly certain. Someone please correct me if I'm wrong.
>
> Kind regards,
>
> Kasper Laudrup
>
> --
> You received this message because you are subscribed to a topic in the Google Groups "Django users" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/topic/django-users/vlHtz3JtsC0/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to django-users+unsubscribe@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/a7420722-8818-4c89-3eb7-4224c70dfc9d%40stacktrace.dk.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/1DE20C20-E9F5-4731-A1E1-4FBF787322CE%40googlemail.com.