Which Connector to use to auto update excel files?
I have several excel files that automatically update daily with the same name. I want to get the data to Domo. I was using File Upload Connector, it doesn't update when the excel was updated. (I tried using File upload connect with an excel by deleting and adding several rows, clicked update through setting, but the dataset was not updated).
I am wondering what is the best connect for this to auto update excel files.
Thanks for you help!
Best Answer
-
@liminlu Where are your excel files stored? If they are stored on a local network/machine then you can use Workbench to look for a file with that name and upload it to a dataset. There are also connectors for cloud services, such as SharePoint and Dropbox if you use those. Any of these options can be set on a schedule so you don't have to upload them manually each day.
0
Answers
-
@liminlu Where are your excel files stored? If they are stored on a local network/machine then you can use Workbench to look for a file with that name and upload it to a dataset. There are also connectors for cloud services, such as SharePoint and Dropbox if you use those. Any of these options can be set on a schedule so you don't have to upload them manually each day.
0
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 559 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 574 Beast Mode
- 12 App Studio
- 28 Variables
- 582 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 26 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 354 Distribute
- 94 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 88 Community Announcements
- 4.8K Archive