PUBLIC - Liferay Portal Community Edition
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-26583

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

    Details

    • Branch Version/s:
      6.1.x
    • Backported to Branch:
      Committed
    • Fix Priority:
      3
    • Similar Issues:
      Show 3 results 

      Description

      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.
      1. Liferay Employees(1).csv
        0.4 kB
        Justin Choi
      1. 7-24-CSV.JPG
        15 kB

        Issue Links

          Activity

          Hide
          Justin Choi added a comment -

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

          Show
          Justin Choi added a comment - This file has several more fields; scroll right to the Department and Years Worked columns.
          Hide
          Manuel de la Peña added a comment -

          The ticket also applies to XML exportation.

          We should change it too.

          Show
          Manuel de la Peña added a comment - The ticket also applies to XML exportation. We should change it too.
          Hide
          Michael Saechang added a comment -

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

          Show
          Michael Saechang added a comment - Committed on: Portal 6.1.x CE GIT ID: a538830d380022cc4ca9b6ff8c8c30289b06ff7f. Portal 6.2.x GIT ID: 11e2494f6030c640c36bce9367c541008d401713.
          Hide
          Justin Choi added a comment -

          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.)
          Show
          Justin Choi added a comment - 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.)

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                3 years, 2 weeks ago

                Development

                  Structure Helper Panel