We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Issue in export - exports Key and not the Value

Thread ID:

Created:

Updated:

Platform:

Replies:

127504 Nov 20,2016 05:45 AM Nov 24,2016 12:15 AM ASP.NET MVC 7
loading
Tags: Grid
Haneef Puttur
Asked On November 20, 2016 05:45 AM

Hi,

I have a dropdown column in my grid it works fine for edit.

ViewBag.genderdata = 

(value) B : (text)Boys
(value) G : (text)Girls
(value) A : (text)All

It displays Fine in Grid
When i save it saves the required Key in Database 

When I export to excel , it exports the Key and not the actual Values associated with it.

When I exported the grid , It shows  B in the exported column, actually I want to see : Boys

############# My column data
 col.Field(p => p.EXSCHD_GENDER).HeaderText("Gender").TextAlign(TextAlign.Left).ForeignKeyField("value").ForeignKeyValue("text").EditType(EditingType.Dropdown).DataSource((List<UGApps.Models.list_item>)ViewBag.genderdata).AllowEditing(true).Add();


#########

Thanks in advance for your great help.
Regards

Haneef Puttur


Jayaprakash Kamaraj [Syncfusion]
Replied On November 21, 2016 06:12 AM

Hi Haneef, 
 
Thank you for contacting Syncfusion support. 
 
We were unable to reproduce the issue at our end. Please share the following information to find the cause of the issue.    
                                                                                                                
1.     Did you face the issue in initial rendering or any actions performed in Grid?    
2.     Share the video/screenshot to show the issue  
3.     Issue replication procedure.   
4.     Essential studio and browser details.  
5.     If possible, provide an issue reproducing sample or replicate the issue in the following sample.   
 
 
Regards, 
 
Jayaprakash K. 


Haneef Puttur
Replied On November 21, 2016 06:33 AM

Hi,

I tried the sample you sent with no changes.
When I click the export to excel option the employee Name column is showing the ID in the exported file , however in the grid view it properly displays the Employee name.
I have not made any changes to the sample file you have sent..  I have just referenced the following lines in web config to my version
  <assemblies>
                <!--<add assembly="Syncfusion.EJ, Version=14.4450.0.15, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />-->
                <add assembly="Syncfusion.EJ, Version=14.3450.0.52, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
                   <!--<add assembly="Syncfusion.EJ.Mvc, Version=14.4500.0.15, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />-->
        <add assembly="Syncfusion.EJ.MVC, Version=14.3500.0.52, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
      </assemblies>

Please compare the screenshot which shows grid and exported version ... so you will understand the issue better.

Regards

Haneef Puttur


Attachment: issue_e1bfa496.zip

Jayaprakash Kamaraj [Syncfusion]
Replied On November 22, 2016 07:57 AM

Hi Haneef, 
 
We were unable to reproduce the issue at our end. Please refer to the below video. 
 
 
Please share the following information to find the cause of the issue.    
                                                                                                              
1.     Did you get any custom patch for any other issue ? If, yes please provide the details. 
2.     browser details.  
 
Regards, 
 
Jayaprakash K. 


Haneef Puttur
Replied On November 23, 2016 12:21 AM

Dear Sir,

Seems you have attached wrong file. Instead of video you have attached the JS files. Even I tried with replacing the files of those attachement still the same issue persists.

To make it more clear here is my actual problem.

If there is a dropdown listbox in grid , the exported view and grid view looks different.
Grid View : Shows the Values of Listbox and Exported Data shows the key value of the listbox.

I am just using the test solution you have sent and not my codes. I face the same problem in my code as well in the solution you have sent.

If you want to have a look of the issue live i can give a session , you can PM me for access details of my pc.

Thanks for all your time and understanding.

Regards

Haneef Puttur


Jayaprakash Kamaraj [Syncfusion]
Replied On November 23, 2016 04:33 AM

Hi Haneef, 
 
A support incident has been created under your account to resolve the issue. Please log on to our support website to check for further updates.  
 
Regards, 

Jayaprakash K.
 


Haneef Puttur
Replied On November 23, 2016 05:41 AM

Thanks for your support and my issue is resolved.

Regards

Haneef Puttur

Jayaprakash Kamaraj [Syncfusion]
Replied On November 24, 2016 12:15 AM

Hi Haneef,  
 
We are happy that the problem has been solved. 
 
Please get back to us if you need any further assistance.   
 
Regards,  
 
Jayaprakash K. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;