Great information. But I wonder why this extra export should be necessary, shouldn't it be possible just to tell OpenERP which field to check before updating? It should be possible just to update pricing by giving the SKU och code for the product (or any other identifier) the internal ID's of openerp doesn't mean anything when creating updates?!
Maybe this is already possible, but it's not mentioned in the post? Also the same should go for importing contacts, it should be easier than using db ID's. Regards, Daniel [quote="l...@camptocamp"]Hi all! Weâre proud to announce the release of a brand new feature in the stable version of OpenERP 5.0.2 : the management of OpenObject and PostgreSQL IDs in the import/export system. Camptocamp financed this new feature in order to allow people to update their stored data through the standard GTK Client. With this new feature you can: * Affect a new, or change, the OpenObject ID of any object in the database, * Update stored data by exporting/importing them (based on the PostgreSQL ID or the OpenObject ID), * Let your customers update their data themselves via CSV files. Concrete example: You need to keep the product cost prices in sync with your supplier price lists (letâs say you have only one supplier per product for this example). Your suppliers give you an Excel file of all prices and references. 1. First, youâll need to export your product with the PostgreSQL and the OpenObject IDs into a CSV file. Take at least all required fields. 2. Update the exported file with the supplier information. Put the new cost price and affect the supplier product reference as OpenObject ID. 3. Import the updated file. Thatâs all! The new product will be created and the existing one will be updated, nothing will be deleted. Note: next time youâll only need to export the OpenObject ID in order to update the data. You wonât need the PostgreSQL ID anymore unless you need to update the supplier product reference! Regards Luc Maurer[/quote] -------------------- m2f -------------------- -- http://www.openobject.com/forum/viewtopic.php?p=52396#52396 -------------------- m2f --------------------
_______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman2/listinfo/tinyerp-users
