Re: Django Excel Import Data Help

Thanks for your reply. My excel column headers are the same as my model field names but i am still getting the error as seen.

On Tuesday, July 23, 2019 at 10:28:09 PM UTC+8, sachinbg sachin wrote:

If ur dumping the data from exel make prepare as per ur database table ur exel headings should be as table name check in models then migrate and make migrate it will work

On Tue, Jul 23, 2019, 5:04 PM Jasmine Chua <babym...@gmail.com> wrote:

Hi,

I am struggling to correctly map my Excel data tab of CaseSummary to my CaseSummary model using Django-Excel. I am getting the error that CaseSummary does not match any given models when it should match my CaseSummary model. I have no problem previously in uploading data from a single tab spreadsheet to a single model without any foreign keys or relationships to other models. However, my objective is to upload a spreadsheet containing multiple tabs of data and my models have foreign keys, one-to-one and many-to-many fields too. However, i cannot seem to find good documentation online about how to do this. i really hope to receive some tips from this mailing list as i have been banging my head against the wall on this one. I look forward to hear from you guys. Thank you very much in advance! 

More details below. 

Error message screenshot while uploading my Excel Spreadsheet:

Screenshot of my CaseSummary tab in my spreadsheet. Fictitious data.

My CaseSummary Model

I am running Python version 2.2.2, Django version 3.7.3 and Django-Excel 0.0.10. 

While reading the documentation at Django-Excel page (http://django.pyexcel.org/en/latest/), i am not sure if i understand choice_func function correctly. I understand the reason why choice_func is required because it has a foreign key to Question and its Question column has to be translate to a Question instance. However, i am guessing that the argument "row" when parsed into choice_func refers to a row of data from Choice data tab in the sample-data.xlsx and row[0] refers to the first column of Choice tab whose values are e.g. 'ide'. Am i correct? 

        def choice_func(row):              q = Question.objects.filter(slug=row[0])[0]              row[0] = q              return row

--
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...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/e8b0cc85-517b-4452-b856-2c4ff14b8019%40googlegroups.com.

--
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/a8b451bf-6154-4185-af14-6c5a778bc764%40googlegroups.com.