Update email dataset via another dataset
Hello Domo Community,
We have the following confuguration:
Dataset 1 - Automated, updating every two hours
Email dataset : We have to export the data from Dataset 1 and send it via email to this dataset.
Is there a way to push the data from Dataset 1 to Email Dataset automatically, since we have hundreds of cards build with the Email datasets and all beast mode functions will not work if we just switch to the the Dataset 1 ?
Hope it makes sense
Comments
-
What are you doing to the data after you export it? Some sort of manual process?
If you absolutely have to keep the email dataset, and you want the export/import automated, it sounds like you need to script your own process outside of Domo.
Generally speaking, that would include:
Using the API, export the data
Using Python or something similar, manipulate the data, and format it as the CSV/XLSX email attachment
Email the attachment to the same email address you're currently using.
In essence, take the people out of the export/manipulate/email process by using a script.
You might also try moving one card over to Dataset1 and recreate the beast modes, sharing each on the dataset. Once the beast modes exist, try moving another cardto Dataset1 and see if it carries over using the new beast modes. It it works using the shared beast modes (use the exact names), then you can just transfer all the cards, which is probably a better, long-term solution anyway.
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
Categories
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive