dani3lsun/apex-plugin-dropzone

Oracle APEX Region Plugin - Dropzone

Oracle APEX Region Plugin - Dropzone

Dropzone is a region type plugin that allows you to provide nice looking drag’n’drop file uploads. It is based on JS Framework dropzone.js (https://github.com/enyo/dropzone).

Demo Application

https://apex.oracle.com/pls/apex/f?p=APEXPLUGIN

Changelog

2.4.1 - Use wwv_flow.ajax endpoint instead of wwv_flow.show for all AJAX actions

2.4.0 - changed "Normal" upload method to use multipart/form-data requests, no base64 conversion needed + works with all web servers

2.3.0 - min. APEX version now is 5.1 ! / Changed chunked upload to also use base64 f01 array (double chunked mechanism) / delete AJAX call only when file has no error

2.2.4 - Updated Dropzone framework to 5.5.0

2.2.3 - Fixed displaying of special characters #39 / some server side code improvements

2.2.2 - Updated Dropzone framework to 5.3.0

2.2.1 - server side waiting: use custom procedure instead of APEX_UTIL.PAUSE (thus only full seconds are possible)

2.2.0 - APEX 5.2 compatibility / Updated Dropzone framework to 5.3.0 / enable dynamic substitution strings for table or collection name / removed parallel uploads option / changed client side waiting to server side waiting after file gets uploaded, removed waiting attribute, general improvements of js and pl/sql code

2.1.0 - Added client side image resizing (before sending to server) / Added configurable chunk size of chunked file uploads

2.0.4 - Added much more detailed Total Upload Progress

2.0.3 - New Style Grey Dashed Border/Background / Improved deleting Files (No longer via Filename, instead the APEX Collection Seq-ID or PK Value of Custom Table is used)

2.0.2 - Performance Improvements for Chunked File Uploads / Improved Upload Status for Chunked File Uploads / Improved Client Side Debug Logging / Improved Server AJAX Error Handling

2.0.1 - Performance Improvements for Chunked File Uploads / Improved Client Side Debug Logging / Oracle Database EPG Note in Docs & Help Pages

2.0.0 - Complete new Version built from ground up. Now much easier to use and with more features

• Choose where to save the Files (APEX Collection or Custom Table)
• No more writing of custom PL/SQL Code inside the Plugin (much more Update save)
• More Events that Developers can use for custom Interactions
• Choose the Upload Method (Normal: 1 Request or Chunked: Multiple Requests)
• Improved Error Handling and Logging for the whole AJAX based Upload Process
• Possibility to delete Files which were accidentally uploaded to the Server
• Better Documentation on Github and in the Plugin Attribute Help
• Much better Internationalization and App Wide definition of Messages
• And of course all the "old" Features as well

Upgrade Notes:

• As the Plugin was rewritten from ground up, Version 2.0.0 is completely incompatible with prior Versions! It is recommended that you install Version 2.0.0 beside Version 1.XX and replace all Dropzone Regions in your App.
• If you didn´t touch the default PL/SQL Code of Version 1.XX and used the default Settings then the Upgrade Process should be straight forward (APEX Collection is the same).
• If you used Plugin Events in Version 1.XX, you have to change these to the Plugin Events of Dropzone 2.*
• If you customized the PL/SQL Code of Version 1.XX to insert additional information, please see Inserting uploaded files into your own tables for information on conveting to the Plugin's default upload method to an APEX Collection, with a PL/SQL dynamic action to perform your custom insert.

---

Changelog Version 1.XX

1.9.6 - fixed issue #15 (Page Items to Submit) / Added new event "Dropzone max files exceeded" (issue #13)

Update Note from v1.9.5: It may be required to renew the PL/SQL Code (Upload) to the default which is shipped with this plugin. Unfortunately Plugin Attributes are not updated automatically.

1.9.5 - fully compatible with APEX 5.1 / Delete files inside Dropzone / General Code Cleanup / New Plugin Events / Float number as max Filesize

Update Note: It may be required to renew the PL/SQL Code (Upload) to the default which is shipped with this plugin. Unfortunately Plugin Attributes are not updated automatically.

1.9.4 - updated dropzone library to 4.3.0 / added a much more detailed upload progress bar per file

1.9.3 - solved performance issues when converting larger files from base64 CLOB to BLOB

1.9.2 - added a random file id to APEX collection (better identification of file by it´s id) / empty file mime types now set to "application/octet-stream" / code cleanup

1.9.1 - added more file preview images / more structured file paths / APEX event triggers on Region (not body) / no global js functions any more, wrapped code in namespace "apexDropzone" / cleaned up js code

1.9 - added option to include a custom callback javascript function which get executed on chosen events (added file & upload completed) + added APEX events for added file & upload completed to trigger Dynamic Actions

1.8 - added option to select a default dropzone style (1: grey border / 2: blue dashed border) / added option to display file type preview images for common file types / minified css/js files (full files for debug mode)

1.7 - solved lots of performance issues (file + base64 data get uploaded to server) / stability improvements

1.6 - added number of parallel uploads option (1 or 2 concurrent) / performance improvements (base64 encoding when file was added instead of sending moment) / better error handling

1.5 - performance improvements(removed redundant AJAX call) / split the clob into a 30k param array (OHS 32k limit for params) / added callback function to apex.server.plugin that processes the files queue

1.4 - added option to refresh a chosen region (with REGION_STATIC_ID) after uploading of all files is complete / Copy&Paste support of images in modern Browsers (like Chrome)

1.3 - set default for "max Files" to dropzone default of 256

1.2 - added max files per upload option / added customizable messages for better multilingual support

1.1 - added options to limit uploading of declared file types (file endings, mime_types, wildcards) / clear dropzone area after uploading of all files finished

1.0 - Initial Release

Beta - In development

Install

• Import plugin file "region_type_plugin_de_danielh_dropzone2.sql" from source directory into your application
• (Optional) Deploy the CSS/JS files from "server" directory on your webserver and change the "File Prefix" to web servers folder (Inside the Plugin Settings).

Plugin Settings

The plugin settings are highly customizable and you can change:

• Storage Type

  • Choose where the uploaded Files are saved. You can either save your Files to a APEX Collection or to a Custom Table.

• Collection / Table Name

  • Name of the APEX Collection or of your Custom Table. Default APEX Collection: DROPZONE_UPLOAD.
  • Note: "Custom Table" setting is limited to storing the filename, mime type, and upload date, in addition to the file content itself. To store additional information, please use APEX Collection and see the Inserting uploaded files into your own tables section below.

• Filename Column

  • Column of your custom Table which holds the information for the Filename. Only if Storage Type is set to Custom Table

• Mime Type Column

  • Column of your custom Table which holds the information for the File Mime-Type. Only if Storage Type is set to Custom Table

• BLOB Column

  • Column of your custom Table which holds the information for the File Content (BLOB). Only if Storage Type is set to Custom Table

  • PK Column

    • Primary Key (PK) Column of your custom file Table. Only if Storage Type is set to Custom Table

• Date Column

  • Column of your custom Table which holds the information for the File Upload Date. Only if Storage Type is set to Custom Table

• Upload Mechanism

  • Normal

    • AJAX: Async Method

    • This Upload Method encodes the File into a Base64 String. This String is then split into an 30kb Array which sends the encoded/splitted File in 1 Request to the Server. This Method works on all Web Servers including Oracle OHS, Oracle WebTier, Oracle Database EPG, Oracle ORDS, Apache, Tomcat. But for large Files the maxPostSize Parameter have to be increased on Tomcat Servers (Default 2MB). Max. File size should not exceed ~50MB.

  • Chunked

    • AJAX: Async Method

    • This Upload Method splits a File into 1MB Pieces (Default / Please Change Component Setting "Chunk Size (in KB))"). Then this 1MB Chunks are base64 encoded and sent via Multiple Requests (For every MB 1 Request) to the Server. This Method works best on modern Web Servers like ORDS, Tomcat or Apache, but not on Oracle OHS, Oracle WebTier or Oracle Database EPG! This Method is good, when you don´t have the possibility to configure Parameters of the Web Server like maxPostSize or want to Upload large Files (> 50MB). If you can edit the Web Servers Config you should go with the Normal Mechanism. But if you expect a lot of big files that get uploaded this Method should be fine for that!

• Delete Files

  • Possibility for end users to delete each file that was uploaded to the server. Only if no Page Refresh has occurred.

• Dropzone Style

  • UI Style of your Dropzone Region. You can choose either Grey Border, Blue Dashed Border or Red Dashed Border

• Width

  • Enter the default width of your Dropzone Region. Valid values are px and % data. E.g. 700px or 100%

• Height

  • Enter the default height of Dropzone Region. Valid values in px. E.g. 400px or 500px

• max. Filesize in MB

  • max. File Size (Float Number) that is allowed per File. If a File is larger, it will be removed.

• max. Files

  • Maximum number of allowed files that can be uploaded at once.

• Accepted File Types

  • If you only want that users can upload Files of declared types. Valid values: comma separated list of Mime-Types (with Wildcard support) or File endings: image/*,application/pdf,.psd

• Clickable

  • If true, the Dropzone Region will be clickable, if false nothing will be clickable and only Drag & Drop is possible.

• Show File Previews

  • Show Preview Images for common File types when adding files. Image-Files got displayed with real content. If you want to add more images or others just Copy/Upload the PNG Files to img directory. Naming: <file-extension>.png

• Copy & Paste Support

  • Adds support for Copy & Paste of Images in modern Browsers (like Chrome or Firefox > 50).

• Image Resizing

  • If true, images are resized to a specified size. This happens on client side before uploading the file to server. Saving upload bandwidth and reducing upload time. Please set at least one resize attribute, e.g. Resize Width or Resize Height.

• Resize Width

  • If set, images will be resized to these dimensions before being uploaded. If only one, resize Width or resize Height is provided, the original aspect ratio of the file will be preserved. Please provide a width in pixels.

• Resize Height

  • If set, images will be resized to these dimensions before being uploaded. If only one, resize Width or resize Height is provided, the original aspect ratio of the file will be preserved. Please provide a height in pixels.

• Remove Files after Upload

  • If true, clears all Files from Dropzone Region after uploading has finished.

• Chunk Size (in KB) (Application Scope)

  • This is the default chunk size if you choose the Chunked upload mechanism. The file is split into pieces of that size. Each piece is sent to the server separately. Thus the files are base64 encoded, there is a little overhead in the file size, so please consider a plus of about 10-15% in file size. Default is 1MB = 1048576 KB.

• Display Message (Application Scope)

  • Message that is displayed inside of the Dropzone Region

• Fallback Message (Application Scope)

  • Message that is displayed when your Browser doesn´t support HTML5 Drag & Drop File Uploads

• File too Big Message (Application Scope)

  • Message that is displayed per File, if the File is bigger than you allowed in the settings. You can use Placeholders like: {{filesize}} or {{maxFilesize}}

• max. Files Message (Application Scope)

  • Message that is displayed per File, if the uploaded Files exceed the max. Files settings. You can use Placeholders like: {{maxFiles}}

• Remove File Message (Application Scope)

  • Message that is displayed below a single File to remove the File. Only when Delete Files is set.

• Cancel Upload Message (Application Scope)

  • Message that is displayed below a single File to Cancel Uploading during the actual Upload Process. Only when Delete Files is set.

• Cancel Upload Confirm Message (Application Scope)

  • Message that is displayed in the Confirm Dialog if you clicked the Upload Cancel Link. Only when Delete Files is set.

• Invalid File Type Message (Application Scope)

  • Message that is displayed per File, if the File´s Mime-Type is in the Exclude List.

Plugin Events

• Dropzone File added

  • DA event that fires when a single file was added to the Dropzone Region (Client Side)
  • this.data holds the file element, e.g file.name or file.size

• Dropzone Chunked File Upload Success (AJAX)

  • DA event that fires when uploading 1 Chunk of a File was successful (Server Side) (Upload Mechanism Chunked)
  • this.data holds the Server response object

• Dropzone Chunked File Upload Error (AJAX)

  • DA event that fires when uploading 1 Chunk of a File has an error (Server Side) (Upload Mechanism Chunked)
  • this.data holds the Server response object

• Dropzone File Upload Success (AJAX)

  • DA event that fires when uploading a File was successful (Server Side) (Upload Mechanism Normal)
  • this.data holds the Server response object

• Dropzone File Upload Error (AJAX)

  • DA event that fires when uploading a File has an error (Server Side) (Upload Mechanism Normal)
  • this.data holds the Server response object

• Dropzone Upload completed

  • DA event that fires when uploading all files completed (Client Side)

• Dropzone File deleted

  • DA event that fires if the Remove File Link of a File is pressed (Client Side)
  • this.data holds the file element, e.g file.name or file.size

• Dropzone File Delete Success (AJAX)

  • DA event that fires when deleting a single files was successful (Server Side)
  • this.data holds the Server response object

• Dropzone File Delete Error (AJAX)

  • DA event that fires when deleting a single files has an error (Server Side)
  • this.data holds the Server response object

• Dropzone max Files exceeded

  • DA event that fires per file when more files are added to the Dropzone than allowed (Client Side)
  • this.data holds the file element, e.g file.name or file.size

• Dropzone Total Upload Progress

  • DA that fires from time to time during upload of all files and return the Total Upload Progress (Client Side)
  • this.data holds the totalPercentage element

• Dropzone File Error

  • DA that fires when processing a file has an error (Client Side)
  • this.data holds the file element, e.g file.name, file.size or file.errorMessage

• Dropzone Dragging File over Region

  • DA that fires when dragging a file over the Dropzone Region (Client Side)

How to use

• Create a Dropzone region on target page
• Choose best fitting Plugin Attributes (Help included)

Get files from APEX Collection

If you use the default Options provided with this Plugin, the files are saved in a APEX collection called DROPZONE_UPLOAD. Select it like that:

SELECT c001    AS filename,
       c002    AS mime_type,
       d001    AS date_created,
       n001    AS file_id,
       blob001 AS file_content
  FROM apex_collections
 WHERE collection_name = 'DROPZONE_UPLOAD';

Inserting uploaded files into your own tables

Although the plugin settings allow you to upload the files directly into your custom table, the default setting of APEX Collection is preferred, as this method provides the flexibility to do custom processing prior to inserting the data into the custom table. A typical use case for this is referencing foreign keys. This is easily accomplished using Dynamic Action with PL/SQL code, as follows, assuming the foreign key ID is stored in page item P1_FK_ID:

• Event: Dropzone Upload completed
• Selection: your dropzone region
• PL/SQL Code:

DECLARE
  -- get files data from saved apex_collection
  CURSOR l_cur_files IS
    SELECT c001    AS filename,
           c002    AS mime_type,
           d001    AS date_created,
           n001    AS file_id,
           blob001 AS file_content
      FROM apex_collections
     WHERE collection_name = 'DROPZONE_UPLOAD';
BEGIN
  -- loop over files cursor
  FOR l_rec_files IN l_cur_files LOOP
    -- do whatever processing is required prior to the insert into your own table
    INSERT INTO custom_table (
        filename,
        mime_type,
        upload_date,
        file_content,
        fk_id
    ) VALUES (
        l_rec_files.filename,
        l_rec_files.mime_type,
        l_rec_files.date_created,
        l_rec_files.file_content,
        :P1_FK_ID
    );
  END LOOP;
  -- clear original apex collection (only if exist)
  IF apex_collection.collection_exists(p_collection_name => 'DROPZONE_UPLOAD') THEN
    apex_collection.delete_collection(p_collection_name => 'DROPZONE_UPLOAD');
  END IF;
END;

Hint for ORDS and Tomcat users

If you have Problems uploading larger Files (only with prefered Upload Mechanism "Normal"), then it could be a Issue with the max. allowed Post Size of Tomcat Server (default is 2MB). To get around this issue please add the Parameter maxPostSize with a Byte value to your Connector in server.xml file of Tomcat.

For AJP connector:

<Connector port="8009" protocol="AJP/1.3" redirectPort="8443" address="127.0.0.1" maxPostSize="15728640" />

For HTTP connector:

<Connector port="8080" protocol="HTTP/1.1" connectionTimeout="20000" redirectPort="8443" address="127.0.0.1" maxPostSize="15728640" />

This example sets maxPostSize to 15MB or 15728640 bytes. Setting the maxPostSize attribute to a value less than zero (e.g -1) disables the whole limitation. More about it in the Tomcat 8 Documentation

Preview

Preview Copy&Paste

apex-plugin-dropzone's Issues

How to accept accented messages

Hi Mr Dani3lsun,
Im sorry for disturbing you again.

Actually, i want to translate the messages to french langage, but when i did it i get this result:

How can i fix it ?
Thank you for help.

APEX version (5.1)
Used web server & version and platform (Apache 9 / win x64)
Used web browser (Chrome )

PL/SQL code incompatible with prior versions

Expected behavior

Existing PL/SQL Code (Upload) on existing dropzone plugins should continue to work after upgrading DropZone to the latest version.

Actual behavior

It appears some of the attribute mappings have changed - e.g. filename is mapped to x02 instead of x01 as it was previously.

Steps to reproduce the issue

Take a dropzone that was built in (e.g.) Dropzone v1.8. The sample code maps filename from apex_application.g_x01.
Upgrade application to Dropzone v1.9.5. The filename is no longer mapped because the plugin now populate it in apex_application.g_x02.

APEX version (4.2.6 / 5.0.3)

5.0.4

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

n/a

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

n/a

How to insert others fields in my custom table

Hi Mr Dani3lSun,
I created custom table to use your plugin, the structure of my table looks like,

But when i insert the file, the pdf files are insered , except my others custom fields are filled with null values, as below

My query is:

DECLARE
v_adr		VARCHAR2(200);
  -- get files data from saved apex_collection
  CURSOR l_cur_files IS
    SELECT c001    AS filename,
           c002    AS mime_type,
           d001    AS date_created,
           n001    AS file_id,
           blob001 AS file_content
      FROM apex_collections
     WHERE collection_name = 'DROPZONE_UPLOAD';
BEGIN
  -- loop over files cursor
  FOR l_rec_files IN l_cur_files LOOP
    -- do whatever processing is required prior to the insert into your own table
   
    INSERT INTO TSL_CC_PIECES (
        UTI_CODE_USER,
        FILENAME,
        MIMETYPE,
        UPLOAD_DATE,
        FILE_CONTENT,
        FK_ID,
        DOS_NUMERO_DOSSIER
    ) VALUES (
        :GLOBAL_CODE_USER,
        l_rec_files.filename,
        l_rec_files.mime_type,
        l_rec_files.date_created,
        l_rec_files.file_content,
        :P10_FK_ID,
        :P10_ID_DOS
    );
  END LOOP;

  -- clear original apex collection (only if exist)
  IF apex_collection.collection_exists(p_collection_name => 'DROPZONE_UPLOAD') THEN
    apex_collection.delete_collection(p_collection_name => 'DROPZONE_UPLOAD');
  END IF;
EXCEPTION
  WHEN OTHERS THEN
    -- clear original apex collection (only if exist)
  IF apex_collection.collection_exists(p_collection_name => 'DROPZONE_UPLOAD') THEN
    apex_collection.delete_collection(p_collection_name => 'DROPZONE_UPLOAD');
  END IF;
END;

• GLOBAL_CODE_USER is application item
• P10_ID_DOS hidden item

Thank you for help.

APEX version (5.1)
Used web server & version and platform (Apache 9 / win x64)
Used web browser (Chrome )

Callback function

if ("COMPLETE" == a.callbackEvent)
try {
var c = "return " + a.callbackFnc.replace(/;+$/, "") + ";"
, d = (new Function(c))();

That comma before d is a typo preventing the callback....

File Error

Expected behavior

When i upload a file

Actual behavior

/*-------------------------------------

• Dropzone Apex Plugin
• Version: 1.9.2 (25.01.2015)
• Author: Daniel Hochleitner
  *-------------------------------------
  */

I use this pluggin cause let me customize insert process on a table. I only change the filezise in the attributes region.

Install the pluggin
Change Filesize Default 2 Mb to 8 Mb (or any size biggest)

APEX version (4.2.6 / 5.0.3)

5.1

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

Tomcat 8

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

Safari, Chrome, Mozilla

Please can you help me?

Refresh dropzone area after remove file - call a 'refresh function'

Expected behavior

Hi!

I have a classic report which union a database table and dropzone collection. So, when I add a file in dropzone, this report is refreshed with it. But I'd like to find a way to refresh dropzone area after removing file from my 'trash icon'. I can remove it from collection, but I can't find a way to refresh this area.
Is there any way or any function for that? I read the code, but couldn't find a way.

Thanks!

PS.: in this picture, I added a file, and it's on my report, when I click on trash icon, dropzone collection will remove it, but dropzone area won't refresh and this file will be like 'ghost'.

PS 2.: this is my global function:

function removerArquivo(id, origem){
		var get = new htmldb_Get(null,$v('pFlowId'),'APPLICATION_PROCESS=RemoverArquivo',$v('pFlowStepId'));
		get.addParam('x01',id);
                get.addParam('x02',origem);
		retorno = get.get();
            
		if(retorno == "sucesso"){
                //Do something to refresh dropzone area!
		}
		else{ alert("Error"); }
}

Actual behavior

Dropzone area isn't refreshed.

Steps to reproduce the issue

APEX version (4.2.6 / 5.0.3)

Application Express 5.1.1.00.08

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

--

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

Google Chrome 61

No Data Found when looking for uploaded files in collection - using default method - on 2 environments

Hello Dani3lSun,

1. Thanks for all plugins you are sharing with us !!! awesome.

2. I tried to implement DropZone 2 on both of my apex environments ( 1 with Apache + Tomecat and the second is tomcat alone ).

3. Did the following only :
   Import plugin file "region_type_plugin_de_danielh_dropzone2.sql" from source directory into your application
   Added the Dropzone2 plugin region.

4. Upload on website looks good (see attached printScreen link : printScreen ) , yet, I can't see the files stored in the collection table running ( getting NO-DATA-FOUND ):

SELECT c001 AS filename,
c002 AS mime_type,
d001 AS date_created,
n001 AS file_id,
blob001 AS file_content
FROM apex_collections
WHERE collection_name = 'DROPZONE_UPLOAD';

Please advise what I am missing ?

Regards
Etay G

How to load thumbnails to drop zone, on page load event by the query?

Expected behavior

Load thumbnails and icons to drop zone, on page load (or other) event from the table?

Actual behavior

Drop zone is blank after every page reload.

APEX version (4.2.6 / 5.0.3)

apex.oracle.com

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

apex.oracle.com

Insert multiple PDF file in custom table

I already sent this issue, but i dont know it is removed.
So to summarize, I created one application to upload multiple files and insert them in custom table(not in apex collection).
I followed your article and specially in 'Inserting uploaded files into your own tables section', leaving
the apex collection.

Doing that, in my test application, the app oddly works, you can see it, in on apex.oracle.com with this credentials:
Workspace: ws_formation
Username: asoukaina
Password: s@boulah123
I used the Application 200218 - Dropzone Demo.

By repoting this in my production environment the upload does not work.
i get this error:

Thank you so much Mr Dani3lSun for your help :D

"Uncaught ReferenceError: vArrayPageItems is not defined"

Expected behavior

files uploaded without error

Actual behavior

after selecting or dropping a file into the dropzone, the file is not uploaded; console shows the following trace:

apexdropzone.min.js:2Uncaught ReferenceError: vArrayPageItems is not defined
at Object.buildPageItemValuesArray (apexdropzone.min.js:2)
at Object.uploadDzFiles (apexdropzone.min.js:3)
at c.f.uploadFiles (apexdropzone.min.js:12)
at c.processFiles (dropzone.min.js:formatted:882)
at c.processFile (dropzone.min.js:formatted:870)
at c.processQueue (dropzone.min.js:formatted:863)
at dropzone.min.js:formatted:769
buildPageItemValuesArray @ apexdropzone.min.js:2
uploadDzFiles @ apexdropzone.min.js:3
f.uploadFiles @ apexdropzone.min.js:12
c.processFiles @ dropzone.min.js:formatted:882
c.processFile @ dropzone.min.js:formatted:870
c.processQueue @ dropzone.min.js:formatted:863
(anonymous) @ dropzone.min.js:formatted:769

Steps to reproduce the issue

Install Dropzone 1.9.5
Select, or drag-and-drop, a file into the dropzone

APEX version (4.2.6 / 5.0.3)

5.0.4

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

Apache 2.4

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

Chrome 55 Windows

Apex 18.1 Not functioning as is. Will there be a version for 18.1

Expected behavior

On Click should open file browser for file selections

Actual behavior

Drag and Drop and Click functionality is disabled. No action on click

Steps to reproduce the issue

Install dropzone on Apex 18.1

APEX version (4.2.6 / 5.0.3)

18.1

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Redhat Linux x64

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

Chrome

Add "renameFile" option to the plugin

Expected behavior

Make it possible to rename a file when uploading.
In the DropzoneJS library there is an option called "renameFile".
This option could be used to call a JavaScript function (or PL/SQL code via DA) so users can rename files as they want themself.
DropzoneJS documentation

Already tried to add the option after line

apex-plugin-dropzone/server/js/apexdropzone.js

Line 690 in 08f83a7

dictInvalidFileType: invalidFileTypeMessage

and it works to call my own JavaScript function.
If it is possible to customize this via PL/SQL code it could be even better but no idea how to do that yet.
Line added:
renameFile: customRenameFile

Actual behavior

Not implemented

Steps to reproduce the issue

Our use case:
When pasting an image from the clipboard (for example take a screenshot), it always defaults to the name "image.png".
We would like to edit this so we can have "screenshot-1.png" or something like that.

APEX version (4.2.6 / 5.0.3)

5.1.4

Dynamic Action not triggering

Expected behavior

Alert should be fired once File is uploaded.

Actual behavior

dynamic action is not fired.

Steps to reproduce the issue

• Added Region
  Dropzone 2 [Plug-in]
  

• Create New DA
  Name : DA1
  Event : Dropzone Chunked File Upload Success (AJAX)
  Selection Type : Region
  Region : 'My Region - Drag & Drop'

  • True Action
    Action : Alert
    Text : 'Uploaded'

From the output, When I drag & drop file to the region, I am not getting any alert message.

APEX version (4.2.6 / 5.0.3)

Apex 5.0.3

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

Tomcat 7, ORDS 3.0.6, Linux Redhat x64

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

Chrome 59.0.3071.115 (Official Build) (64-bit)

Dropzone Upload File Error does not trigger when number of files exceeded the Max Limit

Expected behavior

I thought the Upload File Error (in DA) would recognize when the number of files exceeded the max Files Limit defined for the PlugIn

Actual behavior

Even if files failed to load the condition of Upload File Error does not seem to trigger.

Steps to reproduce the issue

Set max Limit to 20
Create a DA With Event Upload File Error on region Dropzone
Load the Dropzone with 21 or more files
The files over the limit remain with the 'X' but nowhere it was triggered the fact that files failed to load.

APEX version (4.2.6 / 5.0.3)

5.0.3

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

Tomcat 7

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

Chrome 55.0.2883.87 m (64-bit)

Note: Maybe consider adding a new Component Event given that it actually managed the max limit, unfortunately there is no way to see if all I dragged actually loaded or just some.

Accented characters are not decoded correctly

Expected behavior

Changing the default messages in Component Settings should work with accented characters, like in older versions.
This is from v2.1.0:

Actual behavior

Unicode characters are displayed incorrectly.
This is from the same application on the same page and region, with v2.2.2:

APEX version (4.2.6 / 5.0.3)

5.1.1

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

ORDS3.0.9 / Tomcat 8 / Apache 2.4 / Linux x64

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

Firefox 58 Linux

Data Not saving and remove file not showing

Hello,

I have followed your instruction as mentioned in help file. However, I'm facing the issues is that I cant save data in APEX_COLLECTION and also don't showing "Remove File" as showing in your demo application. My DB version 11gR2, Oracle Apex 5.0.3 amd ORDS 3.0 with https SSL.

mixture of old and new dropzone - multiple js errors

Upgraded one of two dropzones on a page to 2.0.0

Actual behavior

Uncaught TypeError: Cannot read property 'toLowerCase' of undefined
at Object.parseBoolean (apexdropzone.js:10)
at Object.apexDropzoneFnc (apexdropzone.js:247)
at f?p=450:1:
at HTMLDocument. (f?p=450:1:
at fire (jquery-2.1.3.js?v=5.0.4.00.12:3094)
at Object.fireWith [as resolveWith] (jquery-2.1.3.js?v=5.0.4.00.12:3206)
at Function.ready (jquery-2.1.3.js?v=5.0.4.00.12:3412)
at HTMLDocument.completed (jquery-2.1.3.js?v=5.0.4.00.12:3428)
parseBoolean @ apexdropzone.js:10
apexDropzoneFnc @ apexdropzone.js:247
(anonymous) @ f?p=450:1:
(anonymous) @ f?p=450:1:
fire @ jquery-2.1.3.js?v=5.0.4.00.12:3094
fireWith @ jquery-2.1.3.js?v=5.0.4.00.12:3206
ready @ jquery-2.1.3.js?v=5.0.4.00.12:3412
completed @ jquery-2.1.3.js?v=5.0.4.00.12:3428

dropzone.js:440 Uncaught Error: No URL provided.
at new Dropzone (dropzone.js:440)
at Function.Dropzone.discover (dropzone.js:1479)
at Dropzone._autoDiscoverFunction (dropzone.js:1761)
at HTMLDocument.init (dropzone.js:1730)
Dropzone @ dropzone.js:440
Dropzone.discover @ dropzone.js:1479
Dropzone._autoDiscoverFunction @ dropzone.js:1761
init @ dropzone.js:1730

dropzone.js:427 Uncaught Error: Dropzone already attached.
at new Dropzone (dropzone.js:427)
at Function.Dropzone.discover (dropzone.js:1479)
at Dropzone._autoDiscoverFunction (dropzone.js:1761)
at HTMLDocument.init (dropzone.js:1730)

Steps to reproduce the issue

APEX version (4.2.6 / 5.0.3)

5.0.4

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

Apache

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

Chrome Windows

Add More Metadata

Expected behavior

Congratulations for the plugin-in! It is spectacular.
How it is possible to add more metadata to the uploaded file?
The scenario is:

1. Select a combo-box value;
2. Upload file and associate the value selected in the combo-box with the file uploaded in the database.
   Many Thanks

Actual behavior

Steps to reproduce the issue

APEX version (4.2.6 / 5.0.3)

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

maxPostSize of request exceeds server default configuration

Expected behavior

setting max. Filesize to 50 (MB)

Actual behavior

error during upload of file for files > ~2MB

seems, that uploading files using your approach (sending the file in pieces of 30K in 1 request) can exceed the maximum allowable POST request size configured on the webserver

Steps to reproduce the issue

APEX version (4.2.6 / 5.0.3)

5.0.3

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

Tomcat 8.0, maxPostSize:
The maximum size in bytes of the POST which will be handled by the container FORM URL parameter parsing. The limit can be disabled by setting this attribute to a value less than zero. If not specified, this attribute is set to 2097152 (2 megabytes). Note that the FailedRequestFilter can be used to reject requests that exceed this limit.

I have no access to the servers configuration in the customers corporate environment.

My suggestion: split the upload request in multiple requests rather then using one single request or using the good-old-fashined CLOB upload method instead (http://www.talkapex.com/2012/08/how-to-sendupload-clob-from-browser-to.html)

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

Data type BLOB can not be converted to VARCHAR2!

Expected behavior

the form should be opening

Actual behavior

the form is not opening and throwing the error Data type BLOB can not be converted to VARCHAR2!. i have uploaded the image with this thread

Steps to reproduce the issue

insert one record to the custom table and try to re-access the form

APEX version (4.2.6 / 5.0.3)

5.1.1

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

ORDS

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

Firefox 56.0.1

Large File Upload - Tomcat

Hi -

Initially, any file over 2mb, failed.

Changed Tomcat AJP Connector as described in docs.

Didn't help.

Changed HTTP Connector with same maxPostSize= settings as AJP connector. Over 2mb worked nicely.

Good work! Nice little tool.

File Character Set

Expected behavior

when uploading files to our custom tables, we have a file character set column for it along with the blob, filename, file_mimetype and data created columns. your pl/sql code which is inserting into the custom table do not reference that column

Actual behavior

no file character set column in handle

Steps to reproduce the issue

APEX version (4.2.6 / 5.0.3)

5.1.1

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

ORDS

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

Firefox 56.01

Before Start of Upload Dynamic Action does not fire

Expected behavior

Dynamic Action "Before Start of File Upload" is suppose to fire before upload process, the idea is, to force the user to set an item before the upload starts (e.g. to set a document category etc.)

Actual behavior

DA does not fire

Steps to reproduce the issue

Create Dropzone , add DA with event before start of file upload, Selection type: region, Affected elements: Dropzone region.

APEX version (4.2.6 / 5.0.3)

5.03

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

ORDS 3

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

Firefox / IE

Possible behavior

Hi Daniel,

will be possible (in some next releases) to use Foreign Key(s) option in the plugin settings due to linking to a master record for file(s)?

regards

Jozef

Display Message changes not being applied

I changed the Display Message in Custom Attributes in the Create/Edit Plug-in screen. The display message did not change when running the application. I also tried adding a new plug in region to my page after changing the message and the new region still had the original message as well.

APEX 5.03, Firefox 54, IE 11, Chrome

Available for Apex 4.2.x

Hi,

Is it possible to use the plugin wiht Apex 4.2.x as well?

Thanks

The apex-plugin-dropzone Apex Sample

I can not successful to deploy the apex-plugin-dropzone.
Could provide me the Apex app sample(57743)?
Thanks a lot.

max. Filesize in MB - use parseFloat instead of parseInt

I wanted to set the maximum file size to 1.5 MB and realized the plugin made 1 MB out of it.

Wouldn't it be better to change parseInt to parseFloat in apexdropzone.js? Or is there a reason you used parseInt for this parameter?

This is the line in apexDropzoneFnc:
var vMaxFileSize = parseInt(vOptions.maxFilesize);

Add callback events to plugin

Add possibility of callback events to the plugin for the different stages like
complete, file added, and so on.
So developers have a chance to react on these actions and can do stuff...

Remove file should delete the files from the table aslo

Expected behavior

when i click the remove button benith the file icon in the dropzone region, it is not removing from the underlying table.

Actual behavior

when i click the remove link, it should remove that particular file from the underlying table

Steps to reproduce the issue

APEX version (4.2.6 / 5.0.3)

5.1.1

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

ORDS

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

56.0.1

Execution of the statement was unsuccessful. ORA-20001: Error creating plug-in id="129251394625485599" ORA-20001: ERR-1014 Application not found.

Expected behavior

i was trying to install region_type_plugin_de_danielh_dropzone2.sql under the source directory into my apex page. it should install the application

Actual behavior

it throw the error
ORA-20001: Error creating plug-in id="129251394625485599" ORA-20001: ERR-1014 Application not found.

Steps to reproduce the issue

install it in apex 5.1.1

APEX version (4.2.6 / 5.0.3)

apex 5.1.1

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

ORDS 3

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

Firefox 55.0.3

How to download and delete uploaded files from custom table

Hi Mr Dani3lSun,
I hope, this post it will be my last in this plugin ;)

As you know im using dropzone plugin with my custom table.
Now i want to download and delete the uploded files.
For that i created IR as:

SELECT 
ID_PIECE,	
UTI_CODE_USER,
DOS_NUMERO_DOSSIER,
FILE_CONTENT,
MIMETYPE,
FILENAME,
UPLOAD_DATE,
FK_ID,
''    AS download,
''    AS delete

FROM    <table_name>
WHERE    DOS_NUMERO_DOSSIER= :P11_DOS_ID

And in the download column, i did: URL LINK:
f?p=&APP_ID.:11:&APP_SESSION.:APPLICATION_PROCESS=DOWNLOAD_TSL_FILE::::&X01=#ID_PIECE#

And in AJAX CALLBACK Process:

But when i run page, i get blank page

So how can i fix this issue, and how can i do delete file too ?

Thank you for help.

APEX version (5.1)
Used web server & version and platform (Apache 9 / win x64)
Used web browser (Chrome )

Is it possible to transfer data as blob instead of clob and also optional without chunking?

Hi Daniel,

first of all: thank you very much for this great plugin (and the APEX 4.2 implementation). The plugin works as expected, but we have performance problems because of two things:

1. apex_web_service.clobbase642blob takes a long time: around 50 seconds for 5 MB without clob caching and around 10 seconds with caching
2. dbms_lob.append apend takes some time: around 3 seconds without caching and 300 milliseconds with caching

We using your last version 1.9.2 for APEX 4.2. Now my questions:

1. I can see in your file apexdropzone.js, that you have a function binaryArray2base64 and I think you do the conversion to clob by yourself. Is there a chance to transfer the data to the DB directly as a blob to avoid the time consuming conversion back to blob in PL/SQL?
2. If I understand the issues and release notes correctly, can you make the split into chunks of 32k size optional? We use APEX Listener 2.x and Tomcat in the moment and it would be nice to save also the processing time in PL/SQL to put the chunks together, if this is technically possible with our setup.

Thank you in advance and best regards
Ottmar

File not uploading in Custom Table.

Hi Daniel,

After getting your demos I was able to run the dropzone without any issues, when it is selected as APRX_COLLECTION. However, While I was trying to insert into custom table getting the error"Database Error During Upload". Could you please shade light on this. Thanks, Munir.

Normal upload mechanism for large files

Expected behavior

Should be uploaded

Actual behavior

Are not uploaded, with error message "error"

Steps to reproduce the issue

Configure the plugin to Upload Mechanism = "Normal" and max. Filesize in MB = "10"

APEX version (4.2.6 / 5.0.3)

5.1

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

ORDS (on Glassfish 4.1) + IIS server (7.5)

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

Chrome

Hi Danny,
Great plugin!
We do have an issue when uploading larger files in "Normal upload mechanism" mode.
I've seen that there were issues in different application server configurations. In our case in Glassfish is the Max Post Size -1 (changing it to something large did not help). We could not find such a setting in IIS.
Do you have any ideas (except to change the mechanism to "chunked")?

Here are the Options, if relevant:
acceptedFiles:"application/pdf"
ajaxIdentifier:"6K3iUTSZXRrXxBKFm9kFmlWNmQ4Tu74TnM6ESXvSroQ"
cancelUploadConfirmMessage:"Are you sure you want to cancel this upload?"
cancelUploadMessage:"Cancel upload"
chunkSize:"1048576"
clickable:"true"
deleteFiles:"false"
displayMessage:"Drop PDF file(s) here or click to upload."
fallbackMessage:"Your browser does not support drag'n'drop file uploads."
fileTooBigMessage:"File is too big ({{filesize}}MiB). Max filesize: {{maxFilesize}}MiB."
invalidFileTypeMessage:"You can not upload files of this type."
maxFiles:256
maxFilesMessage:"You can not upload more than {{maxFiles}} files."
maxFilesize:10
pluginPrefix:"/app_files/hubdev/scn/plugins/dropzone/"
removeAfterUpload:"true"
removeFileMessage:"Remove file"
resizeImages:"false"
showFilePreview:"false"
supportCopyPaste:"false"
uploadMechanism:"NORMAL"

And the debug of the error:
apexDropzone.uploadDzFiles Error error
apexDropzone.handlePluginEvents - error event
apexDropzone.handlePluginEvents - complete event
apexDropzone.handlePluginEvents - totaluploadprogress event
apexDropzone.handlePluginEvents - removedfile event

Regards,
Mirela

How to limit to select only one file?

Hey Dani3lSun,

Great plugin again!

I was wondering how I could limit the user to select only one file.

Although setting "Max. File" to 1 the user still can select as many files they want.

I'm thing to execute $('.dz-hidden-input').prop('disabled', true); when a DA "max Files Exceeded" happens but I am not sure if that is the best approach.

New functionality for page item

Lets suppose i used the plugin to send photos from an meeting event. I wan to send the photos (form mobile or desktop) but before dragging i want to set a page items to write event code, event date, participants and the drag the photos, so my table will get the page items and upload columns accordingly and then your plugin add std columns mimetype,blob,filename etc.

Upload to Cloud

Expected behavior

Actually, it is a feature request, you've done an amazing job. It would really be nice if you add options for direct upload to Amazon and Oracle Cloud Storage.

Actual behavior

Steps to reproduce the issue

APEX version (4.2.6 / 5.0.3)

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

Insert files in custom table

I want to upload multiples PDF files in my own and custom table using DropZone APEX Plugin.
So for that, i created another version, following your article https://github.com/Dani3lSun/apex-plugin-dropzone#inserting-uploaded-files-into-your-own-tables and using my own table 'TSL_CC_PIECES'

But the issue still here, i cant store the files in my custom table.

The demonstration of issue, on apex.oracle.com with this credentials:
Workspace: ws_formation
Username: asoukaina
Password: s@boulah123

I used the Application 200218 - Dropzone Demo.

Thank you a lot for help.

NB:
APEX version (5.1)
Used web server / version and platform (ORDS 3.0.3 / Tomcat 9 / win7 x64)
web browser / version and platform (Chrome ,Firefox )

Thumbnail upload too?

Hi Daniel,

Is it possible to upload files and "thumbnail" along with the files that are already created in the "dropzone" plug-in?

P.S. I use "Oracle XE" without the ability to use ORDSYS packages.

regards

Dmitry

Uploading old TIFF files (maybe corrupt or to old tiff format) results into an error (tested witch files created back in 2008)

Expected behavior

When uploading old tiff files, the process of uploading them should complete or give a detailed error message as to why it stopped.

Actual behavior

When uploading old tiff files the process stops after a few seconds marks the file as an error and when hovering over the file it shows the description: "error". It would be nice to show a detailed errorstring or maybe even no error at all.

Screenshots

Steps to reproduce the issue

Because of data privacy i can't give you any of the files for testing purposes, which will make this very hard to reproduce.

Found Workaround

There is a current workaround that fixes this problem. When opening a tiff in the standard windows viewer, you can rotate the picture. What many don't know, if you rotate a tiff in one direction and close it, windows saves the tiff in the windows default tiff format.

So the workaround to fix this, is rotate->close->open->rotate back->close. And then the upload works. So my guess is that the tiff format of those old files is either corrupt or currently can't be handled by dropzone.

APEX version (4.2.6 / 5.0.3)

APEX version 5.1.2.00.09

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

Tomcat - Don't know which version exactly

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

Internet Explorer 11.0.9600.18893

Number of OPEN_CURSORS just keeps growing and growing..

Expected behavior

I would expect that at some point open cursors are closed otherwise the session APEX_PUBLIC_USER keeps holding them open.

Actual behavior

OPEN_CURSORS keeps increasing and at some point causes the database to issue a ORA-01000 maximum open cursors exceeded

Steps to reproduce the issue

Just add a lot of files to the dropzone, you don't have to write them to the DB, just to load to the collection.
Even if the collection if flushed via TRUNCATE_COLLECTION or writing the files to the DB the OPEN_CURSORS keep growing. Eventually will get to the limit set by Parameter: OPEN_CURSOR.
Validate how it grows and never shrinks using:
1 select s.username, max(a.value)
2 from v$sesstat a, v$statname b, v$session s
3 where a.statistic# = b.statistic#
4 and s.sid (+)= a.sid
5 and b.name = 'opened cursors current'
6* group by s.username

APEX version (4.2.6 / 5.0.3)

5.0.3

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

ORDS 3.0.2.294.08.40, Tomcat 7.0.54, XE 11.2.0.2.0

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

Chrome 55.0.2883.87 m (64-bit)

I suggest to validate:
In the code close the cursors explicitly and close the results set.

Excellent reference on OPEN_CURSORS on applications leaking cursors... http://www.orafaq.com/node/758

Configuration in Apex 5

Hi Daniel,

It would be helpful if you added a demo app , so we could see how you configured your apex page . I have trouble getting your plugin to work, but I would really like to see it work as it really improves the user experience.

External Storage

Hello,
Your contributions are highly appreciated.

Are you planning to support external storage e..g, the files are uploaded to Amazon or Oracle Cloud Storage, then the files link are stored in the DB.

data not does not save while dropzone is empty

Expected behavior

Say, I want to use drop zone for Customer avatar. So it may be empty or user may put images. it should save to database without any images from dropzone .

I have two BLOB column in a table, then how should I insert them into database. As I have seen in Apex collection there is only one BLOB Column. How can I use it for two blob column. Otherwise while I go to save through custom insert statement I got the error: ORA-01465: invalid hex number

Actual behavior

However, while trying to insert record without putting any images to dropzone no data is inserting into database.

Steps to reproduce the issue

try to save without putting images in dropzone with two blob column in a table.

APEX version (4.2.6 / 5.0.3)

5.1

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

Accepted file types - does not accept item name or substitution

Expected behavior

Accepted File Types attribute should be able to be set to the name of an item, or a substitution variable (page or application item).

Actual behavior

Accepted File Types attribute appears to be interpreted literally.

Steps to reproduce the issue

1. Set Accepted File Types to something like P1_MIMETYPE_LIST
2. Set P1_MIMETYPE_LIST to a valid value, e.g. "application/pdf"
3. Drop a file.
   Regardless of file type, the dropzone refuses to accept any file type.

APEX version (4.2.6 / 5.0.3)

5.0.3

Used web server / version and platform (ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64)

ORDS 3.03

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

Chrome 53 on Windows 7

Make files sortable inside of dropzone area

It would be nice to have some kind of sorting possibility inside of the dropzone area.
If a file gets re-ordered a order sequence is updated in the APEX Collection via AJAX.
A possible solution could be via JQuery UI Sortable, see attached GIF.
For the dropzone logic this could be helpful:
dropzone/dropzone#631

Allow to use substitution strings in the collection name

Expected behavior

Allow to use substitution strings in the collection name.

Actual behavior

Has empty string instead.

APEX version (4.2.6 / 5.0.3)

5.1.1

Used web browser / version and platform (Chrome 48 Mac / Firefox 44 Windows)

Chrome

---

Or we could also allow to store values in c003, c004, c005 etc to customize the collection further.

plug in will not work in some browsers

At my work the company standard browsers are IE 11 and Firefox 45.0.2. I have access to Chrome browser but it is not considered a company standard browser and the applications I develop need to be able to run on IE and Firefox.

The drag/drop and file upload feature work, but the paste does not work in IE 11 and Firefox 45.0.2. It does work on Chrome. On my personal PC's that run Microsoft Edge and Firefox 50.0.2 it works like a charm. This plug in is perfect for a project I am currently working on. I would like to work with my company to find a way to be able to use this functionality but wanted to find out from you if we need to be on Edge/latest Firefox, or is there a setting in the IE 11/Firefox 45.0.2 browsers that I need to have changed?

Plugin Not showing in ORDS

Dear Developer , i am going to install dropzone plugin in apex 5.1
ORDS 3.0.3 / Tomcat 7 / Apache 2.4 / Linux x64
when i create region with dropzone plugin its showing nothing.
please help me to run this plugin.

Thanks
Moin Sultan