As an OpenERP user or developer may some time need to data import and export possibly in Migration. There are several methods in OpenERP to server the purpose. In OpenERP 7, data import and export happen in client side so you do not need to have technical knowledge. If you are able to collect the data in a spreadsheet without much efforts; ‘CSV Import’ will be a better solution for data import. Similarly data can also be exported easily as a CSV files. The CSV file format is a text format compatible with most spreadsheet programs (such as
OpenOffice Calc and Microsoft Excel), and is easily editable as a worksheet. The first line contains the name of the fields in the form. All the subsequent lines are data, aligned in their respective columns.
This option is in Setting -> Configuration -> General settings menu as shown below:
After enabling the “Allow users to import data from CSV files” option, the import option is available next to every create button from list view.
If you want to export the data, the option you can find in list view ‘More’ option.
How to Import and Export ?
Its a very simple to Export data in OpenERP 7.0, you just select the data and click on export, open new wizard, you will select the fields that you want to export and click on export to file,
after Export it will create a .CSV file. Export option cannot be disabled by any configuration but you have to write a web module for this.
First you have to select data to import, after selecting data, you can preview right away, thus resulting in a significant gain in time. In previous versions of OpenERP, you had to reiterate the import when the initial one did not meet your criteria. Now after the system analyses the file content and provide indications in case of error.In case of errors in the original file formatting, OpenERP proposes you alternatives and solutions on how to structure your document.
OpenERP 7.0 version gives more file formating options when data importing.
import data form .CSV file.
You must include every field that is colored blue because those fields are required (unless you know that they get filled by default with an appropriate value), and also any other field that is important to you.
Thanks, Hope this post will be helpful to you.
Serpent Consulting Services