export data (odata)

Question

I'm using the datamanager with the odatav4adaptor and a remote odata-webservice.

this.data = new ej.DataManager({
url: "http://odataserver/data",
crossDomain: true,
adaptor: new ej.ODataV4Adaptor,
});

When trying to export the data in the grid there is a call grid.export('/api/export/ExcelExport') to my export-webservice for exporting to Excelfile.

The problem is when the export-call arrives at the export-webservice the known parameter "gridModel" has no properties whichcan be usedto export the data (see below) .

My preferred solution is to get the odata-url from the datamanger, including the odata-parameters for select, expand, filter, orderby, top, skip, etc. (actually the full odata-url the datamanger has send to the odata-service). Is that possible? Or is there another solution for this?

Manivannan Padmanaban · Answer

Hi Sietse, We have analyzed your query and we are able to understand that you need to perform the exporting with the with the odatav4adaptor. We have achieved your requirement by extend the OData adaptor please refer the below code example,

Controller Page: [System.Web.Http.AcceptVerbs("Post")] [ODataRoute("/ExcelExport")] public void ExcelExport() { GridExcelExport GridExp = new GridExcelExport(); string gridModel = HttpContext.Current.Request.Params["GridModel"]; GridProperties gridProperty = ConvertGridObject(gridModel); ExcelExport exp = new ExcelExport(); IEnumerable result = db.Orders.Take(100).ToList(); GridExp.Theme = "default-theme"; GridExp.FileName = "Export.xlsx"; exp.Export(gridProperty, result, GridExp); } [System.Web.Http.AcceptVerbs("Post")] [ODataRoute("/PdfExport")] public void PdfExport() { GridPdfExport GridExp = new GridPdfExport(); string gridModel = HttpContext.Current.Request.Params["GridModel"]; GridProperties gridProperty = ConvertGridObject(gridModel); PdfExport exp = new PdfExport(); IEnumerable result = db.Orders.Take(100).ToList(); GridExp.Theme = "default-theme"; GridExp.FileName = "Export.pdf"; exp.Export(gridProperty, result, GridExp); } [System.Web.Http.AcceptVerbs("Post")] [ODataRoute("/WordExport")] public void WordExport() { GridWordExport GridExp = new GridWordExport(); string gridModel = HttpContext.Current.Request.Params["GridModel"]; GridProperties gridPropert = ConvertGridObject(gridModel); WordExport exp = new WordExport(); IEnumerable data = db.Orders.Take(100).ToList(); GridExp.Theme = "default-theme"; GridExp.FileName = "Export.docx"; exp.Export(gridPropert, (IEnumerable)data, GridExp); } private GridProperties ConvertGridObject(string gridProperty) { JavaScriptSerializer serializer = new JavaScriptSerializer(); IEnumerable div = (IEnumerable)serializer.Deserialize(gridProperty, typeof(IEnumerable)); GridProperties gridProp = new GridProperties(); foreach (KeyValuePair ds in div) { var property = gridProp.GetType().GetProperty(ds.Key, BindingFlags.Instance | BindingFlags.Public | BindingFlags.IgnoreCase); ……… value = serializer.Deserialize(serialize, type); property.SetValue(gridProp, value, null); } } return gridProp; } Please get back to us if you need any other information. Regards, Manivannan Padmanaban.

Sietse Wielenga · Answer

HiI already used the example, but the example-code in method ExcelExport takes some 100 records from the database, not exactly the data which is shown in the grid.So, how do I get in method ExcelExport exactly the data which is shown in the grid?Or is it possible to get the full odata-url (including $select, $filter, etc.) which is used in the datamanager?[System.Web.Http.AcceptVerbs("Post")] [ODataRoute("/ExcelExport")] public void ExcelExport()         {             GridExcelExport GridExp = new GridExcelExport();             string gridModel = HttpContext.Current.Request.Params["GridModel"];             GridProperties gridProperty = ConvertGridObject(gridModel);             ExcelExport exp = new ExcelExport();             IEnumerable<Order> result = db.Orders.Take(100).ToList();            GridExp.Theme = "default-theme";             GridExp.FileName = "Export.xlsx";             exp.Export(gridProperty, result, GridExp);         }

Renjith Singh Rajendran · Answer

Hi Sietse,

Thanks for contacting Syncfusion support.

We have analyzed your query and we found that you are trying to pass the data to server when exporting. You can get the data that is bound to the Grid using the Grid model and export them as shown in the following code example. In the Load event, we have spliced the dataSource from the ignoreOnExport array, which will include the dataSource on the Grid model while Exporting and it can be used for exporting the Grid as server end.

Note: Please use load event to splice the dataSource

Please refer the below code example.

<script>





    function load(args) {

        this.ignoreOnExport.splice(this.ignoreOnExport.indexOf('dataSource'), 1);

    }

</script>

