How do I get Domo to automatically pull in Excel data?
I have data in several Excel spreadsheets, which are updated every day. How do I get Domo to automatically pull in this data? At the moment I can only see how to manually update (with the option to be prompted every day to update). Given there are several sheets, all of which feed into dataflows which run first thing in the morning, it's not practical for us to manually update.
Any solutions/workarounds would be much appreciated!
Best Answer
-
I think if you need to schedule an excel or CSV file upload and the file is on premises you should use workbench tool to do it.
It 's pretty straight forward to use i think. You can download it at the Tool Downloads on the Admin Settings page.
Here's a good link on workbench:
http://knowledge.domo.com?cid=workbench4
Don't hesitate to ask if you need help setting this up.
Hope this Helps.
Ricardo Granada
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.0
Answers
-
Hi,
What connector are you using to upload the excel files?
Regards,
Ricardo Granada
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.0 -
Just the Excel connector, but happy to try others (for instance, a .csv would be fine)
0 -
I think if you need to schedule an excel or CSV file upload and the file is on premises you should use workbench tool to do it.
It 's pretty straight forward to use i think. You can download it at the Tool Downloads on the Admin Settings page.
Here's a good link on workbench:
http://knowledge.domo.com?cid=workbench4
Don't hesitate to ask if you need help setting this up.
Hope this Helps.
Ricardo Granada
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.0 -
Thank you, this is exactly what I was looking for.
1
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 202 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 181 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive