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
MajorDomo@Lusiaves
**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
MajorDomo@Lusiaves
**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
MajorDomo@Lusiaves
**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
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 293 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 96 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 705 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive