Data Importation in OpenERP

Data Importation in OpenERP

      There are different methods to import your data into OpenERP: The best way to import data in OpenERP is to build a module that integrates all the data you want to import. So, when you want to import all the data, you just have to install the module and OpenERP manages the different creation operations.

      Create a new module named data_partners. In the __openerp__.py file, the files containing the data should be written within the 'init_xml'. For example: Here we are importing two files 'res.partner.csv' and 'res.partner.address.csv'. Then, in the __openerp__.py file, write

   'init_xml':[
      'res.partner.csv',
      'res.partner.address.csv'
           ]

The module will import two different files:

res.partner.csv : a CSV file containing records of the res.partner object
res.partner.address.csv : a CSV file containing records of the res.partner.address object

      When you import a .CSV file in OpenERP, you can provide a ‘id’ column that contains a uniq identification number or string for the record. We will use this ‘id’ column to refer to the ID of the record in the original application. As to refer to this record from a many2one field, you can use ‘FIELD_NAME:id’. OpenERP will re-create the relationship between the record using this uniq ID.

Contents of the 'res.partner.csv' file

id,name
partner_2,ASUStek
partner_3,Agrolait
partner_4,Camptocamp
partner_5,Syleam

Contents of the 'res.partner.address.csv' file

id,name,partner_id:id
partner_address2,Benoit Mortier,partner_2
partner_address3,Laurent Jacot,partner_3
partner_address4,Laith Jubair,partner_4
partner_address5,Fabien Pinckaers,partner_4

      When you will install this module, OpenERP will automatically import the partners and then the address and recreate efficiently the link between the two records. When installing a module, OpenERP will test and apply the constraints for consistency of the data.

      If you plan to upload thousands of records through this technique, you should consider using the argument ‘-P’ when running the server.

openerp_server.py -P status.pickle --init=data_partners(module_name)

This method provides a faster importation of the data and, if it crashes in the middle of the import, it will continue at the same line after rerunning the server. This may preserves hours of testing when importing big files.