Oracle APEX - How to Create a File Preview Functionality

[@xoldmanit8297]

Hello, I saw the file preview video, it was very good and useful, I have two questions First, can this method be used to preview Windows office files? Second, is it possible to open and edit the file with Office and save it in Blob?

[@mohamedsameer3549]

Great thanks for this tutorial. Can you please make a video for PDF report generation based on sql query and custom template without any reporting tools. Mainly the file should be downloaded or send as an email attachment.

[@pvrmsc]

Great... thanks a lot for your tutorial, After uploading the completed file in my workspace and trying to run and enter the user name and password it's not allowing please can you check.

[@juancarlosarce63]

can you help me? (It doesn't work when previewing pdf documents when installed as PWA) Any solution?

[@aymanabuhussein929]

Hello Magaly .. It's not work, just preview the fields of the page, not the image !!!! and icons on buttons are not appeared

[@skamransajjad7]

Can you change the resolution of your videos? the fonts are so small to read, especially for me with weak rear eyesight.

[@vladimirtrajkoski7859]

what is username and password to sign in to application?

[@ShubhamSakhare-z5h]

Please make a video or blog on how to preview excel file in oracle apex app

[@fdellipriscoli]

I'm trying to replicate this application, I'm on APEX 21.2.... I have a question...we need to create application item AI_FILE_ID or not??

[@MagalyIraheta]

Hi, yes - for the download process you need to create an application item that will contain the corresponding file id

[@virendragaur5186]

I'm also getting this error how u resolve it

[@rmathew66]

if multiple files attached, using Preview region with Inline-Dialog template is not opening respective attached files. It opens the previous attached file. Instead of Inline-Dialog, if used other templates then it opens respective attached files. Any solution?

[@chetanghogale12]

I tried this it supports image and pdf but I want it support Excel and word files. Can we make it work. If yes please let me know the process. Thanks. This session was very helpful

[@jporrata01]

Hi Magaly, Nice tutorial, However am having problem with calling the add image modal page and getting back to the normal page. When I refresh the report the preview button does not work at all. I need to submit the page in order for the button to work again. Am I missing something? Thanks for any help you can give on this.

[@CarlosRomero-ry7rp]

Hello, The function works fine on a normal page. But in a MODAL page it does not work and generates errors

[@ik_vlogs84]

How can display a file from a file system/directory in apex?

[@inchard18]

The table definition is not included in the completed app. Here you go create table mi_documents ( id number, filename varchar2(350), mimetype varchar2(255), blob_content blob, description varchar2(500) );

[@MagalyIraheta]

Thanks, Richard, for bringing this to my attention. I have updated the completed application and added a separate file with the corresponding scripts.

[@youshark7]

Thank you, you are amazing. Life is Good with YOU.

[@jontrostheim]

Thank you so much for very nice and good work, very useful :-) many thanks :-)

[@ar13147]

can we open Excel file or Word file or txt file etc. also?

[@lukechinsamy7764]

Hi please advise if you offer consulting.

[@md.manjurmurshed6850]

Good Job carry on..I am waiting for the next tutorial

[@skamransajjad7]

How to preview the file in new tab instead of the model dialog?

[@fdellipriscoli]

great tutorial I will try it on my workspace and use it for my daily work. Thanks!!!

[@mitrutene]

Hi. Where can I find the CSS for your defined classes?

[@wizzeico4589]

amazing video , thanks for that. keep going

[@brumasoficial]

A very simple way is to use APEX_UTIL.GET_BLOB_FILE_SRC inside an embed tag attribute. By the way, nice tutorial.

[@GS-hc5zp]

Please eloborate more on it. Plz post, if any tutorial for help.

[@brumasoficial]

@@GS-hc5zp You can find examples reading the APEX_UTIL package documentation...

[@rashidalin2]

what is AI_FILE_ID??

[@sakthikumarperiyasamy2403]

great! looking for this and got it

[@GS-hc5zp]

Hi Magaly, thanks. I implemented view pdf in my project following your tutorial, however issue i am getting is that pdf size is smaller and not fitting the pop up window size. what i am missing?

[@MagalyIraheta]

Hi there, thanks for watching! I’d suggest checking that you have added the size you’d like to your object html element as that’s the place where your PDF will be showing!

[@GS-hc5zp]

@@MagalyIraheta Thanks.. I will check.

[@GS-hc5zp]

I am facing 2 issues: 1. In preview column i see button for those column also where file url is null (i.e blob does not exist for that row, i have resctricted url generation for which blob does not exist). how can i omit preview button appearing if url is null. 2. i played audio and video files using your code, audio-video playes in background even if i close preview dialog. i have used refresh of region on cancel/close dialog still issue persists. would appreciate any clues on above.

[@youshark7]

Big Like

[@willy4453]

🙏 *promo sm*

[@yendys74]

MORE

[@lalitKumar-rc6bp]

Thanks for this tutorial.

[@magedfawaz6956]

table

[@GERAX..]

Muchas gracias ❤👌

[@mundova184]

Hola. Todo bien. Saludos desde México.

[@MagalyIraheta]

Gracias! Saludos desde Inglaterra!

[@moofoof]

What about word documents and excel ?

[@MagalyIraheta]

Unfortunately, the object tag does not support those formats.

[@lucamion3993]

@@MagalyIraheta HI MAGALYLRAHETA , THANKS FOR THIS TUTORIAL! when do you expect an object tag that will support .xlsx and .docx formats?

[@pabloandrescespedesroman4976]

Una funcionalidad muy útil!

[@MagalyIraheta]

Definitivamente! 😄