I am using Data Shuttle to upload a file from OneDrive (attached) and go through all the steps to replace the content in a Sheet in SmartSheet, I get to the point of Mapping but for some reason it does not want to map.
I was able to map this file successfully; is it possible that the file is stored in a shared OneDrive, instead of in a private Drive? Currently Data Shuttle supports uploads to Smartsheet from shared Box drives, but does not support shared drives for Google Drive or OneDrive (see: About Data Shuttle).
If this isn't the case, I have sometimes had it happen where the file needs an extra minute or two to load on that very first page, in order to be recognized later (for example when my internet is being a bit slow). I would recommend starting from scratch again, but waiting a few extra minutes after you select the file to move on to your next pages. You may also want to try setting up the workflow in another Browser.
Let me know if any of this has helped!
What happens when you click on where it says "Not Mapped"?
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
@Genevieve P. I didn't realize that shared Google and One drives were not supported. Good info. Thanks!
Was from a Shared OneDrive, had to create a Flow to move it in to my personal folder to then use Data Shuttle. Am all set.
Glad you're all set! Thanks for letting us know it worked.
I have also found that if you have filters on the Excel file it will not pull. Try turning the filter off in Excel. Now if only I could figure out why certain columns do not show to be mapped.... Or why when we select a specific ID field that the choices below become limited...
@Paul Newcome I'm having a similar issue
The few times this has mapped successfully, the options I am presented with in the the source field drop downs are "A" "B" and "C" only, despite the fact that I have 12 columns of data and have marked the source sheet as having headings in the "select your source file" step.
We have a spreadsheet with data that needs to be updated/validated twice a year. We wanted to use a workflow, but some owners/approvers of the data have 150 rows to their name. We don't want to flood their email with that many emails or have to go through 150 lines that way. We are working with the idea of sending an…
Hello- I am trying to remove the item names from the right side of the gaant chart. Is there a way to get rid of those and preferably add other column information instead? I see the settings pop up but there is no option to get rid of those labels. Thank you!
We would like to request the ability to add multiple conditions to a Conditional Formatting rule. For example: If Step="Backlog" and Flag=Yes, mark row orange.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.