Tutorial create a new partner in openerp - nopri/sqliteboy GitHub Wiki

Tutorial: Create a new partner in OpenERP

In this tutorial, we will create a new partner in OpenERP, using SQLiteBoy form as frontend.

Please note that extended features must be activated.

(Tested: OpenERP 6.1.1 / Windows 7 32-bit)

  1. Create table: partner
    • number of columns: 2
    • table name: partner
    • columns:
      • id: integer primary key autoincrement
      • name: varchar
  2. Create form: add_partner
    • form name: add_partner
    • code:
{
      "title" : "Add Partner",
      "data"  : [
                  {
                    "table"     : "partner",
                    "column"    : "name",
                    "required"  : 1
                  }
                ],
      "message": ["Error: $result", "Error: $result", "OK, Partner ID: $python_handler"],
      "security" : {
                     "run" : ""
                   }
}
  1. Create sqliteboy_user.py file (if not exists) in current working directory. We are using python handler to talk to OpenERP server. Please add the following function:
def form_add_partner(user, db, parsed, form_data, data):
    import xmlrpclib
    #
    #please edit
    server = 'http://localhost:8069'
    server_common = '%s/xmlrpc/common' %(server)
    server_object = '%s/xmlrpc/object' %(server)
    user = 'admin'
    password = 'admin'
    db = 'test1'
    #
    #
    sock_common = xmlrpclib.ServerProxy(server_common)
    uid = sock_common.login(db, user, password)
    #
    sock_object = xmlrpclib.ServerProxy(server_object)
    fields = form_data[1]
    fields_name = fields.get('name')
    partner = {'name': fields_name}
    partner_id = sock_object.execute(
                db, 
                uid, 
                password, 
                'res.partner', 
                'create', 
                partner
    )
    #
    return partner_id
⚠️ **GitHub.com Fallback** ⚠️