def getUserId(name):
""" Search for an OpenERP user with the given name and return his or
her uid.
>>> searchUser('Administrator')
[1]
>>> searchUser('The Hamburgerlar')
"""
uid = searchRecord('res.users', [('name','=',name)])
return uid[0] if uid else False
def getUserId(name):
""" Search for an OpenERP user with the given name and return his or
her uid.
>>> searchUser('Administrator')
[1]
>>> searchUser('The Hamburgerlar')
"""
uid = searchRecord('res.users', [('name', '=', name)])
return uid[0] if uid else False
def translateStageId(code):
""" Translate Status id in CRM to a crm.case.stage id in OpenERP. """
status_codes = {
200000: # Pre Sale
searchRecord('crm.case.stage', [('name', '=', 'Pre Sale')]),
200001: # Prototyping
searchRecord('crm.case.stage', [('name', '=', 'Prototyping')]),
200005: # Mass Production
searchRecord('crm.case.stage', [('name', '=', 'Forecasted')]),
200008: # One Time
searchRecord('crm.case.stage', [('name', '=', 'Forecasted')]),
2: # On Hold
searchRecord('crm.case.stage', [('name', '=', 'On Hold')]),
}
return (status_codes.get(code)[0] if status_codes.get(code) else
searchRecord('crm.case.stage', [('name', '=', 'New')])[0])
def translateStageId(code):
""" Translate Status id in CRM to a crm.case.stage id in OpenERP. """
status_codes = {
200000 : # Pre Sale
searchRecord('crm.case.stage', [('name','=','Pre Sale')]),
200001 : # Prototyping
searchRecord('crm.case.stage', [('name','=','Prototyping')]),
200005 : # Mass Production
searchRecord('crm.case.stage', [('name','=','Forecasted')]),
200008 : # One Time
searchRecord('crm.case.stage', [('name','=','Forecasted')]),
2 : # On Hold
searchRecord('crm.case.stage', [('name','=','On Hold')]),
}
return (status_codes.get(code)[0] if status_codes.get(code) else
searchRecord('crm.case.stage', [('name','=','New')])[0])
def getStateId(name):
""" Return the OpenERP id of the state with the given name. See
'testMemoizedFunctions()' for doctests.
"""
ids = searchRecord('res.country.state',[('name', '=', name)])
return ids[0] if ids else 0
def getCustomerDepositAcctId():
""" Return the id for the customer deposit account. """
return searchRecord('account.account', [('code', '=', '21511-02')])[0]
def getPaymentCheckId():
""" Return the id for payment type 'Check'. """
return searchRecord('lgx.res.paypref', [('name', '=', 'Check')])[0]
record.update(additional_fields)
# Write record to OpenERP
writeRecord('res.partner', record)
# Add name to the cache to avoid duplicate records
seen.add(record['name'])
else:
skipped += 1
"""
total = len(recordsToUpdate)
processed = 0
skipped = 0
seen = set()
_logger.info("Updating %d records in OpenERP...", len(records))
for record in recordsToUpdate:
processed += 1
print "{}Updating {} of {} ({} duplicates)".format("\r", processed, total, skipped),
sys.stdout.flush()
if record['name'] not in seen:
# Add extra fields for OpenERP
record.update(additional_fields)
# Write record to OpenERP
id = searchRecord('res.partner',[('name','=',record['name'])])
updateRecord('res.partner', id, record)
# Add name to the cache to avoid duplicate records
seen.add(record['name'])
else:
skipped += 1
def getCustomerDepositAcctId():
""" Return the id for the customer deposit account. """
return searchRecord('account.account', [('code', '=', '21511-02')])[0]
def getPaymentCheckId():
""" Return the id for payment type 'Check'. """
return searchRecord('lgx.res.paypref', [('name', '=', 'Check')])[0]
def getPartnerIdForName(name):
ids = searchRecord('res.partner', [('name', '=', name)])
return ids[0] if ids else False
# Add extra fields for OpenERP
record.update(additional_fields)
# Write record to OpenERP
writeRecord('res.partner', record)
# Add name to the cache to avoid duplicate records
seen.add(record['name'])
else:
skipped += 1
"""
total = len(recordsToUpdate)
processed = 0
skipped = 0
seen = set()
_logger.info("Updating %d records in OpenERP...", len(records))
for record in recordsToUpdate:
processed += 1
print "{}Updating {} of {} ({} duplicates)".format(
"\r", processed, total, skipped),
sys.stdout.flush()
if record['name'] not in seen:
# Add extra fields for OpenERP
record.update(additional_fields)
# Write record to OpenERP
id = searchRecord('res.partner', [('name', '=', record['name'])])
updateRecord('res.partner', id, record)
# Add name to the cache to avoid duplicate records
seen.add(record['name'])
else:
skipped += 1
def searchPartner(name):
""" Search for an OpenERP partner with the given name and return his or
her uid.
"""
pid = searchRecord('res.partner', [('name','=',name)])
return pid[0] if pid else False
#!/usr/bin/env python
import ringo
from adapters.openerp import (deleteRecord,
searchRecord,
readRecord)
from xmlrpclib import Fault
import logging
_logger = logging.getLogger(__name__)
if __name__ == "__main__":
# Find attached records
partnerIdsWithInvoices = readRecord('account.invoice', [], fields='partner_id')
# Find all records
allIds = searchRecord('res.partner', [('customer','=','True')])
# And destroy the unattached records
unattachedIds = [ x for x in allIds if
x not in partnerIdsWithInvoices ]
for id in unattachedIds:
try:
deleteRecord('res.partner', id)
except Fault:
_logger.warn("Error deleting partner with id %s.", id)
#!/usr/bin/env python
import ringo
from adapters.openerp import (deleteRecord, searchRecord, readRecord)
from xmlrpclib import Fault
import logging
_logger = logging.getLogger(__name__)
if __name__ == "__main__":
# Find attached records
partnerIdsWithInvoices = readRecord('account.invoice', [],
fields='partner_id')
# Find all records
allIds = searchRecord('res.partner', [('customer', '=', 'True')])
# And destroy the unattached records
unattachedIds = [x for x in allIds if x not in partnerIdsWithInvoices]
for id in unattachedIds:
try:
deleteRecord('res.partner', id)
except Fault:
_logger.warn("Error deleting partner with id %s.", id)
def getStateId(name):
""" Return the OpenERP id of the state with the given name. See
'testMemoizedFunctions()' for doctests.
"""
ids = searchRecord('res.country.state', [('name', '=', name)])
return ids[0] if ids else 0
def getPartnerIdForName(name):
ids = searchRecord('res.partner', [('name','=', name)])
return ids[0] if ids else False
def searchPartner(name):
""" Search for an OpenERP partner with the given name and return his or
her uid.
"""
pid = searchRecord('res.partner', [('name', '=', name)])
return pid[0] if pid else False