Kendo UI Grid XML showing data as [object Object]

[Ghazi]

Hi
I have a Kendo UI grid, that will only display values like [object object]. I have the datasource for the grid working so I know there is data.

This is my code 

var ds = new kendo.data.DataSource({
        transport: {
            read: {
                url: dataUrl + "data_xml.p",
                contentType: "text/xml",
                method: "POST",
                processData: false,
                dataType: "xml",
            },
            parameterMap: function() {
                return formxml;
            }
        },
        schema: {
            data: "/ProDataSet/ttCustomers",
            type: "xml"
        },
        model: {

            id: "id",

            fields: {

                first_name: "first_name/text()",

                last_name: "last_name/text()",

                email: "email/text()",


                num_tel: "num_tel/text()",


                adresse: "adresse/text()",
            }
        }

    });

 

Data from server : 

<ProDataSet xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <tt_action>
      <sessionId />
      <action>getdata</action>
      <vstatus>0</vstatus>
      <vmsg />
      <field1 />
      <field2 />
      <field3 />
      <field4 />
   </tt_action>
   <ttCustomers>
      <id>4</id>
      <first_name>Aguistin</first_name>
      <last_name>Scoles</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>8 Elgar Park</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>5</id>
      <first_name>Jada</first_name>
      <last_name>Brigg</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>6011 Birchwood Point</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>7</id>
      <first_name>Corenda</first_name>
      <last_name>Bulleyn</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>159 Sycamore Hill</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>8</id>
      <first_name>Nadeen</first_name>
      <last_name>Birkin</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>6600 Manitowish Drive</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>9</id>
      <first_name>Cassy</first_name>
      <last_name>Wickerson</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>823 Rockefeller Alley</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>10</id>
      <first_name>Dene</first_name>
      <last_name>Palk</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>2053 Kennedy Center</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>11</id>
      <first_name>Garreth</first_name>
      <last_name>Clayal</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>2243 Manitowish Plaza</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>13</id>
      <first_name>Witty</first_name>
      <last_name>Kilgour</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>95 Sage Way</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>14</id>
      <first_name>Abbey</first_name>
      <last_name>Banaszczyk</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>97 Fieldstone Alley</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>15</id>
      <first_name>Byrom</first_name>
      <last_name>Beachamp</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>83369 Golf Drive</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>16</id>
      <first_name>Reeva</first_name>
      <last_name>Moresby</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>5 Sachtjen Parkway</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>17</id>
      <first_name>Hadlee</first_name>
      <last_name>Klisch</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>56 Elka Street</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>18</id>
      <first_name>Marie</first_name>
      <last_name>Mustoo</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>7016 Hovde Circle</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>20</id>
      <first_name>Georgeanne</first_name>
      <last_name>Zecchii</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>10799 Londonderry Drive</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>21</id>
      <first_name>Norah</first_name>
      <last_name>Levane</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>20976 Hanover Alley</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>22</id>
      <first_name>Timi</first_name>
      <last_name>Abramson</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>461 Bellgrove Way</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>23</id>
      <first_name>Kirsten</first_name>
      <last_name>Hearnden</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>0 Melvin Trail</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>24</id>
      <first_name>Tommie</first_name>
      <last_name>Haggarty</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>76 Parkside Parkway</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>25</id>
      <first_name>Orella</first_name>
      <last_name>Gossan</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>0 Blue Bill Park Parkway</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>26</id>
      <first_name>Melly</first_name>
      <last_name>Loidl</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>59541 Forest Hill</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>28</id>
      <first_name>Yettie</first_name>
      <last_name>Petranek</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>3 Montana Avenue</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>29</id>
      <first_name>Natal</first_name>
      <last_name>Bauman</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>03252 Division Plaza</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>30</id>
      <first_name>Joela</first_name>
      <last_name>Bendon</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>056 Caliangt Hill</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>31</id>
      <first_name>Timothy</first_name>
      <last_name>Antonsen</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>3 Tennessee Trail</adresse>
   </ttCustomers>
   <ttCustomers>
      <id>32</id>
      <first_name>Joye</first_name>
      <last_name>Bourgeois</last_name>
      <email>[e-mail]</email>
      <num_tel>[phone]</num_tel>
      <adresse>14377 Spenser Crossing</adresse>
   </ttCustomers>
</ProDataSet>

 

Grid code :

 

$('#customers-list').kendoGrid({
          dataSource: ds,
          toolbar: ["create", "save", "excel"],
          excel: {
              fileName: "Export.xlsx"
          },
          sortable: true,
          columns: [{
              field: "first_name",
              title: "Nom",
          }, {
              field: "last_name",
              title: "Prénom"
          }, {
              field: "email",
              title: "Adresse Email",
          }, {
              field: "num_tel",
              title: "Numéro de téléphone"
          }, {
              field: "adresse",
              title: "Adresse"
          }, {
              command: ["edit", "destroy"],
              title: " ",
              width: "300px"
          }],
          editable: "popup",
          pageable: {
              pageSize: 5,
          }
      });

[Tsvetina]

Hi Ghazi,

Your code is overall correct with one minor exception causing the problem. The model is defined outside of the schema configuration, so it is like there is no model definition at all. Just move the model inside the schema and the columns will populate correctly:

var ds = new kendo.data.DataSource({
        transport: {
            read: {
                url: dataUrl + "data_xml.p",
                contentType: "text/xml",
                method: "POST",
                processData: false,
                dataType: "xml",
            },
            parameterMap: function() {
                return formxml;
            }
        },
        schema: {
            data: "/ProDataSet/ttCustomers",
            type: "xml",
            model: {
                id: "id",
                fields: {
                    first_name: "first_name/text()",
                    last_name: "last_name/text()",
                    email: "email/text()",
                    num_tel: "num_tel/text()",
                    adresse: "adresse/text()",
                }
            }
        }

    });

Regards,
Tsvetina
Progress Telerik

[Ghazi]

Hi Tsvetina

It's working fine now, Thanks!