Monday, March 15, 2010

Version 0.7.0.6 Release

New Features:
1. Computable fields. This feature currently can only be used through direct editing of Schema's Xml.
To add field that will contain values calculated from other fields add Expressions and Expression nodes after Columns node before File node:

    </Columns>
    <Expressions>
      <Expression Name="UpperName" Value='[Upper(Field("Name"))]' />
    </Expressions>
  </File>

In this example additional field will be added to the schema with Upper-Cased values from Name field.
This field is currently only available from Unique Constraint form in the GUI. But I am planning to make Expression fields similar regular fields, so they will be available anywhere in the GUI.
2. Soundex function added to functions that can be used in VB expressions.
3. Duplicate reporting action is added. This feature currently can only be used through direct editing of Schema's Xml.
To create report of duplicate records in the file add Action and DupeReport nodes in the Unique node:

  <Unique>
          <Column Name="Surname" />
          <Column Name="Address1" />
          <Column Name="Postcode" Index="Hash" />
           <Action>
               <DupesReport Path="C:\duplicates.csv" />
          </Action>
      </Unique>

4. Xslt transformation that allows to see schema in browser was slightly improved.

Bugs Fixed:
1. File lookup check box does not work
2. Field copy to file failed
3. Data validation stopped on data format
4. Command Line no longer taking Global variables

Download from:
1. User Group
2. Forum