ray-odoo

1.	Take a backup of the SAAS database.  (You must be logged into odoo.com as the Administrator of the database).

2.	Perform the following PSQL:
update ir_module_module set state = 'to remove' where name = 'saas_trial';

insert into base_config_settings(auth_signup_reset_password) values(true); 

update res_partner set signup_type='reset', signup_token='rsvabcdefghijykalklk', signup_expiration=to_timestamp('20200411','YYYYMMDD') where id=(select partner_id from res_users where id=1);

ALT:

ray-odoo

OUT:

pg_dump production --no-owner --format=c --file=production.sql

FILESTORE:

tar -czvf /home/ubuntu/production.tar.gz production

IN:

ray-odoo

SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'database_name';

ray-odoo

Phone
Hotel
Internet
Meals - Client
Meals - Employee
Shipping
Supplies
Travel Insurance
Airfare
Baggage

ray-odoo

quants = env['stock.quant'].search([])
move_line_ids = []

warning = ''
for quant in quants:
    move_lines = env["stock.move.line"].search([
        ('product_id', '=', quant.product_id.id),
        ('location_id', '=', quant.location_id.id),
        ('lot_id', '=', quant.lot_id.id),
        ('package_id', '=', quant.package_id.id),

ray-odoo

# only tested with the speficic import file with the following schema:
# Internal ID,ID,Name,Asset Type,Asset Original Cost,Asset Current Cost,Serial Number,Quantity,Date Created,Purchase Date,Depreciation Start Date,Current Net Book Value,Cumulative Depreciation


import xlrd
import xmlrpc.client
import requests
import base64
import datetime

ray-odoo

# Available variables:
#  - env: Odoo Environment on which the action is triggered
#  - model: Odoo Model of the record on which the action is triggered; is a void recordset
#  - record: record on which the action is triggered; may be void
#  - records: recordset of all records on which the action is triggered in multi-mode; may be void
#  - time, datetime, dateutil, timezone: useful Python libraries
#  - log: log(message, level='info'): logging function to record debug information in ir.logging table
#  - Warning: Warning Exception to use with raise
# To return an action, assign: action = {...}

ray-odoo

for record in self:
  if record.delivery_count > 0:
    record['x_delivery_status'] = 'draft'
  else:
    global_done = False
    for picking in record.picking_ids.sorted(key=lambda r: r.id):
      local_done = False
      if picking.state in ['waiting','confirmed']:
        record['x_delivery_status'] = 'waiting'
      if picking.state in ['assigned']:

ray-odoo

delete from crm_lead;

delete from purchase_order_line;
delete from purchase_order;

delete from sale_order_line;
delete from sale_order;

delete from procurement_order;
delete from procurement_group;

ray-odoo

# https://www.odoo.com/forum/help-1/how-can-i-leverage-employee-skills-when-assigning-tasks-in-the-projects-app-181599

###### Offboard:

env['ir.ui.view'].search([('name','=','custom_ray_odoo')]).unlink()
env['ir.model.fields'].search([('name','=','x_employee_skill_ids')]).unlink()

###### Onboard:

# Schema