57
Views
8
Comments
Solved
Get the exported file and save in database?
Question

Hello everyone,

I need help, I want to achieve this scenario:
 
I have web screen like this, I have input file, table and button (export file):

Step1: Once I click the button (export file) the output will save at the download settings table.

Step2: Here's the download setting web screen with a table, this is the expected output:


NOTE: After clicking the button (export file) it will save the exported file at the Download Settings Table automatically

2023-10-21 19-42-11
Tousif Khan
Champion
Solution

You need to change the file type from the Windows viewer from the bottom left of the Windows popup section

For OAP files we need to do that, 

However I am still attaching Oml for you

Thanks

UploadAndDownloadPOC.oml
2023-05-30 10-05-13
Lourenço Matalonga

Hello @A L L Y ,


i got your scenario but you need to elaborate where you are struggling and need help with.

Best regards,

Lourenco Matalonga

2025-12-04 09-01-03
Kiet Phan
Champion

Hi,

Convert your Data to CSV, Excel or Json then save it into Database as a Binary field.

At the Download screen, use Download action and assign the input with saved Binary field.

 

2023-10-21 19-42-11
Tousif Khan
Champion

Hello @A L L Y 

You need to create a server action on  ther server action we have a widget called 

You can use this Record List to Excel here to convert your records to an Excel and generate a binary file.

Now you can pass that binary file to the create action of your entity where you are storing the binary data.

I have created a sample Poc with a similar scenario you can take a reference from it.

Sample - https://personal-ejuytnht.outsystemscloud.com/UploadAndDownloadPOC/Employees?_ts=638235810238813922

I hope this will help 

Best Regards
Tousif Khan

UploadAndDownloadPOC.oap
2023-06-27 05-52-18
A L L Y

Hello @Tousif Khan,

I can't open your example file. Do you have oml file for this?

Thanks!

2023-10-21 19-42-11
Tousif Khan
Champion
Solution

You need to change the file type from the Windows viewer from the bottom left of the Windows popup section

For OAP files we need to do that, 

However I am still attaching Oml for you

Thanks

UploadAndDownloadPOC.oml
2023-06-27 05-52-18
A L L Y

Hello @Tousif Khan,

Okay I will try it now and I'll get back to you once it work on my end.

Thanks!

2023-06-27 05-52-18
A L L Y

Hello @Tousif Khan,

It really work on my end, I appreciate your help.

Thank you!

2023-10-21 19-42-11
Tousif Khan
Champion

You are welcome, I am glad that I was able to help :)

Best Regards
Tousif Khan

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.