jQuery UI Widgets Forums Grid Problem Reading XML into Grid

This topic contains 1 reply, has 2 voices, and was last updated by  Dimitar 8 years, 9 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • Problem Reading XML into Grid #74378

    dchun71
    Participant

    I’m trying to read the following xml into a grid.

    <MyRios xmlns=””>
    <RequestStatus>
    <TimeStamp>7/30/2015 1:32:20 PM</TimeStamp>
    <AuthStatus>Approved</AuthStatus>
    <ErrorMsg xsi:nil=”true” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” />
    </RequestStatus>
    <RioRequestParams>
    <BemsId>1374007</BemsId>
    <ProgramIds>144</ProgramIds>
    <AccessMethod>Internal</AccessMethod>
    <Filters>
    <Modes />
    <Phases>Candidate, Open, Open – In Planning, Open – Baselined</Phases>
    <Archived>false</Archived>
    </Filters>
    </RioRequestParams>
    <TotalCount>86</TotalCount>
    <RioList>
    <RioData>
    <MyAccess>Administrator,Owner,Read</MyAccess>
    <RioId>6586</RioId>
    <RioType>I</RioType>
    <RioNo>1</RioNo>
    <AltRioNo>I1</AltRioNo>
    <Title>Reports working for all & modes 2 33</Title>
    <Owners>Ngo, Dylan C</Owners>
    <Phase>Open</Phase>
    <RespTeam>Fine&Dandy</RespTeam>
    <PlanStatus>Red</PlanStatus>
    <CurrentLevel>1 L</CurrentLevel>
    <CurrentLevelColor>#FFFF00</CurrentLevelColor>
    <ConsequenceCategory>1G,2C,3T</ConsequenceCategory>
    <NextOpenItemDate>2014-11-20</NextOpenItemDate>
    <FinData>Y</FinData>
    <Organization>Sprint 2014-4</Organization>
    <SharedFromOtherOrg>N</SharedFromOtherOrg>
    <ModifiedDate>2015-07-08</ModifiedDate>
    <RioUrl>https://borisdev.web.boeing.com/newboris/default.aspx?rid=6586</RioUrl&gt;
    <UfText1>Test Field save</UfText1>
    <UfValue1>last, test, test2, test3</UfValue1>
    <UfText2>Testing 1234</UfText2>
    <UfValue2 />
    <UfText3>Multi Select Dropdown</UfText3>
    <UfValue3>Fine &amp; Dandy, last</UfValue3>
    <UfText4>Only Issue Yes</UfText4>
    <UfValue4 />
    <UfText5>Single Select Hierarchy</UfText5>
    <UfValue5>AAA, BBB, CCC, last</UfValue5>
    <UfText6>hiearchical field testing</UfText6>
    <UfValue6>aaaaaaaaaaaaaaaaaaaaaaaaaaaaaa, first, I love to add values, last, test, this is my really long value a</UfValue6>
    <UfText7>123456789 123456789 123456789 123456789 123456789 </UfText7>
    <UfValue7 />
    </RioData>
    </RioList>
    </MyRios>

    My code looks as such:
    var source =
    {
    datatype: “xml”,
    datafields: [
    { name: ‘Phase’, type: ‘string’ },
    ],
    //id: ‘RioId’,
    root: “MyRios”,
    record: “RioData”,
    localdata: config,
    pager: function (pagenum, pagesize, oldpagenum) {
    // callback called when a page or page size is changed.
    }
    };

    var dataAdapter = new $.jqx.dataAdapter(source, {
    contentType: ‘application/xml; charset=utf-8’,
    loadComplete: function () {
    alert(“Data loaded successfully.”);
    }
    });

    Any ideas as what I’m doing wrong? Any help would be greatly appreciated!

    Problem Reading XML into Grid #74407

    Dimitar
    Participant

    Hello dchun71,

    Your XML contains several syntax errors – ampersands have to be escaped as & amp; and the & gt; on line 38 has to be a >. Note that escape sequences are written without an interval (but the forum would automatically convert them to & and > without one).

    Best Regards,
    Dimitar

    jQWidgets team
    http://www.jqwidgets.com/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.