Dynamically importing files.
I have a situation where a data source is coming in via email only, no available data connector in Domo. The file needs to be appended with a snapshot per email. Is there an automated file archive processes that Domo can provided? Basically, i would need to create a connection to pull the data from a file in a folder path, then be able to differentiate newer uploaded files to append that data. Any ideas?
Best Answer
-
Here are some ways I have solve this before:
#1 - Using Box / Dropbox:
1- Create a new folder in BOX
2-Use the settings of the folder to retrieve the specific e-mail that Box assigns to that folder
3- Send/Forward those files into the Box e-mail. This e-mail will upload the attached files into the folder. The files have to be named exactly the same so they replace the previous file.
4- Use the box connector in DOMO to retrieve that file. Also schedule the datasource so it pulls the data AFTER the new file is placed in Box (this requires for you to have a specific schedule of when are those e-mails coming, if you don't know that put DOMO to schedule at the last minute of the day and update it on a daily basis).
* I believe this might be possible with dropbox as well.
#1 - CSV over FTP:
We have developed internally some windows services that deliver csv files on one of our FTP's. Then we use the CSV-SFTP connector in DOMO to retrieve a file. You can probably find a service or plugin that can do for you and send those attachments to an FTP.
Hope this helps.
3
Answers
-
Here are some ways I have solve this before:
#1 - Using Box / Dropbox:
1- Create a new folder in BOX
2-Use the settings of the folder to retrieve the specific e-mail that Box assigns to that folder
3- Send/Forward those files into the Box e-mail. This e-mail will upload the attached files into the folder. The files have to be named exactly the same so they replace the previous file.
4- Use the box connector in DOMO to retrieve that file. Also schedule the datasource so it pulls the data AFTER the new file is placed in Box (this requires for you to have a specific schedule of when are those e-mails coming, if you don't know that put DOMO to schedule at the last minute of the day and update it on a daily basis).
* I believe this might be possible with dropbox as well.
#1 - CSV over FTP:
We have developed internally some windows services that deliver csv files on one of our FTP's. Then we use the CSV-SFTP connector in DOMO to retrieve a file. You can probably find a service or plugin that can do for you and send those attachments to an FTP.
Hope this helps.
3 -
Sorry i didnt update sooner but i was able to find the same solution. I am testing a Box connector that Domo has setup.
Once the intial setup is complete, the user can configure the connector to look into a folder or search all folders to find specified files. It allows the user to pick up most recently created or modified files, I have tested this process and was successful in appending daily refreshes.
currently i am setting up a FTP client to connect to Box.com. so that i can simulate vendors or services to upload files and tracking if the domo connector would append/replace files. trying to find possible bugs so i can trouble now before i go with this solution.thanks @betogess
1 -
yes it would help others, but the quickest solution was to call domo support
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