Automatically export data from Domo to CSV on a daily basis
Hi,
Not sure this is the right section but I am new to Domo and I need to export data on a daily basis to a CSV file.
This CSV file will be then moved to an FTP server.
Does this solution exist in Domo?
Thanks in advance for your help!
Best Answer
-
Hello,
I don't know of anyway to push data to ftp from Domo but you can use the DomoR library in R to export the data on a daily basis and send it to an ftp server. This will be able to be done all in one R script. The below links are some info on both questions.
https://github.com/domoinc-r/DomoR
https://stackoverflow.com/questions/3620426/how-to-upload-a-file-to-a-server-via-ftp-using-r
Hope this helps,
Brian
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0
Answers
-
Hello,
I don't know of anyway to push data to ftp from Domo but you can use the DomoR library in R to export the data on a daily basis and send it to an ftp server. This will be able to be done all in one R script. The below links are some info on both questions.
https://github.com/domoinc-r/DomoR
https://stackoverflow.com/questions/3620426/how-to-upload-a-file-to-a-server-via-ftp-using-r
Hope this helps,
Brian
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0 -
Hi Brian,
Thanks a lot for your answer.
How can we use R in Domo? Does it have to be installed/activated on our Domo account in some way?
Is R the only solution for what we want to do?
I do not really wish to install Domo-R on my computer but rather to use it directly in Domo.
Thanks in advance for your help!
Nicolas
0
Categories
- 10.5K All Categories
- 5 Connect
- 915 Connectors
- 250 Workbench
- 459 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 186 Visualize
- 250 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
- 170 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive