Data Shuttle importing Values

Michael Culley
Michael Culley ✭✭✭✭✭

When I use Data Shuttle to import data to a sheet, it keeps adding a ' in front of the numbers which turns them into text and not numbers.

For example, $23.50 turns into '23.50 when imported through Data Shuttle.

The original excel file itself is formatted correctly.

Anyone know how to fix this?

Tags:

Best Answer

  • Julio S.
    Julio S. Moderator
    Answer ✓

    Hi@Michael Culley,

    I wasn't able to reproduce what you report but I'd like to point that you now can define the data type for each Column value in the"Mapping" sectionof your Data Shuttle Workflow configuration. I would suggest to define the specific Column as "Number" to try and overcome this:

    Screenshot 2022-11-23 at 10.01.01.png


    If this doesn't seem to work, you could possibly use theVALUE Functionin the target sheet to convert those values to the right formatting.

    If none of these suggestions seem to work, I'd suggest opening a ticket with our Support team viathis formor accessing the newCustomer Support Portal.

    I hope this can be of help.

    Cheers!

    Julio

Answers

@StaggsJordan<\/a> I don't know your full setup, but put one of these ' in front of 7.10 like '7.10. That will identify the \"number\" as a string and keep the trailing 0.<\/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":[]},{"discussionID":112467,"type":"question","name":"Is it possible to change a cell in a date column using a work flow?","excerpt":"Im also wondering if i can change a dropdown with symbols using a work flow?","snippet":"Im also wondering if i can change a dropdown with symbols using a work flow?","categoryID":343,"dateInserted":"2023-11-01T19:48:38+00:00","dateUpdated":null,"dateLastComment":"2023-11-02T10:47:28+00:00","insertUserID":165973,"insertUser":{"userID":165973,"name":"Brandon Morales","url":"https:\/\/community.smartsheet.com\/profile\/Brandon%20Morales","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-11-02T19:56:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":165973,"lastUser":{"userID":165973,"name":"Brandon Morales","url":"https:\/\/community.smartsheet.com\/profile\/Brandon%20Morales","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-11-02T19:56:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":32,"score":null,"hot":3397792566,"url":"https:\/\/community.smartsheet.com\/discussion\/112467\/is-it-possible-to-change-a-cell-in-a-date-column-using-a-work-flow","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112467\/is-it-possible-to-change-a-cell-in-a-date-column-using-a-work-flow","format":"Rich","lastPost":{"discussionID":112467,"commentID":402713,"name":"Re: Is it possible to change a cell in a date column using a work flow?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402713#Comment_402713","dateInserted":"2023-11-02T10:47:28+00:00","insertUserID":165973,"insertUser":{"userID":165973,"name":"Brandon Morales","url":"https:\/\/community.smartsheet.com\/profile\/Brandon%20Morales","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-11-02T19:56:55+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":"2023-11-02T11:57:40+00:00","dateAnswered":"2023-11-02T02:47:09+00:00","acceptedAnswers":[{"commentID":402706,"body":"

You would need a helper column to change to current date then in the cell you want the actual date to be you would need to use the formula of =[helper column date]@row+7<\/p>

For the symbol you would need to do something similar as symbol automation is not currently an option that I am aware of but you can have a helper column change to specific criteria and then set up a formula in your symbol column to reference that cell with an if formula to get the symbol you would like to appear when the cell is changed to the specified criteria<\/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":[]},{"discussionID":88567,"type":"question","name":"WorkApps custom filters and export to MS Excel","excerpt":"Is there a way to allow users who have edit rights to a page in WorkApps to create custom filters and export the sheet to MS Excel? These features are available if you give someone edit permissions directly to the sheet but not when assigning permissions via WorkApps.","snippet":"Is there a way to allow users who have edit rights to a page in WorkApps to create custom filters and export the sheet to MS Excel? These features are available if you give…","categoryID":343,"dateInserted":"2022-03-02T20:39:36+00:00","dateUpdated":"2022-06-14T14:39:14+00:00","dateLastComment":"2023-11-01T16:03:21+00:00","insertUserID":61706,"insertUser":{"userID":61706,"name":"GilN","url":"https:\/\/community.smartsheet.com\/profile\/GilN","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!m9FAn2LNZfo!-nlDNzbiEjw!ZXrmqK8UUTk","dateLastActive":"2023-03-27T19:45:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":169385,"lastUser":{"userID":169385,"name":"prh_intl","title":"Relocation Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/prh_intl","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-11-01T16:09:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":534,"score":null,"hot":3345109977,"url":"https:\/\/community.smartsheet.com\/discussion\/88567\/workapps-custom-filters-and-export-to-ms-excel","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/88567\/workapps-custom-filters-and-export-to-ms-excel","format":"Rich","lastPost":{"discussionID":88567,"commentID":402570,"name":"Re: WorkApps custom filters and export to MS Excel","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402570#Comment_402570","dateInserted":"2023-11-01T16:03:21+00:00","insertUserID":169385,"insertUser":{"userID":169385,"name":"prh_intl","title":"Relocation Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/prh_intl","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-11-01T16:09:24+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-03-08T03:57:28+00:00","dateAnswered":"2022-03-05T18:47:42+00:00","acceptedAnswers":[{"commentID":321678,"body":"

Hi @GilN<\/a> <\/p>

I hope you're well and safe!<\/p>

Unfortunately, it's not possible now, but it's an excellent idea!<\/p>

Please submit an Enhancement Request when you have a moment<\/strong><\/a>.<\/strong><\/p>

I hope that helps!<\/p>

Be safe and have a fantastic weekend!<\/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 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":[]}],"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":719,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts