APEXblog.nl - Tips and Tricks

About This Blog:
I (Richard Weug) started this blog primary for myself to save all kinds of Apex tips and tricks in one place. To use it as a place to write down how I used some coding in my own projects, but also to copy and paste all kinds of articles I find on the Internet. (So I never have to wonder on what website did I read about??? When I see something interesting I collect the content so I have my own archive/knowlegde base.

View my profile on LinkedIn


Tips & Tricks


Drag and Drop into Oracle APEX Application

Written by Richard Weug. Posted in Tips and Tricks

This is a nice demo I found quite some time ago (2010). Recently I looked for this demo, and could hardly find it, so I added it to my website.

Demo on Drag and Drop into Oracle APEX Application. (Excel, upload, file, validate, before, commit)

Original article:

We were recently approached by APEX Home to produce a solution for them, using Oracle APEX, which allowed users to drag data from a spreadsheet into an Oracle APEX application. The solution we developed uses Oracle APEX 3.2.1 and jQuery functionality to detect when data is dragged onto a Drag and Drop zone from a spreadsheet, CSV file or HTML table. Users can also copy and paste their data if preferred.

Take a look at this functionality in action:


Key features
•Dragged data is highlighted and ordered at the start of the report for easy identification.
•Dragged data that amends original data is highlighted in blue and the old record is hidden.
•The user can edit and delete both dragged and original data from the same location, prior to saving dragged data to the database.
•Any errors that occur when saving dragged data are highlighted in red and all other records are successfully saved.
•The functionality has been tested successfully with FireFox, IE7 and IE8.
•There is no limit to the amount of data that can be dragged into the application, other than the inherent memory limitations of your browser and hardware.
•Drag and drop reports can be easily integrated into any Oracle APEX application by changing the report template and can be to be themed to requirements.
•The solution is highly customisable with the ability to add bespoke validation and error messages.

Link to the original article:  http://www.silvercore.co.uk/117-drag-and-drop-into-oracle-apex-application/