Hi there, I would also be interested in your script which imports spreadsheet data into Satchmo.
Would it be possible to share your script with me as well? Cheers, -Chris On Wed, Nov 10, 2010 at 11:53 AM, Sebastian Zwack < [email protected]> wrote: > My answer below had a little delay because this was my first post > which had to be verified. > > So basically I wrote a import script like you suggested. I used xlrd > (http://www.python-excel.org/) instead of the csv module as it handles > unicode out of the box. The Products and Categories show up correctly > so I guess it's working. > > Paul, if you want me to send the script just let me know. > > Regards > Sebastian > > On Nov 9, 3:11 pm, Alex Robbins <[email protected]> wrote: > > I don't think satchmo has anything specifically for this use case. > > However, you could use python's csv module. > > > > http://docs.python.org/library/csv.html#csv.DictReader > > > > Basically, the script would look like this: > > > > from csv import DictReader > > from product.models import Product > > > > reader = DictReader(open('products.csv')) > > for line in reader: > > Product.objects.create( > > #Setup the mapping between csv columns and satchmo product > > attributes here > > title=line['title'], > > slug=line['slug_field]' > > ... > > ) > > > > You'd probably want some error control and stuff like that, but that > > is the basic idea. > > > > Hope that helps, > > Alex > > > > > > > > > > > > > > > > On Mon, Nov 8, 2010 at 1:44 AM, Paul Walsh <[email protected]> wrote: > > > Hi, > > > > > I am a new Satchmo user (and a very very novice Django beginner) - > > > something that wasn't clear to me: > > > > > Is there a core module or an available extension to import data via > > > CSV? I saw the product_feeds extension module but it only seems to > > > deal with export. > > > > > If anyone can point me in the right direction that would be great! > > > > > Thanks, > > > > > Paul. > > > > > -- > > > You received this message because you are subscribed to the Google > Groups "Satchmo users" group. > > > To post to this group, send email to [email protected]. > > > To unsubscribe from this group, send email to > [email protected]<satchmo-users%[email protected]> > . > > > For more options, visit this group athttp:// > groups.google.com/group/satchmo-users?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "Satchmo users" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<satchmo-users%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/satchmo-users?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Satchmo users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/satchmo-users?hl=en.
