Hi there,I'm working with excel library Excel_Library installed from Forge.I'm using provided method Cell_read to read each cell of the first line of the excel in order to validate the presence of every mandatory header.Unfortunately it seems that i can't do this with files larger than 5.5mb.
Any suggestions for workarounds?Thanks
You need to pass the S3 file location to the external library and open excel there.
Hi Giovanni,
This limitation is documented by OutSystems in:
https://success.outsystems.com/documentation/outsystems_developer_cloud/getting_started/outsystems_system_requirements_for_odc/
The maximum payload size for a single request from the frontend to the backend is 28MB. However, this does not directly correspond to the binary file size due to the overhead introduced by base64 encoding.
Consider the solution @Stefan Weber describes in this arcticle: https://without.systems/odc-with-aws-s3-browser-to-s3\
Regards,
Daniel
Hi Daniël,
I've already implemented that S3 solution in my app.The problem indeed is not here.
From the front i upload a single zip the file to S3 then i download it from the back, unzip it, and store the single files in my DB.Then i need to validate those files: i must check if every file contains the mandatory headers.Here i call the Excel_Library function: "Cell_Read" but the error: OS-BERT-ELR-61301 - Error executing action Input payload is too large (8.47MB), maximum allowed is 5.5MB.I know this error is related to a External Library limitations, and I know this is "well" documented.But i really need to validate those files... I've searched online but nothing usefull, i've also tried to "truncate" file in order to pass to function a small-sized file but nothing.Since the function Excel to Record list doesn't raise an exception when just a single structure attribute doesn't match any header I don't know what to do.Thanks for your reply.Giovanni.
Thank you Daniel i'll try this out!
i'm really curious why this arbitrary design choice was made in ODC. 5.5 MB is really small, even for binary files. Something like a picture could easily surpass these limits.