Community mailing list archives
Re: mass importing partners. whats the best way?by
Have you considered erppeek?
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 exampleCOPY your_table (field1, field2, field3, fieldn) from 'yourfile.txt' WITH DELIMITER '|' encoding 'LATIN1';Best regards,
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 EnvironmentHi,<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éoGerência de Implementação+55 11 4063-9872 (SP)+55 21 4063-8872 (RJ)firstname.lastname@example.orgParceiro oficial no Brasil: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
Eric Caudal (from my mobile)