Grid Export rendered data is not reflecting in the exported File, Displayed ID instead of Rendered Label #25963

koushikch7 · 2019-12-10T05:39:09Z

Preconditions

Verified in Magento 2.3.2 and 2.3.3 and found that the data displayed in the grid by rendering columns is not reflecting in the Exported file, Instead, we are getting Id of the data rather than grid value.
Verified in the environments,

Magento 2.3.2 and Magento 2.3.3 & 2.4-develop
Apache and Nginx
Mysql and MongoDB

Steps to reproduce

Log in to the Magento Admin
Choose any grid having an export option. In my case, I choose for Sales Order Grid.
Click on Export using CSV/Excel.

Expected result

CSV/Excel sheet that contains all the details with values as displayed in the grid
e.g.:

Actual result

CSV/Excel sheet that contains Columns with ID rathe than values displayed as in the grid

m2-assistant · 2019-12-10T05:39:11Z

Hi @koushikch7. Thank you for your report.
To help us process this issue please make sure that you provided the following information:

Summary of the issue
Information on your environment
Steps to reproduce
Expected and actual results

Please make sure that the issue is reproducible on the vanilla Magento instance following Steps to reproduce. To deploy vanilla Magento instance on our environment, please, add a comment to the issue:

@magento give me 2.4-develop instance - upcoming 2.4.x release

For more details, please, review the Magento Contributor Assistant documentation.

@koushikch7 do you confirm that you were able to reproduce the issue on vanilla Magento instance following steps to reproduce?

yes
no

Join Magento Community Engineering Slack and ask your questions in #github channel.

tuyennn · 2019-12-10T08:53:28Z

@magento give me 2.4-develop instance

magento-engcom-team · 2019-12-10T08:53:33Z

Hi @tuyennn. Thank you for your request. I'm working on Magento 2.4-develop instance for you

magento-engcom-team · 2019-12-10T08:54:11Z

Hi @tuyennn, here is your Magento instance.
Admin access: https://i-25963-2-4-develop.instances.magento-community.engineering/admin
Login: admin Password: 123123q
Instance will be terminated in up to 3 hours.

m2-assistant · 2019-12-12T14:41:08Z

Hi @engcom-Charlie. Thank you for working on this issue.
In order to make sure that issue has enough information and ready for development, please read and check the following instruction: 👇

1. Verify that issue has all the required information. (Preconditions, Steps to reproduce, Expected result, Actual result).
Details
If the issue has a valid description, the label Issue: Format is valid will be added to the issue automatically. Please, edit issue description if needed, until label Issue: Format is valid appears.
2. Verify that issue has a meaningful description and provides enough information to reproduce the issue. If the report is valid, add Issue: Clear Description label to the issue by yourself.
3. Add Component: XXXXX label(s) to the ticket, indicating the components it may be related to.
4. Verify that the issue is reproducible on 2.4-develop branch
Details
- Add the comment @magento give me 2.4-develop instance to deploy test instance on Magento infrastructure.
- If the issue is reproducible on 2.4-develop branch, please, add the label Reproduced on 2.4.x.
- If the issue is not reproducible, add your comment that issue is not reproducible and close the issue and stop verification process here!
5. Add label Issue: Confirmed once verification is complete.
6. Make sure that automatic system confirms that report has been added to the backlog.

magento-engcom-team · 2019-12-12T15:59:01Z

✅ Confirmed by @engcom-Charlie
Thank you for verifying the issue. Based on the provided information internal tickets MC-29734 were created

Issue Available: @engcom-Charlie, You will be automatically unassigned. Contributors/Maintainers can claim this issue to continue. To reclaim and continue work, reassign the ticket to yourself.

m2-assistant · 2019-12-14T13:58:52Z

Hi @konarshankar07. Thank you for working on this issue.
Looks like this issue is already verified and confirmed. But if you want to validate it one more time, please, go though the following instruction:

