Execute bulk updates in Odoo using Xmlrpc for multiple rows at once

Question

Execute bulk updates in Odoo using Xmlrpc for multiple rows at once

I need assistance updating multiple records of "sale.order.line" products in Odoo Xmlrpc.

for (let i = 0; i <sell.products.length; i ++) {                
          var inParams = [];
          inParams.push ([value1 [i]]);  //id to update
          inParams.push ({
            'name': sale.products [i] .name,
            'product_uom_qty': sales.products [i] .product_uom_qty,
            'price_unit': sales.products [i] .price_unit,
            'product_id': sales.products [i] .product_id
          });
          var params = [];
          params.push (inParams);
          db.execute_kw ('sale.order.line', 'write', params, function (err, value) {
            if (err) {
              return console.log (err);
            }
            return console.log ('Result2:', value);
          });
        }

The error message displayed is: raise psycopg2.OperationalError (msg) \ npsycopg2.OperationalError: Unable to use a closed cursor.

This operation is being carried out on Odoo version 12. Thank you for your help.

javascript odoo odoo-12

Answer 1

Answer №1

Appreciation for the assistance jo541

I managed to resolve the issue by updating odoo xmlrpc with odoo. The updated code is functioning perfectly:

`for (let i = 0; i <sale.products.length; i ++) {
     var params = {
               'name': 'Product #' + sale.products[i].product_id,
               'product_uom_qty': sale.products[i].product_uom_qty,
               'price_unit': sale.products[i].price_unit,
               'product_id': sale.products[i].product_id
     }
     odoo2.update ("sale.order.line", sale.products [i].id, params, function (err, value) {
               if (err) {
                 return console.log (err);
               }
               console.log (value);

    

     });
    };`

Answer 2

Appreciation for the assistance jo541

I managed to resolve the issue by updating odoo xmlrpc with odoo. The updated code is functioning perfectly:

`for (let i = 0; i <sale.products.length; i ++) {
     var params = {
               'name': 'Product #' + sale.products[i].product_id,
               'product_uom_qty': sale.products[i].product_uom_qty,
               'price_unit': sale.products[i].price_unit,
               'product_id': sale.products[i].product_id
     }
     odoo2.update ("sale.order.line", sale.products [i].id, params, function (err, value) {
               if (err) {
                 return console.log (err);
               }
               console.log (value);

    

     });
    };`

Answer 3

Answer №2

I encountered a similar issue where my Odoo server couldn't handle concurrent connections.

To resolve the problem, I implemented a mutex/lock to restrict simultaneous access to the API, resulting in smooth operation :-)

Below is some code for your reference :

import * as Odoo from "odoo-xmlrpc";
import AwaitLock from 'await-lock';

var odoo = new Odoo({
    url: "odooserver/xmlrpc/2",
    db: "databasename",
    username: "username",
    password: "password"
});

var lock = new AwaitLock();

const callOdoo = async (model, method, params) => {
  return new Promise(async (resolve, reject) => {
    odoo.connect(async (err) => {
      if (err) reject(new Error(err));
      await lock.acquireAsync();
      odoo.execute_kw(model, method, params, (err, value) => {
        lock.release();
        if (err) {
          reject(new Error(err));
        }
        console.log(value);
        resolve(value);
      });
    });
  });
}

async function getStockFromOdoo() {
  let items = await callOdoo(
    'product.product',
    'search_read',
    [
      [[['x_volume', '>=', '0.1']]],
      {'fields': ['x_beername', 'qty_available', 'x_volume', 'name', 'default_code']}
    ]
  );
  // Do something with items here.
}

async function getCustomers() {
  let items = await callOdoo(
    'res.partner',
    'search_read',
    [
      [[['is_company', '=', true],['customer', '=', true]]],
      {'fields': ['name']}
    ]);
  // Do something with items here
}

async function createSaleOrder(order){
  let orderId = await callOdoo(
    'sale.order',
    'create',
    [[{ partner_id: order.customer.id }]]
  );
  order.orders.forEach(async (line) => {
    await callOdoo(
      'sale.order.line',
      'create',
      [[{'order_id': orderId, 'product_id': line.beer.id, 'product_uom_qty': line.quantity}]]);
  });
  // do something with it here.
}

Answer 4

I encountered a similar issue where my Odoo server couldn't handle concurrent connections.

To resolve the problem, I implemented a mutex/lock to restrict simultaneous access to the API, resulting in smooth operation :-)

Below is some code for your reference :

import * as Odoo from "odoo-xmlrpc";
import AwaitLock from 'await-lock';

var odoo = new Odoo({
    url: "odooserver/xmlrpc/2",
    db: "databasename",
    username: "username",
    password: "password"
});

var lock = new AwaitLock();

const callOdoo = async (model, method, params) => {
  return new Promise(async (resolve, reject) => {
    odoo.connect(async (err) => {
      if (err) reject(new Error(err));
      await lock.acquireAsync();
      odoo.execute_kw(model, method, params, (err, value) => {
        lock.release();
        if (err) {
          reject(new Error(err));
        }
        console.log(value);
        resolve(value);
      });
    });
  });
}

async function getStockFromOdoo() {
  let items = await callOdoo(
    'product.product',
    'search_read',
    [
      [[['x_volume', '>=', '0.1']]],
      {'fields': ['x_beername', 'qty_available', 'x_volume', 'name', 'default_code']}
    ]
  );
  // Do something with items here.
}

async function getCustomers() {
  let items = await callOdoo(
    'res.partner',
    'search_read',
    [
      [[['is_company', '=', true],['customer', '=', true]]],
      {'fields': ['name']}
    ]);
  // Do something with items here
}

async function createSaleOrder(order){
  let orderId = await callOdoo(
    'sale.order',
    'create',
    [[{ partner_id: order.customer.id }]]
  );
  order.orders.forEach(async (line) => {
    await callOdoo(
      'sale.order.line',
      'create',
      [[{'order_id': orderId, 'product_id': line.beer.id, 'product_uom_qty': line.quantity}]]);
  });
  // do something with it here.
}

Execute bulk updates in Odoo using Xmlrpc for multiple rows at once

Answer №1

Answer №2

Similar questions

How do I include an icon on the far left of my NavBar menu? I'm having trouble figuring out how to add an icon to the header NavBar

Converting various forms of data into arrays using JavaScript

unable to fix slideshow glitch after multiple cycles

What could be causing issues with my JavaScript AJAX?

Determine the execution time of a Python script

Using the updated values from a range slider in JavaScript: A step-by-step guide

What is the solution to fixing the error message "TypeError: Unable to access properties of undefined (reading 'words')"?

Steer clear of specifying product type when using AJAX to update cart count in Shopify

Acquiring the selector value from a tag

What is the best way to implement a loop using JQuery?

What is the best way to display several markers on a Google Map at once?

AngularJS Directive for Creating Dynamic Menus

Sending a value to a specialized component

Save the modal to a variable and display it when clicked

"Enhance your webpage with a captivating opaque background image using Bootstrap

Ways to detect scrolling activity on the v-data-table module?

Automatically Refresh a Div Element Every 5 Seconds Using jQuery's setInterval() Function

Is there a way to continually monitor for collisions between webpage elements?

The combination of Masonry, FlexSlider, and endless scrolling functionality creates a

issue with scrolling using the ideal scrollbar