Skip to Content
Meniu
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
Această întrebare a fost marcată
2 Răspunsuri
1773 Vizualizări

I need to Migrate (data import) from legacy "Infor Visual Manufacturing ERP" to Odoo.

Does anybody have any field mapping script, which I can use for reference purposes to help me populate the Odoo data import templates CSV files (or use SQL to insert directly into Odoo tables)?

Below is an example of the type of mapping script which I seek, which I would use for inserting Visual's "Customer" table into Odoo's table "public_res_partner":

SELECT DISTINCT c.ID AS ref, c.NAME AS name, c.NAME AS company_name, "1" AS is_company, c.OPEN_DATE AS create_date, c.WEB_URL AS website, c.ADDR_1 AS street, c.ZIPCODE AS zip, c.CONTACT_EMAIL AS email, c.CONTACT_PHONE AS phone, c.CONTACT_MOBILE AS mobile, 1 AS active 
INTO public_res_partner_temp
FROM dbo_CUSTOMERl AS c;



Thank you very much!


Imagine profil
Abandonează
Cel mai bun răspuns

Hi Nat,

I think this video can help you: https://www.youtube.com/watch?v=UOBxxnYDIsM&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=1

Imagine profil
Abandonează
Cel mai bun răspuns

Hi,

You can use the import export option of odoo. Suppose if you need to export all the products from legacy erp into odoo, you can export the product records from your erp in an excel sheet or a csv and then you can import it into odoo.


To get an import template for odoo, just create a record in corresponding table, and then from tree view, export it by selecting necessary fields and use the exported file as a template for further imports.


Achieving it using scripts are also fine, you can utilize the xmlrpc to connect with odoo from external application.

Thanks

Imagine profil
Abandonează
Related Posts Răspunsuri Vizualizări Activitate
6
ian. 25
10779
0
ian. 24
657
0
dec. 23
898
1
feb. 25
4687
3
dec. 19
8564