Changelog

Track the latest updates, new features, improvements, and bug fixes in BC2SQL Sync

New Features
Improvements
Bug Fixes

Version 1.5.0

January 24, 2026

Latest
New Features
  • Data Transformation Rules: Comprehensive data transformation system with support for string operations (replace, regex replace, map values, concatenate, truncate, pad), number operations (scale, clamp, round, map ranges), integer operations (enum mapping), boolean operations (string conversion), and date operations (parse, format, add days/months/years, clamp).
  • Transform Rule Testing: Interactive testing interface for transform rules with real-time API integration, allowing users to test transformations against sample Business Central data before applying them in production.
  • Enhanced Transform Rules UI: Modern modal-based interface for managing transform rules with priority-based ordering, parameter configuration, and comprehensive documentation for all available transform types.
Improvements
  • Navigation Enhancements: Improved navigation flow with direct access to transform rules from entity mappings configuration, and updated back navigation to return to the configuration dashboard.
  • Modal-Based Operations: Enhanced user experience with Bootstrap modal confirmations for destructive operations like rule deletion, preventing accidental data loss.
  • API Integration Testing: Robust error handling and validation for transform rule testing against sync server endpoints, with clear feedback for successful transformations and error conditions.
Bug Fixes
  • JSON Serialization Issues: Fixed JSON marshaling problems in transform rule testing by properly handling complex data structures and ensuring correct payload formatting for API calls.
  • Modal State Management: Resolved modal backdrop accumulation and JavaScript errors by implementing proper modal show/hide lifecycle management in the transform rules interface.

Version 1.4.0

January 3, 2026

New Features
  • Monthly Sync Frequency Tracking: Added MonthlySync field to sync jobs to display estimated monthly synchronization frequency based on cron schedule, helping users understand sync job costs and frequency.
  • Enhanced Date Formatting: Standardized date formatting across all detail views using consistent "DD/MM/YYYY HH:MM:SS" format for better readability and consistency.
Improvements
  • Optimized Monthly Frequency Calculation: Improved calculateMonthlyFrequency function with more accurate calculations assuming 30-day months and better handling of different schedule frequencies.
  • Performance Enhancement: Simplified CalculateMonthlySyncStats function to use pre-calculated monthly_sync values from database instead of real-time cron parsing, significantly improving dashboard performance.
Bug Fixes
  • Template Date Formatting: Fixed date formatting errors in sync job detail templates by properly handling time.Time objects instead of string formatting.
  • Dashboard Statistics Accuracy: Resolved calculation inconsistencies in monthly sync statistics by using stored values instead of dynamic calculations.

Version 1.3.0

September 30, 2025

New Features
  • Client-Side Pagination: Added pagination for Entity Mappings and Sync Jobs tables with 10 items per page, improving performance and user experience for large datasets.
  • Smart Field Mapping: Implemented intelligent field mapping suggestions using Levenshtein distance algorithm to automatically match Business Central fields with database columns.
  • Data Type Normalization: Automatic conversion of database-specific data types to standard categories (String, Integer, Decimal, Boolean, Date, DateTime) ensuring successful synchronization across different database systems.
  • Enhanced Field Mapping UI: Improved field mapping interface with Bootstrap modal dialogs for better user experience and streamlined workflow.
Improvements
  • Dashboard Optimization: Enhanced dashboard table layout with compact rows and improved filtering capabilities for better data visualization.
Bug Fixes
  • JavaScript Error Resolution: Fixed Uncaught TypeError and empty field data issues in field mapping interface by wrapping JavaScript in DOMContentLoaded event.
  • Data Persistence: Resolved row deletion persistence issues ensuring that deleted field mappings are properly saved to the database.

Version 1.2.0

June 9, 2025

New Features
  • Suggest Create Table: New feature to automatically generate CREATE TABLE scripts based on Business Central API JSON structure, supporting SQL Server, MySQL, and PostgreSQL.
  • Smart Record Sampling: Enhanced API data fetching with random record selection instead of always using the first record, providing more representative data samples.
  • Enhanced Entity Duplication: Improved entity mapping duplication with option to include or exclude field mappings and value mappings through a confirmation modal.
Improvements
  • SQL Script Formatting: Improved CREATE TABLE script generation with proper database selection commands at the beginning and consistent formatting.
  • Documentation Update: Comprehensive README update with detailed feature descriptions, installation guide, and usage instructions.
  • Code Optimization: Refactored API client code with helper functions for better maintainability and error handling.
Bug Fixes
  • API Error Handling: Improved error handling in API calls with proper fallback mechanisms and user-friendly error messages.

Version 1.1.0

January 18, 2025

New Features
  • Public Changelog Page: Added a public changelog page accessible without authentication to track version updates and improvements.
  • Complete English Localization: Fully translated the entire application interface from Italian to English, including all templates, JavaScript-generated content, and user-facing messages.
Improvements
  • UI Consistency: Standardized all user interface elements and messaging across the application.
  • Code Quality: Improved code maintainability and consistency in template rendering.

Version 1.0.0

Initial Release

Initial Features
Business Central Integration
Multi-Database Support
Entity Mapping
Field Mapping
Scheduled Synchronization
Web Interface
User Authentication
Logging and Monitoring

Ready to experience BC2SQL Sync?

Join organizations worldwide that trust our platform for their Business Central integration needs.