Import/Export di dati con OpenERP

Import/Export di daticon OpenERP

Firenze - 24.10.2013OpenERP Day Italia 2013

davide corio - [email protected] - @davidecorio

API OpenERPXML-RPC - JSON-RPC (v8+)

Non solo CRUD


XML-RPCxmlrpclib, erppeek, ooop, oersted, ...


XMLRPCLIBhttp://docs.python.org/2/library/xmlrpclib.html

import xmlrpc


ERPPEEKhttps://github.com/florentx/erppeek

pip install erppeek


ERPPEEK[interactive]

erppeek --help


ERPPEEK[API]

import erppeek


Bulk ImportCSV - XML


CSVimport csv


CSVea_import

https://github.com/enapps/ea_import


CSVTalend, Pentaho Kettle, ...


XMLDemo Data

<record model="res.partner" id="base.new_customer_1"><field name="name">Cliente 1</field><field name="email">[email protected]</field>

</record>


XMLElementTree, LXML, BeautifulSoup, ...


SQLpyodbc, psycopg2, mysql-python, ...


SQLMicrosoft SQL Server

>>> import pyodbc>>>>>> conn = pyodbc.connect("DRIVER={FreeTDS}; SERVER=server_ip; UID=username; PWD=password; DATABASE=dbname")


SQLOracle

>>> import cx_Oracle>>>>>> connection = cx_Oracle.connect("user", "password", "TNS")


Q&AContatti

Davide [email protected]: @davidecorio


Import/Export di dati con OpenERP

Documents

Transcript of Import/Export di dati con OpenERP