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

asked 08 Apr '16, 09:06

Alex's gravatar image

Alex
3092833
accept rate: 19%

edited 27 Apr '16, 04:44

FOEX-SUPPORT's gravatar image

FOEX-SUPPORT
3.7k15

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

(12 Apr '16, 09:58) FOEX-SUPPORT FOEX-SUPPORT's gravatar image

Hi - what did you find?

(26 Apr '16, 02:21) Alex Alex's gravatar image

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

link

answered 27 Apr '16, 04:43

FOEX-SUPPORT's gravatar image

FOEX-SUPPORT
3.7k15
accept rate: 32%

Thanks - looking forward to the bugfix

(04 May '16, 04:45) Alex Alex's gravatar image

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

link

answered 31 Aug '16, 09:53

Alex's gravatar image

Alex
3092833
accept rate: 19%

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

(02 Sep '16, 03:29) FOEX-SUPPORT FOEX-SUPPORT's gravatar image

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?

link

answered 16 Sep '16, 17:55

Alex's gravatar image

Alex
3092833
accept rate: 19%

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"

(01 Feb, 07:24) Alex Alex's gravatar image
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×523
×25

Asked: 08 Apr '16, 09:06

Seen: 737 times

Last updated: 01 Feb, 07:24

FOEX Links