Rons Data Gear - Product History

Current Version (2023.10.13.0726)

• Data Stream: Resilience to failed data sources improved.
• Data Stream: Small visual changes.
• Data Gear: Clipboard operations streamlined.

• Data Stream: Blank preview data issue fixed.
• Various reported bugs fixed.

Version 2023.09.27.1521

• Data Edit: 'Cell Fill' from HTTP API endpoint added.
• Data Edit: 'Document\Save' added to Page per Row.
• Data Gear: Clipboard lock handling added.

• Various reported bugs fixed.

Version 2023.09.11.1413

• Data Edit: Row Pivot added.
• Data Edit: Rons CSV Editor settings migration added at startup.
• Data Edit: Rons CSV Editor licenses accepted.
• Data Edit: Performance improvements.

• Various reported bugs fixed.

Version 2023.08.30.1700

• Data Edit: Menu added as an alternative to the Ribbon bar, for back compatibility.
• Data Edit: Ribbon streamlined to coordinate with menu.
• Data Edit: Options consolidated for clarity.
• Data Edit: Various visual improvements.
• Data Edit: Option to turn row headers off added.
• Data Stream: Output Row Split made clearer.
• Data Gear: XML/JSON import improved to deal with huge records.

• Data Edit: Cleaner column order bug fix.
• Various bugs fixed.

Version 2023.08.02.0914

• Data Edit: Pinned files and locations added.
• Data Edit: 'Fill Empty' added.
• Data Edit: 'Remove Duplicate Cells' added.

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

Version 2023.07.25.0823

• Data Edit: Copy path elements added to document tabs.
• Data Edit: Status bar added to cell editor.
• Data Tools: Icons updated.
• Both: Expression column addressing improved.
• Both: Internet connectivity diagnostics added.

• Data Edit: Internet Proxy setting not being used correctly fixed.
• Data Tools: 'Merge CSV Files Horizontally' bug fixed.
• Various bugs fixed.

Version 2023.06.30.1737

• Data Gear: Remove diacritics added to Text Format.
• All: Diacritics updated (ignore accents improved).

• Data Edit: Export all documents to Excel row clipping bug fixed.
• Data Edit: Cell editor double click bug fixed.
• All: Startup window position on multiple monitors with different scale fixed.
• Various bugs fixed.

Version 2023.06.16.1232

• Data Edit: Keyboard navigation and control overhaul.
• Data Gear: Expression processor commands added.
• Data Gear: Expression editor highlighting added.
• Data Gear: Expression editor command helpers added to context menu.
• All: Diacritics updated (ignore accents improved).

• Data Edit: Proxy port bug fixed.
• Various bugs fixed.

Version 2023.06.03.1211

• Data Edit: Column Append added.
• Data Edit: Find First/Last added.
• Data Edit: 'Replace' current added to Replace Panel.
• Data Edit: 'Update' current added to Toolbox Panel.
• Data Edit: Code highlighting added to Cell Edit panel for Text, HTML, XML and JSON.
• Data Stream: Parquet support removed.
• Data Gear: 'Format Text' rule added for Text, HTML, XML and JSON.
• Diagnostic added to License Check Window.

• Data Gear: Cell edit positioning bug fixed.
• Various bug fixes.

Version 2023.05.12.1624

• None.

• Various bug fixes.

Version 2023.05.10.1637

• Data Edit: 'Document Find' popup added ('Ctrl-Alt-O').
• Data Edit: 'Export all Open Documents' to Excel command added.
• Data Edit: 'Copy HTML' added to Command Shortcuts Window.
• Data Edit: Navigating between open documents assigned to 'Ctrl-Page Up' and 'Ctrl-Page Down'.
• Data Edit: Navigating between Views improved.
• Data Edit: Side panel icons improved.
• Data Edit: Command search improved.
• Data Edit: Document path added to window title and tab tool tips.
• Data Edit: Button tooltips improved.

• 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.03.31.1704

• Data Edit: Page per Row now uses font in Options/Appearance setting.
• Data Edit: Maximum column width added to Options/Appearance setting.
• Data Edit: Maximum column width after load added to Options/Appearance setting.

• Data Edit: Graph Plot number handling fixed.
• Data Edit: Copy 'no header' bug fixed.
• Various bug fixes.

Version 2023.03.25.0915

• Data Edit: Automatic product updates integrated.
• Data Edit: Performance for large number of columns improved.
• Data Edit: Message history popup added.
• Data Edit: Text and Numerical summary popups split.
• Data Edit: Type detection improved.

• Data Edit: Excel data format for non English regions fixed.
• Various bug fixes.

Version 2023.03.02.0719

• Data Edit: Row number offset added to Options / Appearance Settings.

• Data Edit: 'Show Row Data' from Summary of filtered view scope fixed.
• Various bug fixes.

Version 2023.02.26.1606

• Data Edit: Multiple window support added.
• Data Edit: Row Height Mode default can now be set in Options / Appearance Settings.

• Various bug fixes.

Version 2023.02.14.1812

• Data Gear: Grid rendering of non-text elements at high DPI improved.
• Data Edit: 'Save View As' now uses the main document Profile if the file extension is the same.

• Various bug fixes.

Version 2023.02.09.1445

• Data Gear: Parsing badly encoded files improved.
• None.

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

Version 2023.01.24.1727

• Data Edit: Quick filter 'Match Not (Invert)' option added.
• Data Edit: Manual column sizing added.
• Data Edit: Command line parameters explanation added.
• Data Edit: HTML cell view style applied (fonts).
• Data Gear: Grid colors updated.
• Data Gear: Wheel scroll speed adjusted.

• Data Stream: Invalid Cleaner in Preview bug fixed.
• Various bug fixes.

Version 2023.01.15.1205

• Data Edit: Export for CSV, HTML, JSON, XML and Tokens added.
• Data Edit: Grid font configuration added.
• Data Edit: Cell editor font configuration added.
• Data Edit: Import from Clipboard includes HTML text.
• Data Gear: Improved HTML output.

• Data Edit: Grid gesture conflict resolved.
• Various bug fixes.

Version 2022.12.30.0826

• Data Gear: Column fallback type added to Expression operations.
• All: Token information added to License window.

• Data Edit: Save after 'New from Import' for non-CSV source fixed.
• All: Handling adverse environment bugs fixes.
• Various bug fixes.

Version 2022.12.19.1400

• Data Gear: Grid rendering contrast improvement.

• Data Gear: Grid rendering issue with rows and columns frozen fixed.
• Data Edit: Saving to Quick Access Toolbar issue fixed.
• Various bug fixes.

Version 2022.12.15.1646

• Data Edit: Import directly from Internet added.
• Data Edit: Import HTML table, Token, JSON and XML added.

• Data Edit: 'Length Filter' for empty cell bug fixed.
• Data Gear: Inline cell editor character capture overwrite fixed.
• Data Gear: Grid rendering glitches fixed.
• Data Stream: Log location fixed.
• Various bug fixes.

Version 2022.12.01.1026

• None.

• Data Edit: find previous/next issue fixed.
• Various bug fixes.

Version 2022.11.28.0753

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

• Data Edit: find wrap issue, when column headers included, fixed.
• Data Gear: grid rendering anomalies fixed.
• Various bug fixes.

Version 2022.11.14.0822

• Data Edit: Duplicate Column command added.

• Data Edit: No action message fixed.
• Various bug fixes.

Version 2022.11.09.0813

• Data Edit: Improvements to column/row/cell move popup panel flow.
• Data Edit: 'Reset Tool' command added to Toolbox.
• Data Gear: In cell edit placement and size improved for multi-line cells.
• Data Gear: Auto-detect improved.

• Various bug fixes.

Version 2022.11.07.1754

• Data Edit: Added number of recent locations/files configuration to Options.
• Data Edit: Column headers can now be copied with the default Profile format or as a list.
• Data Gear: Regular expression handling in search changed to better handle lines in cells.

• Various bug fixes.

Version 2022.10.31.1506

• Data Edit: Automatic delimiter detection options moved from Profiles to Options.
• Data Edit: Automatic delimiter detection options added to override Open/Close/Escape from Profile.
• Data Edit: Automatic delimiter detection added for Paste.
• Data Edit: Detected delimiters shown in message if changed on document load.
• Data Edit: Document Properties panel re-arranged to make delimiters clearer.
• Data Edit: Automatic delimiter detection command added to Document Properties panel.
• Data Edit: Selection shown with text (Excel) column names in status bar and usable in Goto Column.
• Data Gear: 'Now' added to 'Add Date/Time' Toolbox tool and Data Stream Cleaner Rule.

• Various bug fixes.

Version 2022.10.23.1629

• Data Edit: Document Properties configuration flow improved.
• Data Edit: Paste text now honors the Profile set as the default for the clipboard, including auto detect.
• Data Edit: Cell Open/Close delimiters automatically applied when Separator added to the document.

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

Version 2022.10.17.1017

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

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

Version 2022.09.27.1634

• Data Edit: View layout copy/paste added.
• Data Edit: View layout edit, load/save added.
• Data Edit: View Layout different to Schema indicator added.
• Data Edit: update Schema from View Layout added.
• Data Edit: Data Cleaner integration improved.
• Data Edit: document integrity check added.
• Data Edit: Column Split right to left direction added.
• Data Stream: Preview now works with Source and no Target.
• Data Stream: fill values added to 'Add Row' rule.
• Data Gear: cell operation 'Add Expression Text' added.
• Data Gear: hyper-link cell support added (Ctrl-Click).
• Data Gear: import delimiter auto detect added.

• Data Gear: grid rendering improved.
• Data Gear: HTML encode bug fixed.
• Various bug fixes.

Version 2022.09.06.1144

• Data Gear: Automatic multi-line height added to the grid view.
• Data Edit: 'Schema Edit' new column values added.
• Data Edit: 'Find All' added.
• Data Edit: 'Page per Row' layout improved.
• Data Edit: Construct work flow improved.
• Data Edit: warning added when Excel export cells truncated.
• Data Edit: row counts added to view list.

• Various bug fixes.

Version 2022.08.25.1412

• Data Edit: Direct support for compressed ("*.gz" and "*.gzip") files added.
• Data Edit: View Set (multiple views) load and save added.
• Data Edit: "Max Cell Size" option added.
• Data Edit: column move menus smoothed and aligned.
• Data Edit: 'Make Row Header' now moves the column names to a row.
• Data Edit: HTML preview improved.
• Data Gear: Delimiter auto detect improved.
• Data Gear: Grid editor positioning improved.
• Data Gear: Horizontal mouse wheel support added.

• Data Gear: Grid editor DPI positioning fixed.
• Various bug fixes.

Version 2022.07.22.1427

• Data Edit: Column type detect improved.
• Data Edit: Column schema edit improved.
• Data Edit: Multiple 'Quick Filter' views allowed.
• Data Edit: Improvements to 'Data Summary'.
• Data Edit: Improvements to 'Import Join'.

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

Version 2022.06.29.0818

• Data Edit: Delimiter auto detect improved.
• Data Edit: Cell tools setting exchange improved.
• Data Edit: Filter navigation improved.
• Data Edit: Various customer feedback incorporated.
• Data Gear: Ellipsis added to grid.

• Data Edit: Filter load/save bug fixed
• Various bug fixes.

Version 2022.06.19.1706

• Data Edit: Command search improved.
• Data Edit: Direct menus added to tools buttons.
• Data Edit: Row Delete/Remove duplicates function added.
• Data Edit: View name added.

• Various bug fixes.

Version 2022.06.16.0804

• Data Edit: Column tool 'Pivot Columns' added.
• Data Edit: Search added to filter panel.

• Data Edit: 'Quick Access Toolbar' now keeps added buttons.
• Various bug fixes.

Version 2022.06.02.0844

• Data Edit: Command Palette popup added.
• Data Gear: 'Remove Space' updated to handle Unicode characters.
• Data Gear: 'Remove Space' updated to accept HTML encoded characters in input fields.

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

Version 2022.05.18.0754

• Data Gear: Installation streamlined.
• Data Gear: Multi-screen DPI handling implemented.
• Data Gear: Preview added to import.
• Data Edit: Match All/Any added to Quick Filter.

• Various bug fixes.

Version 2022.04.13.1433

• Data Edit: Symbols can be ignored in 'Sort' and 'Find Duplicates'.
• Data Edit: 'Select/Cell(s) Only' added.
• Data Edit: Background search/replace count added.
• Data Edit: Background selection summary added.
• Data Edit: Mouse tracking added to Graph view.

• Various bug fixes.

Version 2022.04.08.0827

• Data Edit: File associations added.
• Data Edit: Text encoding header handled.
• Data Edit: Improved control over search/replace.
• Data Edit: Multi-line header support added.
• Data Edit: Close All Documents added.
• Data Edit: File menu updated.

• Various bug fixes.

Version 2022.03.14.1532

• Data Gear: Icon Refresh.
• Data Edit: Manual document lock added.
• Data Edit: System file 'Read-Only' honored.
• Data Edit: Main window can now be used with Page per Row.

• Various bug fixes.

Version 2022.02.26.1110

• Data Gear: Icon Refresh.
• Data Edit: Import Join added.
• Data Edit: Column and Row Tools split into separate panels.
• Data Edit: Drag/drop document re-ordering added.
• Data Edit: Command line file handling added.
• Data Edit: Row/Column Clear commands added.

• Various bug fixes.

Version 2022.02.06.1624

• Data Gear: Icon Refresh.
• Data Edit: Column, row and cell movement smoothed.

• Various bug fixes.

Version 2022.01.30.1559

• Data Edit: Rename implemented in Location panel.
• Data Edit: Column, row and cell movement smoothed.
• Data Edit: Preview added to Edit panel.

• Various bug fixes.

Version 2022.01.24.0745

• Data Edit: Construct View added.
• Data Edit: Navigation commands added.
• Data Edit: Manual update commands added to Views.
• Data Edit: Filter builder layout improved.

• Various bug fixes.

Version 2022.01.19.1103

• Data Edit: Cell Viewer/Editor added.
• Data Edit: Graph view added.
• Data Edit: Open in new Window added to Graph view and Summary view.
• Data Edit: Goto View Row added.

• Various bug fixes.

Version 2021.12.16.1101

• Data Edit: Command tidy up.
• Data Edit: Page per Row window added.

• Various bug fixes.

Version 2021.12.05.1405

• Data Edit: Command Editor window added.
• Data Edit: 'Hide Empty' command added to Column View.
• Data Edit: Preview added to Cell block operations.

• Various bug fixes.

Version 2021.11.26.0802

• Data Edit: Summary View 'Copy' and 'Filter' commands added.
• Data Edit: Document change detection added.
• Data Gear: Usability improvements.
• Data Gear: Performance and memory usage improvements.

• Various bug fixes.

Current Version 2021.11.18.1417

• Data Edit: File management options added to Document Management and Location panel added.
• Data Edit: Direct Column editing functions added.

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

Version 2021.11.10.1559

• Data Edit: Document Management and Location panel added.

• Data Edit: Delimiter auto detection improved.
• Various bug fixes.

Version 2021.10.30.1006

• Data Edit: Cell operations, fill lookup,.
• Data Edit: Batch replace,.
• Data Stream: 'Fill Lookup' and 'Replace Lookup' updated to use grid.

• Data Stream: source to output text encoding bug fixed.

Version 2021.10.17.1235

• Data Edit: Cell operations, part two,.

• Various bug fixes.

Version 2021.10.08.1003

• Data Edit: Cell operations.

• Various bug fixes.

Version 2021.10.04.0851

• Data Edit: 'Split/Merge' panel part two for.

• Various bug fixes.

Version 2021.09.30.0857

• Data Edit: 'Split/Merge' panel part one for.
• Data Edit: 'Duplicate Rows' view cleaned up.
• Data Edit: Layout improvements.

• Various bug fixes.

Version 2021.09.27.0708

• Data Edit: 'Filter' panel added.
• Data Edit: 'Filter' helpers added.
• Data Edit: Document region integrated into all region related operations (sort, filter, summary).
• Data Edit: Delimiter auto detect improved.

• Various bug fixes.

Version 2021.09.07.0740

• All: Updated to use .net Framework 4.8.
• All: Computer ID improved to ignore WiFi adapters.
• Data Edit: 'Sort' panel added.

• Various bug fixes.

Version 2021.08.16.1710

• Data Edit: 'Search'/'Replace' panel added.

• Various bug fixes.

Version 2021.08.13.0930

• Data Edit: 'ToolBox' panel added.

• Various bug fixes.

Version 2021.08.05.1257

• Data Edit: 'Cleaner' integrated.
• Data Edit: 'Cleaner' panel added.

• Various bug fixes.

Version 2021.07.22.0837

• None.

• Various bug fixes.

Version 2021.06.30.0908

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

• Various bug fixes.

Version 2021.03.06.1047

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

• Data Stream: UNC path issue fixed.
• Various bug fixes.

Version 2021.02.28.1645

• Data Stream: Azure Blob Container support added.

• Various bug fixes.

Version 2021.02.20.1533

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

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

Version 2021.02.17.0850

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

• None.

Version 2021.01.15.0902

• Data Stream: New Data Tools window added.
• Data Stream: 'Merge CSV Files Horizontally' added to Data Tools.
• Data Stream: 'Append extra line' added to all text output formatters.
• Data Stream: New line options added to all text output formatters.
• Data Stream: New line in cell options added to CSV output formatter.
• Data Stream: '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 Stream: Data Preview added for text output targets.
• Data Stream: Data Preview flow improved.
• Data Stream: Missing JSON data types added.

• Various bug fixes.

Version 2020.08.20.1047

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

• Various bug fixes.

Version 2020.08.13.0857

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

• Data mapping fixes.
• Various bug fixes.

Version 2020.07.23.1051

• Data Stream: Text template Output Format added (part one).

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

Version 2020.07.02.1101

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

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

Version 2020.02.25.0734

• All: Updated to use .net Framework 4.7.

• None.

Version 2019.09.18.0954

• Data Stream: Product name changed to 'Rons Data Gear'.

• None.

Version 2019.09.13.1142

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

• None.

Version 2019.09.11.1419

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

• Data Stream: Parquet issue fixed in the install.
• Various bug fixes.

Version 2019.09.06.1607

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

• Various bug fixes.

Current Version 2019.09.02.1240

• Data Stream: Command line variables introduced.
• Data Stream: Internal variable engine improved.

• None.

Version 2019.08.02.0905

• All: Portable version introduced.

• None.

Version 2019.07.22.1645

• None.

• Data Stream: Main window close bug fixed.

Version 2019.05.27.1142

• Data Stream: Cleaner file extension changed to avoid conflict.

• None.

Version 2019.05.24.1443

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

• None.

Version 2019.05.21.1529

• Data Stream: SQLite output format added.
• Data Stream: Parquet output format added.

• None.

Version 2019.05.17.0950

• Data Stream: SQL Tables options added for table lifetime control.

• None.

Version 2019.05.16.1826

• Data Stream: JSON output added.
• Data Stream: XML output improved.

• Data Stream: SQL empty and badly formatted columns handled.
• Data Stream: SQL bugs fixed.

Version 2019.05.15.1705

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

• Various bug fixes.

Version 2019.05.13.1324

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

• Various bug fixes.

Version 2019.05.08.1602

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

• Various bug fixes.

Version 2019.4.29.1436

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

• None.

Version 2019.4.29.1436

• Data Stream: HTTP Source Location added.
• Data Stream: HTML table Source Profile added.

• None.

Version 2019.04.09.0844

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

• None.

Version 2019.03.22.1405

• Data Stream: Import for Fill lookup rule added.
• Data Stream: Import for Replace lookup rule added.

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

Version 2019.03.17.1431

• Data Stream: Fill lookup rule added.
• Data Stream: Replace lookup rule added.

• None.

Version 2019.03.10.1719

• Data Stream: Command line execution added.

• None.

Version 2019.03.08.1743

• Data Stream: Data change logging added to Cleaner rules.

• None.

Version 2019.02.26.1322

• Initial Beta release.

• None.