Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
2 Trả lời
2226 Lượt xem

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!


Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

Hi Nat,

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

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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

Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
6
thg 1 25
11535
0
thg 1 24
989
0
thg 12 23
1222
1
thg 6 25
320
1
thg 2 25
5047