Mar 28, 2014

openerp 7 import csv

before you import your data (contact, product, invoice, sales order etc). You need to enable external identifier to make openerp recognize your data to be referred.

example :
you need to import product, which is have "manufacture_id" or "agent_id"  (refers to res_partner), to enable importing your data, you need to create external identifier.

see here :

openerp 7 import csv contact

then it automatically change the view base on your record_id


after this steps, you just need to create a simple excel formula to map your text-base-description to be external-identifier-format. (a simple vlookup)


you can see that you can use cust/id field  (its refers to res_partner)

thats all, hopefully useful 

.
before you import your data (contact, product, invoice, sales order etc). You need to enable external identifier to make openerp recognize your data to be referred.

example :
you need to import product, which is have "manufacture_id" or "agent_id"  (refers to res_partner), to enable importing your data, you need to create external identifier.

see here :

openerp 7 import csv contact

then it automatically change the view base on your record_id


after this steps, you just need to create a simple excel formula to map your text-base-description to be external-identifier-format. (a simple vlookup)


you can see that you can use cust/id field  (its refers to res_partner)

thats all, hopefully useful 

No comments:

Post a Comment