When exporting a dynamic data list in a CSV format, the chart shows the values instead of the options for Radio and Select fields.

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 6.1.0 CE GA1, 6.1.10 EE GA1
• Fix Version/s: 6.1.1 CE GA2, 6.1.20 EE GA2, --Sprint 11/12, 6.2.0 CE M2
• Component/s: Dynamic Data Lists, Frameworks, Frameworks > Dynamic Data Mapping
• Labels:
  • QA-R
• Environment: Tomcat 7 + MySQL 5. 6.1.x GIT ID: b4ac0314909dc7078ff140e01c3ed0b3645d52d1. ; Tomcat 7 + MySQL 5. 6.2.x GIT ID: 2f151a3ca3405bf6c5cbd698f760935ac476cd6f.
• Branch Version/s:
  6.1.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Similar Issues: Show 3 results ; ;

  LPS-21753	When adding an option to the Radio and the Select fields, the option will not show up in Predefined Value until definition is first saved.
  LPS-19962	DDL: Unable to Save add Option in Radio and Select field
  LPS-27416	Custom Dynamic Data lists do not honor all fields in configuration.

If the user creates a list using the Radio and Select fields and export the list in CSV format, the radio and select fields show the value '2' or '3' instead of the option name (e.g. 'Core Engineer'.)

1. Add a page and the DDLD portlet.
2. Add a list called Employees.
3. Add a definition:
   1. Drag and drop the Radio field into the build container.
   2. Rename it as Department.
   3. In the Options field -
      1. Option 1 = Core Engineer; enter 1 in the value column.
      2. Option 2 = QA Engineer; enter 2 in the value column.
      3. Option 3 = Support Engineer; enter 3 in the value column.
   4. Add a fourth option.
      1. Option 4 = Marketing; enter 4 in the value column.
   5. Save the field.
   6. Drag and drop the Select field into the build container.
   7. Rename it as Years Worked.
   8. In the Options field -
      1. Option 1 = 1-2; enter 1 in the value column.
      2. Option 2 = 3-5; enter 2 in the value column.
      3. Option 3 = 6-8; enter 3 in the value column.
   9. Add a fourth option.
      1. Option 4 = 8+; enter 4 in the value column.
   10. Save the field.
4. Save the definition.
5. Select this definition for the list.
6. Add a record: QA Engineer, 3-5 .
7. Go to the Control Panel> Dynamic Data Lists.
8. Select this list.
9. Click Actions> Export as CSV
10. Open the CSV file. Instead of displaying QA Engineer, 3-5 under the Department and Years Worked columns, it displays "2" and "2" which were the values. See attached file.

[Justin Choi]

This file has several more fields; scroll right to the Department and Years Worked columns.

[Manuel de la Peña]

The ticket also applies to XML exportation.

We should change it too.

[Michael Saechang]

Committed on:
Portal 6.1.x CE GIT ID: a538830d380022cc4ca9b6ff8c8c30289b06ff7f.
Portal 6.2.x GIT ID: 11e2494f6030c640c36bce9367c541008d401713.

[Justin Choi]

PASSED Manual Testing following the steps in the description:

Fixed on:
Tomcat 7.0 + MySQL 5. Portal 6.1.x EE GIT ID: 9c3a7ede3b980c49fc2a23958f03f5b5faf3bad4.
Tomcat 7.0 + MySQL 5. Portal 6.2.x GIT ID: 1e3f5ab831e6412a431e7d6ed4c45d43fdad97b6.

• Exported CSV file displays the correct DDL option labels instead of values. (See the second picture.)