-
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 deleting rows
Hi all, Im new to data shuttle, implementing my first workflow.. overall its working fine, but what its not doing is deleting records when I attach new data to my source sheet. The scenario is, the source sheet contains a row thats not in the updated data. My expectation is when data shuttle runs it finds a target row…
-
Connect Data Table to multiple sheets, Bridge, or Salesforce
It would be nice if we were able to import information from sheets, Bridge, or a connector to a Data Table. We have a sheet that was created via multiple imports from Salesforce. We would like to add more information to it but because of Cell limits we are unable to. It would be helpful if we could setup a connector from…
-
When I upload a smaller file to my Data Table will it remove the old data if it exceeds the new?
Hello,, I'm figuring out data tables slowly and a question I have is if i upload a csv with 200k rows to my data table, then i turn around and upload the same file but it only has 150k rows, will it delete the extra 50k? thanks, Spencer
-
DataTable Run Errors
I'm trying to pull from a DataTable, but I keep getting this error message: I've tried to delete and rebuild the connection, but I'm not having any luck. Is it some type of server error, or is it another type of issue?
-
Assistance connecting document to dropdown in intake form
We would like to use the form capabilities on project sheets to prepopulate dropdown fields with preselected information from source documents or sheets that live in the same project folder. Example - if a person is updating a specific deliverable, to ensure the naming convention and correct deliverable is selcted and…
-
Multiple columns using same datatable to lookup values
Hello everyone, I have a sheet that stores part numbers / stock codes. There are 5 columns that have a part number. The "master" part number list has 45K records, and I have successfully stored this as a datatable. I have also linked this datatable to one column in my sheet, using the stock code, to look up the…
-
Merged: Validation Phone Prefix is missing for many countries
This discussion has been merged.
-
Data Table not showing data
Hi all, I'm trying to add data to a new Data Table. When I run a workflow through Data Shuttle it says 506,233 rows have been added (see image) but in my DataTable is says "There's Nothing Here" (see image 2). Any ideas?
-
Data Table clean up
There is currently not a way to clean up data tables efficiently, only continue adding data to them. Would be good to be able to run some type of clean up on the table to remove data that is no longer needed. This would also help free up server space.