Oracle APEX - Adding user-friendly validations to Data Loading Wizard

Hi everyone, welcome to my channel! My name is Magaly and I'm an Oracle APEX Developer.
In this video, we take a look at how to customize a Data Loading Wizard to validate and display user-friendly messages while using APEX collections.
- Topics Discussed:
➡️ APEX Collections
➡️ Data Load Definition
✏️ XLSX, base application, and table scripts can be found here: bit.ly/custom-data-load-wizard
APEX Version: 21.2
Follow me:
🦔 Twitter: / magalyiraheta
🦔 LinkedIn: / magaly-iraheta

[@Superdooperhero]

This is the most amazing Oracle Apex video I have ever seen, and I have watched a lot. You put Oracle to shame. I certainly hope you make more videos.

[@user-wg5mh8gj8w]

Very helpful video. Nice Presentation. Looking forward to more such videos from your channel. Thank you so much.

[@uhum300984]

Very good presentation and explanation. Thank you.

[@pedromagalhaes2149]

Thanks for the video, it's very good! One thing I would add in the file validations is, for the file type, also have the server-side condition for when the file browse item is not null as well. Otherwise, when there is no file selected, both validations will be triggered.

[@massaradana3135]

Just amazing - Thank you

[@shyamn7998]

Great info about data loading. In same manner you can make video for data updation of certain column based on primary key or condition.

[@juno7893]

Great video👍🏻

[@pabloandrescespedesroman4976]

Excelente contenido! Nuevo fan, saludos desde Paraguay 🎉

[@MagalyIraheta]

Hola Pablo, me alegra escuchar que te gustó mi video! Muchas gracias por el apoyo! 😊

[@mohamedsameer3549]

Thanks, well informative video. I have done the similar task but in single page approach to reduce the user Clicks. But I need an idea how to give option to the end-user to map the column names.

[@user-zv1yr3dg4r]

Hi Magaly, Thanks for this superb video! Can you please let me know how to include header in the collection? I want to validate if the header is correct and as per the template provided to user. Unfortunately, the heder has to be skipped if we have named selectors in the data profile. Do you have a workaround?

[@MartinTriana1407]

Thanks for the tutorial. I would like to ask you if you can make a tutorial on how to load or create a page as a matrix in Excel style. I want to create a matrix of rows and columns so that the user can fill in each field or fill it in like they do in Excel. Thank you very much for sharing your knowledge.

[@zakerjoy7951]

nice mam we want to more apex tutorial

[@kirubasrinivasan2705]

hello ...thanks for the video it looks great...i have a similar data load option...but our application users load wrong file or incorrect columns...how do i add validation to ensure they are loading the right columns/right file name...please help..thanks in advance

[@enockoloo3814]

Hi Can you confirm if this approach I'd backward compatible with APEX 5.x because some features here wouldn't...thanks

[@YTI202.]

great 👍

[@FlorenceYeddu]

how records got inserted ? I think all the records including error records got inserted . correct me if i was wrong .

[@yashikaparanjothi3165]

How to clear the collection once the finish button is pressed??

[@khaledelsayed2954]

👍 as usual

[@SSReddy-t7r]

How to create collection?

[@kok0s]

Great job Is there any solution to add session_id to the apex_collections ? (distinguish multiple user loading files simultaneously)

[@brumasoficial]

APEX Collections already works like this...

[@karankahar99]

Very helpful video. Thank you so much. At the time of validation, can we update data on the same region by using an interactive grid where we get errors?

[@MagalyIraheta]

Hi, yes that’s possible, update data on the same region where you’re getting the errors!

[@karankahar99]

@@MagalyIraheta ok thanks 😊, i will try it

[@karankahar99]

Hi ​@@MagalyIraheta How we can make it faster while loading huge amount of data like 25k to 30k rows in excel. Please guide. Thanks

[@arieldelacerna856]

Hello Magaly, would you be able to compile your Oracle videos or create Oracle lessons and post them on Udemy Courses? I'd love to buy your comprehensive tutorials, which would help a lot of people who want to learn about the concept. I appreciate your time and effort in sharing your expertise. Hopefully, you will consider my suggestions for creating a comprehensive course and posting it on Udemy. Thank you very much.

[@epicuser4478]

HI Magaly, When I created the validation for File Type, Apex doesn't seem to find apex_data_parser.asert_file_type. It wants me to delcare asert_file_type. I might be missing the apex_data_parser package. How do I get it? I can't find a place to download the package and functions. Any Ideas? Thank you Tom.

[@pedromagalhaes2149]

maybe because it's "assert_file_type" (ss)

[@mohammadubaid5626]

I have a suggestion that you add the sample file. whereas the user can download and upload data accordingly.

[@markogoljak1011]

Great job ;) Can you also send scripts for tables, packages, ...

[@MagalyIraheta]

Hi Marko, thank you for watching! You can find the scripts and supporting files in the link in the description!

[@bowflex92000]

I've a similar scenario. Need some help. If you have some time please let me know and I'll provide the contacts. Thanks.

[@skamransajjad7]

WoW.........

[@asifiqbal5877]

Hello make video on ajax

[@ConcernedCitizen574]

Very helpful video. Nice Presentation. Looking forward to more such videos from your channel. Thank you so much.