Skip to Main Content
Feature Request FR-1936
Product Area Application Builder
Status ROADMAP

25 Voters

APEX_DATA_PARSER - parameter that can be passed in parser function to ignore null records/empty line

suniti.dhingra Internal · Sep 8 2021

Idea Summary
APEX_DATA_PARSER - parameter that can be passed in parser function to ignore null records/empty line

Use Case
Users by mistake sometimes enter the empty line at the end of excel/csv files and they get uploaded in the system which are of no use as the records are empty.  These records take unnecessary time to upload and users has to explicitly delete those records.  

Preferred Solution (Optional)
How would you implement this idea? If you are not sure, leave blank.

This is currently on the roadmap for a future release of Oracle APEX.

Comments

Comments

  • mswvette OP 3.1 years ago

    Typically there is just 1 or a few columns that define if the record should be included, just add a where clause (e.g. where col001 is not null and col002 is not null)

  • carsten.czarski APEX Team OP 3.1 years ago

    Hi Suniti,

    which APEX version are you using …? And which type of file are you uploading? That should actually be the standard behavior of APEX_DATA_PARSER, so you might have encountered a bug.

    regards

    _Carsten

  • suniti.dhingra OP 3.1 years ago

    Hi Carsten

    I was uploading csv file in which there were approx 200 columns and unconsciously user has added null records at the end, which gets uploaded and processed, when I implemented the solution to upload and process csv files using APEX_DATA_PARSER version was 20. In APEX_DATA_PARSER there is no parameter to ignore all null values.  Thanks!

  • suniti.dhingra OP 3.1 years ago

    @ mswvette - Dynamic solution implemented in which user upload the csv file and dynamic forms build out of that and user choose id columns, not in the control of developer to add where clause. User can upload 2 columns or 300 columns. Thanks!

  • carsten.czarski APEX Team OP 3.1 years ago

    Hi Suniti,

    so, empty rows in the CSV file should already be ignored. Uploading content  like this will have the empty row not being uploaded. I verified that, and even APEX 19.1 ignores that empty row already.

    A,B,C
11,12,13
21,22,23

31,32,33

    However, if you're uploading content like this, a row with NULL values is created (instead the comma, a TAB could be used as well).

    A,B,C
11,12,13
21,22,23
,,
31,32,33

    is that the case you're after?

    regards

    -Carsten

  • girish.manchanda OP 1.4 years ago

    Hi Carsten,

    We have again encountered this issue (Yes, the 2nd case). Also, there can be row with NULL values before header. Any plans to get a fix in future APEX release?

    ,,
A,B,C
11,12,13
21,22,23
31,32,33
  • carsten.czarski APEX Team OP 1.4 years ago

    Hi Girish,

    I don't have an ETA for this enhancement to arrive.

    However, when it's about leading rows, you can use the P_SKIP_ROWS parameter in order to have APEX_DATA_PARSER starting at a later row than the first one …

    regards

    -Carsten