Automate Excel Data Refresh
I am new to DOMO so excuse me for my ignorance.
Is it possible to schedule and automatic Excel data refresh? Lets say I have a network shared drive folder. Where in I put excel files. Now, can I automate the process to upload the excel to DOMO and refresh the cards to use the new excel everyday?
Comments
-
Hi,
Either the Excel connector or Workbench are the way to go. Both allow to set the update frequecy.
If your file is on premises, i would personally use the workbench tool.
After the excel has been uploaded every card connected to the excel dataset or any dataset descending from that one will automatically update.
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 -
Hi
When you say the Excel connector can I assume you refer to O365? What if the file is dropped on a shared drive and I want it automatically uploaded and replace the dataset in Domo associated with that file, can this be achieved with a connector or WB is the only way?
Thanks mate
0 -
Hey @Soda
I would stick with the WB solution.
Create a form entry template in Excel (a basic spreadsheet) and make people or yourself type in data into it.
Via WB make it refresh itself every hour, for example.
(Sorry, I'm not an admin nor have access to WB so I can't walk you through the process on doing the schedule)
Once scheduled, just create the cards or apps you need. Everytime you save the Excel file, Domo will go and look into it at every scheduled timelapse and retrieve the new data it has.
Hope this helps!
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive