Hi Francois - there is no script for parsing. I'm importing CSV files right into the database through the import function in myphpadmin. I've populated the following tables:
product_price product_product product_productpricelookup product_product_category the items are not showing in the /admin list area for satchmo. this really could be a general question and not a satchmo specific one. What could cause items in the database to NOT show up in the / admin area via list or search? On Nov 18, 5:06 am, Francois Verbeek <franc...@verbeek.name> wrote: > 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 > athttp://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=.
