xml2sql-v is based on expat and is a quick and dirty solution to transform the content of any well-formed XML file into SQL INSERT statements such that you can postprocess the content of the XML data with SQL. The XML file is neither tested for correctness nor is it checked to contain anything reasonable. The insert statements will have the UTF-8 characterset but there are 3 more utilities (entityfix, latin1-utf8, and utf8-latin1), to fix broken HTML entities within the XML files, convert "forgotten" Latin1-Characters into proper XML entities, and convert the output back to Latin1 for easy insertion into the database.
|Tags||Database Text Processing Filters Markup XML|
|Operating Systems||POSIX Linux Unix|