This is a migrated thread and some comments may be shown as answers.

Viewing XML file with grid

2 Answers 19 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Andrew
Top achievements
Rank 1
Andrew asked on 15 Dec 2017, 12:51 AM

I'd like to browse through the attached XML file using a grid. Eventually, I will need to import data from a file like this into a database. I'm very new to hierarchical grids, so a strong clue in the right direction would be appreciated.

 

In case the attachment did not work, here's the contents:

<creditBureau xmlns="http://www.transunion.com/namespace" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.transunion.com/namespace">
<document>response</document>
<version>2.8</version>
<transactionControl>
<userRefNumber>20999</userRefNumber>
<subscriber>
<industryCode>Z</industryCode>
<memberCode>05633723</memberCode>
<inquirySubscriberPrefixCode>0622</inquirySubscriberPrefixCode>
</subscriber>
<options>
<country>us</country>
<language>en</language>
</options>
<tracking>
<transactionTimeStamp>2012-03-30T13:43:56.627-05:00</transactionTimeStamp>
</tracking>
</transactionControl>
<product>
<code>07000</code>
<subject>
<number>1</number>
<subjectRecord>
<fileNumber>01</fileNumber>
<consumerID>10506984FB5B</consumerID>
<fileSummary>
<fileHitIndicator>regularHit</fileHitIndicator>
<ssnMatchIndicator>exact</ssnMatchIndicator>
<consumerStatementIndicator>false</consumerStatementIndicator>
<market>32</market>
<submarket>QU</submarket>
<creditDataStatus>
<suppressed>false</suppressed>
<doNotPromote>
<indicator>false</indicator>
</doNotPromote>
<freeze>
<indicator>false</indicator>
</freeze>
<minor>false</minor>
<disputed>false</disputed>
</creditDataStatus>
<inFileSinceDate estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">1983-04-23</inFileSinceDate>
</fileSummary>
<indicative>
<name source="file">
<person>
<first>ZELNINO</first>
<middle>XX</middle>
<last>WINTER</last>
</person>
</name>
<name source="file">
<qualifier>alsoKnownAs</qualifier>
<person>
<unparsed>SUMMER</unparsed>
</person>
</name>
<address source="file">
<status>current</status>
<qualifier>personal</qualifier>
<street>
<number>760</number>
<name>SPROUL</name>
<preDirectional>W</preDirectional>
<type>RD</type>
</street>
<location>
<city>FANTASY ISLAND</city>
<state>IL</state>
<zipCode>60750</zipCode>
</location>
<dateReported estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2008-07-16</dateReported>
</address>
<address source="file">
<status>previous</status>
<qualifier>personal</qualifier>
<street>
<number>555</number>
<name>ADAMS</name>
<preDirectional>W</preDirectional>
<type>ST</type>
</street>
<location>
<city>CHICAGO</city>
<state>IL</state>
<zipCode>60661</zipCode>
</location>
<dateReported estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2003-06-24</dateReported>
</address>
<socialSecurity source="file">
<number>666125812</number>
</socialSecurity>
<dateOfBirth estimatedYear="false" estimatedMonth="false" estimatedCentury="false" source="file" estimatedDay="false">1966-08-01</dateOfBirth>
<employment source="file">
<employer>
<unparsed>AJILON</unparsed>
</employer>
<occupation>IT</occupation>
<dateHired estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2006-05-01</dateHired>
<dateOnFileSince estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-03-01</dateOnFileSince>
</employment>
<employment source="file">
<employer>
<unparsed>AJILON</unparsed>
</employer>
<occupation>IT</occupation>
<dateHired estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2006-05-01</dateHired>
<dateOnFileSince estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-03-01</dateOnFileSince>
</employment>
</indicative>
<consumerFileData>
<statement>
<text>NEVER SAY MOE THAN IS NECESSARY</text>
</statement>
</consumerFileData>
<custom>
<credit>
<trade>
<subscriber>
<industryCode>R</industryCode>
<memberCode>060LA001</memberCode>
<name>
<unparsed>MT W VLY MHP</unparsed>
</name>
</subscriber>
<portfolioType>open</portfolioType>
<accountNumber>88</accountNumber>
<ECOADesignator>individual</ECOADesignator>
<dateOpened estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2006-10-31</dateOpened>
<dateEffective estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-03-01</dateEffective>
<currentBalance>000001849</currentBalance>
<highCredit>000001849</highCredit>
<creditLimit>000002500</creditLimit>
<accountRating>09</accountRating>
<remark>
<code>PRL</code>
<type>affiliate</type>
</remark>
<pastDue>000001849</pastDue>
<paymentHistory>
<maxDelinquency>
<earliest>false</earliest>
</maxDelinquency>
</paymentHistory>
<updateMethod>locked</updateMethod>
</trade>
<trade>
<subscriber>
<industryCode>BZ</industryCode>
<memberCode>06613014</memberCode>
<name>
<unparsed>PNC BANK</unparsed>
</name>
</subscriber>
<portfolioType>installment</portfolioType>
<accountNumber>65005002</accountNumber>
<ECOADesignator>individual</ECOADesignator>
<dateOpened estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2009-09-24</dateOpened>
<dateEffective estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-03-01</dateEffective>
<currentBalance>000008677</currentBalance>
<highCredit>000009005</highCredit>
<accountRating>02</accountRating>
<terms>
<paymentFrequency>monthly</paymentFrequency>
<paymentScheduleMonthCount>60</paymentScheduleMonthCount>
<scheduledMonthlyPayment>000000333</scheduledMonthlyPayment>
</terms>
<paymentHistory>
<maxDelinquency>
<earliest>false</earliest>
</maxDelinquency>
<paymentPattern>
<startDate estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-02-01</startDate>
<text>21X11X111X11111X11111</text>
</paymentPattern>
<historicalCounters>
<monthsReviewedCount>21</monthsReviewedCount>
<late30DaysTotal>01</late30DaysTotal>
<late60DaysTotal>00</late60DaysTotal>
<late90DaysTotal>00</late90DaysTotal>
</historicalCounters>
</paymentHistory>
<updateMethod>manual</updateMethod>
</trade>
<trade>
<subscriber>
<industryCode>BM</industryCode>
<memberCode>0860V001</memberCode>
<name>
<unparsed>EQUICREDIT</unparsed>
</name>
</subscriber>
<portfolioType>mortgage</portfolioType>
<accountNumber>009985</accountNumber>
<ECOADesignator>jointContractLiability</ECOADesignator>
<dateOpened estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2005-11-08</dateOpened>
<dateEffective estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-03-01</dateEffective>
<currentBalance>000000100</currentBalance>
<highCredit>000000104</highCredit>
<accountRating>01</accountRating>
<terms>
<paymentFrequency>monthly</paymentFrequency>
<paymentScheduleMonthCount>168</paymentScheduleMonthCount>
<scheduledMonthlyPayment>000000967</scheduledMonthlyPayment>
</terms>
<account>
<type>CV</type>
</account>
<pastDue>000000000</pastDue>
<paymentHistory>
<maxDelinquency>
<earliest>false</earliest>
</maxDelinquency>
<paymentPattern>
<startDate estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-02-01</startDate>
<text>1111XXX111111111111X1111111111X1111111111111111</text>
</paymentPattern>
<historicalCounters>
<monthsReviewedCount>48</monthsReviewedCount>
<late30DaysTotal>00</late30DaysTotal>
<late60DaysTotal>00</late60DaysTotal>
<late90DaysTotal>00</late90DaysTotal>
</historicalCounters>
</paymentHistory>
<updateMethod>manual</updateMethod>
</trade>
<trade>
<subscriber>
<industryCode>BI</industryCode>
<memberCode>0728P546</memberCode>
<name>
<unparsed>MELLON BK-E</unparsed>
</name>
</subscriber>
<portfolioType>revolving</portfolioType>
<accountNumber>69</accountNumber>
<ECOADesignator>individual</ECOADesignator>
<dateOpened estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2003-08-04</dateOpened>
<dateEffective estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-03-01</dateEffective>
<currentBalance>000000657</currentBalance>
<highCredit>000001200</highCredit>
<creditLimit>000001500</creditLimit>
<accountRating>01</accountRating>
<pastDue>000000000</pastDue>
<paymentHistory>
<maxDelinquency>
<earliest>false</earliest>
</maxDelinquency>
<paymentPattern>
<startDate estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-02-01</startDate>
<text>111111111111111111111111111111111111111111111111</text>
</paymentPattern>
<historicalCounters>
<monthsReviewedCount>48</monthsReviewedCount>
<late30DaysTotal>00</late30DaysTotal>
<late60DaysTotal>00</late60DaysTotal>
<late90DaysTotal>00</late90DaysTotal>
</historicalCounters>
</paymentHistory>
<updateMethod>manual</updateMethod>
</trade>
<trade>
<subscriber>
<industryCode>BC</industryCode>
<memberCode>01597029</memberCode>
<name>
<unparsed>BK OF AMER</unparsed>
</name>
</subscriber>
<portfolioType>revolving</portfolioType>
<accountNumber>5674449044</accountNumber>
<ECOADesignator>individual</ECOADesignator>
<dateOpened estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2009-04-22</dateOpened>
<dateEffective estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-03-01</dateEffective>
<currentBalance>000000000</currentBalance>
<highCredit>000001005</highCredit>
<creditLimit>000002500</creditLimit>
<accountRating>01</accountRating>
<paymentHistory>
<maxDelinquency>
<earliest>false</earliest>
</maxDelinquency>
<paymentPattern>
<startDate estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-02-01</startDate>
<text>11111111111111111111111111111111</text>
</paymentPattern>
<historicalCounters>
<monthsReviewedCount>25</monthsReviewedCount>
<late30DaysTotal>00</late30DaysTotal>
<late60DaysTotal>00</late60DaysTotal>
<late90DaysTotal>00</late90DaysTotal>
</historicalCounters>
</paymentHistory>
<updateMethod>manual</updateMethod>
</trade>
<trade>
<subscriber>
<industryCode>VZ</industryCode>
<memberCode>01066024</memberCode>
<name>
<unparsed>CRESTAR BANK</unparsed>
</name>
</subscriber>
<portfolioType>installment</portfolioType>
<accountNumber>976771</accountNumber>
<ECOADesignator>individual</ECOADesignator>
<dateOpened estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2003-10-31</dateOpened>
<dateEffective estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2011-01-13</dateEffective>
<dateClosed estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2011-01-18</dateClosed>
<closedIndicator>normal</closedIndicator>
<currentBalance>000000000</currentBalance>
<highCredit>000002623</highCredit>
<accountRating>01</accountRating>
<remark>
<code>CLO</code>
<type>affiliate</type>
</remark>
<terms>
<paymentFrequency>monthly</paymentFrequency>
<paymentScheduleMonthCount>64</paymentScheduleMonthCount>
<scheduledMonthlyPayment>000000051</scheduledMonthlyPayment>
</terms>
<account>
<type>ST</type>
</account>
<pastDue>000000000</pastDue>
<paymentHistory>
<maxDelinquency>
<earliest>false</earliest>
</maxDelinquency>
<paymentPattern>
<startDate estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2010-12-13</startDate>
<text>XXXXXXXXXXXXXX111111111111111111</text>
</paymentPattern>
<historicalCounters>
<monthsReviewedCount>48</monthsReviewedCount>
<late30DaysTotal>00</late30DaysTotal>
<late60DaysTotal>00</late60DaysTotal>
<late90DaysTotal>00</late90DaysTotal>
</historicalCounters>
</paymentHistory>
<updateMethod>manual</updateMethod>
</trade>
<collection>
<subscriber>
<industryCode>Y</industryCode>
<memberCode>098MC001</memberCode>
<name>
<unparsed>RECOVERY SYS</unparsed>
</name>
</subscriber>
<portfolioType>open</portfolioType>
<accountNumber>19899</accountNumber>
<ECOADesignator>individual</ECOADesignator>
<dateOpened estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2010-05-07</dateOpened>
<dateEffective estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-03-01</dateEffective>
<currentBalance>000000293</currentBalance>
<original>
<creditGrantor>
<unparsed>MEDICAL</unparsed>
</creditGrantor>
<creditorClassification>medicalOrHealthCare</creditorClassification>
<balance>000000293</balance>
</original>
<pastDue>000000293</pastDue>
<accountRating>9B</accountRating>
<remark>
<code>CLA</code>
<type>affiliate</type>
</remark>
<updateMethod>locked</updateMethod>
</collection>
<publicRecord>
<type>PC</type>
<subscriber>
<industryCode>ZP</industryCode>
<memberCode>05048107</memberCode>
</subscriber>
<docketNumber>97000002040</docketNumber>
<attorney>N LEVI</attorney>
<plaintiff>FORD MOTOR CREDIT</plaintiff>
<dateReported estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2010-10-31</dateReported>
<dateFiled estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2010-10-31</dateFiled>
<datePaid estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2011-06-03</datePaid>
<liabilities>000000876</liabilities>
<ECOADesignator>individual</ECOADesignator>
<source>
<type>circuit</type>
</source>
</publicRecord>
<inquiry>
<ECOADesignator>individual</ECOADesignator>
<subscriber>
<industryCode>Z</industryCode>
<memberCode>05633723</memberCode>
<inquirySubscriberPrefixCode>06TR</inquirySubscriberPrefixCode>
<name>
<unparsed>TU INTERNAL</unparsed>
</name>
</subscriber>
<date estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-03-30</date>
</inquiry>
<inquiry>
<ECOADesignator>individual</ECOADesignator>
<subscriber>
<industryCode>B</industryCode>
<memberCode>02382255</memberCode>
<inquirySubscriberPrefixCode>40LO</inquirySubscriberPrefixCode>
<name>
<unparsed>HSBC</unparsed>
</name>
</subscriber>
<date estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-03-24</date>
</inquiry>
<inquiry>
<ECOADesignator>individual</ECOADesignator>
<subscriber>
<industryCode>X</industryCode>
<memberCode>00000102</memberCode>
<inquirySubscriberPrefixCode>06US</inquirySubscriberPrefixCode>
<name>
<unparsed>TEST SUBCODE</unparsed>
</name>
</subscriber>
<date estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2010-01-22</date>
</inquiry>
<inquiry>
<ECOADesignator>individual</ECOADesignator>
<subscriber>
<industryCode>X</industryCode>
<memberCode>00000102</memberCode>
<inquirySubscriberPrefixCode>06US</inquirySubscriberPrefixCode>
<name>
<unparsed>TEST SUBCODE</unparsed>
</name>
</subscriber>
<date estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2009-11-30</date>
</inquiry>
<inquiry>
<ECOADesignator>individual</ECOADesignator>
<subscriber>
<industryCode>X</industryCode>
<memberCode>00000102</memberCode>
<inquirySubscriberPrefixCode>06US</inquirySubscriberPrefixCode>
<name>
<unparsed>TEST SUBCODE</unparsed>
</name>
</subscriber>
<date estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2009-06-27</date>
</inquiry>
<inquiry>
<ECOADesignator>individual</ECOADesignator>
<subscriber>
<industryCode>X</industryCode>
<memberCode>00000102</memberCode>
<inquirySubscriberPrefixCode>06US</inquirySubscriberPrefixCode>
<name>
<unparsed>TEST SUBCODE</unparsed>
</name>
</subscriber>
<date estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2009-03-31</date>
</inquiry>
<creditSummary>
<revolvingAmount>
<percentAvailableCredit>084</percentAvailableCredit>
<highCredit>000002205</highCredit>
<creditLimit>000004000</creditLimit>
<currentBalance>000000657</currentBalance>
<pastDue>000000000</pastDue>
<monthlyPayment>000000000</monthlyPayment>
</revolvingAmount>
<installmentAmount>
<highCredit>000009005</highCredit>
<creditLimit>000000000</creditLimit>
<currentBalance>000008677</currentBalance>
<pastDue>000000000</pastDue>
<monthlyPayment>000000333</monthlyPayment>
</installmentAmount>
<mortgageAmount>
<highCredit>000000104</highCredit>
<creditLimit>000000000</creditLimit>
<currentBalance>000000100</currentBalance>
<pastDue>000000000</pastDue>
<monthlyPayment>000000967</monthlyPayment>
</mortgageAmount>
<openAmount>
<percentAvailableCredit>026</percentAvailableCredit>
<highCredit>000001849</highCredit>
<creditLimit>000002500</creditLimit>
<currentBalance>000001849</currentBalance>
<pastDue>000001849</pastDue>
<monthlyPayment>000000000</monthlyPayment>
</openAmount>
<totalAmount>
<highCredit>000013163</highCredit>
<creditLimit>000006500</creditLimit>
<currentBalance>000011283</currentBalance>
<pastDue>000001849</pastDue>
<monthlyPayment>000001300</monthlyPayment>
</totalAmount>
<recordCounts reportingPeriod="totalHistory">
<publicRecordCount>001</publicRecordCount>
<collectionCount>001</collectionCount>
<totalTradeCount>006</totalTradeCount>
<negativeTradeCount>002</negativeTradeCount>
<historicalNegativeTradeCount>001</historicalNegativeTradeCount>
<historicalNegativeOccurrencesCount>001</historicalNegativeOccurrencesCount>
<revolvingTradeCount>002</revolvingTradeCount>
<installmentTradeCount>002</installmentTradeCount>
<mortgageTradeCount>001</mortgageTradeCount>
<openTradeCount>001</openTradeCount>
<unspecifiedTradeCount>000</unspecifiedTradeCount>
<totalInquiryCount>006</totalInquiryCount>
</recordCounts>
</creditSummary>
</credit>
</custom>
<addOnProduct>
<code>06500</code>
<status>delivered</status>
<highRiskFraudAlert>
<inquiryHistory timeframe="90Days">
<messageCode>5501</messageCode>
<inquiryWithCurrentInputCount>018</inquiryWithCurrentInputCount>
<maxInquiryCount>01</maxInquiryCount>
</inquiryHistory>
<identificationIssuance source="input">
<type>ssn</type>
<alertMessageCode>5504</alertMessageCode>
<yearRange>
<startYear>2008</startYear>
<endYear>0000</endYear>
</yearRange>
<state>CT</state>
<ageObtained>
<rangeStart>+40</rangeStart>
<rangeEnd>+41</rangeEnd>
</ageObtained>
</identificationIssuance>
<identificationIssuance source="file">
<type>ssn</type>
<alertMessageCode>5504</alertMessageCode>
<yearRange>
<startYear>2008</startYear>
<endYear>0000</endYear>
</yearRange>
<state>CT</state>
<ageObtained>
<rangeStart>+41</rangeStart>
<rangeEnd>+42</rangeEnd>
</ageObtained>
</identificationIssuance>
</highRiskFraudAlert>
</addOnProduct>
<addOnProduct>
<code>00P02</code>
<status>delivered</status>
<scoreModel>
<score>
<results>+581</results>
<derogatoryAlert>false</derogatoryAlert>
<fileInquiriesImpactedScore>false</fileInquiriesImpactedScore>
<factors>
<factor>
<rank>1</rank>
<code>038</code>
</factor>
<factor>
<rank>2</rank>
<code>013</code>
</factor>
<factor>
<rank>3</rank>
<code>018</code>
</factor>
<factor>
<rank>4</rank>
<code>020</code>
</factor>
</factors>
</score>
</scoreModel>
</addOnProduct>
<addOnProduct>
<code>07014</code>
<status>defaultDelivered</status>
<authUserAlert searchStatus="clear"/>
</addOnProduct>
<addOnProduct>
<code>07013</code>
<status>defaultDelivered</status>
<armAlert searchStatus="noHit"/>
</addOnProduct>
</subjectRecord>
</subject>
</product>
</creditBureau>

 

2 Answers, 1 is accepted

Sort by
0
Accepted
Dess | Tech Support Engineer, Principal
Telerik team
answered on 15 Dec 2017, 08:07 AM
Hello, Andrew,

Thank you for writing.  

Binding to XML is not directly supported by RadGridView. However, DataTables are supported and a DataSet (containing DataTables) can be created from an XML document. Once, you have the data filled in DataTables, you can set up the grid hierarchy. The following help article is quite useful on this topic: 
https://docs.telerik.com/devtools/winforms/gridview/populating-with-data/bind-to-xml
https://docs.telerik.com/devtools/winforms/gridview/hierarchical-grid/binding-to-hierarchical-data-programmatically

I hope this information helps. Should you have further questions I would be glad to help.
 
Regards,
Dess
Progress Telerik
Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
0
Andrew
Top achievements
Rank 1
answered on 15 Dec 2017, 04:50 PM
Thanks. The second article looks like it's more relevant to my situation since this XML is complicated (at least for me).
Tags
GridView
Asked by
Andrew
Top achievements
Rank 1
Answers by
Dess | Tech Support Engineer, Principal
Telerik team
Andrew
Top achievements
Rank 1
Share this question
or