I have an email with two attachments that go to different datasets. How to extract?
I have an email coming in from a vendor that has two different .xlsx files with two different datasets. Each file would end up in separate datasets in Domo. I've already asked if they can combine into one and got the standard "not at this time" answer. What is the best way to handle this so that both files get into their correct (new) datasets?
My only thought is to have two email connectors that are looking for each file separately, but that seems like overkill?
A few quick notes, both files have unique starting names, so no worries there. These are new datasets, so no legacy dataflows to work around. These are manually triggered files that are sent at a random point near the end of the month. Lastly, not on consumption, so no workflow access at this time.
Thanks in advance!
Best Answer
-
Setting up two separate email connectors may seem like overkill, but it would be a clean and reliable way to make sure the files get to the right dataset. Since these are apparently manually triggered, having two separate connectors would make sure each file is processed independently as soon as the email is received.
note - email is not a secure communication method. Be sure you aren't handling any private or personal data in the transmissions. There are lots of scammers and foreign countries intercepting email…its not hard.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Answers
-
Depending upon the process, you can append rather than replace.
I bring xlsx files into Domo using Domo WorkBench…find it under admin > toolkit. You could also setup an ETL to merge the two using the Append tile. But it might trigger unecessary credits on your account.
You could also create an external application to merge the files before importing.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Sorry, just to be clear, these are two separate datasets that cannot be merged into a single file. The data must come across from email. I could certainly build out a tool to track files hitting an inbox and extract both files. If the email connector makes it tricky to have one email with two files (each needing to go to a separate dataset in Domo) then that might be the answer.
0 -
Setting up two separate email connectors may seem like overkill, but it would be a clean and reliable way to make sure the files get to the right dataset. Since these are apparently manually triggered, having two separate connectors would make sure each file is processed independently as soon as the email is received.
note - email is not a secure communication method. Be sure you aren't handling any private or personal data in the transmissions. There are lots of scammers and foreign countries intercepting email…its not hard.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **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
- 709 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
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive