Re: Django Excel Import Data Help

2019-07-23 Thread Jasmine Chua
Sorry may I trouble you to please spell your sentence properly? I am having difficulty understanding what i should check for in terms of case sensitivity. I suspect that the problem lies in my functions when importing the data into my Models because certain fields are foreign keys i need to imp

Re: Django Excel Import Data Help

2019-07-23 Thread Jasmine Chua
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 shoul

Excel Import Generic Relations

2011-10-23 Thread stephenstubbs
We have created an excel import application called cute_import at https://bitbucket.org/darrenma/django-cuteimport which is able to create and update records based on an excel spreadsheet. This works well for one model currently. Currently it imports foreign keys based on how they are matched up

Re: excel import

2007-05-14 Thread schmidg
Hello! I import Excel files with pyExcelerator http://sourceforge.net/projects/pyexcelerator It works well with multiple sheets and supports all formats up to office 2003. Yours, Guillaume. On Mon, 2007-05-14 at 06:00 -0400, Todd O'Bryan wrote: > Check out Xlrd. It will import Excel files and

Re: excel import

2007-05-14 Thread Todd O'Bryan
Check out Xlrd. It will import Excel files and change them into a list of lists. http://cheeseshop.python.org/pypi/xlrd/0.5.2 Todd On Mon, 2007-05-14 at 11:25 +0200, Aidas Bendoraitis wrote: > Hello, Dmitry! > > You could save the excel sheet as comma separated values and then read > and parse

Re: excel import

2007-05-14 Thread Aidas Bendoraitis
Hello, Dmitry! You could save the excel sheet as comma separated values and then read and parse them line-by-line using python. For each category (which is one of the columns) you can get_or_create a category record in the database and assign that as a foreign key or many to many relationship to

excel import

2007-05-11 Thread [EMAIL PROTECTED]
Hello, everyone! I want to implement some sort of importing data into my database from excel. And i have a problem: this xls tables are huge and needs to be normalized to relation structure, in other words i want to torn one excel table to many with FK relationships between them, but i dunno how