Navigation

Some examples

Partners importation

res_partner_address.csv
header:“Address Type”
City Contact Name Country Name Customer E-Mail Phone Street Street2 Supplier Title Zip Partner Name Partner Language Partner Country Name Partner City Salesman Name Salesman Email
default Paris Arthur Grosbonnet France 1 a.g@wealthyandsons.com 3368978776 1 rue Rockfeller   0 Sir 75016 Bank Wealthy and sons en_US France Paris Lucie Weiss lucie.weis@dns.org
default Bruxelles Carl François Belgium 1 carl.françois@bml.be +32-258-256545 89 Chaussée de Waterloo   0   1000 Centrale d’achats BML en_US Belgium Bruxelles Lucie Weiss lucie.weis@dns.org
default Buenos Aires Jack Daniels Argentina 1 contact@smartbusiness.ar
  1. 4773-9666
 Palermo, Capital Federal C1414CMS Capital Federal 0   1659 SmartBusiness en_US Argentina Buenos Aires Lucie Weiss lucie.weis@dns.org
default Liege Karine Lesbrouffe Belgium 1 k.lesbrouffe@eci-liege.info +32 421 52571 2 Impasse de la Soif   0   6985 Ecole de Commerce de Liege en_US Belgium Liege Lucie Weiss lucie.weis@dns.org
default Champs sur Marne Laith Jubair France 1 info@axelor.com +33 1 64 61 04 01 12 rue Albert Einstein   1   77420 Axelor en_US France Champs sur Marne Lucie Weiss lucie.weis@dns.org
default Avignon CEDEX 09 Laurent Jacot France 1 contact@tecsas.fr (+33)4.32.74.10.57 85 rue du traite de Rome   0   84911 Tecsas en_US France Avignon CEDEX 09 Lucie Weiss lucie.weis@dns.org
default Grenoble Loïc Dupont China 1 l.dupont@tecsas.fr +33-658-256545 Rue Lavoisier 145   0   38100 Tecsas en_US France Avignon CEDEX 09 Lucie Weiss lucie.weis@dns.org
default Namur Lucien Ferguson   1 lucien.ferguson@bml.be +32-621-568978 89 Chaussée de Liège   0   5000 Magazin BML 1 en_US   Namur Lucie Weiss lucie.weis@dns.org
default Lausanne Luc Maurer Switzerland 1   +41 21 619 10 04 PSE-A, EPFL   1   1015 Camptocamp en_US Switzerland Lausanne Lucie Weiss lucie.weis@dns.org
default Brest Marine Leclerc   1 marine@leclerc.fr +33-298.334558 rue Grande   0   29200 Leclerc en_US   Brest Lucie Weiss lucie.weis@dns.org
default Liège Martine Ohio   1 martine.ohio@ulg.ac.be +32-45895245 Place du 20Août   0   4000 Université de Liège en_US   Liège Lucie Weiss lucie.weis@dns.org
default Bruxelles Michel Schumacher Belgium 1 info@balmerinc.be (+32)2 211 34 83 Rue des Palais 51, bte 33   0   1000 BalmerInc S.A. en_US Belgium Bruxelles Lucie Weiss lucie.weis@dns.org
default Namur NotSoTiny SARL Belgium 1   (+32).81.81.37.00 Rue du Nid 1   0   5000 NotSoTiny SARL en_US Belgium Namur Lucie Weiss lucie.weis@dns.org
default Cupertino Seagate Technology United States 1 info@seagate.com +1 408 256987 10200 S. De Anza Blvd   1   95014 Seagate en_US United States Cupertino Lucie Weiss lucie.weis@dns.org
default Alencon Sebastien LANGE France 1 contact@syleam.fr +33 (0) 2 33 31 22 10 1 place de l’Église   0   61000 Syleam en_US France Alencon Martin Shain martin.shain@dns.org
default Wavre Sylvie Lelitre Belgium 1 s.l@agrolait.be 3281588558 69 rue de Chimay   0 Madam 5478 Agrolait en_US Belgium Wavre Martin Shain martin.shain@dns.org
default Boston Tiny Work United States 1 info@tinyatwork.com +33 (0) 2 33 31 22 10 One Lincoln Street   0   5501 Tiny AT Work en_US United States Boston Martin Shain martin.shain@dns.org
default Shanghai Zen China 1 zen@chinaexport.com +86-751-64845671 52 Chop Suey street   0   478552 China Export en_US China Shanghai Martin Shain martin.shain@dns.org
default Wavre Paul Lelitre Belgium 1 p.l@agrolait.be 3281588557 71 rue de Chimay   0 Sir 5478 Agrolait en_US Belgium Wavre Martin Shain martin.shain@dns.org
default Brest Claude Leclerc   1 claude@leclerc.fr +33-298.334598 rue Grande   0   29200 Leclerc en_US   Brest Martin Shain martin.shain@dns.org
default Wavre Serge Lelitre Belgium 1 serge.l@agrolait.be 3281588556 69 rue de Chimay   0 Sir 5478 Agrolait en_US Belgium Wavre Martin Shain martin.shain@dns.org
default Antwerpen   Belgium 1     Antwerpsesteenweg 254   0   2000 NotSoTiny SARL en_US Belgium Namur Martin Shain martin.shain@dns.org
default Mons Eric Dubois Belgium 1 e.dubois@gmail.com (+32).758 958 789 Chaussée de Binche, 27   0   7000 Eric Dubois en_US Belgium Mons Martin Shain martin.shain@dns.org
default Namur Fabien Dupont Belgium 1     Blvd Kennedy, 3   0   5000 Fabien Dupont en_US Belgium Namur Martin Shain martin.shain@dns.org
default Brussels Geoff Belgium 1         0     ZeroOne Inc en_US Belgium Brussels Martin Shain martin.shain@dns.org
default Paris Henry Chard France 1         0     The Shelve House en_US France Paris Lucky Luke lucky.luke@west.org
default Puurs Leen Vandenloep Belgium 1   (+32).70.12.85.00 Schoonmansveld 28   1   2870 Vicking Direct en_US Belgium Puurs Lucky Luke lucky.luke@west.org
default Brussels Marc Dubois Belgium 1 m.dubois@dubois.be   Avenue de la Liberté 56   0   1000 Dubois sprl en_US Belgium Brussels Lucky Luke lucky.luke@west.org
default Louvain-la-Neuve Thomas Passot Belgium 1   (+32).10.45.17.73 Rue de l’Angelique, 1   0   1348 Mediapole SPRL en_US Belgium Louvain-la-Neuve Lucky Luke lucky.luke@west.org
default Grand-Rosière   Belgium 1     Chaussée de Namur   0   1367 Lucie Vonck en_US Belgium Grand-Rosière Lucky Luke lucky.luke@west.org

