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.
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 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.
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?
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.
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 there, by default, if apex_page.get_url is called from a modal dialog, JavaScript code to close the modal dialog is included in the generated URL. You could set the parameter p_plain_url to true to avoid it. Hope that helps!
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.
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.
Good Job carry on..I am waiting for the next tutorial
Thank you,
you are amazing.
Life is Good with YOU.
great tutorial I will try it on my workspace and use it for my daily work. Thanks!!!
Thank you so much for very nice and good work, very useful :-) many thanks :-)
Can you change the resolution of your videos? the fonts are so small to read, especially for me with weak rear eyesight.
amazing video , thanks for that. keep going
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.
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?
Hi there, unfortunately no, this approach is only for types that are supported by the object html element
Hi. Where can I find the CSS for your defined classes?
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?
can you help me? (It doesn't work when previewing pdf documents when installed as PWA) Any solution?
How to preview the file in new tab instead of the model dialog?
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
Multiple Issues. Unable to login after import. Page item not found. Display error on APEX.GET_URL
Thanks for this tutorial.
How can display a file from a file system/directory in apex?
great! looking for this and got it
can we open Excel file or Word file or txt file etc. also?
Please make a video or blog on how to preview excel file in oracle apex app
Hello,
The function works fine on a normal page.
But in a MODAL page it does not work and generates errors
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!
@@TheCoderGal 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.
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 there, by default, if apex_page.get_url is called from a modal dialog, JavaScript code to close the modal dialog is included in the generated URL. You could set the parameter p_plain_url to true to avoid it. Hope that helps!
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
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.
what is username and password to sign in to application?
Muchas gracias ❤👌
what is AI_FILE_ID??
Hello Magaly .. It's not work, just preview the fields of the page, not the image !!!! and icons on buttons are not appeared
What about word documents and excel ?
Unfortunately, the object tag does not support those formats.
@@TheCoderGal HI MAGALYLRAHETA , THANKS FOR THIS TUTORIAL! when do you expect an object tag that will support .xlsx and .docx formats?
The link is broken.
Thanks for reporting, the link should be working now!
Una funcionalidad muy útil!
Definitivamente! 😄
Hola. Todo bien. Saludos desde México.
Gracias! Saludos desde Inglaterra!
Big Like
🙏 *promo sm*
table
MORE
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...