Odoo cargar datos python con un fichero csv utilizando rpc
Código ejemplo
import xmlrpc.client
import csv
host = '127.0.0.1'
port = 8069
db = 'db16-other'
user = 'admin'
password = 'x1234567890'
url = 'http://%s:%d/xmlrpc/2/' % (host, port)
common_proxy = xmlrpc.client.ServerProxy(url + 'common')
object_proxy = xmlrpc.client.ServerProxy(url + 'object')
uid = common_proxy.login(db, user, password)
if uid:
print('Conectado al servidor maestro')
def _create(state):
print("=1=")
print(state)
if state is True:
archive = csv.DictReader(open('data.csv'))
cont = 0
for field in archive:
cont += 1
_name = field['name'].strip()
_email = field['email'].strip()
_phone = field['phone'].strip()
vals = {}
vals['name'] = _name
vals['email'] = _email
vals['phone'] = _phone
vals['active'] = True
print(vals)
# Validate the register does not exist
_id = object_proxy.execute_kw(db, uid, password, 'res.partner', 'search', [[['name', '=', _name]]])
if _id:
print('= El registro ya existe =')
else:
new_partner = object_proxy.execute(db, uid, password, 'res.partner', 'create', vals)
if new_partner:
print("Se ha creado el registro: ")
else:
print("No se ha creado el registro: ")
cont += 1
print("Se han creado: ", cont)
def main():
print("Ha comenzado el proceso")
_create(True)
print('Ha finalizado la carga tabla')
main()
mfalconsoft@gmail.com / +34 (662) 47 0645RSS