Databases
StackOverflow2013
Postsdbo
POReturn XML Values from Multiple Files in Python?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POReturn XML Values from Multiple Files in Python?
    primarykey
    data
    text
    <p>So I am working on a browser based program, written in Python, that parses XML data from multiple files in a directory, then returns the values of certain XML tags on the page. I have successfully been able to return the values from one of the XML files, but am hoping to collect data from every file within the directory and return the values in spreadsheet format. How do I parse the data from every XML file? Also, the XML files are not static, there will be new files coming and going. Thanks! Below is my code:</p> <pre><code>from xml.dom.minidom import parseString import os path = 'C:\Vestigo\XML' listing = os.listdir(path) for infile in listing: print infile file = open(os.path.join(path,infile),'r') data = file.read() file.close() dom = parseString(data) xmlTag0 = dom.getElementsByTagName('Extrinsic')[0].toxml() xmlData0 = xmlTag0.replace('&lt;Extrinsic&gt;','').replace('&lt;/Extrinsic&gt;','') xmlTag1 = dom.getElementsByTagName('DeliverTo')[0].toxml() xmlData1 = xmlTag1.replace('&lt;DeliverTo&gt;','').replace('&lt;/DeliverTo&gt;','') xmlTag2 = dom.getElementsByTagName('Street1')[0].toxml() xmlData2 = xmlTag2.replace('&lt;Street1&gt;','').replace('&lt;/Street1&gt;','') xmlTag3 = dom.getElementsByTagName('City')[0].toxml() xmlData3 = xmlTag3.replace('&lt;City&gt;','').replace('&lt;/City&gt;','') xmlTag4 = dom.getElementsByTagName('State')[0].toxml() xmlData4 = xmlTag4.replace('&lt;State&gt;','').replace('&lt;/State&gt;','') xmlTag5 = dom.getElementsByTagName('PostalCode')[0].toxml() xmlData5 = xmlTag5.replace('&lt;PostalCode&gt;','').replace('&lt;/PostalCode&gt;','') import cherrypy class Root(object): def index(self): return ('Order Number:', ' ', xmlData0, '&lt;br&gt;Name: ', xmlData1, '&lt;br&gt;Street Address: ', xmlData2, '&lt;br&gt;City/State/Zip: ', xmlData3, ', ', xmlData4, ' ', xmlData5, ' ', """&lt;br&gt;&lt;br&gt;&lt;a href="/exit"&gt;Quit&lt;/a&gt;""") index.exposed = True def exit(self): raise SystemExit(0) exit.exposed = True def start(): import webbrowser cherrypy.tree.mount(Root(), '/') cherrypy.engine.start_with_callback( webbrowser.open, ('http://localhost:8080/',), ) cherrypy.engine.block() if __name__=='__main__': start() </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USKjuly
    1. USDryden Long
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POReturn XML Values from Multiple Files in Python?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhat's the problem?
      singulars
      1. POReturn XML Values from Multiple Files in Python?
      1. USJohn Mee
    2. COThe problem is that I have a multitude of XML files in a directory, all of which have the same headers. For example: <name>Person's Name</name> appears in each and every file. I can pull the name from 1 file, but how do I pull the names from all files, regardless of the file name? Thanks!
      singulars
      1. POReturn XML Values from Multiple Files in Python?
      1. USDryden Long
    3. CODoes the indenting of your code here match what you have there? Why don't you put your name extractor into a `def` routine then call it from inside the `infile for listing` loop?
      singulars
      1. POReturn XML Values from Multiple Files in Python?
      1. USJohn Mee
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload