Bulk Updating Sheet using Data Shuttle?
Trying to build a solution for data updates on a mass scale.
I use Data Shuttle UPLOAD to pull in & update rows of data that need attention from one person (list is 900 rows right now). From there, I use Data Shuttle OFFLOAD to send a file of any rows that have not received input to a shared folder. The next step is for the user to record action (OK, REJECTED) in a column of the offloaded sheet, and then use Data Shuttle UPLOAD of that file to edit the data in the sheet. It doesn't seem to work though!? I've tested edits in the offloaded doc, and when it uploads, nothing 'merges' with the sheet.
I do not want to replace all the data because we need to record what has already received updates.
Am I missing something? Or is this not a capability?