I’ve solved the issue mentioned in the previous post and the application is currently running on my server for test.

My FF2Db application now parses Statlinks action files. The configuration options are numerous; you can specify exactly which format the file to parse has (such as string, int, float and date/time) and which values goes into which table as a single value or in a group of two or more.

The application works, but there are a few issues I need to solve. The first and trickiest issue is the matter of knowing which lines to parse after a restart of the application. With the date-sorted files this was an easy matter since each file went into its own table, thereby enabling an easy time-check against the database. With these action files the matter is more complicated – firstly each line the application read can be split into multiple tables. Secondly, the application doesn’t know which kind of data it is writing to the database; it does not care (you can write three columns of data to a table without a date/time key give them a timestamp).

Contact me if you’re interested in trying it out.