How to parse XSD file with Python

Question

How can I parse the XSD below to get the 3 names inside

I would like to get the names "measures", "description", and "notes" and put each one in a column on the csv (no other information, just these 3 names to show up as headers for now).

I am trying to use lxml but I do not know how to go into the specific complexType tag that I want.

Below is the XSD file:




        
        
        
        
                
                        
                                This enumerates the types of pre-collector interfaces a helper class
                                will implement.
                        
                
                
                        
                        
                        
                
        
        
        
                
                        
                                This type defines the pattern for a allowed OM register name.
                        
                
                
                        
                        
                
        
        
        
                
                        
                                This type defines the pattern for a allowed class name.
                        
                
                
                        
                        
                
        

        
                
                        
                                This type defines the pattern for a allowed package name.
                        
                
                
                        
                        
                
        
        
        
                
                        
                                This type defines the pattern for a allowed OM group name.
                        
                
                
                        
                        
                        
                
        

        
            
                
                    
                        
                    
                
            
        

        
                
                    
                    
                
        

        
                
                        
                                This type defines the way that you define which NE types
                                will generate a given OM group.  It uses the NE base type
                                that we use for our engineering and configuration parameters.
                        
                
                
                        
                                
                        
                        
                
        
        
        
            
                
                
            
        

        
                
                        
                        
                        
                
                
        
        
        
                
                        
                
        
        
        
                
                        
                                
                        
                
        
        
        
                
                        
                
        
        
        
                
                        
                
        
        
        
                
        
        
        
                
                
        
        
        
                
                        
                                
                                        
                                        
                                        
                                
                        
                
        
        
        
        
        
        
        
        
        
        
                
                        
                        
                        
                
        
        
        
                
                        
                        
                        
                        
                        
                        
                                
                                
                                
                                
                        
                
        
        
        
                
                        
                        
                
        
        
        
                
                        
                        
                                
                                        
                                        
                                
                                
                                        
                                        
                                
                                
                                        
                                        
                                
                                
                                        
                                        
                                        
                                
                                
                                        
                                        
                                
                                
                                        
                                        
                                
                                
                                        
                                        
                                
                                
                                        
                                        
                                
                                
                                
                                
                                
                                
                                        
                                        
                                
                                
                                        
                                        
                                
                                
                                        
                                        
                                
                                
                                        
                                        
                                
                        
                        
                        
                
                
                
                    
                        
                            This attribute is set to true for those OM groups that measure
                            something that can only be counted on the active network element
                            instance.  Many call-related counts require this attribute to
                            be set to "true" to ensure that any averages are calculated
                            correctly.
                        
                    
                
        
        
        
                
                        
                                Each OM row class can belong to one and only one OM group.
                                That is more restrictive than the underlying framework, but
                                it would be difficult to impossible to make the documentation 
                                markup work since the meaning of the fields would change depending on 
                                the OM group to which the class belonged.

What I tried

from xml.etree import ElementTree
import csv


tree = ElementTree.parse('Omschema.xsd')

sitescope_data = open('Out.csv', 'w', newline='', encoding='utf-8')
csvwriter = csv.writer(sitescope_data)

#Create all needed columns here in order and writes them to excel file

def recurse(root):
    for child in root:
        recurse(child)
        print(child.tag)

    for event in root.findall('{http://www.w3.org/2001/XMLSchema}complexType'):
        event_data = []
        event_id = event.find('{http://www.w3.org/2001/XMLSchema}sequence')
        if event_id != None:
            event_id = event_id.text
        event_data.append(event_id)

        csvwriter.writerow(event_data)

root = tree.getroot()
recurse(root)
sitescope_data.close()

MendelG · Accepted Answer

Since you tagged BeautifulSoup, here's how to do it:

import csv
from bs4 import BeautifulSoup

soup = BeautifulSoup(your_xml, "xml")

tag_names = soup.find("xsd:complexType", {"name": "Register-Type"})

with open('data.csv', 'w') as f:
    headers = [tag['name'] for tag in tag_names.find_all("xsd:element")]
    writer = csv.DictWriter(f, fieldnames=headers)
    writer.writeheader()

data.csv:

measures,description,notes

How to parse XSD file with Python

Answers (1)

Related Questions