You have got this. According to the source <https://github.com/stephenmcd/cartridge/blob/master/cartridge/shop/management/commands/product_db.py#L146>, the file needs to be comma-delimited, not tab-delimited.
On Tue, Aug 5, 2014 at 8:56 AM, Stevo <[email protected]> wrote: > > I ran that product_db command with --export and it coughed up a .csv file > full of magic ponies. I tried to make my upload file the same, but when I > ran the command with --import, I got this: > > (mezzcart)hobbo5424@hobbo5424-Inspiron-N4050 ~/mezzcart/proj1 $ python > manage.py product_db --import produpload3.csv > /home/hobbo5424/mezzcart/local/lib/python2.7/site-packages/mezzanine/utils/conf.py:92: > UserWarning: mezzanine.pages.context_processors.page is required in the > TEMPLATE_CONTEXT_PROCESSORS setting. Adding it now, but you should update > settings.py to explicitly include it. > "explicitly include it." % cp) > Importing .. > {'Title\tContent\tDescription\tCategory\tSub-Category\tSKU\tImage\tNumber > in Stock\tUnit Price\tSale Price\tSale Start Date\tSale Start Time\tSale > End Date\tSale End Time': 'Old Boot\t<p>This brown leather foot covering > will keep your feet warm</p>\t<p>Light tan in colour and buffed to > perfection</p>\tShop\t\t13\tproduct/red.png\t2\t50\t5\t\t\t\t'} > Traceback (most recent call last): > File "manage.py", line 29, in <module> > execute_from_command_line(sys.argv) > File > "/home/hobbo5424/mezzcart/local/lib/python2.7/site-packages/django/core/management/__init__.py", > line 399, in execute_from_command_line > utility.execute() > File > "/home/hobbo5424/mezzcart/local/lib/python2.7/site-packages/django/core/management/__init__.py", > line 392, in execute > self.fetch_command(subcommand).run_from_argv(self.argv) > File > "/home/hobbo5424/mezzcart/local/lib/python2.7/site-packages/django/core/management/base.py", > line 242, in run_from_argv > self.execute(*args, **options.__dict__) > File > "/home/hobbo5424/mezzcart/local/lib/python2.7/site-packages/django/core/management/base.py", > line 285, in execute > output = self.handle(*args, **options) > File > "/home/hobbo5424/mezzcart/local/lib/python2.7/site-packages/cartridge/shop/management/commands/product_db.py", > line 94, in handle > import_products(csv_file) > File > "/home/hobbo5424/mezzcart/local/lib/python2.7/site-packages/cartridge/shop/management/commands/product_db.py", > line 149, in import_products > product = _product_from_row(row) > File > "/home/hobbo5424/mezzcart/local/lib/python2.7/site-packages/cartridge/shop/management/commands/product_db.py", > line 100, in _product_from_row > product, created = Product.objects.get_or_create(title=row[TITLE]) > KeyError: u'Title' > > This is the same error I got when I tried to import it the first time > before I did the export, so I don't think it's a fault in the text file. I > keep reading nin's answer, but there's no customisation and I made the > column headers the same as those from the export output. > > So what's my problem? And what's the limit on dumb questions? C'mon we can > do this!!!! > > Best Regards, > > > > On Tuesday, August 5, 2014 1:25:53 PM UTC+10, Stevo wrote: > >> Ahhh now I get it - thank you! And thanks for those tute links - >> exactly what I need right now. The help this group has given is awesome. >> Regards to all! >> >> On Tuesday, August 5, 2014 1:53:24 AM UTC+10, [email protected] wrote: >> >>> Stevo, >>> >>> From your mezzanine project directory, >>> >>> ./manage.py product_db --import <datafile> >>> >>> where datafile is a tab delimited text file. If you have customized the >>> product table, you need to do same to product_db and make sure the column >>> names the same as the text file with your datafile... >>> >>> It's best to test it inside virtualenv. >>> >>> On Monday, August 4, 2014 7:43:56 AM UTC-5, Stevo wrote: >>>> >>>> Hi Ken, I think you got that right, coz when I tried again my error was >>>> different: >>>> >>>> File "/home/hobbo5424/mezzcart/local/lib/python2.7/site- >>>> packages/django/conf/__init__.py", line 47, in _setup >>>> % (desc, ENVIRONMENT_VARIABLE)) >>>> django.core.exceptions.ImproperlyConfigured: Requested setting >>>> INSTALLED_APPS, but settings are not configured. You must either define the >>>> environment variable DJANGO_SETTINGS_MODULE or call settings.configure() >>>> before accessing settings. >>>> >>>> If you could suggest a way to set it up properly, I'd be happy to start >>>> over again - I haven't done any real work on the site yet. At this stage, I >>>> just need to prove it can be done (by me at least). >>>> What is supposed to happen when you run product_db.py? I can't see >>>> where or how it would find a .csv file to upload. >>>> Martin suggested "playing around with Cartridge api within a shell to >>>> play around with the product database." I don't know how to do that either. >>>> Sorry to ask dumb questions, but Ryan said to keep trying and not give >>>> up. >>>> Cheers and thanks! >>>> >>>> >>>> On Sunday, August 3, 2014 10:20:41 PM UTC+10, Kenneth Bolton wrote: >>>>> >>>>> sounds like you are running the script possibly with the wrong python, >>>>> e.g. without your virtualenv activated. >>>>> >>>>> ken >>>>> >>>>> >>>>> On Sun, Aug 3, 2014 at 6:57 AM, Stevo <[email protected]> wrote: >>>>> >>>>>> Thanks Ryan! - I tried to run the script from: >>>>>> myproject/lib/python2.7/site-packages/cartridge/shop/ >>>>>> management/commands/product_db.py >>>>>> but got an ImportError: No module name mezzanine.conf >>>>>> I couldn't find anything in the Cartridge docs or in Mezzanine. So is >>>>>> it in Django documentation? >>>>>> Please, could you give me a couple more hints and/or tell me where to >>>>>> go for more info on what to do? >>>>>> I passed my python MOOC so I've got plenty of time on my hands now. >>>>>> Haha! >>>>>> Regards, Stevo >>>>>> >>>>>> >>>>>> On Saturday, August 2, 2014 12:54:26 AM UTC+10, Ryan Sadwick wrote: >>>>>>> >>>>>>> I recently made a script that calls Amazon's product api and inserts >>>>>>> into cartridge for an affiliate mash up site. I based the script off of >>>>>>> what Stephen linked earlier and the mezz/cartirdge chart: >>>>>>> http://cartridge.jupo.org/_images/graph.png. The most products >>>>>>> I've inserted at one time has been around 100 since I'm hand picking the >>>>>>> products and I loop through a list of item numbers that call the script >>>>>>> to >>>>>>> insert into cartridge. >>>>>>> >>>>>>> I didn't run into any problems, everything works - ratings, images, >>>>>>> categories. I'd suggestion playing around with Cartridge api within a >>>>>>> shell to play around with the product database. >>>>>>> >>>>>>> I'd suggest to keep at it and don't give up. >>>>>>> >>>>>>> Ryan >>>>>>> >>>>>>> On Wednesday, July 30, 2014 9:35:35 PM UTC-4, Stevo wrote: >>>>>>>> >>>>>>>> My biggest product feed is JSON and has 20k skus and gets updated >>>>>>>> every 2 weeks. Other files are .csv, and only 3-4k skus, updated every >>>>>>>> 2 >>>>>>>> months or so. >>>>>>>> My main needs are: a) quoting tool to guide/train/remind the user >>>>>>>> on the process and options in quoting complex product bundles b) large >>>>>>>> number of products with lots of attributes c) speed for about 20 >>>>>>>> users, >>>>>>>> and d) easy coding to suit my high-level noobosity. >>>>>>>> All I've tried so far is doing Dr Chuck's Python Course >>>>>>>> <https://www.coursera.org/course/pythonlearn>, the Django tute >>>>>>>> <https://docs.djangoproject.com/en/1.7/intro/tutorial01/>, Ross >>>>>>>> Laird's tutes >>>>>>>> <http://www.rosslaird.com/blog/first-steps-with-mezzanine/> and >>>>>>>> installing Mezzanine <http://mezzanine.jupo.org/> and trying out >>>>>>>> python-docx <https://python-docx.readthedocs.org/en/latest/> (How >>>>>>>> cool is that gizmo?) >>>>>>>> Like Mike, I love Mezzanine "out-of-the-box" plus its >>>>>>>> not-insurmountable learning curve. I've had a look at OpenERP, Magento, >>>>>>>> SugarCRM and vTiger and a few others. They all do a great job, but the >>>>>>>> complexity of all that functionality is a problem for a web-admin >>>>>>>> person in >>>>>>>> a team of one, like me. So maybe it's better to do a bit of coding to >>>>>>>> get >>>>>>>> one app to do more, rather than manage three apps from the admin >>>>>>>> interface >>>>>>>> and try to get them to talk to each other. >>>>>>>> My thinking is to use Mezzanine as a kind of "intranet-hub" to >>>>>>>> other apps, like the quoting tool. Or actually use Mezzanine and >>>>>>>> Cartridge >>>>>>>> to do the quoting tool itself. So I was just hoping for some advice >>>>>>>> before >>>>>>>> I get started. So if you think it not a dumb idea, I'll try Sam's Way >>>>>>>> first >>>>>>>> and report back when I've got some results. >>>>>>>> Best regards Ken et al, and many thanks for the prompt advice. >>>>>>>> Stevo. >>>>>>>> >>>>>>>> On Wednesday, July 30, 2014 11:43:29 PM UTC+10, Kenneth Bolton >>>>>>>> wrote: >>>>>>>>> >>>>>>>>> What have you tried? What form do you currently have those "at >>>>>>>>> least 20,000 products" in? >>>>>>>>> >>>>>>>>> The management command Stephen wrote about still works, afaik. And >>>>>>>>> Sam's technique is a tried-and-true method of bulk-inserting complex >>>>>>>>> data >>>>>>>>> into Django already in use within Cartridge. >>>>>>>>> >>>>>>>>> ken >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> On Wed, Jul 30, 2014 at 8:36 AM, Stevo <[email protected]> wrote: >>>>>>>>> >>>>>>>>>> Is there any chance of an update on this issue? I'd really love >>>>>>>>>> to use Mezzanine rather than Magento, but I have to load up at least >>>>>>>>>> 20,000 >>>>>>>>>> products. I was hoping to use Cartridge as the foundation to allow >>>>>>>>>> users to >>>>>>>>>> do quite complex quotes and proposals and output them using >>>>>>>>>> python-docx. Or >>>>>>>>>> is this out of scope for Mezzanine? Any advice appreciated. >>>>>>>>>> Regards. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Monday, February 25, 2013 2:26:26 PM UTC+11, Martin Hickey >>>>>>>>>> wrote: >>>>>>>>>>> >>>>>>>>>>> I am non-programmer, but I have launched a number of Mezzanine >>>>>>>>>>> sites. I love the framework and am looking forward to learning more. >>>>>>>>>>> >>>>>>>>>>> I am beginning to play around with a concept that would require >>>>>>>>>>> Cartridge. I have gone through the documentation, but I am sure >>>>>>>>>>> that it is >>>>>>>>>>> possible I missed it. Is there a way to bulk upload products into >>>>>>>>>>> Cartridge. I have considered integrating something like >>>>>>>>>>> django-feedmapper, >>>>>>>>>>> but sure would love to avoid the time involved in a custom >>>>>>>>>>> integration. Can >>>>>>>>>>> you let me know if this is my best bet at this point? >>>>>>>>>>> >>>>>>>>>>> Thanks >>>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> You received this message because you are subscribed to the >>>>>>>>>> Google Groups "Mezzanine Users" group. >>>>>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>>>>> send an email to [email protected]. >>>>>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "Mezzanine Users" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to [email protected]. >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>> >>>>> -- > You received this message because you are subscribed to the Google Groups > "Mezzanine Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Mezzanine Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
