-
Data Shuttle upload using CSV files on a Google Drive
Hi, I hope someone can tell me what I'm doing wrong. I'm trying to use Data Shuttle to upload data from CSV files stored in a Google Drive folder. The CSV files are updated by batch jobs which do NOT change the filename or the file ID. Data Shuttle shows the workflows completing successfully (green check next to the…
-
Data Shuttle - Delay in adding line to Target sheet
I have experienced a line of data that was submitted on 8/07/2023 show up on the target sheet on 5/24/2024. I am looking in to see if anyone else has experienced this and what could be causing this delay in the line being added to a target sheet. I have seen others in the past add to target sheet within 24 hours, but this…
-
Work around for Data Shuttle not recognizing identical data
Hello! This is pretty hard to explain but I am hoping someone can help me with this dilemma: I am using Smartsheet to build a tracking system that monitors where field project workers are showing up on a weekly basis. I get the job addresses as a spreadsheet from another department. Since I am working with hundreds of…
-
Data Shuttle Failing "Workflow Execute: Could not access source"
I have a Data Shuttle automation to pull in an Excel file to a sheet (replace) on a weekly basis that lives on Sharepoint. Every time the automation runs, I get the error message "Workflow Execute: Could not access source. Please check your workflow configuration for errors." The Excel file will also not be hyperlinked…
-
Pharmaceutical Life Cycle Management
Hello, my name is Louis and I work in Life Cycle Management for a rare disease pharmaceutical company. In my role, I use Smartsheet to translate the impact of project activity on our commercial products to the supply chain business. We detail project milestones, regulatory strategies and product demand to visualise…
-
Data Table constant error, "An Internal error occurred. Connection will refresh on next execution"
I have a Data Table linked to a sheet that gives a constant error (above), and will not work no matter how many times I rebuild it. There are no numbers with special characters, and the dataset is pretty standard stuff. I can't find any info at all on Data Table errors, and this has been going on for 24-hours. I used Data…
-
Data Shuttle Last Run Date and Timestamp
Please show the actual date/time rather than a relative Last Run Days/Hours/Minutes Ago. This would make it easier to do troubleshooting, especially with Data Shuttles that are scheduled to run more than once per hour.
-
Simultaneous Update of Project and Review Sheets, for Non-Existent Projects, with one form
I am part of a Solution Architecture department that uses Smartsheet to track project reviews. Our workflow involves two Smartsheet sheets: a Master sheet for basic project information (project name, ID, contacts, status), and a Review sheet for detailed review data (review ID, review name, review type, project name, and…
-
Merged: Data Shuttle Ownership Transfer
This discussion has been merged.
-
Data Shuttle changing the format of imported rows
I am data shuttling an excel spreadsheet .xlsx when adding any new data it is changing the format of the field. The entry in the field should look like 2019 when new data is shuttled over it changes this to 2019.00. The format of the rows in the excel are number and no decimal places. Does anyone have any ideas