Data Shuttle Not Adding Net New Entries
Hello! I have set up Data Shuttle with the intention that the PM on the project can attach the daily issue log she receives from our IT department and her sheet would be automatically updated. She document she receives from IT is an .xlsx spreadsheet.
I noticed that with each new attachment, the existing data would be updated accordingly, but the new issues were not being added to the Smartsheet. I reached out to a couple of other Smartsheet SME's in my company, but we're all stumped.
I thought I had found a couple of things that could have been the culprit - sometimes IT will add a second tab to their Excel doc, or they will add or delete column. Unfortunately, this doesn't seem to be the case... I manipulated all the Excel docs that I have so that they were all 1 tab and all of the columns matched. I then created a Smartsheet from scratch and created a brand new upload workflow in Data Shuttle. I gave it a test and I'm still not getting new entries added to my sheet!
If anyone has any insight they can offer, it will be greatly appreciated.
Settings below; I have no filters or expression on this workflow:
Best Answer
-
kelceyg ✭✭✭
Hello! Just to close the loop on this - turns out there were hidden tabs on the Excel spreadsheets I was being provided. When I ran the Data Shuttle, it was reading the information on the hidden tab, not the tab I was seeing/needed. Once I removed the hidden tabs, Data Shuttle worked as expected!
Answers
-
Genevieve P. Employee Admin
Hi@kelceyg
All of your settings look correct!
The checkbox to "Add rows as they are added to the source file" should enable new rows with a newuniqueID in your Number column to pull over.
The only thing I can think of in this moment is if the new rows have duplicate content in that Number column, so it's not seen as a new, unique row. Could that be possible?
Cheers,
Genevieve
-
kelceyg ✭✭✭
Hello! Just to close the loop on this - turns out there were hidden tabs on the Excel spreadsheets I was being provided. When I ran the Data Shuttle, it was reading the information on the hidden tab, not the tab I was seeing/needed. Once I removed the hidden tabs, Data Shuttle worked as expected!
Categories
I got 2 ideas :<\/p>
- Build a Report that refer to all project sheets (as source sheets) and setup \"As current user\" filter, then embed that Report to a Dashboard (with Viewer mode setting is \"Their own perspective\" in Dashboard). The viewer will not see only data regarding to them without the comment column.<\/li>
- Build a Report that refer to all project sheets (as source sheets) and build a Dynamic View (DV) that refer to this Report (as source data) and setup :
- \"As current user\" filter in this DV for external stakeholders to see only data regarding to them. <\/li>
- Hide comment<\/li><\/ol><\/li><\/ol>
This will save your effort to build many DV for different stakeholders<\/p>
Hope that helps<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":466,"urlcode":"control-center","name":"Control Center"},{"tagID":578,"urlcode":"portfolio-workapp","name":"PORTFOLIO WORKAPP"},{"tagID":580,"urlcode":"workapp","name":"workapp"},{"tagID":581,"urlcode":"comments","name":"comments"},{"tagID":582,"urlcode":"global-updates","name":"global updates"}]},{"discussionID":94351,"type":"question","name":"Copy a Row Automation in Control Center","excerpt":"Hello Everyone, I am recently started working on the Control Center. In my blueprint, there is one Automation workflow \"Copy Row into Completed Sheet\". So the Condition is if the Completed task is checked then the row moved to the Completed sheet. But when I create a new project using the control center then in this…","snippet":"Hello Everyone, I am recently started working on the Control Center. In my blueprint, there is one Automation workflow \"Copy Row into Completed Sheet\". So the Condition is if the…","categoryID":343,"dateInserted":"2022-08-17T06:34:21+00:00","dateUpdated":"2022-08-18T11:54:54+00:00","dateLastComment":"2023-08-01T16:21:51+00:00","insertUserID":134589,"insertUser":{"userID":134589,"name":"Kaveri Vipat","url":"https:\/\/community.smartsheet.com\/profile\/Kaveri%20Vipat","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/NQKN3CYKP7WS\/nPGXBF6SL3KW8.jpg","dateLastActive":"2023-08-02T13:38:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"lastUserID":164385,"lastUser":{"userID":164385,"name":"Caitlin N","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Caitlin%20N","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-01T16:20:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":240,"score":null,"hot":3351626772,"url":"https:\/\/community.smartsheet.com\/discussion\/94351\/copy-a-row-automation-in-control-center","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94351\/copy-a-row-automation-in-control-center","format":"Rich","tagIDs":[334],"lastPost":{"discussionID":94351,"commentID":388236,"name":"Re: Copy a Row Automation in Control Center","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388236#Comment_388236","dateInserted":"2023-08-01T16:21:51+00:00","insertUserID":164385,"insertUser":{"userID":164385,"name":"Caitlin N","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Caitlin%20N","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-01T16:20:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-17T13:29:56+00:00","dateAnswered":"2022-08-17T08:03:13+00:00","acceptedAnswers":[{"commentID":340023,"body":"
Hi @Kaveri Vipat<\/a> <\/p>
I hope you're well and safe!<\/p>
Unfortunately, as far as I know, it's not possible now to have the Destination Sheet change dynamically, but it's an excellent idea!<\/p>
Please submit this as a Product Feedback or Idea <\/strong>(If it hasn't been added already)<\/em><\/strong> when you have a moment.<\/strong><\/a><\/p>
I hope that helps!<\/p>
Be safe and have a fantastic week!<\/p>
Best,<\/p>
Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":108283,"type":"question","name":"Bridge: Add Row module with empty cells","excerpt":"Hello - I am working a Bridge workflow to Get Row from a source sheet, and Copy Row with select columns to a target sheet. The workflow between the sheets is working great, but my question is that some row cell information will be blank from the source sheet going to the target sheet and thus my Get Row Cells Values come…","snippet":"Hello - I am working a Bridge workflow to Get Row from a source sheet, and Copy Row with select columns to a target sheet. The workflow between the sheets is working great, but my…","categoryID":343,"dateInserted":"2023-07-28T22:43:32+00:00","dateUpdated":"2023-07-31T09:08:57+00:00","dateLastComment":"2023-08-01T12:05:13+00:00","insertUserID":155331,"insertUser":{"userID":155331,"name":"MHalvey","url":"https:\/\/community.smartsheet.com\/profile\/MHalvey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5XN473Z9AXCW\/nOE57ZX9L8KLD.png","dateLastActive":"2023-08-01T21:28:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":91566,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-02T18:22:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":47,"score":null,"hot":3381478725,"url":"https:\/\/community.smartsheet.com\/discussion\/108283\/bridge-add-row-module-with-empty-cells","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108283\/bridge-add-row-module-with-empty-cells","format":"Rich","tagIDs":[227,277,369,448],"lastPost":{"discussionID":108283,"commentID":388166,"name":"Re: Bridge: Add Row module with empty cells","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388166#Comment_388166","dateInserted":"2023-08-01T12:05:13+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-02T18:22:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/SAB67C168CJ8\/get-row-cell-info.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Get Row Cell Info.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-31T20:14:05+00:00","dateAnswered":"2023-07-31T16:55:59+00:00","acceptedAnswers":[{"commentID":388055,"body":"
I misspoke. You would set one up for each column. The trigger would be when rows are added or changed and [Column Name] changes to any value, condition is [Column Name] contains {{, action would be Clear Cell Value in [Column Name].<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":369,"urlcode":"bridge-by-smartsheet","name":"Bridge"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=343&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-dateLastComment&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":629,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">