Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I am looking to create a scenario that will export an RMarkdown report as a PDF and save it to a managed folder. I can manually download the RMarkdown report as a PDF today by going into the report -> Actions -> Download so I figured this would be able to be done through scenarios. However, when I go to create a scenario and select "Export RMarkdown Report" as the step there is no option to select a destination folder.
I have done a similar setup with a dashboard but the "Export Dashboard" step for the scenarios allows you to select a destination folder.
I think it has to be saving a PDF somewhere when "Export RMarkdown Report" is ran because the viewer under Rmarkdown Reports -> My Report loads a PDF. I am just not sure where on the server this is being done or how to save it in a way I can access it.
Has anyone ran into this that would know a way to export the report in PDF format through a scenario?
Operating system used: Linux
Okay I think I figured something out that works for this. I will preface this solution with saying that we host in house so I don't think it would work in the cloud version. I found out that if in the scenario I do "send a message" as a step, I can attach an RMarkdown report to an email. This still didn't resolve my use case (without writing a bunch of code to connect to our mail server and pull the message) since I wanted to actually move the file. However, what I discovered is that doing the send a message step with attachment also generates the PDF (or whatever output you have the RMarkdown report set to) locally on the server in the path <dataiku install>/data_dir/code-reports/<project slug>/<report slug>/snapshots/ The name appears to be random but if you sort by timestamp you can find it.
With this, I plan to setup a CRON job on the server to move any PDF that appears in that directory to the destination I want it.
Not the best solution but hopefully that helps someone!
Okay I think I figured something out that works for this. I will preface this solution with saying that we host in house so I don't think it would work in the cloud version. I found out that if in the scenario I do "send a message" as a step, I can attach an RMarkdown report to an email. This still didn't resolve my use case (without writing a bunch of code to connect to our mail server and pull the message) since I wanted to actually move the file. However, what I discovered is that doing the send a message step with attachment also generates the PDF (or whatever output you have the RMarkdown report set to) locally on the server in the path <dataiku install>/data_dir/code-reports/<project slug>/<report slug>/snapshots/ The name appears to be random but if you sort by timestamp you can find it.
With this, I plan to setup a CRON job on the server to move any PDF that appears in that directory to the destination I want it.
Not the best solution but hopefully that helps someone!