Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

What is the maximum number of items for the scheduler report these items available delivery ?

By
Michel Hugues
on 5/9/14, 4:14 PM 1,172 views

Hello to everyone!

I am trying to create a sales history of several years for my business. (server is OpenErp V7 - bzr fresh install)

For one year, I imported 2375 Sales Quotations with Shipping Policy "Deliver all products at once". In detail it gives 23 243 lines and 234 967 items.

I fully followed workflow and inventory items is sufficient.

In "Warehouse/../Deliver Products" 234 967 items is "Waiting Availabity". (This is normal you tell me ...) Then I started manually "Run Schedulers" then I waited over an entire day, the state has not changed, is always "Waiting Availability". The only thing has changed is: in Delivery Order when I click on "Checking Availabity" items become available.

After reducing the csv file to 28 Sales Quotations and 190 items (cut 2347 Sales Quotations), I did the same thing and this time it has succeeded. The status becomes "Available". WHY ?

My question is:

Is there a maximum number of items or Delivery Orders from which the status of items never becomes available after "Run Schedulers" ?

I made another test with 537 Sales Quotations and 6203 items in "Warehouse/../Deliver Products". Then I started manually "Run Schedulers", all items are status becomes "Available" ! To summarize: for 234 967 items don't work and for 190 or 6203 items it's work.

Michel Hugues
on 5/11/14, 3:48 PM
0
Michel Hugues
On 5/12/14, 11:01 AM

If someone interested, I wrote a bash script to simulate mouse clicks under Xwindows to make available articles in delivery. I used it successfully for over 7500 delivery orders

#!/bin/bash
# Script to validate large amounts availability of items in Delivery Order
# by mouse auto-click in X
#
# Prior install xdotool (sudo apt-get install xdotool)
#
#
# Launch terminal and:
#   - type command "xdotool getmouselocation"
#   - position the mouse over the button you want to locate
#   - press the enter key (in the terminal)
#   - xdotools report X and Y location
#
# Paste this 2x2 values in this script
# Set the number of Delivery Order to validate +1
# Set first sleep time, depending on the number of lines of the Delivery Order
# Made first tests with a small number of validations !

# Run this script and go for a drink ...



for ((i=1 ; 64 - $i ; i++))
    do echo "Number of validations: " $i

    # mark the "Force Availabity" or "Check Availabity" button, then click
    xdotool mousemove 1148 291 click 1 &
    sleep 2

    # mark button Next Delivery order, then click
    xdotool mousemove 1790 250 click 1 &
    sleep 1

done

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 5/9/14, 4:14 PM
Seen: 1172 times
Last updated: 3/16/15, 8:10 AM