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 sudhirp712 over 7 years ago

Hi George/Venu/Sathya,
I have tried the below change datasubset - saveinto (exportData.datasubset) it shows us download popup to save the file but not in correct format(note the screenshot attached) and when we trying to save as - "The File could not be downloaded".

When we monitor the process it run successfully without any error and also saved exportData variable(Note the screenshot)

Please suggest if you have any idea why export of the file is not coming in correct format and not to save the file.?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sudhirp712 over 7 years ago

Hi George/Venu/Sathya,
I have tried the below change datasubset - saveinto (exportData.datasubset) it shows us download popup to save the file but not in correct format(note the screenshot attached) and when we trying to save as - "The File could not be downloaded".

When we monitor the process it run successfully without any error and also saved exportData variable(Note the screenshot)

Please suggest if you have any idea why export of the file is not coming in correct format and not to save the file.?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data