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

CRM
e-Commerce
Knjigovodstvo
Zaloga
PoS
Projekt
MRP

All apps

All Posts People Badges

Ključne besede (View all)

odoo accounting v14 pos v15

About this forum

Pomoč

Create product using XMLRPC - PHP, issue with public_categ_ids

php xmlrpc many2many

2 Odgovori

11949 Prikazi

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

Avtor

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

Avtor

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

Avtor

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!

Prijavi

Related Posts	Odgovori	Prikazi
XMLRPC WITH PHP php xmlrpc	0 mar. 18	4961
Openerp xmlrpc PHP insert into re.users with company_id php xmlrpc	2 mar. 15	11332
How to identify record is created from xmlrpc script(php) when create method overrite php xmlrpc	1 mar. 15	8563
PHP Ripcord UnicodeEncodeError on Read php xmlrpc utf8	1 jan. 23	5763
How to find out the table name for a many2many relation (Where is the many2many table name stored?) Solved orm xmlrpc many2many	4 okt. 21	25225

This question has been flagged

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