Community mailing list archives

community@mail.odoo.com

Re: mass importing partners. whats the best way?

by
OSSE - Oficina de Soluciones y Servicios Empresariales, jolevq
- 09/10/2015 20:13:41
If you need to validate the data with the Odoo model similar to the import csv feature, the modules mentioned before should be a good option. Nevertheless, if don't need any odoo validation or you already done it with another procedure, you may only use a bulk load directly to Postgres using a text file using any separator you have. Assuming this is a "one time (first) load", maybe works for you. We've load more than 10 millions of records with that procedure in less than 20 mins with a really tiny infrastructure. For us this is a special case, because it is necessary to load this data often. Obviously it is not an standard procedure, but it worked for this special case.

Here is some documentation and an example

COPY your_table (field1, field2, field3, fieldn) from 'yourfile.txt' WITH DELIMITER '|' encoding 'LATIN1';

Best regards,

 

José Elcorrobarrutia
Mail:  jelcorrobarrutia@osse.com.pe

Perú  (51) 663-3841

Móvil (51) 9-9277-4277




Aviso de confidencialidad:
Este mensaje de correo electrónico contiene información estrictamente confidencial no susceptible de ser distribuida.Si usted no es el destinatario de este mensaje, por favor no publicarlo, copiarlo o tomar cualquier otro tipo de accion sobre esta transmision. Si recibio este mensaje por error, por favor notifiquenoslo y eliminelo lo antes posible.

Warning of confidentiality:
This message of electronic mail contains strictly confidential information nonsusceptible to be distributed.If you are not the adressee of this message, please do not publish it, copy it or take any other kind of action on this transmission. If you got this message by mistake, please notify it to us and eliminate it as soon as possible.



• Evite imprimir, piense en su compromiso con el Medio Ambiente / Avoid printing, think about your responsability with the Environment                                           

2015-09-10 18:48 GMT-05:00 Luis Felipe Miléo <mileo@kmee.com.br>:
Hi,<br><br>We import 30k with import_odbc from a Oracle database.<br><br>You can split the import columns in many imports, like name, address and etc.<br><br>Best regards

- Luis Felipe Miléo
Gerência de Implementação
+55 21 4063-8872 (RJ)
Parceiro oficial no Brasil:
  


De: "robert" <robert@redcor.ch>
Para: "Followers of Community" <community@mail.odoo.com>
Enviadas: Quinta-feira, 10 de setembro de 2015 7:07:32
Assunto: mass importing partners. whats the best way?

Hi there,

I would like to import some 60'000 partners from a foreign (mysql) database.
I tried to import them from a csv file.
But this just seems next to impossible in one single lifetime ..

Now my questions:
what is the best way do do so?
I do not mind to write a python script to achieve this.
However I would be gratefull for a kind of sample on how to do it.

thanks
robert

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe