-
Data Shuttle source file is password protected
I am using Data Shuttle to import data into a DataTable from an Excel file that's password protected. After the workflow runs there's no data in the DataTable as a result. I've tested the same Data Shuttle workflow with a file that's not password protected, and it works fine. Is there a way to import data from a…
-
Time columns from Excel to Smartsheet via Data Shuttle
I'm trying to Data Shuttle an Excel doc from another system into Smartsheet. All is fine, except for the Start Time and End Time columns. They look like this in Excel: But when I pull them into Smartsheet via Data Shuttle, the columns show only the date part of those columns: I'm really only interested in the time…
-
Data Shuttle to Power BI
I am working on a project for a client, where they want to have dashboards built out for data analytic purposes that update automatically. The client already invested money into data shuttle, so data is automatically going to pull from the different data sources. Given that Smartsheet dashboards have limited analytics…
-
Data Shuttle: Why am I getting this error and how do I fix it?
I download excel from sharepoint and upload it to smartsheet as a new attachment. It was working perfectly fine but about 20 days ago it started showing this error message. What is causing this issue and how do I fix it?
-
Integrating Jotform via Zapier
Hi all, Wondering if anyone has had luck integrating Jotform and Smartsheet via Zapier. We would like to create an action where submissions in Jotform are "shuttled" as new rows to a grid in Smartsheet. Unfortunately Data Shuttle does not support Jotform (at least for us), but could a similar action be created via Zaps?…
-
Integrating Jotform via Zapier
Hi all, Wondering if anyone has had luck integrating Jotform and Smartsheet via Zapier. We would like to create an action where submissions in Jotform are "shuttled" as new rows to a grid in Smartsheet. Unfortunately Data Shuttle does not support Jotform (at least for us), but could a similar action be created via Zaps?…
-
Please Allow Multiple Admins for DataMesh
Our team is really struggling to troubleshoot issue when the owner of a DataMesh or Data Shuttle is out of the office. Please allow multiple Admins and/or Editors (or, at the very least, Viewers) for these critical tools.
-
Data Shuttle, how to find the right Excel Tab number
Hi all, having some trouble nailing the logic for the tab number and I don't see this in the documentation or in prior questions. First, I assumed the tab number would be the count, left to right, of the visible tabs (3rd one). But that wasn't right. Next I tried looking at the tabs in the VB editor and counting top to…
-
Data Shuttle, Use sheet name to link which tab to reference
The tab number in Excel is easily changed and seems unreliable. In my experience, when the tab number does change, there isn't a method for Data Shuttle to alert you of any issue. It's typically an end user that alerts me that some data appears outdated. Preventing file changes in Excel would be one counter measure, but…
-
How do I opt-in on large scale sheets (individually) so that I can use Data Shuttle with Tables?
My organization has access to both EAP features and Table View, alongside the increase in limits associated with that. Despite this, one of my colleagues cannot seem to use Data Shuttle to upload more than 20,000 rows worth of data. I've seen bits and pieces of information suggesting a per-sheet/table opt-in, but cannot…