Main Region

How can I get the csv export for filtered results to return data in the same format as the full export? (FXP-2396)
| | 3 answers | 39 views

AL
Posted by Alex
Apr 8th, 2016 at 14:06
0

When we enable the export button from a grid, the exported results are different when using the export for filtered results vs. the full export. I've built an example in my APEX 4 Workspace on App 217 Page 3025, filter with the value "1000".

The filtered output does not translate a LOV from an ID, German UTF8 characters are garbled when opening the csv from excel, and the date/time displayed on the grid seems to be formatted into a date-only value.

We would expect the filtered output format to be the same as the standard output.

alt text

5 Comments

Profile Image
FOEX-SUPPORT on Apr 12th, 2016 at 14:58

Hi Alex, thank you for the test case, we will investigate it.

AL
Alex on Apr 26th, 2016 at 07:21

Hi - what did you find?

AL
Alex on May 4th, 2016 at 09:45

Thanks - looking forward to the bugfix

Profile Image
FOEX-SUPPORT on Sep 2nd, 2016 at 08:29

We will supply a fix in the next hot fix release for v2.2.0 due out soon.

AL
Alex on Feb 1st, 2017 at 13:24

In "Export filtered data" The issues look resolved now, however on our sample page in the APEX 5 environment, App 268 Page 50002 we get

alt text

when using "Export visible rows"

Profile Image
Posted by FOEX-SUPPORT
Apr 27th, 2016 at 09:43
0

We confirm this is an issue and filed a ticket (FXP-2396)

0 Comments

AL
Posted by Alex
Aug 31st, 2016 at 14:53
0

Hi - I have just tested this in the latest FOEX Hotfix and the issue still persists. Can you give an ETA for the fix?

0 Comments

AL
Posted by Alex
Sep 16th, 2016 at 22:55
0

I have retested this in hotfix HFXP-2552 released yesterday but cannot see any changes to the behaviour. I've got an example on the APEX 5 FOEX trial instance, app 268 Page 50002.

alt text

Visible Records: A file is created, but it has a size of zero bytes

foex.js?v=2.2.0:19442 Resource interpreted as Document but transferred with MIME type application/excel: "http://trial.tryfoexnow.com/ords/wwv_flow.show".visibleRecordsCSVExport @ foex.js?v=2.2.0:19442handler @ foex.js?v=2.2.0:19138callback @ ext-all-debug-w-comments.js?v=2.2.0:12368onClick @ foex.js?v=2.2.0:26793onClick @ foex.js?v=2.2.0:26856(anonymous function) @ VM1148:6wrap @ ext-all-debug-w-comments.js?v=2.2.0:17229
2016-09-16 21:39:56.588 foex.js?v=2.2.0:19476 Resource interpreted as Document but transferred with MIME type

Filtered Data: A file is created, but when opening it with Excel, the special characters are garbled:

alt text

application/excel: "http://trial.tryfoexnow.com/ords/wwv_flow.show".filteredCSVExport @ foex.js?v=2.2.0:19476handler @ foex.js?v=2.2.0:19148callback @ ext-all-debug-w-comments.js?v=2.2.0:12368onClick @ foex.js?v=2.2.0:26793onClick @ foex.js?v=2.2.0:26856(anonymous function) @ VM1148:6wrap @ ext-all-debug-w-comments.js?v=2.2.0:17229
2016-09-16 21:40:20.091 foex.js?v=2.2.0:19483

The Standard csv Export gives the expected results when opening the Excel file

alt text

Resource interpreted as Document but transferred with MIME type application/excel: "http://trial.tryfoexnow.com/ords/f?p=268:50002:15621141377119:FLOW_EXCEL_OUTPUT_R223198070395014727_en_gb".CSVExport @ foex.js?v=2.2.0:19483fullExportFn @ foex.js?v=2.2.0:19116callback @ ext-all-debug-w-comments.js?v=2.2.0:12368onClick @ foex.js?v=2.2.0:26793onClick @ foex.js?v=2.2.0:26856(anonymous function) @ VM1148:6wrap @ ext-all-debug-w-comments.js?v=2.2.0:17229

In addition, when you have a grid with no pagination scheme, an uncaught type error is thrown when you choose "Export Visible Rows"

I have also reproduced this in the APEX 5 trial instance, app 268 Page 50003.

ext-all-debug-w-comments.js:107359 Uncaught TypeError: Cannot read property 'length' of undefinedeach @ ext-all-debug-w-comments.js:107359getVisibleRecords @ foex.js:19329visibleRecordsCSVExport @ foex.js:19408handler @ foex.js:19138callback @ ext-all-debug-w-comments.js:12368onClick @ foex.js:26793onClick @ foex.js:26856(anonymous function) @ (program):6wrap @ ext-all-debug-w-comments.js:17229

How can we get this to work consistently?

0 Comments

You must log in or sign up to post questions and answers.