I've just started working with DataShuttle to automate a few of our reports.
We pull these reports weekly from SAP as an excel file, what we want to do is replace the file each week with the new file. These always download from SAP with the same name (EXPORT.XLSX), and I was wondering if this will effect the upload, or if we would need to copy the data from the new report into the source file each week in order for the upload into Smartsheet to work correctly?
Changing the file out in our tests didn't seem to effect the shuttle itself (The file name doesn't grey out), but I did notice that the data in one of the columns didn't appear to update until I went in and re-selected the source file.