Excel from SFTP workbench error
Trying to upload an excel file with multiple sheets using Workbench from an SFTP server, When I validate the settings I get the error: Path extension '.tmp' is not supported. Use ExcelFile.Load method that accepts LoadOptions paramter to explicitly specify source file format. Parameter name: path
The path is in the following format, specifying the file type that is to be imported.
/xxxxx/xx/xxxxx/xxxxxxx/xxx/xxxxxxxx.xlsx
If i change the name of the file i'm searching for to an incorrect value it says the file does not exist, so I know it is resolving the path.
If i run the job anyways, the data comes across but only from the first sheet in the dataset. I cannot specify a sheet to pull from.
any ideas?
Comments
-
That looks like a bug in validation to me. You should be able to pick the sheet. What happens if you preview first?
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
When I run the preview it loads the first sheet of data from the workbook correctly, but also gives me the error "Workbench DataSet Job xxxxxxx.domo.com:13 (XXXXXXXXX) is not allowed to dynamically change schemas."
After previewing I can still not select a sheet name form workbench.
0 -
That schema change error is a configuration option you can check/uncheck on the settings for the job, toward the bottom of the page under the heading Additional Settings. Make sure you've checked that the job can "allow schema changes" (at least for now).
What happens when you preview, without error, and click on the Sheet Name dropdown under the Data Source Properties section of the Source tab? Does it now show all the sheets, or when you click on that dropdown does the interface not do anything?
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
allowing the schema to change fixed the preview error I was getting, but I still cannot select a sheet even after the preview has run without errors.
0 -
Partial victory?
What does the interface do when you click on the dropdown? Does it expand but only show the one sheet?
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
I suppose, never impacted the run for the first sheet data though.
The interface still doesn't do anything when clicking on the dropdown, doesn't even show the first sheet
Thanks for the help, I'll have to see if i can find a workaround for this.
0 -
Sounds like a bug. It works for me. Consider contacting Support.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
I know this is sort of an older case but want to put in that I ran into this error today (using wb 4) and ended up just re-creating the job and it cleared up. I think I had saved/edited so much something just got screwy on the back end.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 621 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive