what's your model like? What's your import script like? What's your sheet like? We need an idea of what you're trying to do before we can help.
I've personally always preferred writing a parser for the xls file (usually in csv form instead of xls, though) and directly create/use/save the model objects to populate the database instead of accessing the tables directly. If you really want to make your life difficult or need exotic parsing of the file (like multiple sheets, non-linear parsing, etc.) , using a win32com connexion to Excel and generating a python script -- that would contain your data-- can work. Francois ----- Original Message ----- From: "Bobby Roberts" <tchend...@gmail.com> To: "Django users" <django-users@googlegroups.com> Sent: Tuesday, 17 November, 2009 9:19:21 PM Subject: bulk product import to satchmo I've posted this on the satchmo group but i'm not getting any love so I wanted to post it here to see if anyone has done what i'm trying to do. My client has about 3500 products in an excel spreadsheet and i'm trying to at least import as much product data as possible so that he doesn't have to hand type all of this stuff again. I've got the product_product table populated but there are no products listed on the product listing page in the admin so he can edit the items. This leads me to believe that there are other tables which need to be populated in order for the items to show up on the listing page. Has anyone ever done bulk importing from csv successfully? If so, what fields are required to get it to show up in the /admin listing page? -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=. -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=.
