datatime should be NULL not '000-00-00 00:00:00'
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenERP Connector - Magento |
Fix Released
|
Low
|
Unassigned |
Bug Description
Ubuntu 12.04, Postgres 9.1, OpenERP Version 7.0-20130806-231058
Magento connector from c2c restricted area updated today. Installed according to instruction from magentoerpconnect. I didn't check instruction for Magento side. It was installed by someone else.
It is big db of Magento used before in pair of OpenERP 6.0-Magento 1.5
Now Magento db migrated to 1.7.
OpenERP db migrated by OpenERP to 7.0.
I try to import data from Magento 1.7.
I tried to import Customers Groups - Success.
Import of Customers - no success - I iwll make another bug report.
Import of Products categories - no success - I will make another bug report
but
When I tried to import products I see that 5 Product Categories were imported from Magento (now not 100% sure if it was partial success of Product Categories import or Categories were imported together wit Products.)
Import of Product - just 1 imported. For all the rest (few thousends) I see following bug report:
Task openerp.
Traceback (most recent call last): File "/home/
Related branches
- Guewen Baconnier @ Camptocamp: Approve
- Jan-Philipp Fischer (community): Needs Resubmitting
-
Diff: 58 lines (+34/-2)2 files modifiedmagentoerpconnect/product.py (+3/-2)
magentoerpconnect/unit/mapper.py (+31/-0)
information type: | Embargoed → Public |
affects: | openerp-connector → openerp-connector-magento |
Changed in openerp-connector-magento: | |
status: | Confirmed → Fix Committed |
Changed in openerp-connector-magento: | |
status: | Fix Committed → Won't Fix |
status: | Won't Fix → Fix Released |
OpenERP log looks like:
2013-08-09 10:51:19,846 2965 DEBUG v70_ff_ 20130807_ migrated_ 01 openerp. addons. connector. unit.mapper: converting record {'ff_vegan': None, 'msrp_enabled': None, 'type_id': 'simple', 'ff_wein_land': None, 'ff_laktosefrei': None, 'sku': '1002433a', 'ff_auf_ startseite' : None, 'ff_bio': None, 'custom_design_to': None, 'meta_title': 'NIVEA Shampoo for Men Strong Power', 'fett_gesaettigt': None, 'news_to_date': None, 'format': '331', 'tier_price': [], 'kalorien': None, 'categories': ['353'], 'ff_flugobst': None, 'name': 'NIVEA Shampoo for Men Strong Power', 'set': '9', 'options_ container' : 'container2', 'cost': '1.8300', 'ff_gp_einheit': 'ml', 'meta_description': 'NIVEA Shampoo for Men Strong Power, Schampoo', 'msrp_display_ actual_ price_type' : None, 'is_imported': None, 'tax_class_id': '1', 'deposit_ helper_ isdeposit' : None, 'ff_regional': None, 'rebsorte': None, 'enable_ googlecheckout' : '1', 'special_price': None, 'geschmack': None, 'manufacturer': None, 'delivery_time': None, 'required_options': '0', 'product_id': '897', 'region': None, 'ff_von_hier': None, 'generate_meta': '0', 'ff_glutenfrei': None, 'produktbezeich nung': None, 'small_ image_label' : 'NIVEA Shampoo for Men Strong Power 250ml', 'ff_naturland_neu': None, 'thumbnail_label': 'NIVEA Shampoo for Men Strong Power 250ml', 'url_key': 'nivea- shampoo- for-men- strong- power', 'group_price': [], 'page_layout': None, 'minimal_price': None, 'gift_message_ available' : None, 'type': 'simple', 'news_from_date': None, 'visibility': '4', 'ff_jahrgang': None, 'recurring_ profile' : None, 'is_recurring': None, 'eiweiss': None, 'custom_ design_ from': None, 'msrp': None, 'image_label': 'NIVEA Shampoo for Men Strong Power 250ml', 'updated_at': '2013-01-05 18:16:34', 'websites': ['1'], 'kohlenhydrate': None, 'fett': None, 'country_ of_manufacture' : None, 'ff_bioland': None, 'meta_keyword': 'NIVEA Shampoo for Men Strong Power, Schampoo', 'custom_ layout_ update' : None, 'short_ description' : 'NIVEA - for Men Strong Power', 'ff_grundpreis': u'250 ml (100 ml = 1,32 \u20ac)', 'ff_demeter': None, 'status': '1', 'balaststoffe': None, 'description': u'Das Strong Power For Men Shampoo st\xe4rkt das Haar messbar, ist f\xfcr die t\xe4gliche Haarw\xe4sche geeignet.', 'old_id': None, 'price': '3.2900', 'deposit_ helper_ sku': None, 'zucker': None, 'ff_inhaltsstoffe': None, 'url_path': 'nivea- shampoo- for-men- strong- power.html' , 'typ': None, 'created_at': '0000-00-00 00:00:00', 'ff_fairtrade': None, 'special_ from_date' : None, 'product_ ingredients' : None, 'special_to_date': None, 'custom_design': None, 'has_options': '0'} to model magento. product. product 20130807_ migrated_ 01 openerp.sql_db: bad query: insert into "magento_ product_ product" (id,openerp_ id,"updated_ at","backend_ id","created_ at","backorders ","manage_ stock", "product_ type"," magento_ id",create_ uid,create_ date,write_ uid,write_ date) values (1106,7530, '2013-01- 05 18:16:34' ,1,'0000- 00-00 00:00:00' ,'use_default' ,'use_default' ,'simple' ,'897', 1,(now( ) at time zone 'UTC'),1,(now() at time zone 'UTC')) gg/openerp- server- 7.0/openerp/ sql_db. py", line 226, in execute
2013-08-09 10:51:20,228 2965 ERROR v70_ff_
Traceback (most recent call last):
File "/home/
re...