1. Mailing Lists
  2. Connectors
  3. Product Connector

Connectors mailing list archives

connectors@odoo-community.org

Browse archives

Best Practice Bundle Import (Magento - Odoo 8)

Connector Openerp 7 magento 2

Avatar

Product Connector

by
jason.morgan
- 06/05/2017 11:37:36
Hi,

We are going to be using Odoo for Manufacturing and Inventory.
I have Products (we call them Parts) located in an Aras Innovator PLM database.
Rather than copying a subset of records (which I can do using a Python script), I'd like to create a live connection using the Connector Module or External database connection.

The external (Aras) database has both RPC and MSSQL access methods.
The external database Part table only has a couple fields that are of any use in Odoo, but obviously we still need the rest of the fields from Odoo.

Only a select subset of the external records are of any use in Odoo, so the connector should filter out meaningless records by certain column values.

Effectively the Code, Name and Description Odoo fields are defined in Aras. Released Parts with certain other field values should appear in Odoo as Products.  The externally defined Code, Name and Description fields are not writeable in Odoo.

How do I approach this?

Do I create a Part model, then somehow merge the Parts and Products?
Do I modify the Product model to get the key fields from Aras?
Do I modify the access methods (e.g. search) to return the data and merge the values in code?

I've looked at the 'External Database' access, and though i can create a connection (after a LOT of trial and error with the connection string), I have no idea how to use it to 'merge' external Parts with Odoo Products.

I've looked at the Connector module and it seems that might do exactly what I want, but I need some pointers where to get started.

Regards,
Jason
--

Jason Morgan
Principal Engineer

t: +44 1223 781555
m: +44 (0) 7877 662290
ddi: +44 1223 781556

Engineering
Pavegen Systems Ltd
Future Business Centre
Kings Hedges Road
Cambridge, CB4 2HY

Head Office
5-15 Cromer St
London, WC1H 8LS

t: +44 (0) 2033 977 279

pavegen.com
#thenextstep16

     

The content of this email and any attachments are confidential and may contain privileged information. If you are not the addressee it may be unlawful for you to read, copy, distribute, disclose or otherwise use the information contained herein.

Company Registered no: 06980029 | Company VAT no: 996499723


Follow-Ups