My Oracle Support Banner

Data Listings Export in Excel Format is Missing Records by Comparison with CSV Export (Doc ID 2618692.1)

Last updated on DECEMBER 20, 2019

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4.8.2 and later
Information in this document applies to any platform.

Symptoms

On Oracle Health Sciences Data Management Workbench (DMW) 2.4.8.2 version,

ACTUAL BEHAVIOR
---------------
For a table listing in a specific study, when exporting all contents in Excel format, there are 621428 records.
When exporting the same table contents in CSV format there are 61429 records.

EXPECTED BEHAVIOR
-----------------------
It would be expected that the number of records exported in Excel and CSV format to match.

STEPS
-----------------------
The issue can be reproduced with the following steps:
1. From DMW, open a study.
2. Go to "Data Management"/"Data Review"
3. Under "Listings" tab, select a model.
4. Select a table under Default Listings panel.
5. Select "Export"/"Export All to Excel".
6. Select "Export"/"Export All to CSV".
7. Compare the two exported files.


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.