09-15-2023 06:17 PM - last edited on 09-21-2023 05:42 AM by JackLacava
Hi All,
I create a spreadsheet business rule to refresh the data from external table using Table Views, now our users wants to drop these files into OneStream file share on daily basis so external systems can consume.
Is it possible to use parcel service to refresh these files (using table views with in the spreadsheet) and drop them into file share every time the job trigger ?
Or Is there any alternate approaches to export data from custom table to excel files ?
Thank you.
Solved! Go to Solution.
09-21-2023 05:41 AM
There are 3 approaches I am aware of, via standard Data Management features:
Then you can probably use Parcel Service to send out the resulting output, but I'm not very familiar with it myself.
09-21-2023 05:41 AM
There are 3 approaches I am aware of, via standard Data Management features:
Then you can probably use Parcel Service to send out the resulting output, but I'm not very familiar with it myself.
10-04-2023 02:41 PM
Thank you @JackLacava for providing those details.
I tried all 3 steps, 2nd and 3rd is working. But for the 1st step if I try to export using DM step with SQL Table Editor/Grid View components with in dashboard, it is just exporting empty file with out data.
Thank you.
Sridhar
11-14-2023 09:22 AM
Hi Sridhar
We're having a similar issue. Did you manage to resolve this?
Regards,
Mark
11-14-2023 12:21 PM
Hi @MarkBird
None of the existing dashboard components worked for me, so I created an Extender Business Rule and used BR Apis to create data tables and VB.Net code to export it to excel and drop it to file share. Please let me know if you have any further questions, I am happy to answer.
Regards
Sridhar
LinkedIn: Sridhar