-
Enhancement to update Data Shuttle to recognize/preserve leading zeros in front of numbers
Use case: Managing hundreds of cloud accounts that have a fixed length ID and a randomly assigned number. Some account IDs have 1-3 leading zeros, some have none, as long as the overall length is 12 digits. Issue: When using Data Shuttle to import updated lists of accounts, existing accounts with leading zeros, are deleted…
-
Using data shuttle for weekly backups from smartsheet to sharepoint
I have successfully turned on the weekly export from smartsheet to sharepoint, but the action is "replace". I don't want to replace my file each week, I want a series of dated weekly backups for an audit trail. Is this possible?
-
Some dates importing incorrectly through Data Shuttle
I am uploading data onto Smartsheet through Data Shuttle from a CSV file. I have a date column and have confirmed most dates are importing correctly, however there are instances where the day and month are swapped. i.e. the date on the CSV file reads 12/04/24 (DD/MM/YY), but is added to the Smartsheet as 04/12/24. I've…
-
Data Shuttle inconsistencies in updates
Hello, everyone. We've been working with support but I wanted to get a feel on what other users are finding. Does anyone else find inconsistencies in their Data Shuttle updates? It's been suggested to us that we need to try smaller batches that what we're needing but even with that we're finding that things like mapping…
-
Offloading Data to One Drive using Data Shuttle
Hi everyone, I am trying to offload a Smartsheet sheet to OneDrive. When I sign in from the "Select your target file" page after selecting "OneDrive & Sharepoint" as my target location, a notification appears that I "Need admin approval". I have contacted my IT team to grant me the approval but they are telling me that a…
-
Data Shuttle Mapping
I am creating a data shuffle workflow with a source that has 74 columns. Is there a way for the headers to auto populate when I am mapping, or do I manually have to type in my headers for all columns?
-
The Data Shuttles aren't processing on upload but I can run manually. Any ideas why?
I have about 100 Data Shuttle workflows which have been running as expected on upload for the past 6 months. On 11/13 all of sudden about 100 decided to stop running on upload. I can still manually run them. The offload workflows are working so that should trigger them to run.
-
Data Shuttle Offload--Where is the data ?
Hello- I have created an offload workflow in data shuttle-from one smartsheet to another, but once the workflow says complete I can not find the new rows. When I look in the sheet history of the target sheet it shows that an attachment was succesfully added. Does anyone have any experience with this issue?
-
Can Data Shuttle avoid overwriting existing cells that meet a current criteria in Smartsheet?
I am uploading a status from another system. The other system may contain information not yet available in Smartsheet, but Smartsheet remains the most current version. If an item is marked as "Complete" in Smartsheet, I'd like it to remain "Complete" and not be overwritten by the Data Shuttle. I see there are filters for…
-
Sheet Access Report Size Limitations
Hello Community Friends - Does anyone have a creative solution for managing the Sheet Access Report? Ours has exceeded the max row limitations of both Excel and Google Sheets. We need the ability to look up who is Sheet Owner and/or Admin of various sheets that we might not have access to, but we can no longer load all of…