Main > Reference Manual > Download and install > Configuring the OpenERP connector

FrePPLe provides an integration with the OpenERP, a leading open source ERP. The connector provides the following functionality:

  • Two-way integration:
    1. Synchronizes the frePPLe database with items, locations, bill of materials, routings, resources, sales orders, customers, inventory, production orders, purchase orders from OpenERP.
    2. Uploads new production orders and/or purchase orders from frePPLe to OpenERP.
  • Uses the XMLRPC API to access OpenERP.
  • Allows net-change download of only the objects that have been changed in OpenERP within a certain time frame.
  • Easy to customize.

The integration contains 2 parts:

  • An additional Django application to be deployed in the frePPLe web application.
    It contains the commands to pull data from OpenERP and push results back to OpenERP.
  • An OpenERP module that defines extra models, fields and screens in OpenERP.
    It is used to allow frePPLe-specific input information to be maintained in OpenERP.

The integration is based on OpenERP v6 and requires the following modules to be installed:

  • mrp
  • mrp_subproduct
  • sale

Configuring the frePPLe web application

  1. Copy the application folder
    The folder contrib/openerp/openerp needs to be copied to contrib/django/freppledb (or custom/freppledb when you used the Windows installer).
  2. Edit the file settings.py
    The following settings need updating:
    • INSTALLED_APPS: Add (or uncomment) freppledb.openerp in the list of applications.
  3. Configure the following paramters in the frePPLe database:
    • openerp_url: URL for the XML-RPC server
    • openerp_db: OpenERP database to connect to
    • openerp_user: OpenERP user for the connection
    • openerp_password: Password for the connection
    If you use the syncdb command to initialize the database, the parameters will be created automatically. Otherwise you can create them manually.
  4. You are now ready to synchronize the frePPLe database with OpenERP.
    Issue the command:
        manage.py openerp_import
    
    The following optional arguments can be provided:
    • openerp_url: URL for the XML-RPC server. Overrides the parameter with the same name.
    • openerp_db: OpenERP database to connect to. Overrides the parameter with the same name.
    • openerp_user: OpenERP user for the connection. Overrides the parameter with the same name.
    • openerp_password: Password for the connection. Overrides the parameter with the same name.
    • user: frePPLe user running the command
    • delta: Number of days for which we extract changed OpenERP data. Older data is expected to be already in frePPLe and are no extracted again. The default value is 3650, meaning that all data is extracted.
    • database: The frePPLe database to load the data into. Only relevant for configurations with multiple frePPLe databases.
  5. When the frePPLe plan is ready, you can bring the results back to OpenERP with the following command:
       manage.py openerp_export
    
    The following optional arguments can be provided:
    • openerp_url: URL for the XML-RPC server. Overrides the parameter with the same name.
    • openerp_db: OpenERP database to connect to. Overrides the parameter with the same name.
    • openerp_user: OpenERP user for the connection. Overrides the parameter with the same name.
    • openerp_password: Password for the connection. Overrides the parameter with the same name.
    • user: frePPLe user running the command
    • database: The frePPLe database to load the data into. Only relevant for configurations with multiple frePPLe databases.
    Implementation of this command is in progress.

Configuring the OpenERP module

The module can be installed as a regular extension module.

It extends OpenERP with the following capabilities:

  • Add setupmatrix as a new model.

This module is currently in development and not ready.