public class HomeController : Controller

    {

        IEnumerable<EditableOrder> currentData = null;

...

    public void ExportToExcel(string GridModel)

        {

            ExcelExport exp = new ExcelExport();

            GridProperties obj = ConvertGridObject(GridModel);

            exp.Export(obj, currentData, "Export.xlsx", ExcelVersion.Excel2010, false, false, "flat-saffron");

        }

        ...



        private GridProperties ConvertGridObject(string gridProperty)

        {

            JavaScriptSerializer serializer = new JavaScriptSerializer();

            IEnumerable div = (IEnumerable)serializer.Deserialize(gridProperty, typeof(IEnumerable));

            GridProperties gridProp = new GridProperties();

            foreach (KeyValuePair<string, object> ds in div)

            {

                //Check and retrieve additional property here

                if (ds.Key == "dataSource")

                {

                    foreach (KeyValuePair<string, object> data in (dynamic)ds.Value)

                    {

                        if (data.Key == "dataSource")

                        {

                            foreach (KeyValuePair<string, object> data1 in (dynamic)data.Value)

                            {

                                if (data1.Key == "json")

                                {

                                    string serial = serializer.Serialize(data1.Value);

                                    currentData = JsonConvert.DeserializeObject<IEnumerable<EditableOrder>>(serial);

                                    break;

                                }

                            }

                        }

                    }

                }

...

            return gridProp;

        }

Refer the documentation link.

Load event link: https://help.syncfusion.com/api/js/ejgrid#events:load

https://help.syncfusion.com/aspnetmvc/grid/exporting#list-of-properties-ignored-on-export

Please make a note that this solution works only for the local data. We have discussed about this in the following Help Document.

https://help.syncfusion.com/aspnetmvc/grid/exporting#local-data

Please let us know if you need further assistance.

Regards,

Renjith Singh Rajendran.

Thanks for the information

Sietse Wielenga · Answer

Hi,Thank you for the explanation, but it does not met my needs because I don't want to use local data.For getting the export data I would prefer using the full odata url (including $select, $filter and $orderby) which is used by the datamanager to retrieve the data in the grid.So I figured out how to retrieve the full odata url from the odataadaptor and now I can pass it to the export-method.export class BaseGridComponent implements OnInit {private dataUrl: string = "";ngOnInit(): void {        this.customAdaptor = new CustomOdataAdaptor();
this.customAdaptor.urlChanged = ((url: string) => {
this.dataUrl = url;
});var dm = new ej.DataManager({            url: http://server/odata/entity,            crossDomain: true,            headers: [{ 'Accept': 'application/json' }, { 'Content-Type': 'application/json' }],            adaptor: this.customAdaptor});}toolbarClick(args: any): void {        if (args.itemName == "Export") {
grid.export('/api/export/ExcelExport?odataurl=' + encodeURI(this.dataUrl));
args.cancel = true;}}}class CustomOdataAdaptor extends ej.ODataV4Adaptor {
    constructor() {
        super();
    }

urlChanged: (url: string) => void;
beforeSend(dm, request, settings): void {
this.urlChanged(settings.url);
        super.beforeSend(dm, request, settings);
    }

processQuery(ds, query) {
        return super.processQuery(ds, query);
    }

processResponse(data, ds, query, xhr, request, changes) {
this.urlChanged(request.url);
        return super.processResponse(data, ds, query, xhr, request, changes);
    }
}

Renjith Singh Rajendran · Answer

Hi Sietse, 
 
Thanks for the update. 
 
We are glad that you had to achieved your requirement. 
 
Please get back to us if you need further assistance. 
 
Regards, 
Renjith Singh Rajendran

shekhar parate · Answer

Hi Sietse,

Thanks for contacting Syncfusion support.

We have analyzed your query and we found that you are trying to pass the data to server when exporting. You can get the data that is bound to the Grid using the Grid model and export them as shown in the following code example. In the Load event, we have spliced the dataSource from the ignoreOnExport array, which will include the dataSource on the Grid model while Exporting and it can be used for exporting the Grid as server end.

Note: Please use load event to splice the dataSource

Please refer the below code example.

<script>





    function load(args) {

        this.ignoreOnExport.splice(this.ignoreOnExport.indexOf('dataSource'), 1);

    }

</script>

public class HomeController : Controller

    {

        IEnumerable<EditableOrder> currentData = null;

...

    public void ExportToExcel(string GridModel)

        {

            ExcelExport exp = new ExcelExport();

            GridProperties obj = ConvertGridObject(GridModel);

            exp.Export(obj, currentData, "Export.xlsx", ExcelVersion.Excel2010, false, false, "flat-saffron");

        }

        ...



        private GridProperties ConvertGridObject(string gridProperty)

        {

            JavaScriptSerializer serializer = new JavaScriptSerializer();

            IEnumerable div = (IEnumerable)serializer.Deserialize(gridProperty, typeof(IEnumerable));

            GridProperties gridProp = new GridProperties();

            foreach (KeyValuePair<string, object> ds in div)

            {

                //Check and retrieve additional property here

                if (ds.Key == "dataSource")

                {

                    foreach (KeyValuePair<string, object> data in (dynamic)ds.Value)

                    {

                        if (data.Key == "dataSource")

                        {

                            foreach (KeyValuePair<string, object> data1 in (dynamic)data.Value)

                            {

                                if (data1.Key == "json")

                                {

                                    string serial = serializer.Serialize(data1.Value);

                                    currentData = JsonConvert.DeserializeObject<IEnumerable<EditableOrder>>(serial);

                                    break;

                                }

                            }

                        }

                    }

                }

...

            return gridProp;

        }

Refer the documentation link.

Load event link: https://help.syncfusion.com/api/js/ejgrid#events:load

https://help.syncfusion.com/aspnetmvc/grid/exporting#list-of-properties-ignored-on-export

Please make a note that this solution works only for the local data. We have discussed about this in the following Help Document.

https://help.syncfusion.com/aspnetmvc/grid/exporting#local-data

Please let us know if you need further assistance.

Regards,

Renjith Singh Rajendran.

Thanks for the information

Farveen Sulthana Thameeztheen Basha · Answer

Hi Shekhar, 

Thanks for your update. Please get back to us if you need any further assistance. 

Regards, 

Farveen sulthana T