Append XML metadata to HTML code using Python

Question

Hi All, I have a script which pulls information from a number of XML files to populate a table within a HTML document. Although I can pull the information, it is overwriting the table space with the new information. What I would like to do is append the table space (body) of the HTML document for each new XML file, so that I will have a Thumbnail, metadata details for each XML creating a large HTML listing of data for quick reference.import arcpy, sys import xml.etree.ElementTree as ET html_head = """ """ fh = open(r'D:\Temp\CSD_HTML\file.html', 'wb') fh.write(html_head) XML_List = [r'D:\Temp\CSD_HTML est.xml', r'D:\Temp\CSD_HTML\contours.sdc.xml'] for xml in XML_List: print xml + ' ' path = xml tree = ET.parse(path) for node in tree.findall('.//title'): title = node.text print 'Title: ' + node.text for node in tree.findall('.//westbc'): westbc = node.text print 'West: ' + node.text for node in tree.findall('.//eastbc'): eastbc = node.text print 'East: ' + node.text for node in tree.findall('.//northbc'): northbc = node.text print 'North: ' + node.text for node in tree.findall('.//southbc'): southbc = node.text print 'South: ' + node.text for node in tree.findall('.//geogunit'): geogunit = node.text print 'Geographic Units: ' + node.text for node in tree.findall('.//horizdn'): horizdn = node.text print 'Projection: ' + node.text for node in tree.findall('.//ellips'): ellips = node.text print 'Ellipsoid: ' + node.text html_body = """

Title: """ + title + """
	North: """ + northbc + """
West: """ + westbc + """		East: """ + eastbc + """
	South: """ + southbc + """
Geographic Units: """ + geogunit + """ Projection: """ + horizdn + """ Ellipsoid: """ + ellips + """

""" fh = open(r'D:\Temp\CSD_HTML\file.html', 'a+') fh.write(html_body) html_tail = """ """ fh = open(r'D:\Temp\CSD_HTML\file.html', 'wb') fh.write(html_tail) fh.close() del tree Having an issue getting subsequent tables to add to HTML with each metadata details for each XML file. Regards, Craig

ShaunWalbridge · Accepted Answer

Having an issue getting subsequent tables to add to HTML with each metadata details for each XML file.

Just open a single file handle, and use that to write all of your data:fh = open(r'D:\Temp\CSD_HTML\file.html', 'wb')

Don't reopen the handle throughout the script, it isn't necessary here, and in the last block when you open the file 'wb' you're effectively truncating the rest of the file prior to closing. You can just use the single 'fh' object throughout your script, and be in fine shape.

cheers,
Shaun