BLACKLIST XML -- parser is in python code.
<row>
<B>
<BlackListBulkSearch>
<SerialNumber>123</SerialNumber>
<Item>
<BlackListStatus>YES</BlackListStatus>
<BlackListNo>10</BlackListNo>
<BlackListedDate>2046-11-21</BlackListedDate>
<Name>HETAUDA LEATHER INDUSTRIES</Name>
<FatherName>NULL</FatherName>
<CitizenshipNo>NULL</CitizenshipNo>
<CitizenshipIssuedDate>NULL</CitizenshipIssuedDate>
<CitizenshipIssuedDistrict>NULL</CitizenshipIssuedDistrict>
<PanNo>NULL</PanNo>
<CompanyRegNo>002-2701-8-1</CompanyRegNo>
<ConsumerDOB>NULL</ConsumerDOB>
<CompanyRegDate>1999-12-31</CompanyRegDate>
<CompanyRegAuth>Office Of Company Registrar</CompanyRegAuth>
<PassportNo>NULL</PassportNo>
<IndianEmbassyNo>NULL</IndianEmbassyNo>
</Item>
<Item>
<BlackListStatus>YES</BlackListStatus>
<BlackListNo>10</BlackListNo>
<BlackListedDate>2046-11-21</BlackListedDate>
<Name>BANSBARI LEATHER AND SHOE FACTORY</Name>
<FatherName>NULL</FatherName>
<CitizenshipNo>NULL</CitizenshipNo>
<CitizenshipIssuedDate>NULL</CitizenshipIssuedDate>
<CitizenshipIssuedDistrict>NULL</CitizenshipIssuedDistrict>
<PanNo>NULL</PanNo>
<CompanyRegNo>002-2701-8-1-2</CompanyRegNo>
<ConsumerDOB>NULL</ConsumerDOB>
<CompanyRegDate>1999-12-31</CompanyRegDate>
<CompanyRegAuth>Office Of Company Registrar</CompanyRegAuth>
<PassportNo>NULL</PassportNo>
<IndianEmbassyNo>NULL</IndianEmbassyNo>
</Item>
<Item>
<BlackListStatus>YES</BlackListStatus>
<BlackListNo>20</BlackListNo>
<BlackListedDate>2047-01-03</BlackListedDate>
<Name>BIDHYA DEVI BHATTARAI</Name>
<FatherName>NA</FatherName>
<CitizenshipNo>002-3401-2-1-1</CitizenshipNo>
<CitizenshipIssuedDate>2010-01-01</CitizenshipIssuedDate>
<CitizenshipIssuedDistrict>Kathmandu</CitizenshipIssuedDistrict>
<PanNo>NULL</PanNo>
<CompanyRegNo>NULL</CompanyRegNo>
<ConsumerDOB>1999-12-31</ConsumerDOB>
<CompanyRegDate>NULL</CompanyRegDate>
<CompanyRegAuth>NULL</CompanyRegAuth>
<PassportNo>NULL</PassportNo>
<IndianEmbassyNo>NULL</IndianEmbassyNo>
</Item>
</BlackListBulkSearch>
</B>
</row>
import xml.etree.ElementTree as ET
data= '''
<BlackListBulkSearch>
<SerialNumber>123</SerialNumber>
<Item>
<BlackListStatus>YES</BlackListStatus>
<BlackListNo>10</BlackListNo>
</Item>
<Item>
<BlackListStatus>YES</BlackListStatus>
<BlackListNo>500</BlackListNo>
</Item>
</BlackListBulkSearch>'''
myroot = ET.fromstring(data)
print(myroot.tag)
#print(myroot[0].tag) #denotes first child
#print(myroot[0].attrib) #attrib are present as dictionary
#for x in myroot[0]:
#print(x.tag,x.attrib)
#for x in myroot[0]:
#print(x.text)
for x in myroot.findall('Item'):
item =x.find('BlackListStatus').text
froms =x.find('BlackListNo').text
print(item,froms)
Comments
Post a Comment