def transform_extract(records):
equiv_company_ids = [(3,2),(4,1),(1,3)]
conn2 = Odoo(url=destination_host,session=destination_session)
records_final = []
for record in records:
if record["user_ids"]:
if record["user_id"]:
if users_dict.get(str(record["user_id"]),False):
record["user_id"] = users_dict[str(record["user_id"])]["id"]
if record["create_uid"]:
if users_dict.get(str(record["create_uid"]),False):
record["create_uid"] = users_dict[str(record["create_uid"])]["id"]
if record.get("company_id"):
record["company_id"] = [eq[1] for eq in equiv_company_ids
if record.get("company_id") == eq[0]][0]
if len(record["user_ids"][0][2]) == 1:
old_user_id = record["user_ids"][0][2][0]
new_user_id = users_dict[str(old_user_id)]["id"]
rec = conn2.call_kw("res.users","search_read",kwargs={"fields":["id","partner_id"],
"domain":[["id","=",int(new_user_id)]] })
del record["user_ids"]
record["write"] = True
record["new_id"] = rec[0]["partner_id"][0]
#record.update({"company_id":})
records_final.append(record)
return records_final
record["product_id"] = int(products_dict[str(
record["product_id"])]["id"])
tax_id = record.get("tax_id", False)
if tax_id:
record["tax_id"] = [(6, 0, [
int(impuestos_dict[str(tax_id)]["id"])
for tax_id in tax_id[0][2]
])]
record["discount"] = round(record["discount"], 2)
return records
#Descargar datos en Jsons
conn1 = Odoo(origin_db, origin_user, origin_pass, origin_host)
conn1.authenticate()
fields = [
"id", "name", "product_id", "product_uom_qty", "product_uom", "price_unit",
"tax_id", "purchase_price", "order_id", "discount", "customer_lead"
]
file_name = conn1.download_json(
"sale.order.line",
fields,
domain=[["order_id", "!=", False],
["order_id.partner_id", "not in", [1, 2, 3, 4, 5, 6]]],
transform=transform,
order="id ASC",
limit=0)
conn2 = Odoo(url=destination_host, session=destination_session)
# Configure Logger
logger = logging.getLogger("DaemonLog")
logger.setLevel(logging.INFO)
handler = logging.FileHandler("/var/log/scheduler.log")
formatter = logging.Formatter("%(asctime)s - %(name)s - %(levelname)s - %(message)s")
handler.setFormatter(formatter)
logger.addHandler(handler)
# Initialize Pgsql service
pgsql = Pgsql()
pgsql.logger = logger
pgsql.connect()
logger.info("Connected to Pgsql!")
# Initialize Odoo service
odoo = Odoo()
odoo.logger = logger
odoo.connect()
logger.info("Connected to Odoo!")
# Get job_task_id passed via command line
job_task_id = sys.argv[1]
# Load information from database
job_task = pgsql.query_one("SELECT * FROM unison_job_task WHERE id = " + str(job_task_id))
job = pgsql.query_one("SELECT * FROM unison_job WHERE id = " + str(job_task.job_id))
job_type = pgsql.query_one("SELECT * FROM unison_job_type WHERE id = " + str(job.job_type_id))
# Execute job task (date_start was marked on execute_job.py script)
logger.info("Executing task '" + job_task.name + "' (calling to " + job_task.model_name + "." + job_task.function + "on id " + str(job_task.model_id) + ")...")
success = odoo.execute(job_task.model_name, job_task.model_id, job_task.function)
boms_dict = json.loads(boms.read())
products = open("product.product_load_20200121.json", "r")
products_dict = json.loads(products.read())
uoms = open("product.uom_load_20200121.json", "r")
uoms_dict = json.loads(uoms.read())
def transform(record, records):
record["bom_id"] = boms_dict[str(record["bom_id"])]["id"]
record["product_id"] = products_dict[str(record["product_id"])]["id"]
record["product_uom_id"] = uoms_dict[str(record["product_uom_id"])]["id"]
return record
#Descargar datos en Json
conn1 = Odoo(origin_db, origin_user, origin_pass, origin_host)
conn1.authenticate()
fields = ["id", "product_qty", "product_id", "product_uom_id", "bom_id"]
file_name = conn1.download_json("mrp.bom.line", fields, limit=0, domain=[])
conn2 = Odoo(destination_db, destination_user, destination_pass,
destination_host)
conn2.authenticate()
#Eliminar Productos
#recs = conn2.call_kw("product.product","search_read",kwargs={"fields":["id"]})
#conn2.call_kw("product.product","unlink",args=[[rec["id"] for rec in recs]])
#Cargar Nuevos
conn2.load_json("mrp.bom.line", file_name, transform=transform, threads=20)
from odoo import Odoo
import json
import base64
from PIL import Image
from io import BytesIO
from datetime import datetime
import pandas as pd
#Establecer Parámetros
##################################################################
conn = Odoo(db="universal",login="******",password="******",
url="localhost:8005",ssl=False)
##################################################################
conn.authenticate()
def fetch_product_ids(conn):
res = conn.call_kw("product.template","search_read",[],{"domain":[],"fields":["id"]})
return list(map(lambda r:r["id"],res))
def download_product_image(conn,product_id):
error_logs = open("error_logs_{}.logs".format(datetime.now().strftime("%Y-%m-%d %H-%M-%S")),"w")
res = conn.call_kw("product.template","search_read",[],{"domain":[["id","=",product_id]],"fields":["name","image"]})
if len(res)>0:
image_id = res[0]["id"]
image_b64 = res[0]["image"]
try:
im = Image.open(BytesIO(base64.b64decode(image_b64)))
im.save('images/{}.png'.format(image_id), 'PNG')
except Exception as e:
from odoo import Odoo
import json
odoo = Odoo('*****@*****.**', 'test1')
odoo.connect()
# exemple : on cherche l'evenement avec un id de 2
# et on affiche que la propriete name et
# l organisateur de l evenement
# Ne pas oublier de rajouter au moins 2 evenements
#print(odoo.searchRead("event.event", [["id", "=", 2]], ["name", "organizer_id"]))
# exemple : sans filtre, on affiche tous les evenements
# verifier bien que l'id de la personne existe sinon
# changez l id
#print(odoo.searchRead("res.partner", [],
# ["name", "id", "birthdate"]))
#result = odoo.searchPartnerByBirthdate("1998-06-10")
#data = result[0]
#output = tuple(data.items())
#print(output)
#print(output[2][1]) #to get the email
#print(output[0][1]) #to get the user id
#print(output[1][1]) #to get the name
#odoo.createEvent("event_test23", "2022-12-28 20:18:18",
# "2022-12-29 20:18:18", 6)
conn1 = Odoo("5WI1q4kLj2_db","admin","admin","htc.facturacion.vip")
conn1.authenticate()
fields = ["id","name","cost_currency_id","currency_id"]
products = conn1.call_kw("product.template","search_read",kwargs={"fields":fields})
for x in products:
print(x)
company = conn1.call_kw("res.company","search_read",kwargs={"fields":["name","currency_id"]})
print(company)
"""
#conn1 = Odoo("highlanddb_oct_final_migra","admin","admin","localhost:8827")
#conn1 = Odoo("5WI1q4kLj2_db","admin","admin","htc.facturacion.vip")
conn1 = Odoo("naomis_db_13_nov", "yeyson5", "Elbaronrojo5", "localhost:8827")
conn1.authenticate()
productos = conn1.call_kw(
"product.product",
"search_read",
kwargs={"fields": ["id", "name", "categ_id", "standard_price"]})
productos_dict = {}
for product in productos:
productos_dict.update({
product["id"]:
[product["name"], product["categ_id"][1], product["standard_price"]]
})
pos_orders = conn1.call_kw("pos.order",
"search_read",
province_id = str(partner["province_id"][1] if partner["province_id"] else "")
district_id = str(partner["district_id"][1] if partner["district_id"] else "")
customer = str(partner["customer"])
supplier = str(partner["supplier"])
linea_credito = str(partner["linea_credito"])
employee = str(partner["employee"])
parent_id = partner["parent_id"][1] if partner["parent_id"] else ""
function = str(partner["function"])
phone = str(partner["phone"])
row = [idx,tipo,name,catalog_06_id,vat,company_type,estado_contribuyente,
registration_name,street,mobile,email,ubigeo,country_id,
state_id,province_id,district_id,customer,supplier,linea_credito,
employee,parent_id,function,phone]
partner_writer.writerow(row)
"""
conn = Odoo("IW94Do1PeS_db", "admin", "adm1n*2019-11", "erp.highlandtc.com",
True)
conn.authenticate()
lista = conn.call_kw("res.partner",
"search_read",
kwargs={
"domain":
['|', ["active", "=", 0], ["active", "=", 1]],
"fields": ["name", "active"]
})
print([x for x in lista if x["active"]])
from odoo import Odoo
conn = Odoo("santaclara_db_1","admin","admin","localhost:8827",False)
conn.authenticate()
l =conn.call_kw("product.product","search_read",
kwargs={'fields':['name','product_tmpl_id',"list_price"],'limit':10,'domain':[['name','ilike','3XXX MARACUYA 1.8LT']]})
print(l)
l =conn.call_kw("product.product","read",[[5494],["name",'display_name']],kwargs={"context":{"bin_size":True,"params":{"action":119}}})
print(l)
conn.call_kw("product.template","write",[[5495],{"name":"3XXX MARACUYA 1.8LT *XYZ123*****","list_price":2003.33}])
#l =conn.call_kw("product.template","read",args=[[5495],['name']])
#print(l)
#DOWNLOAD PARTNERS
"""
fields = ["id","type","name","catalog_06_id","vat","company_type","estado_contribuyente",
"registration_name","street","mobile","email","zip","customer",
"supplier","linea_credito","employee","parent_id","function","phone"]
"""
#conn.download_json("res.partner",fields,order="parent_id DESC",limit=0)
#DOWNLOAD LÍNEA DE COMPROBANTES
fields = []
#conn.download_json("account.invoice.line",fields)
#DOWNLOAD COMPROBANTES
"""
fields = ["id","number","move_name","date_order","partner_id","journal_id","tipo_operacion",
from odoo import Odoo
import json
from variables import *
conn2 = Odoo(url=destination_host,session=destination_session)
#conn2 = Odoo(origin_db,origin_user,origin_pass,origin_host)
#conn2.authenticate()
recs = conn2.call_kw("account.invoice","search_read",kwargs={"fields":["id"]})
rec_ids = [rec["id"] for rec in recs]
print(rec_ids)
#print(conn2.call_kw("account.invoice","write",args=[rec,{"move_name":"","name":"","state":"draft"}]))
salto = 30
for rec in [rec_ids[x:x+salto] for x in range(0,len(rec_ids),salto)]:
print(rec)
conn2.call_kw("account.invoice","compute_taxes",args=[rec])