OpenERP 7, hacking
fields.property to
insert property_account_income and
property_account_expense to
product_template.
just a little concept you should know is about "fields.property", it is a function, so you can not inserting as commonly you do with xml-rpc, because you can not casting an object into it.
its very different with many2many connection, such as
taxes_id or
supplier_taxes_id, to set your product has it, just try setup one product and you can use a simple sql as below :
select * product_taxes_rel (product_id, tax_id)
the output
#1;1
#204;1
so you just need to run :
insert into product_taxes_rel(prod_id, tax_id) select id, '1' from product_template where id not in (1,204)
then
select * from product_supplier_taxes_rel
the output
#1;2
#204;2
you just need run :
insert into product_supplier_taxes_rel(prod_id, tax_id) select id, '2' from product_template where id not in (1,204)
well, lets back to inserting property, to inserting those properties, you need try setup one product, then look out on your database, it seem as below :
select * from ir_property where name in ('property_account_income', 'property_account_expense')
the output
27;1;"2013-02-05 14:27:05.3211";"2013-02-05 14:27:05.3211";1;"";;"property_account_expense";;"many2one";1;1940;"";"";"account.account,307";"product.template,1"
28;1;"2013-02-05 14:27:05.3211";"2013-02-05 14:27:05.3211";1;"";;"property_account_income";;"many2one";1;1938;"";"";"account.account,308";"product.template,1"
there are two ways to inserting
A. Direct SQL.
- you need to create simple hack_property.py
- run it and cast the output to sql-file, just like python hack_property.py > sql-file.sql
- run the sql
here is the example of hack_propery.py
import xmlrpclib
username = "username"
pwd = "password"
dbname = "yourdb"
sock_common = xmlrpclib.ServerProxy("http://localhost:8069/xmlrpc/common")
uid = sock_common.login(dbname, username, pwd)
sock = xmlrpclib.ServerProxy("http://localhost:8069/xmlrpc/object")
results = sock.execute(dbname, uid, pwd, 'product.template', 'search', [])
for i in results:
sql = """ insert into ir_property (create_uid, create_date, write_date, write_uid, name, type, company_id, fields_id, value_reference, res_id) select '1', LOCALTIMESTAMP, LOCALTIMESTAMP,'1', 'property_account_expense', 'many2one', '1', '1940', 'account.account,307', 'product.template,"""
sql = sql + str(i) + "';"
print sql
sql = """ insert into ir_property (create_uid, create_date, write_date, write_uid, name, type, company_id, fields_id, value_reference, res_id) select '1', LOCALTIMESTAMP, LOCALTIMESTAMP,'1', 'property_account_income', 'many2one', '1', '1938', 'account.account,308', 'product.template,"""
sql = sql + str(i) + "';"
print sql
your sql-file should be like this :
insert into ir_property (create_uid, create_date, write_date, write_uid, name, type, company_id, fields_id, value_reference, res_id) select '1', LOCALTIMESTAMP, LOCALTIMESTAMP,'1', 'property_account_expense', 'many2one', '1', '1940', 'account.account,307', 'product.template,1';
insert into ir_property (create_uid, create_date, write_date, write_uid, name, type, company_id, fields_id, value_reference, res_id) select '1', LOCALTIMESTAMP, LOCALTIMESTAMP,'1', 'property_account_income', 'many2one', '1', '1938', 'account.account,308', 'product.template,1';
insert into ir_property (create_uid, create_date, write_date, write_uid, name, type, company_id, fields_id, value_reference, res_id) select '1', LOCALTIMESTAMP, LOCALTIMESTAMP,'1', 'property_account_expense', 'many2one', '1', '1940', 'account.account,307', 'product.template,2';
insert into ir_property (create_uid, create_date, write_date, write_uid, name, type, company_id, fields_id, value_reference, res_id) select '1', LOCALTIMESTAMP, LOCALTIMESTAMP,'1', 'property_account_income', 'many2one', '1', '1938', 'account.account,308', 'product.template,2';
B. Pure xml-rpc
in this step, you need to look the structure of fields.property, you need to copy this creation style
prop = obj.pool.get('ir.property')
return prop.create(cr, uid, {
'name': propdef.name,
'value': id_val,
'res_id': obj._name+','+str(id),
'company_id': cid,
'fields_id': def_id,
'type': self._type,
}, context=context)
thats all, its already update thousands data of mine... :D
after running those script, you will see that all of product are proper now..
