Yeah, the unicode failing in the csv module is a pain. Every time I use it I wonder why they didn't just make it unicode friendly. They even have an example of the modifications to make it work with unicode in the docs. Why didn't they just make it work from the beginning?
Anyway, good to hear it is working for you! Alex On Wed, Nov 10, 2010 at 1:53 PM, 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]. >> > 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]. > 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.
