open source basecamp

 

Archive for August, 2009

Camptocamp parle d’OpenStreetMap dans Bilan

Saturday, August 29th, 2009 by Cédric Moullet

Bilan présente OpenStreetMap , l’encyclopédie cartographie.

Lien: https://trac.mapfish.org/trac/mapfish/attachment/wiki/downloadFiles/Article_Bilan_OSM.pdf?format=raw

INTERGEO 2009

Sunday, August 23rd, 2009 by Stéphanie Debayle

Le projet MapFish sera présenté les 22, 23 et 24 septembre prochains à Intergeo 2009, qui aura lieu à Karlsruhe, en Allemagne : http://www.intergeo-community.de/

Intergeo 2009, conférence et exposition mondiale intégrées en un même événement dédié à la géodésie, la géoinformation et l’aménagement du territoire, accueillera aussi un « Open Source Park ».

C’est dans ce cadre que Camptocamp présentera le projet MapFish, une application Web-SIG simple d’utilisation et extensible, construite sur la base de GeoExt.

Nous vous invitons à venir nous rejoindre à cette occasion, et serons ravis de vous accueillir sur le stand communautaire MapFish au sein de l’Open Source Park.

Update your OpenERP data by yourself with the new import/export financed by Camptocamp

Wednesday, August 12th, 2009 by Joël Grand-Guillaume

Hi all!

We’re proud to announce the release of a brand new feature in the stable version of OpenERP 5.0.1: 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!

Joël Grand-Guillaume