Data Shuttle deleting my whole sheet??
I have a mystery with my Data Shuttle workflow and I cannot figure it out. I have been using it successfully for the past several months and today for some reason, when I upload a new attachment, it deletes all my rows in my target sheet. The unique identifiers are still the same and I cannot figure out what is different this time that it would delete everything.
Any insight?
Answers
-
It sounds like perhaps your DataShuttle workflow is configured to "Delete rows that no longer match the filter criteria", could that be the case? If so, it may be that the unique identifiers are no longer finding a match between your two documents.
I would recommend importing your source sheet in manually and then you could use a COUNTIF formula to see if the unique values are matching between sheets.
You may also want to reach out to Smartsheet Support with a screen recording of your entire workflow set up, the source file, and an image of the sheet in Smartsheet (and url). They'll be able to troubleshoot this with you in a private channel where you can share more details.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank You @Genevieve P.
I have no filter criteria set up and we changed nothing in the DataShuttle workflow which worked properly last week which is why we are stumped.
I manually checked all unique identifiers and everything is identical to the last time we ran it so it is quite the mystery.
I will definitely follow up with Support since this seems to be more complicated then me simply overlooking something. Thank you so much for your input.
Susan
-
@Susan Vieira Last time this happened to me the person sending me the excel report had made a barely noticeable change to some column headers.
-
@Paul H , thanks!! I will have them double check!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives