Skip to main content
Solved

Excel Add In Migration Custom Field Not Working

  • October 23, 2020
  • 1 reply
  • 682 views

Forum|alt.badge.img+10
  • Sidekick (Customer)
  • 133 replies

Hello,

Yesterday I posted a question about an Excel Add In Migration error.  I was able to resolve that error.  But the migration job isn’t inserting/modifying the data.  Does anyone know what I’m missing?  So far I haven’t been able to use the online documentation to resolve this problem.

 

This is my migration job (I’ve tried several variations - this is the latest) -  

  • the Search function fetches the records from IFS
  • Validating the data returns Validate OK
  • Execute shows Updated in the Result Column
  • But when I query the results in IFS there has been no change in the Custom Field

 

 

I have tried entering the Column Name and the Column Value.  I have also tried leaving them blank.

 

 

 

I have separately tried both the OBJKEY and Contract/Part_no in the FETCHCONDITION Rule Value
INVENTORY_PART.CONTRACT=INVENTORY_PART_CFV.CONTRACT and INVENTORY_PART.PART_NO=INVENTORY_PART_CFV.PART_NO

INVENTORY_PART.OBJKEY=INVENTORY_PART_CFV.OBJKEY

 

The results are fetched and shown in Excel using Search
Validate OK appears in the Result Column on Validate
Updated appears in the Result Column on Execute
But when I check in IFS, no changes are made to Brand
​​​​

 
A change to the Description does update IFS
But the change to the Brand is still missing

 

Best answer by jtobin

I finally was able to make this work.  I realized I had a mismatch in the field name.  The Method Attribute field was called xxx_DB but the Source Mapping didn’t.  Operator error!

View original

1 reply

Forum|alt.badge.img+10
  • Author
  • Sidekick (Customer)
  • 133 replies
  • Answer
  • October 23, 2020

I finally was able to make this work.  I realized I had a mismatch in the field name.  The Method Attribute field was called xxx_DB but the Source Mapping didn’t.  Operator error!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings