What's New?

[CLOSED] get grid data in xml format

  1. #1
    Dec 11, 2012, 6:59 PM

    [CLOSED] get grid data in xml format

    Last edited by Daniil; Dec 12, 2012 at 12:47 PM. Reason: [CLOSED]
  2. #2
    Dec 12, 2012, 12:42 AM
    Hello!

    Unfortunately, there is no default function to do this, but you can look at function recordToXML in the following example:

    <%@ Page Language="C#" %>

<%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %>

<script runat="server">
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!X.IsAjaxRequest)
        {
            this.Store1.DataSource = this.Data;
            this.Store1.DataBind();
        }
    }

    private object[] Data
    {
        get
        {
            return new object[]
            {
                new object[] { "3m Co", 71.72, 0.02, 0.03, "9/1 12:00am" },
                new object[] { "Alcoa Inc", 29.01, 0.42, 1.47, "9/1 12:00am" },
                new object[] { "Altria Group Inc", 83.81, 0.28, 0.34, "9/1 12:00am" },
                new object[] { "American Express Company", 52.55, 0.01, 0.02, "9/1 12:00am" },
                new object[] { "American International Group, Inc.", 64.13, 0.31, 0.49, "9/1 12:00am" },
                new object[] { "AT&T Inc.", 31.61, -0.48, -1.54, "9/1 12:00am" },
                new object[] { "Boeing Co.", 75.43, 0.53, 0.71, "9/1 12:00am" },
                new object[] { "Caterpillar Inc.", 67.27, 0.92, 1.39, "9/1 12:00am" },
                new object[] { "Citigroup, Inc.", 49.37, 0.02, 0.04, "9/1 12:00am" },
                new object[] { "E.I. du Pont de Nemours and Company", 40.48, 0.51, 1.28, "9/1 12:00am" },
                new object[] { "Exxon Mobil Corp", 68.1, -0.43, -0.64, "9/1 12:00am" },
                new object[] { "General Electric Company", 34.14, -0.08, -0.23, "9/1 12:00am" },
                new object[] { "General Motors Corporation", 30.27, 1.09, 3.74, "9/1 12:00am" },
                new object[] { "Hewlett-Packard Co.", 36.53, -0.03, -0.08, "9/1 12:00am" },
                new object[] { "Honeywell Intl Inc", 38.77, 0.05, 0.13, "9/1 12:00am" },
                new object[] { "Intel Corporation", 19.88, 0.31, 1.58, "9/1 12:00am" },
                new object[] { "International Business Machines", 81.41, 0.44, 0.54, "9/1 12:00am" },
                new object[] { "Johnson & Johnson", 64.72, 0.06, 0.09, "9/1 12:00am" },
                new object[] { "JP Morgan & Chase & Co", 45.73, 0.07, 0.15, "9/1 12:00am" },
                new object[] { "McDonald\"s Corporation", 36.76, 0.86, 2.40, "9/1 12:00am" },
                new object[] { "Merck & Co., Inc.", 40.96, 0.41, 1.01, "9/1 12:00am" },
                new object[] { "Microsoft Corporation", 25.84, 0.14, 0.54, "9/1 12:00am" },
                new object[] { "Pfizer Inc", 27.96, 0.4, 1.45, "9/1 12:00am" },
                new object[] { "The Coca-Cola Company", 45.07, 0.26, 0.58, "9/1 12:00am" },
                new object[] { "The Home Depot, Inc.", 34.64, 0.35, 1.02, "9/1 12:00am" },
                new object[] { "The Procter & Gamble Company", 61.91, 0.01, 0.02, "9/1 12:00am" },
                new object[] { "United Technologies Corporation", 63.26, 0.55, 0.88, "9/1 12:00am" },
                new object[] { "Verizon Communications", 35.57, 0.39, 1.11, "9/1 12:00am" },
                new object[] { "Wal-Mart Stores, Inc.", 45.45, 0.73, 1.63, "9/1 12:00am" }
            };
        }
    }
</script>

<!DOCTYPE html>

<html>
<head runat="server">
    <title>Simple Array Grid - Ext.NET Examples</title>
    <link href="/resources/css/examples.css" rel="stylesheet" />    

    <style>
        .x-grid-row-over .x-grid-cell-inner {
            font-weight : bold;
        }
    </style>

    <script>
        var template = '<span style="color:{0};">{1}</span>';

        var change = function (value) {
            return Ext.String.format(template, (value > 0) ? "green" : "red", value);
        };

        var pctChange = function (value) {
            return Ext.String.format(template, (value > 0) ? "green" : "red", value + "%");
        };
    </script>
    
    <script>
        function recordtoXML(data, root, encode) {
            var xml = [],
                i = 0,
                len = data.length,
                record = 'record',
                item,
                result,
                key;
            // may not exist
            xml.push('<?xml version="1.0" encoding="UTF-8"?>');
                
            if (root) {
                xml.push('<', root, '>');
            }
            
            for (; i < len; ++i) {
                item = data.getAt(i).data;
                xml.push('<', record, '>');
                for (key in item) {
                    if (item.hasOwnProperty(key)) {
                        xml.push('<', key, '>', item[key], '</', key, '>');
                    }
                }
                xml.push('</', record, '>');
            }
        
            if (root) {
                xml.push('</', root, '>');
            }
            
            var result = xml.join('');
            
            return encode === true ? Ext.encode('result') : result;
        }
    </script>
</head>
<body>
    <ext:ResourceManager runat="server" />
    
    <h1>Simple Array Grid</h1>
    
    <ext:GridPanel 
        ID="GridPanel1"
        runat="server" 
        Title="Array Grid" 
        Width="600" 
        Height="350">
        <Store>
            <ext:Store ID="Store1" runat="server">
                <Model>
                    <ext:Model runat="server">
                        <Fields>
                            <ext:ModelField Name="company" />
                            <ext:ModelField Name="price" Type="Float" />
                            <ext:ModelField Name="change" Type="Float" />
                            <ext:ModelField Name="pctChange" Type="Float" />
                            <ext:ModelField Name="lastChange" Type="Date" DateFormat="M/d hh:mmtt" />
                        </Fields>
                    </ext:Model>
                </Model>
            </ext:Store>
        </Store>
        <ColumnModel>
            <Columns>
                <ext:Column runat="server" Text="Company" DataIndex="company" Flex="1" />
                <ext:Column runat="server" Text="Price" DataIndex="price">                  
                    <Renderer Format="UsMoney" />
                </ext:Column>
                <ext:Column runat="server" Text="Change" DataIndex="change">
                    <Renderer Fn="change" />
                </ext:Column>
                <ext:Column runat="server" Text="Change" DataIndex="pctChange">
                    <Renderer Fn="pctChange" />
                </ext:Column>
                <ext:DateColumn runat="server" Text="Last Updated" DataIndex="lastChange" />
            </Columns>            
        </ColumnModel>       
        <SelectionModel>
            <ext:RowSelectionModel runat="server" />
        </SelectionModel>
        <Buttons>
            <ext:Button runat="server" Text="GetStoreRecordsInXml" OnClientClick="#{XmlTextArea}.setValue(recordtoXML(#{Store1}.data, 'root')); "></ext:Button>
        </Buttons>
    </ext:GridPanel>
    
    
    <ext:TextArea runat="server" ID="XmlTextArea" Width="600" Height="500"></ext:TextArea>
</body>
</html>
  3. #3
    Dec 12, 2012, 5:27 AM
    Hi all,

    Just to clarify: @Baidaly used (if I am not wrong) the XML writer's writeRecords function.
    http://docs.sencha.com/ext-js/4-1/#!...ata.writer.Xml

    Personally, I would reuse it this way (certainly, if it suites your needs).

    Example
    var data = App.GridPanel1.getStore().getAllRange();
    xmlWriter = Ext.create("Ext.data.writer.Xml", {
        header: "some header"
        /* other settings */
    }),
    xmlData = xmlWriter.writeRecords({}, data).xmlData;
    
alert(xmlData);
  4. #4
    Dec 12, 2012, 10:10 AM
  5. #5
    Dec 12, 2012, 11:56 AM
    Please replace:
    App.GridPanel1.getStore().getAllRange()
    with
    App.GridPanel1.getStore().getRecordsValues()
  6. #6
    Dec 12, 2012, 12:33 PM
    Works very fine!!!!

    Thanks a lot, Daniil!

Similar Threads

  1. Export grid panel data to excel with UI format
    By sumesh in forum 1.x Help
    Replies: 1
    Last Post: May 28, 2012, 5:17 AM
  2. Export Data from Grid Panel to XLS or other format using an AjaxRequest
    By tanky65 in forum 2.x Help
    Replies: 2
    Last Post: May 19, 2012, 9:09 AM
  3. [CLOSED] Assign Culture Format for a Double Data Type Property when Binding to Coolite Grid
    By speedstepmem3 in forum 1.x Legacy Premium Help
    Replies: 4
    Last Post: Nov 22, 2010, 12:54 PM
  4. [CLOSED] DateField data format problem
    By asztern in forum 1.x Legacy Premium Help
    Replies: 5
    Last Post: Oct 08, 2010, 9:36 PM
  5. How to Show Data In Decimal format in GridColumn
    By Dinesh.T in forum 1.x Help
    Replies: 0
    Last Post: Jun 11, 2010, 7:25 AM

Posting Permissions