Drag and Drop into Oracle APEX Application

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.

If you have any questions or are interested in this functionality please contact us.