I’ve just uploaded a beta 1 version of the flat file to database conversion tool I’ve been working on. You can download it here: (beta download no longer available)

To run it you’ll need to extract the files to a folder of your choice an then edit the settings. The “settings.xml” that comes with the archive is setup to work with the files produced by Husdata.se’s Statlink software, as well as Lämpömittari (although I have yet to verify this).

The configuration should be pretty self explanatory. There are really only a few settings you’ll need to change; the FlatFileToDb/DatabaseConnection/* and the FlatFileToDb/DateSortedFiles/RootPath settings.

If you’re going to use this software with Statlink, you’re now all set. Users trying to get it to work with Lämpömittari need to edit the FlatFileToDb/DateSortedFiles/* settings as the filenames are likely not the same as Lämpömittari produces.

I don’t recommend changing the <../File/RegExp>-tags unless you really know how regular expressions works.

Once you have the settings sorted, you can now use the SQL script file that comes with the archive to create the required database on your MySQL server. If you’re not using the default configuration in the FlatFileToDb/DateSortedFiles/ section you’ll have to create your own database with associated tables.

There are two modes the application can run in; Auto parsing and manual. To enable the auto parsing mode you’ll have to start the application using the command switch “/auto”, ie. “c:\path\FlatFileToDatabase.exe /auto”. When in auto mode, most of the user interface is disabled.

Exiting the application can only be done using the exit-button, other ways (ALT-F4 etc.) will only hide the application window; it will then only be available through a double-click on the applications icon the notification area (or Systray, depending on who you ask) on your Start-bar.

Even though I doubt that by using this application you put you and yours in danger (or your files for that matter), you use this software at your own risk.