Author: lgrant@nevacross.com

  • Extracting event logs from a cable modem

    Extracting event logs from a cable modem

    As part of monitoring my home network, I wanted to capture the event logs from my Arris SB6190 cable modem, so I could watch for any recurring problems. The modem has an “Event Log” page, so capturing the data is just a matter of fetching the HTML page, converting it to XHTML, and using XML…

  • PDF bursting on the cheap

    I have always been intrigued by PDF bursting programs, programs that take a PDF containing, say, a bunch of invoices, and based on a hidden field on each invoice, split them up into one file per customer, to be sent to them by email. (I am also tickled by the name “PDF burster”, because I…

  • Converting DBASE files from GIS shapefiles to XML

    Converting DBASE files from GIS shapefiles to XML

    Shapefiles, also know as ESRI shapefiles, are used to convey geographic information about locales to GIS (Geographic Information Systems) programs like ArcGIS or QGIS. However, they frequently contain useful information about the locales they describe. A shape file is a .zip file containing at least the following files: The .dbf file frequently contains information that…

  • Converting CSV files to XML, revisited

    Converting CSV files to XML, revisited

    In a previous post, I gave an example of how to use XQuery to convert a .csv file, in the common format of header records followed by detail records, into an XML file. In this post I will show you another approach, using Python with the pandas and xml.etree.ElementTree packages. We will use the same…

  • Welcome to the new XML Adventure

    Welcome to our new site. The content has not changed; just the presentation. The old site was a Joomla site, and the Joomla software was getting long in the tooth. Although I love almost everything about my web host, they are really geared toward WordPress, and getting Joomla and its prerequisites up to date proved…

  • Converting Microsoft Excel spreadsheets to XML

    Several years ago, I posted an XQuery program to convert LibreOffice Calc spreadsheets to usable XML. The following rationale was given in that article: I was working on an educational game about Medieval England, with an XML based GUI. For example, the new player would be asked to choose a name, a profession, and other…

  • Better program listings with MathML?

    Better program listings with MathML?

    For scientific programmers, it has long been a goal to have mathematical equations in their programs displayed as they would normally write them, with superscripts and subscripts in the right places, and that sort of thing. One early attempt was the HAL/S language, developed in the 1970s for the NASA Space Shuttle program. An equation…

  • MathML: Mathematics in XML

    MathML: Mathematics in XML

    Typesetting mathematics has always been a chore, for as long as typesetting has been a thing. These articles give some insight into mathematical typesetting in the days of hot-metal type: From boiling lead and black art: An essay on the history of mathematical typography, by Eddie Smith, and The Monotype 4-Line System for Setting Mathematics, by Daniel Rhatigan.…

  • Converting CSV files to XML

    Converting CSV files to XML

    I recently approached an upstream application group, requesting that they provide data in XML form. “We already provide a .csv file,” they said. “Isn’t that good enough?” I thought about at a bit and, although that was not the answer I had hoped for, I could, indeed, convert their .csv file into an XML file,…

  • Converting LibreOffice Calc spreadsheets to XML

    I was working on an educational game about Medieval England, with an XML-based GUI. For example, the new player would be asked to choose a name, a profession, and other characteristics. These were read from XML files in order to populate the list of choices. The researcher on the team would send us spreadsheets with…