You can bring the planning results to Openbravo in three ways:
Incremental export from the frePPLe user interface
User can select proposed purchase orders, distribution orders or manufacturing
orders in the frePPLe screens, and then use the action menu to bring them
immediately to Openbravo.
Bulk export from the frePPLe user interface.
The execute screen has a specific section where you can launch the export
connector. This allows to export all proposed transactions meeting certain
criteria to Openbravo.
Three parameters define a filter criterion to select which transactions
will be included in the bulk exports.
Bulk export from the command line.
Issue the command below. The script is especially handy when you want to
run the interface automatically.
It is possible to combine both the incremental and bulk export in the same frePPLe
instance. For instance, proposed purchase orders for a total value less than a certain
dollar threshold can be exported automatically to Openbravo. Proposed purchase orders
above the threshold are then reviewed in frePPLe by the planner, and export
incrementally upon the planners’ approval.
Edit the configuration file djangosettings.py
The file is found under /etc/frepple (linux) or <install folder>bincustom
Assure that the freppledb.openbravo is included in the setting
INSTALLED_APPS which defines the enabled extensions. By default
it is not enabled.
Migrate your frePPLe database
Run the migrate command to add some extra fields in the database, and load the
Configure the following parameters
In the frePPLe user interface, the menu item ‘admin/parameters’ opens a
data table to edit these.
openbravo.host: host where the Openbravo web service is running
openbravo.user: Openbravo user used to for the connection
openbravo.password: Password for the connection
For improved security it is recommended to specify this password in the
setting OPENBRAVO_PASSWORDS in the djangosettings.py file rather then
using this parameter.
openbravo.date_format: Date format for openbravo webservice filter
Date format defaults to %Y-%m-%d (i.e. YYYY-MM-DD) but can here be changed
to other formats like %m-%d-%Y (i.e. MM-DD-YYYY).
By default we export purchase requisitions and manufacturing work orders.
By switching this flag to true, we will export to the purchaseplan object instead,
which is where the Openbravo MRP run normally stores its results. Switch this
flag to true only if you have specific customizations using the purchaseplan table.
Filter expression purchase orders for bulk export of purchase orders.
Filter expression for bulk export of manufacturing orders.
Filter expression for bulk export of distribution orders.
Data mapping details
The connector doesn’t cover all possible configurations of Openbravo and
frePPLe. The connector is quite likely to require some customization to fit
the particular setup of the Openbravo and the planning requirements in frePPLe.