Xmf\Database\TableLoadhas several methods that provide a standard solution to this common problem.
queryFromFile()function. This method has some drawbacks. For an example, consider this line from a language specific file used in the installation of XOOPS:
queryFromFile()function applies the prefix to the table names. Creating the SQL INSERTS requires removal of those prefixes, often a manual process.
TableLoadextracting a fresh revision of the help pages is this simple:
Criteriaobject to define the data we want, define the id column we want to not include, and save it.