Release: 1.1.1131 2026-08-24

Data Migration

• CHANGE: Conversion job WHERE statements now require the word 'where' (all existing scripts have been automatically updated.
• New:  Conversion job WHERE statement input now supports more 'data filtering' features. Including:
  • WHERE (must be first item if used)
  • GROUP BY (requires aggregate in the mappings for that target table - all used source fields must be referenced in the GROUP BY or aggregated in the mappings)
  • HAVING (can only be used in relation to a GROUP BY as a post grouping filter)
  • ORDER BY (depending on data and complexity this will impact completion times)
  • LIMIT (set the max number of rows to output, before an exit) 
  • more details here, Defining and running conversions

Minor updates and fixes

• TAG based filtering added to Conversion Jobs list

Utilities

• Updates to the following to allow output to be saved to specific folder:
  • Data Files: combine multiple CSVs (v2)
  • Data Files: Convert XLSX to CSVs (now also supports .XLS and has options to specify header row position and 1st data row position)
  • SQL: Modify a CSV data file (v2)