-
Error encountered with DataTables: Error getting CSV primary key values
I'm using Data Shuttle to upload data onto a new Data table. For this upload workflow, i am using an existing smartsheet attachment (from offload workflow) However, running my upload workflow caused an error: If i were to replace the target from Data Table to a sheet, it can run without any error. Here's the fields in my…
-
Data Shuttle not pulling in new rows from source sheet
Hi, I have a Data Shuttle workflow that I set up that has been working for 4 months, but for the past few weeks, has not been picking up rows that should be added to the Target sheet. Any ideas why it suddenly stopped working? The source file is saved in Box (I've verified/reconnected by Box account). There are 96 rows in…
-
Merged: Automations that trigger Shuttles
This discussion has been merged.
-
Saved changes and updates from Dynamic View are not saved in source sheet
I have some team members assigned to projects via Dynamic view, and everytime they go to edit and save their changes, it temporarily saves them, then when we go to look at the reflected changes in the source sheet they disappear. Functionality was working for a couple months, but just this week multiple team members have…
-
Data Shuttle Error Message
This data shuttle started receiving this error message recently and I'm not sure what it means. Nothing was changed on the sheet except for 3 additional text fields were added and those are set up properly with the right column properties. I checked all other column properties and those also seem to be fine. Also do not…
-
Data Shuttle Features should be native to Smartsheet
Making certain features such as not being able to upload data into an existing sheet is a serious flaw in the foundational system and making it a premium paid add-on to get this feature that users have repeatedly requested isn't a great business model.
-
Data Shuttle Upload Filters
I am using Data Shuttle to upload Smartsheet's own Users.csv report into a sheet. That report has multiple TRUE/FALSE columns. I was trying to apply a filter to one of these columns. In my target sheet all of these Booleans are configured as checkbox columns, and all columns are mapped. It took me about 15 attempts to get…
-
Troubleshooting Data Shuttle
I am having issues with Data Shuttle adding rows at the bottom. It seems to be skipping 20+ rows in Smartsheet when my data source doesn't have those blank rows. I did add a filter to filter out blank rows. Any suggestions?
-
I need Data Shuttle to work with Trailing Zeroes
This is a huge pain point for me. I often have Data Shuttle lookup values that end in a zero (like 6457813.54610). When I set up a data shuttle, the rows that have a trailing zero don't pull back match when the Data Shuttle runs. I REALLY don't want to have to write a function that says: look for the "." and if the count…
-
Data Shuttle Price and features
Hi. Can someone tell me the monthly subscription fee of Data Shuttle please? The only feature I expect to accomplish with Data Shuttle, is to auto-update the dropdown column values, by linking the given dropdown column to another column / sheet of Smartsheet. By this I mean I will not be importing data from any external…