2
# -*- encoding: utf-8 -*-
4
import xmlrpclib, csv, sys, ConfigParser
6
cfg_file="/home/administrator/ETL/openerp.cfg"
8
# Set up parameters (for connection to Open ERP Database) ********************************************
9
config = ConfigParser.ConfigParser()
10
config.read([cfg_file]) # if file is in home dir add also: , os.path.expanduser('~/.openerp.cfg')])
11
dbname=config.get('dbaccess','dbname')
12
user=config.get('dbaccess','user')
13
pwd=config.get('dbaccess','pwd')
14
server=config.get('dbaccess','server')
15
port=config.get('dbaccess','port') # verify if it's necessary: getint
16
separator=config.get('dbaccess','separator') # test
17
file_name_pickle=config.get('dbaccess','file_name_pickle') # Pickle file name
18
percorso="/home/administrator/ETL/"
19
header_lines=0 # non header on CSV file
21
# XMLRPC connection for autentication (UID) and proxy
22
sock = xmlrpclib.ServerProxy('http://' + server + ':' + port + '/xmlrpc/common', allow_none=True)
23
uid = sock.login(dbname ,user ,pwd)
24
sock = xmlrpclib.ServerProxy('http://' + server + ':' + port + '/xmlrpc/object', allow_none=True)
26
# Create or get standard Items mandatory for program:
28
italian_partner_ids = sock.execute(dbname, uid, pwd, 'res.partner', 'search', [('type_cei','=','i')])
29
modify = sock.execute(dbname, uid, pwd, 'res.partner', 'write', italian_partner_ids, {'pricelist_model_id': 139,})
30
print "Listini italiani impostati"