#django

fub: text fields in particular should not use null=True

okay, because then django import-export fails

(with an empty field)

fub: as i said before: fix your import, not your models.

ok, so then I will write some custom import method.

question for this: what in your experience is easier to work with, a CSV import or an EXCEL import? Because I can tell my import users to convert to CSV before

I just have to work around the strange excel to csv export mess

pandas can be useful for importing excel

ok

moldy: thanks for your help. any article suggestion with a starting point?

probably the pandas doc

moldy: I mean regarding the admin import

or maybe openpyxl instead

I looked at a few things, but most of them explained how to add somethign to the action dropdown

fub: read the django-import-export docs to see how to fix the NULL problem

it's probably easier than you think. showing us the code might also help.

moldy: http://dpaste.com/3BDXW24

you can ignore the CustomImportForm for now, as you can see I commented it out in L47-50. I had hoped to let the user using the import form is able to "overwrite" the organization, but I fought hours with this and then gave up.

but this is another problem

the not-null constraint for example fails for the postcode field

fub: tell django-import-export to pass "" instead of None for empty values

https://django-import-export.readthedocs.io/en/... i guess `default` is it

btw, that get_instance() method looks weird

moldy: I had to use this because otherwise I get an error because of the "id" (pk, auto inc field) fails

this get_instance() tells its a new record, so an id is created

hmm, sounds weird

moldy: indeed, but I did not find a better workaround.

i am pretty sure you are doing something wrong somewhere to cause that problem in the first place. full traceback might help.

https://django-import-export.readthedocs.io/en/... doesn't say you need to override get_instance()

moldy: http://dpaste.com/230GVAN

fub: i guess that is because you have `id` in exclude?

moldy: when I remove it, the error is slightly different: http://dpaste.com/07YA1AW

but it comes again to a keyerror

fub: is the import supposed to *only* create new records, or to also update existing ones?

moldy: only import

(create new records)

ok, in that case i guess you can keep the get_instance() override

your users will need to be careful not to create lots of duplicate records

your Customer model has no unique field except for `id`. if someone imports a file with 10 customers 5 times, you will end up with 50 customer records

yeah, thats why I only want this functionality in the admin panel

so only admin knowing how this works can use it

moldy: coming back to the organization field, do you have any idea how I can make this field selectable in the form?

I manage to show this field in the form, but its not correctly used to set this field for all values

*to set this selected value from the form for all imported fields

how to mock test class all method

fub: not from the top of my head. will need custom code.

maybe create the ImportResource dynamically or such

moldy: ok

so my current problem is that when importing excel, it is trying to import like and endless amount of empty rows at the end

which ofc fails because of constraints

well, insert some check for empty rows and just skip them

moldy: can you point me to where to add checks? is it in import_data() ?

fub: don't know from the top of my head, sorry.

check https://django-import-export.readthedocs.io/en/...

can i have some quick question?

yes

hello

Hello, can someone tell me if there is any other django community and support platform aside from the google groups mailing list?

irc. Those are two official support channels.

@jtiai, you mean this channel and a second one?

There is no second one. only this. and the mailinglist.

Kejra: and there is professional support

ah ok, I was looking for something like a forum, unfortunate that there is not...

stackoverflow has lots of django entries.

Of course using stackoverflow requires that you really know which answers are valid... :)

Lots of *solved* django entries. =P