Data Shuttle - Not Mapped , unable to Map - Please select a Source in order to see dropdown options
Hi,
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.
Any Idea?
Best Answer
-
Hi @PhilipG
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!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
What happens when you click on where it says "Not Mapped"?
-
Hi @PhilipG
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!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@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.
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives