Skip to Content
This question has been flagged
pythondatabaseorm
1 Reply
14560 डेटा देखने का तरीका
अवतार
Jim Biergans

I'm writing an application to speed up the product import procedure, but I'm stuck on the qty on hand part. It appears this is a calculated field (?) and there is no way to insert it directly into a table. Does anybody have any info/suggestions? I've got the import process to about 14 records per second, vs. the OpenERP import which takes almost a full second per record, so I'd rather not use the OpenERP import. TIA!

अवतार
खारिज करें
अवतार
Ray Carnes
Best Answer

Import a Physical Inventory

Warehouse --> Inventory Control --> Physical Inventories

https://doc.openerp.com/7.0/book/5/5_14_Stock/5_14_Stock_inv/#initial-inventory

Quantity on hand takes into account

  • products in stock
  • products ordered but not yet received
  • products sold but not yet delivered
  • products to be manufactured
अवतार
खारिज करें
Jim Biergans
लेखक

Thanks. That's kind of what I figured. Was hoping I could just write a simple sql insert but that doesn't look likely. Might just have to use the initial inventory routine.

Ray Carnes

SQL is a dangerous way to go - it bypasses all of the business logic. You could quickly end up with a mess of a database. OpenERP wasn't written to handle a database in an inconsistent state and it won't do so elegantly. You should configure the server to log SQL calls so you can see what is happening when something is done via the UI to make sure you are 100% sure you understand the data model and can use SQL properly to update the database.

Jim Biergans
लेखक

Yeah, I was thinking the same thing and looking at how to enable logging in PostgresQL. Any tips? I've got logging set to "all" in the conf file, but it's not logging anything - i made changes to the inventory and product and get nuthin...

Jim Biergans
लेखक

first thing i did was google it. got logging on postgresql enabled and i think everything in the conf file is right... still don't get any sql stuff... i'm stuck...i'll post it on stackoverflow and see if anyone there knows what i'm missing... thanks for your help though.

Mayte Montaño

Take a look at OpenERP Webservice!

Related Posts Replies डेटा देखने का तरीका ऐक्टिविटी
How to get value from DB using Odoo(ver. 9-10) ORM Solved
python database orm ir.ui.menu
अवतार
अवतार
1
अक्तू॰ 16
8117
how to access database using python code?
python database
अवतार
अवतार
1
मार्च 15
8976
Get author_id from mail_message in openERP
python orm
अवतार
अवतार
1
मार्च 15
7696
write/create id database
database orm
अवतार
अवतार
1
मार्च 15
8035
Odoo - Create absence record for every student in every subject Solved
python database orm oepnerp7 odoo
अवतार
अवतार
2
अप्रैल 15
6294