Even dealing with the most robust web-based services my functionality tests are smooth not that often, and the methods of how everything is done are rarely clear-cut at once. But with TrackVia this is the case.
Aiming not to pick on services, but to define the best way of particular issue solving, the showcase I experienced testing TrackVia this time can be cited as an example of how the data structure should be modified within the system and how the program should function.
What I especially liked is that system notifies the user in Notes what will happen with the data in the column in case I decide to change the field type.
Convert function works as good as it looks, so there was no problem changing the type.