- Unique Identifier Column
I'm trying to get a Datashuttle migration to work and there is no documentation on the limitations of the unique identifier column. Can this column in SS be a column formula as that is how my unique IDs are being generated. I know that both of these columns exist and tested by creating a paste values column in SS in which…
- 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 importing Values
When I use Data Shuttle to import data to a sheet, it keeps adding a ' in front of the numbers which turns them into text and not numbers. For example, $23.50 turns into '23.50 when imported through Data Shuttle. The original excel file itself is formatted correctly. Anyone know how to fix this?
- 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…
- How to push data into Data Table via API?
Hello, Is there an API to push data into Data Table in Smartsheet? We have a client using Smartsheet and we are able to push data into sheets using the SDK. However we have been asked to feed them into Data Table directly. I can't see anything in the API documentation related to Data Tables. Is it even possible? I read…