Importation script:

from csv2oerp import Field, Model, Session, Openerp, show_stats
from csv2oerp import callbacks as cb

oerp = Openerp('198.168.0.1', 8069, 'admin', 'admin', 'database', 'fr_FR')

#===============================================================================
# res_partner_address
#===============================================================================
# 0: Address Type
# 1: City
# 2: Contact Name
# 3: Country Name
# 4: Customer
# 5: E-Mail
# 6: Phone
# 7: Street
# 8: Street2
# 9: Supplier
# 10: Title
# 11: Zip
# 12: Partner Name
# 13: Partner Language
# 14: Partner Country Name
# 15: Partner City
# 16: Salesman Name
# 17: Salesman Email
res_partner_address = Session('Partner import', 'res_partner_address',
        'res_partner_address.csv',
        delimiter=';', quotechar='"', encoding='utf8')

salesman = Model('res.users', fields=[
    Field('name', [16]),
    Field('user_email', [17]),
    Field('login', [17]),
    ], update=False, search=['name', 'user_email'])

country_partner = Model('res.country', fields=[
    Field('name', [3]),
    ], update=False, search=['name'])

country_address = Model('res.country', fields=[
    Field('name', [14]),
    ], update=False, search=['name'])

partner_title = Model('res.partner.title', fields=[
    Field('name', [10]),
    ], update=False, search=['name'])

partner = Model('res.partner', fields=[

    Field('customer', [4], callbacks=[cb.to_boolean()]),
    Field('supplier', [9], callbacks=[cb.to_boolean()]),
    Field('name', [12]),
    Field('lang', [13]),

    Field('user_id', relation=salesman),
    Field('country', relation=country_partner),

    ], search=['name', 'city'])

addresses = Model('res.partner.address', fields=[

    Field('type', [0]),
    Field('city', [1]),
    Field('name', [2]),
    Field('email', [5]),
    Field('phone', [6]),
    Field('street', [7]),
    Field('street2', [8]),
    Field('zip', [11]),

    Field('partner_id', relation=partner),
    Field('country_id', relation=country_address),
    Field('title', relation=partner_title),

    ], search=['type', 'partner_id'])

res_partner_address.bind(oerp, models=[addresses])

show_stats()

Table Of Contents

Previous topic

Callbacks module

This Page

Navigation

© Copyright 2011, Stéphane Mangin. Created using Sphinx 1.1.3.