When Uploading Values To A Dynamic Data Set (DDS) Using A CSV Import File, Some Columns Are Not Updated With the Values Being Loaded From CSV (Doc ID 2768794.1)

Last updated on OCTOBER 03, 2024

Applies to:

Symptoms

On Unifier : Any Version

In Data Structure Setup for a Dynamic Data Set:

When uploading values to a Dynamic Data Set (DDS) using a CSV Import File, some of the "<Name>" columns are not updated with the expected values for all of the DDS Rows. In this case, there are some duplicate column names being uploaded, we'll call them "Name". So there is more than one column with the same Form Label of "Name".

EXPECTED BEHAVIOR
-----------------------
Expecting all columns in the DDS set to be updated with the values from the CSV import file.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Log into the Unifier Environment.
2. Navigate to Company Workspace > Admin Mode > Data Structure Setup > Dynamic Data Sets > Select DDS to be updated.
3. File > Export > File "DDS-1.csv" is downloaded.
4. Update the "DDS-1" file as desired. Note that all columns of Form Label "Name" contain data.
5. Import the CSV file.
6. Then export the newly imported data by clicking on File > Export > File "DDS-2.csv".
7. Review the downloaded "DDS-2.csv" file.
8. Note that only the first of the columns with Form Label "Name" is added to the DDS and the other(s) do not exist in the result.

Cause

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