Friday, December 11, 2009

Version 0.6.9 is released

Version 0.6.9 includes a feature that hopefully will make you scream with joy.

Finally it is possible to correct erroneous values directly from Flat File Checker with out going to any text editors or MS Excel.

Lets see how it works:

1) After the validation was complete we open the data error list () :

2) Change one or more values directly in the grid:

Now few things are new on this form

  • changed values are highlighted with blue background;
  • message in the left-bottom conner tells how many values were changed;
  • "Apply Changes" button allows to apply corrections done in the form to the original data files.
3) After we click on "Apply Changes" button few things will happen:
  • Corrected values will disappear from the errors list;
  • "Apply Changes" button itself  will disappear or become disabled;
  • Message will show the status of file update:

Hope this new feature will streamline the work with data in flat files even more!

Windows installer can be downloaded here.

Sunday, December 6, 2009

Version 0.6.8 is released

New features in v.0.6.8:

Global Variables
It is now possible to define global variables that are accessible from different parts of the schema.

To add new variables or edit existing ones click on Options->Global Variables in main form menu:

In the Global Constant Variables form fill in names of variables and their values.

Now you can use these values in different places of the schema through Constant function in VB expression, i.e.: [Constant('AgencyCode')] will be replaced with "RK".

This functionality can be useful if you want to use same schema for data files where some parameters change regularly.

Copy objects
Now it is possible to copy existing files or fields through GUI.
For example you can copy field with all rules from one file to another:
Copy field:

   Paste field: