-
Uploading Large Sheets In As Data Dumps
Hello, We are working on a project where we create data dumps in a folder that many sheets can use as a resource through formulas. Is there any way to upload daily under the same name, overwrite the file and not break the formulas that are pointing to these sheets? What are some solutions around this? Will we need…
-
Data Shuttle - Workflows Failing
I have multiple offload and upload workflows that have functioning quite well in Smartsheet, however after a week or two they seem to randomly not be able to find the Attachment File for the upload workflow and then give me that wonderful red error message. Anyone have a solution for this issue or at least an explanation?…
-
Automatically Export Data from a MySQL Database
Hi, I need to automatically import data from a database, which is a MySQL into Smartsheet. My admin tells me that DataIUploader wouldn't work and DataShuttle doesn't have databases as a source option? Does SmartSheet have a tool to automatically pull data from a MySQL database? Thanks in advance.
-
Data Shuttle Update Rows Workflow: Preventing Duplicate Updates
Hi all, I have a data shuttle update workflow that runs on a schedule updating rows in the target Smartsheet as they change in an excel source file stored in Box. I wanted to see if there was a way to somehow configure the data shuttle workflow so once a row has been updated, it can't be changed again. I tried doing this…
-
Data Shuttle Expression Not Working
Hello, I'm trying to create a Unique ID using an expression in Data Shuttle that looks at three columns. First, if there is a value in column A, then use that, if not use column B to create the first value (Value 1). Then I'm checking in column C to see this there's a value (Value 2). Then, I create the Unique ID, by…
-
Uploading an Excel with Data Shuttle Containing Duplicate Rows
I have a Data Upload workflow via Data Shuttle that runs on attachment for the most recent file. The excel files that stakeholders are uploading usually only have ~10 rows and when it goes through the workflow, the rows self-populate into the correct positions within a Smartsheet master database. The problem I have…
-
Reupload Data with DataShuttle
Dear All! I would like to create a tool which uses Data Shuttle. Basic idea is to ask user to upload attachment (via a form) which would trigger a data shuttle and info in the attachment would go to a transition sheet from where it would be moved to the target sheet with automation. It works nicely, however, I need to…
-
Data Shuttle Error Message
I realized a few of my shuttles were completed with errors and they all have the same error message of "Unable to add rows to target sheet : UNKNOWN: The specified key does not exist." but I'm unsure how to fix this error? I tried reselecting the target sheet, but it already seemed to be looking in the correct area.
-
Data Shuttle Error "Specified Key Does Not Exist"
In Data Shuttle, I have a workflow that is producing the following error: Unable to add rows to target sheet : UNKNOWN: The specified key does not exist. (Service: S3, Status Code: 404, Request ID: 7FED8H5R7Q5AXB87) This workflow has been operating fine for months (runs twice a day) with no errors and this just started…