Question

How to use Excel Migration to update Custom Field

  • 5 September 2023
  • 1 reply
  • 121 views
S
Rank
Badge +2

Hello All,

I'm looking for guidance on how to update a custom field in IFSAPP9 using an Excel Migration job. While I've created several migration job in the past this is the first one I'm creating that requires me to dump data into a custom field. The Custom field Is named HB_Origin. when looking at the debug console I see that IFS use the OBJID to update the field. How can get the OBJID from the Part_No the end user enters?

 

 

1 reply

E
Rank

Hii,

You can following step that may be help you to solve issue:

  1. Use SQL to query the database for the OBJID associated with the provided 'Part_No.' You can use Excel's SQL Query functionality or an external SQL tool.
  2. In your Excel Migration job, map the OBJID obtained from the query to the 'HB_Origin' custom field for the corresponding 'Part_No' record.
  3. Execute the migration job to update the custom field with the mapped OBJID values.

Reply


Terms & ConditionsCookie settings