Solved

Excel Add In Migration Custom Field Not Working

  • 23 October 2020
  • 1 reply
  • 571 views

Userlevel 5
Badge +10
  • Sidekick (Customer)
  • 117 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

 

icon

Best answer by jtobin 23 October 2020, 20:30

View original

1 reply

Userlevel 5
Badge +10

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