search

sandeepmohan23 / yfai_data_migration

YFAI Data Migration
0 stars 0 forks source link

Issue#7 Program (Master) Attributes are not matching #21

Open rajender2k opened 7 years ago

sandeepmohan23 commented 7 years ago

Updated with dispositions for each reported issue on Master Programs

@premshankar1 please update/troubleshoot

a+b) ng4DCLaunchSiteRgn is incorrectly mapped toyf5_LeadMfgCountry for the Ng4_MasterPrgRevision object. Mapping needs to be updated to be mapped to yf5_VehicleSalesRegions

c+d) mapping seems to be correct. is this happening for other values (not legacy)

e+f) attribute seems to be mapped correctly, need to take a look at source + target XMLs

g+h) ng4SDTLead was not mapped for iteration 2. ng4SDTLead is a string attribute that holds email addresses in TC9. It is an untryped reference in TC10. YFAI needs to provide a lookup/mapping for theses

i+j) mapping spreadsheet maps ng4VehicleName to yf5_OEM_Model_Name, as does the mapping xml file. mapping is correct, Sarma is looking at "Model Name" attribute in TC10 ASP when he should be looking at "OEM Model Name"

premshankar1 commented 7 years ago

e+f: Checked assy_transfer\ALL_NG4_PRG_MASTERPRG_PWP_Phase0_ITEMS_1.xml before and after transform. The attribute ng4PrgStatus, with the same mapping transforms ok for Ng4_Program but not for Ng4_MasterPrg. The to-be attribute a9_ProgramStatus does not appear in the A9_ProgramItemRevision node in the transformed file

premshankar1 commented 7 years ago

a+b: Does not work. Opened issue https://github.com/sandeepmohan23/yfai_data_migration/issues/28 for this e+f: working OK g+h: Working OK with a dummy lookup file

premshankar1 commented 7 years ago

@sandeepmohan23 is there a feedback on c+d. If it is working ok, let us close this issue.

premshankar1 commented 7 years ago

a+b: Working OK