Exporting Grid with Dropdowns only displays values

QuestionsExporting Grid with Dropdowns only displays values
Greg asked 9 years ago

Hi,

I was wondering if there was an update on this issue?

https://phpgrid.desk.com/customer/portal/questions/6066686-export-excel-for-content-filtered-by-dropdown

I have a grid that uses the drop-downs to make it easier for people to select values that translate to IDs behind the scenes. However, when we do the export, it does not use the client facing name but the back-end Id. Is there a way to override this in the export?

Thank you – Greg.

3 Answers
Abu Ghufran answered 9 years ago

I guess the solution is mentioned in this ticket.
More details here:

Code: http://phpgrid.org/demo/demos/export/export-excel.phps
Demo: http://phpgrid.org/demo/demos/export/export-excel.php

Michiel Blotwijk answered 5 years ago

Hi Abu,

I’m running into this same issue and your demo is not solving it either. If I export the data from your demo, column “B” (client) is empty where the actual names should be. Is there a way to solve this? I guess we could create a custom export, but I’m not sure how a filtered export would work then.

Your advice will be appreciated.

regards,
Michiel

Abu Ghufran Staff answered 5 years ago

Hello,

In latest build, it is fixed. However if you are using old version you can use this process:

https://www.phpgrid.org/demo/demos/appearance/dropdown.phps

Line 57 uses dropdown column which is not exportable.

Line 75 uses another text column which is hidden but exportable.

Demo: https://www.phpgrid.org/demo/demos/appearance/dropdown.php

_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework
 
Your Answer

6 + 18 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?