Problem Reading XML into Grid

[dchun71Participant]

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!

[DimitarParticipant]

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/

[Author]

Posts