Rons Data Stream - Product History

Current Version (2024.11.18.1417)

• Preview now Data Builder (editing Cleaners from live data).
• Data Builder Context introduced to make relation to Job source(s) and Cleaner(s) clearer.
• Selection highlight for current Cleaner rule added to Data Builder.
• Link from Data Builder to Cleaner added.
• Job and Data Cleaner Auto Cleanup added to remove bad or orphaned rules.
• Popup message can now be closed by clicking.

• Various reported bugs fixed.

Version 2024.10.16.1101

• Automatic update improvements.
• Library update.

• Various reported bugs fixed.

Version 2024.09.28.1142

• 'Split URL' cell rule added.
• Better path handling for SQL data sources to improve filtering.
• Unix time parsing added to 'Replace Date Time' tool.
• Folder browser dialog improved.
• Layout improvements.
• Library update.

• Grid rendering issue on Intel graphics cards fixed.
• Various reported bugs fixed.

Version 2024.07.08.0830

• 'Data Shaper' output processes added:
• 'Split - Row Ratio' splits the output in a defined ratio of rows (for Machine Learning).
• 'Locations' (directory browser) panel added.
• 'Preview' panel overhauled.
• Ability to open preview data files in a new tab added.
• Data process moved to background, with a popup control panel.
• Data process can now be started from the 'Preview' panel.
• JSON and XML parsers made more resilient to bad data.
• Various visual enhancements.
• 'Process Job' window removed.
• 'Quick Job' removed.

• HTML Encode 'URL' format bug fixed.
• Various reported bugs fixed.

Current Version (2024.06.10.1251)

• 'Data Shaper' output processes added:
• 'Split - Row Count' splits the output every x rows.
• 'Split - Row Filter' splits the output into matching and not matching based on a Row Selector.
• 'Split - Column Value' splits the output into data groups based on row data and a Column Selector.
• Data Profiles added.
• Data Profile usage and auto detect added for CSV data sources.
• Last file opened consolidated and applied.
• Gzip support added.
• Various visual enhancements.
• Environment resilience improved.
• Temporary file directory moved after strange error reports.

• Edge case parsing bugs fixed.
• SQLite concurrency bug fixed.
• Various reported bugs fixed.

Current Version (2024.04.02.0829)

• Non administrator/local user install mode added.
• HTML decoding hexadecimal character decoding improved.
• Library update.
• Environment resilience improved.

• Various reported bugs fixed.

Version 2024.03.28.1111

• Library update.

• Various reported bugs fixed.

Version 2024.02.11.1814

• File drag and drop open added.
• Clipboard error handling made even more robust.

• Grid selection border drawing issue fixed.
• 'Update Now' issue fixed.
• Various reported bugs fixed.

Version 2024.01.24.1615

• Limited time full product evaluation added.

• None.

Version 2024.01.12.0807

• Product split from Rons Data Gear.
• Icon updated.

• None.

Version 2023.12.27.0828

• Tooltips added to overflow cells.

• Split on New Line bug fixed.
• Various reported bugs fixed.

Version 2023.12.17.1617

• Colors themes added.
• Dark and light mode added.
• Windows dark mode setting honored.
• Automatic product updates integrated.

• Various reported bugs fixed.

Version 2023.10.13.0726

• Resilience to failed data sources improved.
• Small visual changes.
• Clipboard operations streamlined.

• Blank preview data issue fixed.
• Various reported bugs fixed.

Version 2023.09.27.1521

• Clipboard lock handling added.

• Various reported bugs fixed.

Version 2023.08.30.1700

• Output Row Split made clearer.
• XML/JSON import improved to deal with huge records.

• Various bugs fixed.

Version 2023.08.02.0914

• Text clipping due to Windows Text Sizing fixed.
• Various bugs fixed.

Version 2023.07.25.0823

• Both: Expression column addressing improved.
• Both: Internet connectivity diagnostics added.

• Various bugs fixed.

Version 2023.06.30.1737

• Remove diacritics added to Text Format.
• Diacritics updated (ignore accents improved).

• Startup window position on multiple monitors with different scale fixed.
• Various bugs fixed.

Version 2023.06.16.1232

• Expression processor commands added.
• Expression editor highlighting added.
• Expression editor command helpers added to context menu.
• Diacritics updated (ignore accents improved).

• Various bugs fixed.

Version 2023.06.03.1211

• Parquet support removed.
• 'Format Text' rule added for Text, HTML, XML and JSON.
• Diagnostic added to License Check Window.

• Cell edit positioning bug fixed.
• Various bug fixes.

Version 2023.05.12.1624

• None.

• Various bug fixes.

Version 2023.04.18.0725

• Icon refresh.

• Various bug fixes.

Version 2023.04.06.1344

• Company name changed to 'Rons Place Software Inc.'.

• None.

Version 2023.02.14.1812

