Community mailing list archives
community@mail.odoo.com
Browse archives
Re: mass importing partners. whats the best way?
by
Camptocamp France SAS, Alexandre Fayolle - Camptocamp
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
-
mass importing partners. whats the best way?
byredCOR AG, robert rottermann-
Re: mass importing partners. whats the best way?
byOpusVL, Nuria Arranz-Velazquez -
-
Re: mass importing partners. whats the best way?
byredCOR AG, robert rottermann -
Re: mass importing partners. whats the best way?
byredCOR AG, robert rottermann -
Re: mass importing partners. whats the best way?
byCamptocamp France SAS, Alexandre Fayolle - Camptocamp -
Re: mass importing partners. whats the best way?
byEric Caudal (Odoo Community Association) -
Re: mass importing partners. whats the best way?
byOSSE - Oficina de Soluciones y Servicios Empresariales, jolevq -
Re: mass importing partners. whats the best way?
byKMEE, Luis Felipe Miléo -
-
Re: mass importing partners. whats the best way?
byLaurent Mignon - Senior Software Engineer, Acsone
-