Data Shuttle not updating blank values from source file?

ygoldgrab

Anyone else having this issue?

All the Data Shuttles that I set up, are not anymore been bringing data to Smartsheet from cells that have changed to being blank in my Source Location.

This was discovered yesterday, 10/17, when I received many reports from colleagues that work on different sheets that the data shuttle integration was updating only some values but not all. After extensive research - I discovered that the values in source file that were not blank were being updated in Smartsheet but not the values that changed to being blank in the source file were not getting updated in Smartsheet.

I've been using Data Shuttle for a long time to merge and update data from Source files of Smartsheet Excel Attachments and for Source being files in Box and has been working fine to update all values from source whether blank or not. I've tested this by creating new workflows and have had the same result - blank values from Source file are not being updated in Smartsheet.

Below is a test workflow where blank values from Source file are not being updated while non blank values were updated. I reached to Support but I feel that the community should know as I spent a lot of time researching this and searching the community to see if anyone else was having this issue

ygoldgrab

Support just let me know that this issue was resolved!!!

I tested this with Source as Box and as Excel attachments and blank values now update!!

Ryan Kramer

Some of my clients have migrated from using Data Shuttle because of issues like this and another case where data does not load for large files. Gets cut off.

Alternatively, you can build a data upload process that scripts the deletion and insertion of the rows on a daily basis.

ygoldgrab

This has worked in the past so maybe data validation was added to exclude blank values?

Ryan Kramer

I'm not sure. We have pretty much migrated from Data Shuttle to Scripted ETL.

It just works more consistently and we usually have some transformation we are doing in the scripts so it just fits our needs better.

Happy to chat if you would like some of these built out for you.

Ryan

ygoldgrab

Thanks for the info, but I'm still looking for help with Data Shuttle

Ryan Kramer

All good and good luck!

Ryan

Genevieve P.

Hey @ygoldgrab

I checked in with Support and they let me know you have a case open with them already and that they're investigating this behaviour. Support will be the better place to chat through your details so you can share private information (such as screen recordings of your set-up and more information about your source and destination sheets).

Thank you!

Genevieve

Jennifer O

My organization is also experiencing this issue. This week with our Data Shuttles any blank field is not updating. This is causing problems with a lot of our workflows. Hopefully Smartsheet will resolve this soon or communicate how to correct it.

ygoldgrab

Support just let me know that this issue was resolved!!!

I tested this with Source as Box and as Excel attachments and blank values now update!!

Trieu Nguyen

@Ryan Kramer would it be possible for you to share the Python ELT scripts to replace Data Shuttle workflows with me? Thanks.