1. Add/Edit Component: XXXXX label(s) to the ticket, indicating the components it may be related to.
2. Verify that the issue is reproducible on 2.4-develop branch
Details
- Add the comment @magento give me 2.4-develop instance to deploy test instance on Magento infrastructure.
- If the issue is reproducible on 2.4-develop branch, please, add the label Reproduced on 2.4.x.
- If the issue is not reproducible, add your comment that issue is not reproducible and close the issue and stop verification process here!
3. If the issue is not relevant or is not reproducible any more, feel free to close it.

Join Magento Community Engineering Slack and ask your questions in #github channel.

koushikch7 · 2019-12-20T04:47:46Z

@konarshankar07 This issue is not only for the Customer group grid, but also for the all grids (Default and Custom) which need fixed globally not like everywhere i think.

koushikch7 · 2020-01-11T10:09:14Z

@magento give me 2.4-develop instance

magento-engcom-team · 2020-01-11T10:09:17Z

Hi @koushikch7. Thank you for your request. I'm working on Magento 2.4-develop instance for you

magento-engcom-team · 2020-01-11T10:09:56Z

Hi @koushikch7, here is your Magento instance.
Admin access: https://i-25963-2-4-develop.instances.magento-community.engineering/admin
Login: admin Password: 123123q
Instance will be terminated in up to 3 hours.

koushikch7 · 2020-01-23T12:22:11Z

@magento give me 2.3.2 instance

magento-engcom-team · 2020-01-23T12:22:13Z

Hi @koushikch7. Thank you for your request. I'm working on Magento 2.3.2 instance for you

magento-engcom-team · 2020-01-23T12:22:47Z

Hi @koushikch7, here is your Magento instance.
Admin access: https://i-25963-2-3-2.instances.magento-community.engineering/admin_cc6b
Login: c3da96b8 Password: 34e7a9268dff
Instance will be terminated in up to 3 hours.

…played ID instead of Rendered Label #25963. Fixed grids export: option labels are taken from grid filters and columns now.

…played ID instead of Rendered Label magento#25963. Implemented strict types.

…played ID instead of Rendered Label magento#25963. Fixed case when options are configured via XML directly instead of providing a class.

…played ID instead of Rendered Label magento#25963. Fixed Unit tests.

…played ID instead of Rendered Label magento#25963. Unit tests code reformatting.

…played ID instead of Rendered Label magento#25963. Implemented Unit tests coverage.

…played ID instead of Rendered Label magento#25963. Removed deprecated class.

magento-engcom-team · 2020-02-21T22:20:12Z

Hi @koushikch7. Thank you for your report.
The issue has been fixed in #26523 by @novikor in 2.4-develop branch
Related commit(s):

The fix will be available with the upcoming 2.4.0 release.

…m grid filters and columns now. #26523 - Merge Pull Request #26523 from novikor/magento2:25963-grid-export-labels - Merged commits: 1. b43980b 2. 93793d8 3. c517f5f 4. 9bb416f 5. cd24e41 6. 6b434ba 7. b117b0c 8. 4a78ca5 9. 34d1876 10. 4483911 11. 0d3e478 12. 1a1ab4d 13. 5849cb6

…m grid filters and columns now. #26523

engcom-Charlie self-assigned this Dec 12, 2019

ghost unassigned engcom-Charlie Dec 12, 2019

magento-engcom-team added the Issue: Ready for Work Gate 4. Acknowledged. Issue is added to backlog and ready for development label Dec 12, 2019

konarshankar07 self-assigned this Dec 14, 2019

konarshankar07 mentioned this issue Dec 14, 2019

Grid export issue task 25963 #26046

Closed

4 tasks

novikor added Reproduced on 2.3.x The issue has been reproduced on latest 2.3 release and removed good first issue labels Jan 23, 2020

novikor added a commit that referenced this issue Jan 24, 2020

Grid Export rendered data is not reflecting in the exported File, Dis…

b43980b

…played ID instead of Rendered Label #25963. Fixed grids export: option labels are taken from grid filters and columns now.

novikor mentioned this issue Jan 24, 2020

