How do I pull all excel files in a particular folder into a dataset?
Hi Everyone,
Brand new Domo user here, so I apologize if this question is pretty basic.
We have ~300+ clients upload an excel file each week using out Citix Sharefile file drop folder, which we then route into a folder based on which client it came from. We'd like to set up a dataset that pulls in all files in a particular folder regardless of name (there is a common string in each name that we could use). Additionally, due to HIPAA requirements we need to encrypt the data as its pulled in.
Right now the plan is to use workbench's SFTP connection and write separate Powershell scripting to rename each file as it is uploaded so that the most recent will always be named "Current" (or some similar name) - however I know there is a FTP Box connection that can pull files in based on a keyword so hopefully we can build something similar.
Thanks!
Edits: Added information and changed our datasource
Comments
-
Hi all,
Can anybody help @anafziger out?
Thanks!0 -
kshah008,
Thanks for the bump - I've updated the post a bit which will hopefully be helpful to readers.
Best,
Austin
0 -
Hi @anafziger,
Thanks for reaching out! With your HIPAA requirements, currently Workbench will be your best option. However at the moment, there is no option to select files based on their containing string. I can submit a feature request to our Dev. team for you to have that added as a future component.In addition to submitting the enhancement request, you are able to create suggestions in the Domo Dojo here:https://dojo.domo.com/t5/Ideas-Please-suggest-ideas-to/idb-p/Ideas.
In this section, suggestions can be "liked" by other customers and updates will be intermittently provided about whether something will be implemented, and if so, when.Thanks,
Maxwell Isley
Technical Advisor
Maxwell
Dojo User
**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 -
For what it's worth, Workbench can interface with custom written plugins that can potentially do what you're looking for. You'd need someone to script a plugin.
Domo also has a "big data" development team that can either advise you or work on this kind of activity for a fee. So you have some options at your disposal.
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 -
Might have to reach out to that team...
Do you happen to know if there is a forum or listing of the plugins that have already been produced by others? working on another similar issue that would help with.
0 -
I have not heard of a forum or similar listing of developed plugins. Domo's workbench squad would probably have a good idea about what they've developed and seen others develop. It may just be tribal knowledge at this point.
See https://knowledge.domo.com/?cid=wb4plugins for a tiny bit more info.
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 -
@anafziger, tagging you to check out AS's reply.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive