Data shuttle not seeing my file
Hi,
I have two files in a location on OneDrive. I have a test file and another real file that I want to upload using data shuttle. When I connect (no prob connecting to OneDrive), however, it is only seeing one file. Note I created the test file in the screenshot, another user created the second file but I have access and can open it. Just not in Data Shuttle.
What i see in Data Shuttle:
Answers
-
It's the file format - the "missing" file is an .xls file in Office 97 format which is quite old. DS works with .xlsx files.
-
@Brian_Richardson Does Data Shuttle not recognize XLSM files? I am trying to connect to a couple files on SharePoint. When I try to connect the files, I see the folders in the same location but not the 3 .xlsm files. Is there a work around that I can do? These files do not belong to me, so converting the file type is not an easy option. I am only trying to connect to them to pull their info into Master document in Smartsheet.
-
I'm not sure Kristen, sorry. I'd make sure you have the access rights, if they aren't showing up then it's likely that XLSM isn't supported, but you'd need to reach out to Support for an official answer on that one.
-
Hi @Kristen Cummings & @Brian_Richardson!
Data Shuttle requires data downloaded in CSV, XLSX, or Google Sheet format for uploads. You can find more details on Data Shuttle here: Data Shuttle FAQs.I hope this helps!
Cheers,
Isaac.Join us at Smartsheet ENGAGE 2024🎉
October 8 - 10, Seattle, WA | Register now
-
Hi @Isaac A.
Thanks for the info. It unfortunately does not solve my problem without a manual intervention which is not how I would want to handle this situation. Are there any requests to have this feature upgraded to other file types? Excel Macros are used quite frequently, I feel like this is a big miss.
-
Thanks for sharing your feedback @Kristen Cummings. I agree that it’s a great idea! After closely checking, I found an existing product idea related to this feature: Enable import of xlsm by Data Shuttle.
Feel free to add your vote and input there to help our product team prioritize implementing it!
Cheers,
Isaac.Join us at Smartsheet ENGAGE 2024🎉
October 8 - 10, Seattle, WA | Register now
-
Thank you Isaac.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives