Solved

INSERT OR UPDATE procedure of data migration

  • 28 May 2021
  • 2 replies
  • 556 views

Userlevel 2
Badge +5

Hi, 

 

Currently I’m having the need of updating data daily to inventory_part_planning view. And I was recommended to use INSERT_OR_UPDATE procedure for this. How can I selectively update just for some fields, e.g safety stock, order point? Much appreciated if someone has a user guideline for this type of procedure.

 

 

 

icon

Best answer by Eranga Jayatissa 30 May 2021, 13:43

View original

This topic has been closed for comments

2 replies

Userlevel 4
Badge +6

Hi,

As I understood, you want to update the existing records connected to inventory_part_planning view.

There is procedure called Modify_Order_Point_Parameters in Inventory_Part_Planning_API. I hope you can use this procedure to update the order point parameters which you mentioned.

Or else you can use Modify___ Procedure inside Inventory_Part_Planning_API since you are going to update the existing records. You can pass the updated values through an attribute string to this method.

Hope this information will help you.

Best Regards,
Eranga

Userlevel 2
Badge +5

Thank you for your help @Eranga Jayatissa

I guess it is also good if I set up the File mapping like below. Pos 10-50 as the order in the csv file, and 0 for the rest of columns, which we dont want to update.

 

/Hazel