Martin Bramwell is trying to make import and export for openERP much more easier than the standard methods. I am very interested how to setup the datapump on a virtual Ubunto 10.04 or 12.04 machine. I want to: Make exports from v6.1.1. Manipulate the exports And after that import the manipulated data back into OpenERP v6.1.1. In a next phase at the end of this year: I want to export data from v6.1.1 and import it in v7.

I try to build up the answer (I hope with some help) myself: Make a fresh install of Ubuntu 12.04. easy_install gspread gives a command not found error. To avoid this: Install easy_install on Ubuntu with the following command: sudo apt-get install python-setuptools (don't make the mistake to use an underscore in python-setuptools). See: http://www.hacksparrow.com/ubuntu-how-to-install-easy_install.html [1] easy_install gspread --> OK easy_install openerplib gives an error:"No local packages or

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

How to setup Bramwells datapump on a virtual machine for v6.1.1 and v7?

v6.1 export import v7 migrate v6.1.1

2 Odpowiedzi

5997 Widoki

ton123

Martin Bramwell is trying to make import and export for openERP much more easier than the standard methods.

I am very interested how to setup the datapump on a virtual Ubunto 10.04 or 12.04 machine. I want to:

Make exports from v6.1.1.
Manipulate the exports
And after that import the manipulated data back into OpenERP v6.1.1.

In a next phase at the end of this year:

I want to export data from v6.1.1 and
import it in v7.

Martin

You should only need Python and the four easy_install libraries I mention. git clone the project and run it. If you hit a problem with those please let me know immediately. I have been wanting to make a YouTube video showing the complete procedure from scratch, but I have a commitment to a client that has to have priority. You may prefer to wait for the video if my written instructions fail to serve. A 'dictum' of OSS software is "Release early. Release often!" but that's for the benefit of collaborators rather than end-users. Which of those are you? "Buyer beware" ;-)

ton123

Autor

@Martin I agree with the dictum. I am end-user. A change is a trigger for the start of a money flow from end-user to collaboraters, the more change the more money for the collaboraters. I will report back my findings.

ton123

Autor

Error in step 6, see my answer.

Martin

btw, I have not addressed the export side at all. My data is coming from Google spreadsheets, so I have not needed that aspect. It's also postponed because the export side is many times easier than the import side, and I prefer to solve the hardest problems first.

Martin

To preempt complaints that we are in breach of forum rules with this discussion, I have created a Wiki page here : Please use this page to discuss getting started issues.

Documentation improved 2013/05/05

ton123

Autor

I think you are right about this.

Martin

please see wiki page update

ton123

Autor

I am further now. My findings are on the discussion page.

ton123

Autor

I try to build up the answer (I hope with some help) myself:

Make a fresh install of Ubuntu 12.04.
easy_install gspread gives a command not found error. To avoid this:
Install easy_install on Ubuntu with the following command:
sudo apt-get install python-setuptools (don't make the mistake to use an underscore in python-setuptools). See: http://www.hacksparrow.com/ubuntu-how-to-install-easy_install.html
easy_install gspread --> OK
easy_install openerplib gives an error:"No local packages or download links found for openerplib error: couldn't find suitable distribution for requirement.parse (openerplib)

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
is it normal that csv import almost never is working? Rozwiązane v6.1 export import v7 csv	6 gru 23	21180
Why does my Openerp export rubbish? v6.1 export v7	1 mar 15	6383
Workflow of openErp how it works export import migration v7	0 mar 15	4391
Export from v7 to Import into v8 v8 export import v7	1 mar 15	5614
How to export and import contacts and products back? Rozwiązane v6.1 export product import contacts	9 kwi 24	37138

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!