So just an update for everyone, I solved this by creating 3 queries. One for adding new records, one for deleting records, and one for updating records. In the customization on the dashboard (shown previosly) I added a button to trigger the dynamic queries, and then looped through the results calling the adapter for UD08 to add, delete or update respectively. After some fiddling around with adapters I was able to get everything to work. I was worried about performance to be slow, but it’s surprisingly quick, probably thanks to the UD BO not really having any special rules to follow.
I probably (maybe should have??) done all of this on the server side with a BPM on my queries, but I’m a little more familiar with the client side, so that’s the way I went.
At the end of the day, the guy that’s doing the work can hit one button when he needs the tables updated, it takes about 5 to 10 seconds to run if there is a lot to update, and he’s ready to go. Much better than us manufacturing engineers copy pasting into DMT anymore.
Thanks for the discussion.