Question

Excel Migration Job - Modification Issue

  • 13 July 2023
  • 2 replies
  • 97 views

Userlevel 4
Badge +11

I’ve created an Excel migration job to modify values on a Sales Price List, but it seems that each time that I execute the job, a new record is created instead of updating the record that already exists. 

For this particular migration job, there will never be a requirement to insert new values, only update existing.  

 

Any ideas what I am doing incorrectly?

 

Environment: 23R1 SU 1

 

Source Mapping:

Method List Attributes:

 


2 replies

Userlevel 4
Badge +8

Hi @astfarazt 

 

Probably it has something to do with the field MIN_DURATION which should have the value -1

 

Please have a look into another community post where a similar issue occured:

 

/Jens

Userlevel 4
Badge +11

Thanks for the feedback, @Jens.

I tried that method, but, unfortunately, it was the same issue.  

I scrapped trying the Excel Migration and just used a standard Insert or Update via a File and that resolved the issue.  

In general, I noticed some strange behavior with the Excel Add In.  

Reply