Extract dbo.vStageSourceAndTargetDataWithAttributes data to csv or txt
Hi everyone, I need to add a button to a dashboard to allow users to export to csv or txt some data from the staging area, specifically from dbo.vStageSourceAndTargetDataWithAttributes I tried mu...
Hi fc: if you are already planning to have a dashboard that the end user accesses, you can display the data in a generic grid view component. Users can then Right-Click > Export > To CSV. We put this directly in the import workflow as part of the Validate step. No Business Rules required.
You can also create full 'dashboard button to csv' exports. Our flow is spread across a few BR components (as they are generalized/parameterized), but I would expect it could be all within one Dashboard Extender. Some of the key components include:
BRApi.Dashboards.Process.GetAdoDataSetForAdapter(...) - for executing the data adapter that queries the dbo.vStageSourceAndTarget
A function/sub for converting from a DataTable to a CSV - we found one from the net. There might be more formal solutions for this now.
BRApi.Utilities.SaveFileBytesToUserTempFolder(...) - which saves the output to a temp folder and pops it up on screen for the users like they'd expect with an extract.
