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.
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?
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.
Hi When i am using this i am getting Fetch api can not suppor javascript scheme. The apex_page.get_url is giving me the value starting with javascript:..... how do i resovle that
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.
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?
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
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?
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!
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.
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) );
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.
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?
Good Job carry on..I am waiting for the next tutorial
Thank you,
you are amazing.
Life is Good with YOU.
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.
Hi When i am using this i am getting Fetch api can not suppor javascript scheme. The apex_page.get_url is giving me the value starting with javascript:..... how do i resovle that
great tutorial I will try it on my workspace and use it for my daily work. Thanks!!!
Multiple Issues. Unable to login after import. Page item not found. Display error on APEX.GET_URL
Can you change the resolution of your videos? the fonts are so small to read, especially for me with weak rear eyesight.
great! looking for this and got it
can you help me? (It doesn't work when previewing pdf documents when installed as PWA) Any solution?
Please make a video or blog on how to preview excel file in oracle apex app
How can display a file from a file system/directory in apex?
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.
Thanks for this tutorial.
amazing video , thanks for that. keep going
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?
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
How to preview the file in new tab instead of the model dialog?
Hi. Where can I find the CSS for your defined classes?
Thank you so much for very nice and good work, very useful :-) many thanks :-)
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?
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!
@@MagalyIraheta Thanks.. I will check.
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.
can we open Excel file or Word file or txt file etc. also?
Hello,
The function works fine on a normal page.
But in a MODAL page it does not work and generates errors
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??
Hi, yes - for the download process you need to create an application item that will contain the corresponding file id
I'm also getting this error how u resolve it
Muchas gracias ❤👌
Hola. Todo bien. Saludos desde México.
Gracias! Saludos desde Inglaterra!
Hello Magaly .. It's not work, just preview the fields of the page, not the image !!!! and icons on buttons are not appeared
what is username and password to sign in to application?
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)
);
Thanks, Richard, for bringing this to my attention. I have updated the completed application and added a separate file with the corresponding scripts.
Hi please advise if you offer consulting.
Una funcionalidad muy útil!
Definitivamente! 😄
Big Like
What about word documents and excel ?
Unfortunately, the object tag does not support those formats.
@@MagalyIraheta HI MAGALYLRAHETA , THANKS FOR THIS TUTORIAL! when do you expect an object tag that will support .xlsx and .docx formats?
what is AI_FILE_ID??
MORE
table
🙏 *promo sm*
A very simple way is to use APEX_UTIL.GET_BLOB_FILE_SRC inside an embed tag attribute. By the way, nice tutorial.
Please eloborate more on it. Plz post, if any tutorial for help.
@@GS-hc5zp You can find examples reading the APEX_UTIL package documentation...