Data Shuttle won't run manually or on a schedule after first instance
I've been struggling with this for a day. I am offloading a Sheet to a Google Drive. When I create the workflow in Data Shuttle and click RUN, it runs fine. If I try to do it again, it seems to process the file, but it never updates in on Google drive. I can repeat this over and over, it will only run once. Ive tried waiting about 15 minutes, and it's the same result. Also, the scheduling just stopped working. It's seems to be working fine on a pre-exisitng Workflow though. What am I doing wrong?
Best Answer
-
I assume you are writing out the file with the same filename? On google drive it will overwrite the exiting file. Does the date time stamp change? If you right mouse click you can see "Manage Versions". Does it show multiple versions of the file?
Also, after the first run did you delete the file from Google Drive? If so, then check the trash to see if the file now has multiple versions. Once smartsheet writes out a file, it updates the file by file id, not by name. So if you move/delete the file it does not write out a new file where you are expecting it.
/marc
Answers
-
I assume you are writing out the file with the same filename? On google drive it will overwrite the exiting file. Does the date time stamp change? If you right mouse click you can see "Manage Versions". Does it show multiple versions of the file?
Also, after the first run did you delete the file from Google Drive? If so, then check the trash to see if the file now has multiple versions. Once smartsheet writes out a file, it updates the file by file id, not by name. So if you move/delete the file it does not write out a new file where you are expecting it.
/marc
-
Thanks, Marc4. Based on your questions I figured out how it operates. It is working great now!
-
@marc4 Thank you for your previous answer, it saved me today!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives