Sign in
Try it free
  1. Mailing Lists
  2. Community
  3. Re: mass importing partners. whats the best way?

Community mailing list archives

community@mail.odoo.com

Browse archives

Re: mass importing partners. whats the best way?

Re: mass importing partners. whats the best way?

Re: mass importing partners. whats the best way?

by
Camptocamp France SAS, Alexandre Fayolle - Camptocamp
- 09/11/2015 02:11:58 
Careful though, not all fields are table columns, so this approach may
miss a few issues, such as properties.

Alexandre

On 11/09/2015 02:17, José Elcorrobarrutia wrote:
> 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
> http://www.postgresql.org/docs/9.0/static/sql-copy.html
> 
> COPY your_table (field1, field2, field3, fieldn) from 'yourfile.txt'
> WITH DELIMITER '|' encoding 'LATIN1';
> 
> Best regards,
> 
> 	
> 
> * *
> 
> *José Elcorrobarrutia*
> Mail:  jelcorrobarrutia@osse.com.pe <mailto: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
> <mailto:mileo@kmee.com.br>>:
> 
>     Hi,

We import 30k with import_odbc from a Oracle
>     database.

You can split the import columns in many imports,
>     like name, address and etc.

Best regards
> 
>     *- Luis Felipe Miléo*
>     *Gerência de Implementação*
>     +55 11 4063-9872  (SP)
>     +55 21 4063-8872 (RJ)
>     mileo@kmee.com.br <mailto:ananias@kmee.com.br>
>     *kmee.com.br* 
>     *Parceiro oficial no Brasil:*
>       
> 
>     ------------------------------------------------------------------------
>     *De: *"robert" 
>     *Para: *"Followers of Community" <community@mail.odoo.com
>     <mailto: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 <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 <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
> 


-- 
Alexandre Fayolle
Chef de Projet
Tel : +33 4 58 48 20 30

Camptocamp France SAS
Savoie Technolac, BP 352
73377 Le Bourget du Lac Cedex
http://www.camptocamp.com

Reference