Data Shuttle not updating with all data
I have created a Data Shuttle upload, with no filters, to replace rows on my Smartsheet destination sheet. I discovered that all rows were not being added to the destination sheet. Debugging narrowed the problem down to the contents of one column. In Smartsheet, the column is formatted as Text/Number.
In Excel for testing, I created a small test file and formatted the column as Number, as Text, and I have even added an apostrophe to the beginning. When uploaded with Data Shuttle, the highlighted row is not copied; the other rows are copied. Here is my sample Excel file:
These values will NOT be used as numbers for calculations. I thought that, at the very least, adding the apostrophe would force Smartsheet to consider it as a string. What am I missing?
Best Answer
-
Hi @LWright
Have you tried adjusting the column format in the mapping of the workflow to be Text, like so:
The number you have showing is too many characters to be seen as numerical in Smartsheet. When I mapped the same data into a "Number" column, that one value was still brought in, but was automatically seen as text.
If adjusting the column type to text hasn't helped, would you be able to post screen captures of your workflow set-up? I'd like to see if I can replicate this.
Thanks!
Genevieve
Answers
-
Hi @LWright
Have you tried adjusting the column format in the mapping of the workflow to be Text, like so:
The number you have showing is too many characters to be seen as numerical in Smartsheet. When I mapped the same data into a "Number" column, that one value was still brought in, but was automatically seen as text.
If adjusting the column type to text hasn't helped, would you be able to post screen captures of your workflow set-up? I'd like to see if I can replicate this.
Thanks!
Genevieve
-
Thanks for the pointer, Genevieve.
I didn't know about the Column type in Data Shuttle -- by default (at least for me), it was collapsed/hidden. I'm just getting my feet wet with Data Shuttle and have a lot to learn! When I changed to type "Text", as you indicated, all values were copied to my target sheet as expected! Thanks again.
-
No problem! I'm glad that the setting worked for you 🙂