• Grid rendering of non-text elements at high DPI improved.

• Various bug fixes.

Version 2023.02.09.1445

• Parsing badly encoded files improved.
• None.

• Newline character for certain fonts issue fixed.
• Various bug fixes.

Version 2023.01.24.1727

• Grid colors updated.
• Wheel scroll speed adjusted.

• Invalid Cleaner in Preview bug fixed.
• Various bug fixes.

Version 2023.01.15.1205

• Improved HTML output.

• Various bug fixes.

Version 2022.12.30.0826

• Column fallback type added to Expression operations.
• Token information added to License window.

• Handling adverse environment bugs fixes.
• Various bug fixes.

Version 2022.12.19.1400

• Grid rendering contrast improvement.

• Grid rendering issue with rows and columns frozen fixed.
• Various bug fixes.

Version 2022.12.15.1646

• Inline cell editor character capture overwrite fixed.
• Grid rendering glitches fixed.
• Log location fixed.
• Various bug fixes.

Version 2022.12.01.1026

• None.

• Various bug fixes.

Version 2022.11.28.0753

• grid rendering engine re-written to handle font substitution.
• Views now included in SQL data source.

• grid rendering anomalies fixed.
• Various bug fixes.

Version 2022.11.09.0813

• In cell edit placement and size improved for multi-line cells.
• Auto-detect improved.

• Various bug fixes.

Version 2022.11.07.1754

• Regular expression handling in search changed to better handle lines in cells.

• Various bug fixes.

Version 2022.10.31.1506

• 'Now' added to 'Add Date/Time' Toolbox tool and Data Stream Cleaner Rule.

• Various bug fixes.

Version 2022.10.23.1629

• Escape character parsing error fixed.
• Various bug fixes.

Version 2022.10.17.1017

• Multiple Cleaners per Job support added.
• column/row regular expression split includes match character(s) in output.
• multi monitor DPI switch support added.
• delimiter detection improved.

• grid DPI detection when main screen greater than 100% scaling fixed.
• Various bug fixes.

Version 2022.09.27.1634

• Preview now works with Source and no Target.
• fill values added to 'Add Row' rule.
• cell operation 'Add Expression Text' added.
• hyper-link cell support added (Ctrl-Click).
• import delimiter auto detect added.

• grid rendering improved.
• HTML encode bug fixed.
• Various bug fixes.

Version 2022.09.06.1144

• Automatic multi-line height added to the grid view.

• Various bug fixes.

Version 2022.08.25.1412

• Delimiter auto detect improved.
• Grid editor positioning improved.
• Horizontal mouse wheel support added.

• Grid editor DPI positioning fixed.
• Various bug fixes.

Version 2022.07.22.1427

• Occasional license deletion bug fixed.
• Various bug fixes.

Version 2022.06.29.0818

• Ellipsis added to grid.

• Various bug fixes.

Version 2022.06.02.0844

• 'Remove Space' updated to handle Unicode characters.
• 'Remove Space' updated to accept HTML encoded characters in input fields.

• 'Copy Column' used with 'Delete Column' bug fixed.
• Various bug fixes.

Version 2022.05.18.0754

• Installation streamlined.
• Multi-screen DPI handling implemented.
• Preview added to import.

• Various bug fixes.

Version 2022.03.14.1532

• Icon Refresh.

• Various bug fixes.

Version 2022.02.26.1110

• Icon Refresh.

• Various bug fixes.

Version 2022.02.06.1624

• Icon Refresh.

• Various bug fixes.

Version 2021.11.26.0802

• Usability improvements.
• Performance and memory usage improvements.

• Various bug fixes.

Version 2021.11.18.1417

• Schema update issues fixed with column rename.
• Various bug fixes.

Version 2021.10.30.1006

• 'Fill Lookup' and 'Replace Lookup' updated to use grid.

• source to output text encoding bug fixed.

Version 2021.09.07.0740

• Updated to use .net Framework 4.8.
• Computer ID improved to ignore WiFi adapters.

• Various bug fixes.

Version 2021.07.22.0837

• None.

• Various bug fixes.

Version 2021.06.30.0908

• Parquet data source added.
• Significantly faster grids introduced.
• Performance improved.
• Fast, light CSV editor included.

• Various bug fixes.

Version 2021.03.06.1047

• CSV 'Escape Character' support added.
• Output file split option added.

• UNC path issue fixed.
• Various bug fixes.

Version 2021.02.28.1645

• Azure Blob Container support added.

• Various bug fixes.

Version 2021.02.20.1533

• 'Refresh' button added to 'Preview' side panel for sources that refresh slowly (for example tables in web pages).
• 'Preview' processed (output) view enabled when no 'Cleaner' selected.
• 'Preview' flow improved.

• External 'Cleaner' in 'Job' switching to embedded 'Cleaner' fixed.
• 'Quick Job' fixed.
• 'Preview' refresh on 'Quick Job' already open in 'Preview' fixed.

Version 2021.02.17.0850

• Product renamed to 'Rons Data Stream'.
• Data Stream Pro/Lite introduced.

• None.

Version 2021.01.15.0902

• New Data Tools window added.
• 'Merge CSV Files Horizontally' added to Data Tools.
• 'Append extra line' added to all text output formatters.
• New line options added to all text output formatters.
• New line in cell options added to CSV output formatter.
• 'Split Row' rule added to 'Row Processors'.

• Various bug fixes.

Version 2020.09.10.1716

• None.

• Various bug fixes.

Version 2020.08.30.1303

• Data Preview added for text output targets.
• Data Preview flow improved.
• Missing JSON data types added.

• Various bug fixes.

Version 2020.08.20.1047

• Text template Output Format dialects added for CSV, HTML, JSON and SQL Server (part two).

• Various bug fixes.

Version 2020.08.13.0857

• SQL Server source added.
• Data pipeline updated to handle multiple data types.

• Data mapping fixes.
• Various bug fixes.

Version 2020.07.23.1051

• Text template Output Format added (part one).

• Empty source crash in Preview fixed.
• Changing to Embedded Cleaner issue fixed.
• Parquet target fixed.
• Various bug fixes.

Version 2020.07.02.1101

• Job Result Preview side panel added to Main Window.
• Job Result Preview improved to add all related components.
• Preview Window job results removed.
• Cell Change side panel added to Preview Window.
• Maximum cell size before parsing error now configurable - added to the CSV source.
• Replace regular expression handling improved for empty matches.

• Multi tab issues fixed.
• Detecting change in Embedded Cleaner as part of Job issue fixed.
• Various bug fixes.

Version 2020.02.25.0734

• Updated to use .net Framework 4.7.

• None.

Version 2019.09.18.0954

• Product name changed to 'Rons Data Stream'.

• None.

Version 2019.09.13.1142

• Added 'Skip Rule' option to 'If Table Exists' option in SQL table output format.

• None.

Version 2019.09.11.1419

• Job step identifiers added to variable processing.
• Type support added to JSON.
• Type support added to Parquet.
• Better status output added to Command line execution.

• Parquet issue fixed in the install.
• Various bug fixes.

Version 2019.09.06.1607

• Data type handling added to SQL Server and SQLite output formats.
• Add Column rule updated to set output data types.
• Update Column rule introduced, for setting output data types.
• Data Stream processor grouping added in the editor.

• Various bug fixes.

Version 2019.09.02.1240

• Command line variables introduced.
• Internal variable engine improved.

• None.

Version 2019.08.02.0905

• Portable version introduced.

• None.

Version 2019.07.22.1645

• None.

• Main window close bug fixed.

Version 2019.05.27.1142

• Cleaner file extension changed to avoid conflict.

• None.

Version 2019.05.24.1443

• Embedding Cleaners in jobs added to make one click jobs easier.
• Shared Cleaners between jobs added.
• Local files removed from Preview window (use Quick Job instead).
• Default SQL table output type changed for greater flexibility.
• Job and Cleaner icons added in Explorer for more clarity.

• None.

Version 2019.05.21.1529

• SQLite output format added.
• Parquet output format added.

• None.

Version 2019.05.17.0950

• SQL Tables options added for table lifetime control.

• None.

Version 2019.05.16.1826

• JSON output added.
• XML output improved.

• SQL empty and badly formatted columns handled.
• SQL bugs fixed.

Version 2019.05.15.1705

• Copy added to Job rules outside of main Job edit.
• Raw data source view added to Preview Window.
• Improved error handling fetching source in Preview Window.
• Some GUI tidy up.

• Various bug fixes.

Version 2019.05.13.1324

• XML Source Profile added.
• JSON Source Profile added.
• Skip lines added to CSV source.
• Add skipped lines added to CSV target.
• CSV parser made more resilient.

• Various bug fixes.

Version 2019.05.08.1602

• Add invert option to all filters.
• Empty column match expression now matches empty columns.

• Various bug fixes.

Version 2019.4.29.1436

• Code signing certificate changed to 'Rons Place Software'.

• None.

Version 2019.4.29.1436

• HTTP Source Location added.
• HTML table Source Profile added.

• None.

Version 2019.04.09.0844

• Significant overhaul of Quick Job to better fit work flow.

• None.

Version 2019.03.22.1405

• Import for Fill lookup rule added.
• Import for Replace lookup rule added.

• File find in job execute fixed.
• Handling of zero files found in job execute improved.

Version 2019.03.17.1431

• Fill lookup rule added.
• Replace lookup rule added.

• None.

Version 2019.03.10.1719

• Command line execution added.

• None.

Version 2019.03.08.1743

• Data change logging added to Cleaner rules.

• None.

Version 2019.02.26.1322

• Initial Beta release.

• None.