download excel report from temporary community document folder to local drive

sudhirp712 over 7 years ago

Hi ,

We have created a process model which will extract the report from querydatabase and export it to excel and save it under temporary document folder in community section.

We need to add this to report tab in tempo page as XYZ Report. Users needs to click on XYZ Report and the excel generated report could be downloadable and save this to local drive.

Could anyone help us and let us know how to do it.

Attached the process model.

Discussion posts and replies are publicly visible

Parents

0 Venu over 7 years ago

Here no need of export to excel smart service. its enough to Populate the 'exportData' variable with your data in script task. this variable data will be picked to export in excel. check the below configuration for exportData:

fieldNames:{"firstName","lastName","dateOfBirth","gender"},/* these values are CDT properties from which cdt type you export*/
fieldLabels:{"First Name","Last Name","DOB","Gender"}/*These values will be headers in your exported excel*/
datasubset:rule!TEST_getMyOrders({pv!OrderIds},topaginginfo(1,-1))/* this is query rule, i passed paginginfo to get in datasubset format*/
filename:"Exported data"

Whenever you clicked on download link that will trigger the process model. Can you monitor process instances is that exportData is populated or not
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Venu over 7 years ago

Here no need of export to excel smart service. its enough to Populate the 'exportData' variable with your data in script task. this variable data will be picked to export in excel. check the below configuration for exportData:

fieldNames:{"firstName","lastName","dateOfBirth","gender"},/* these values are CDT properties from which cdt type you export*/
fieldLabels:{"First Name","Last Name","DOB","Gender"}/*These values will be headers in your exported excel*/
datasubset:rule!TEST_getMyOrders({pv!OrderIds},topaginginfo(1,-1))/* this is query rule, i passed paginginfo to get in datasubset format*/
filename:"Exported data"

Whenever you clicked on download link that will trigger the process model. Can you monitor process instances is that exportData is populated or not
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data