Archive for February, 2007

New project

Feb 26th

Posted by Per in Temperaturkoll

While FF2Db is running on my logging computer to give it some additional weeks of testing, I’ve begun on another project, named “Temperaturkoll” (“temperature notifier” is the equivalent in english). In short, this program will read data from temperatur.nu and display it in the notification area. Since this applications audience is mainly swedish people it will initially be in Swedish only. The screenshots represents a first draft of the interface – it will change for sure.

Manual ready

Feb 23rd

Posted by Per in Flat file to database

The manual for FF2DB can now be downloaded from <removed>.

[Update] New location is: http://www.pmalmberg.com/ff2db/

Two weeks testing

Feb 23rd

Posted by Per in Flat file to database

FF2Db has been running flawlessly on my logging computer for two weeks now and I’ve frozen the code at its current state. The users manual is 80% complete.

Getting close to completion

Feb 10th

Posted by Per in Uncategorized

As I’ve previously stated, the FF2DB now parses both date-sorted and static (new data added at end of file by third-party application, never deleted) files. The two parses can work simultaneously and independent of each other.

I’m currently optimizing the application and making it a bit more user-friendly. The user interface isn’t much for show, but it is not supposed to be – the application’s strength is its parsing capabilities.

Progress update

Feb 7th

Posted by Per in Flat file to database

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

Parsing Statlinks action files

Feb 3rd

Posted by Per in Flat file to database

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.