Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Бухоблік
Склад
PoS
Проект
MRP

All apps

All Posts Люди Значки

Мітки (View all)

odoo accounting v14 pos v15

Про цей форум

Допомога

Create product using XMLRPC - PHP, issue with public_categ_ids

php xmlrpc many2many

2 Відповіді

11959 Переглядів

Fred Cruypenninck

Hi there,

I'm coding a small interface synchronisation between Odoo V9 and other ERP. Everything is working fine except for the public category ids.

Here's my field:

$fields = array( 'name' => 'test', 'default_code' => '1111', 'public_categ_ids' => array( 81 ) );
$odoo->create_product('product.product', $fields);
public function create_product($model, $fields){
$create = $this->ripcord_models->execute_kw($this->db, $this->uid, $this->password, $model, 'create', array( $fields )) ;
}

And here's the result (using xmlrpc debug):

DEBUG? openerp.http.rpc.request: 'name': 'test',

DEBUG? openerp.http.rpc.request: 'default_code': '1111',

DEBUG? openerp.http.rpc.request: 'public_categ_ids': [81],

All other fields are correctly set (name, default_code, etc.) but not the public_categ_ids and i don't have any error....

Do someone has any clue for me?

Thank you

Jérémy Kersten (jke)

Take a look here: https://www.odoo.com/documentation/8.0/reference/orm.html#openerp.models.Model.write

Have you try something like 'public_categ_ids' => array(array(6,0, array( 81 ))) that should generate the equivalent of ( 'public_categ_ids' = [(6, 0, [81])] )


    $url = "http://127.0.0.1:8069";
    $db = "8.0-debug";
    $username = "admin";
    $password = "admin";
    require_once('ripcord.php');
    $common = ripcord::client("$url/xmlrpc/2/common");
    $uid = $common->authenticate($db, $username, $password, array());
    $models = ripcord::client("$url/xmlrpc/2/object");
    $vals = array(
                array( 
                    'name' => 'test', 
                    'default_code' => '1111', 
                    'public_categ_ids' =>  array(
                        array(6,0, array(1))
                    )
                )
            );
    $create = $models->execute_kw($db, $uid, $password,
        'product.product', 'create', $vals
    );
    echo $create;

Fred Cruypenninck

Автор

Jérémy... I tried... it works!!! it seems exactly similar to my code... anyway... THANK YOU! If you participate to the 2016 odoo days, i'll offer you a good beer :)

Jérémy Kersten (jke)

Sure, I will be there :) thank you

Fred Cruypenninck

Автор

Hi Jérémy,

Thx for your reply.

I tried with...

'public_categ_ids' => array( array( 0,0, array( 81 ) ) ), error => cannot convert dictionary update sequence element #0 to a sequence

'public_categ_ids' => array( 0,0, array( 81 ) ), no error, not working

'public_categ_ids' => array( 6,0, array( 81 ) ), no error, not working

ps. i'm trying to create, not to update products

Jérémy Kersten (jke)

can you provide simplified php code to regenerate the issue in local ... that will be faster... And what is 81 ? the id of an existing product category ? so it should be 6 ...

Jérémy Kersten (jke)

Take a look in my previous answer, I have updated with a example which works !

Fred Cruypenninck

Автор

Here you can browse my code: https://bitbucket.org/sp4tz/odoo-sync/src I simplyfied it a bit, so you wont have the ERP source part...

Jérémy Kersten (jke)

Have you try me code from previous answer ?
'public_categ_ids' => array(array(6,0, array( 81 ))) should works !

'cannot convert dictionary update sequence element' was because you try 0 instead of 6 ! 0 take a dict and not a list of id :)

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Реєстрація

Related Posts	Відповіді	Переглядів
XMLRPC WITH PHP php xmlrpc	0 бер. 18	4967
Openerp xmlrpc PHP insert into re.users with company_id php xmlrpc	2 бер. 15	11339
How to identify record is created from xmlrpc script(php) when create method overrite php xmlrpc	1 бер. 15	8569
PHP Ripcord UnicodeEncodeError on Read php xmlrpc utf8	1 січ. 23	5771
How to find out the table name for a many2many relation (Where is the many2many table name stored?) Вирішено orm xmlrpc many2many	4 жовт. 21	25233

Це запитання позначене

Enjoying the discussion? Don't just read, join in!