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!