[#25963] Fixed grids export: option labels are taken from grid filters and columns now. #26523

Merged

4 tasks

ghost assigned novikor Jan 24, 2020

novikor added a commit to novikor/magento2 that referenced this issue Jan 24, 2020

Grid Export rendered data is not reflecting in the exported File, Dis…

93793d8

…played ID instead of Rendered Label magento#25963. Implemented strict types.

novikor added a commit to novikor/magento2 that referenced this issue Jan 30, 2020

Grid Export rendered data is not reflecting in the exported File, Dis…

9bb416f

…played ID instead of Rendered Label magento#25963. Fixed Unit tests.

novikor added a commit to novikor/magento2 that referenced this issue Jan 30, 2020

Grid Export rendered data is not reflecting in the exported File, Dis…

cd24e41

…played ID instead of Rendered Label magento#25963. Unit tests code reformatting.

novikor added a commit to novikor/magento2 that referenced this issue Jan 30, 2020

Grid Export rendered data is not reflecting in the exported File, Dis…

6b434ba

…played ID instead of Rendered Label magento#25963. Implemented Unit tests coverage.

novikor added a commit to novikor/magento2 that referenced this issue Jan 31, 2020

Grid Export rendered data is not reflecting in the exported File, Dis…

b117b0c

…played ID instead of Rendered Label magento#25963. Removed deprecated class.

novikor added a commit to novikor/magento2 that referenced this issue Jan 31, 2020

Grid Export rendered data is not reflecting in the exported File, Dis…

4a78ca5

…played ID instead of Rendered Label magento#25963. Removed deprecated class.

magento-engcom-team added the Fixed in 2.4.x The issue has been fixed in 2.4-develop branch label Feb 21, 2020

magento-engcom-team closed this as completed Feb 21, 2020

magento-engcom-team pushed a commit that referenced this issue Feb 21, 2020

ENGCOM-6901: [#25963] Fixed grids export: option labels are taken fro…

88dedff

…m grid filters and columns now. #26523

sdzhepa mentioned this issue May 9, 2022

tyutyu sdzhepa/magento2#5

Open

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Grid Export rendered data is not reflecting in the exported File, Displayed ID instead of Rendered Label #25963

Grid Export rendered data is not reflecting in the exported File, Displayed ID instead of Rendered Label #25963

koushikch7 commented Dec 10, 2019 •

edited

Loading

m2-assistant bot commented Dec 10, 2019

tuyennn commented Dec 10, 2019

magento-engcom-team commented Dec 10, 2019

magento-engcom-team commented Dec 10, 2019

m2-assistant bot commented Dec 12, 2019

magento-engcom-team commented Dec 12, 2019

m2-assistant bot commented Dec 14, 2019

koushikch7 commented Dec 20, 2019

koushikch7 commented Jan 11, 2020

magento-engcom-team commented Jan 11, 2020

magento-engcom-team commented Jan 11, 2020

koushikch7 commented Jan 23, 2020

magento-engcom-team commented Jan 23, 2020

magento-engcom-team commented Jan 23, 2020

magento-engcom-team commented Feb 21, 2020

Grid Export rendered data is not reflecting in the exported File, Displayed ID instead of Rendered Label #25963

Grid Export rendered data is not reflecting in the exported File, Displayed ID instead of Rendered Label #25963

Comments

koushikch7 commented Dec 10, 2019 • edited Loading

Preconditions

Steps to reproduce

Expected result

Actual result

m2-assistant bot commented Dec 10, 2019

tuyennn commented Dec 10, 2019

magento-engcom-team commented Dec 10, 2019

magento-engcom-team commented Dec 10, 2019

m2-assistant bot commented Dec 12, 2019

magento-engcom-team commented Dec 12, 2019

m2-assistant bot commented Dec 14, 2019

koushikch7 commented Dec 20, 2019

koushikch7 commented Jan 11, 2020

magento-engcom-team commented Jan 11, 2020

magento-engcom-team commented Jan 11, 2020

koushikch7 commented Jan 23, 2020

magento-engcom-team commented Jan 23, 2020

magento-engcom-team commented Jan 23, 2020

magento-engcom-team commented Feb 21, 2020

koushikch7 commented Dec 10, 2019 •

edited

Loading