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.
