Skip to main content
Solved

Excel Migration job not updating column values for Custom pages

  • October 25, 2021
  • 2 replies
  • 556 views

Forum|alt.badge.img+2

Hello,

I have created 2 separate Excel migration jobs for creating and modifying records of Custom page.

Creating job is working fine where as updating job not working(Observed that objkey is not fetching).

As per below IFS community suggestions i changed the key flags as well ,then too not working.

Is there anything i have missed ?

Here are my job details 

Note: If i use other job procedures like 'INSERT_OR_UPDATE’  its working fine, facing this issue only for Excel Migration.

Best answer by Technical Outlaws

When it comes to migrating into custom logical units, we have to make some changes to the following areas.

Source Mapping

  • Decide and set the Key (K) flag against the appropriate column(s) and adjust the position so that they are in sequential order.

 

Method List Attributes

  • Ensure the Column Sequence and Flags are amended to reflect what is shown in the Source Mapping.
  • The On New and On Modify checkboxes should be set to reflect which attributes are to be included in the new and update process.

 

This topic has been closed for replies.

2 replies

Technical Outlaws
Hero (Employee)
Forum|alt.badge.img+11

When it comes to migrating into custom logical units, we have to make some changes to the following areas.

Source Mapping

  • Decide and set the Key (K) flag against the appropriate column(s) and adjust the position so that they are in sequential order.

 

Method List Attributes

  • Ensure the Column Sequence and Flags are amended to reflect what is shown in the Source Mapping.
  • The On New and On Modify checkboxes should be set to reflect which attributes are to be included in the new and update process.

 


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Partner)
  • November 3, 2021

Hello Technical Outlaws,

 

The thing i missed ,I have not changed the key flags in method list attributes.

Thanks for your help to resolve the issue and its working now .