Skip to main content
Question

Excel Migration Job - Modification Issue

  • July 13, 2023
  • 2 replies
  • 167 views

Forum|alt.badge.img+12

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

Jens
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • 137 replies
  • July 13, 2023

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


Forum|alt.badge.img+12
  • Author
  • Hero (Partner)
  • 230 replies
  • July 14, 2023

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.