ExcelTL Release Notes

ExcelTL Release Notes

Version: 1.0.5

📅 Release Date: 2025-11-27
Download ExcelTL

📋 Overview

ExcelTL v1.0.5 focuses on improving reliability when loading data to Salesforce, stabilizing transformation logic, enhancing visibility in execution logs, and providing new operational controls such as job termination and Slack notifications.

This release is recommended for all users upgrading from earlier versions.

✨ Release Highlights

  • Reliable clearing of lookup fields when loading to Salesforce
  • Faster performance in Bulk mode
  • Improved correctness for Conditional Branching and Masking
  • Step-level summary logs for clearer job insights
  • New Slack integration
  • Ability to terminate running jobs directly from the UI

🛠️ Bug Fixes

1. Salesforce Loading

Lookup field clearing issue resolved

  • Fixed a bug where ParentId / lookup fields could not be updated from a non-null value to null.
  • Lookup relationships now clear correctly when source data specifies a null value.
2. Bulk Mode Performance
  • Improved overall execution speed during multi-record Bulk loads.
  • Enhanced stability for large datasets and repeated Bulk operations.
3. Conditional Branching Transformation
  • Fixed inconsistent behavior occurring when the same field was selected twice in a Conditional Branching step.
  • Transformation now processes duplicated field selections safely and consistently.
4. Masking Transformation
  • Corrected improper type conversion for numeric parameters (startIndex, length, keep).
  • Masking functions now behave correctly across all supported masking patterns.
5. Logging – Step-Level Summary

Added a detailed summary table for each step, including:

  • Number of successful records
  • Number of failed records
  • Execution statistics and other relevant details

Improves readability and helps users quickly evaluate job outcomes.

🚀 New Features

1. Slack Integration
2. Terminate Running Job
  • Introduced the ability to manually terminate a job from the UI.
  • Ideal for stopping long-running jobs or cancelling unintended executions.
3. Convert DateTime UTC Transformation
  • Added a new transformation to convert DateTime values to DateTime UTC.
  • This helps normalize timestamps across systems and time zones, ensuring consistent time-based processing.

🎨 UI Enhancements

1. Case List Improvements

Updated display logic to highlight:

  • Newly created cases
  • Cases with recent interactions

Helps users identify items requiring immediate attention.

2. Dashboard Improvements
  • Expanded the Job Execution History view with clearer and more detailed past run data.
  • Supports easier review and analysis of previous executions.

📝 Technical Notes

💻 Compatibility

Component Supported Version
Salesforce API REST + Bulk API v2
OS Support Windows

⬆️ Upgrade Notes

✅ ExcelTL v1.0.5 is a stability-focused release, delivering stronger Salesforce integration, safer data transformations, and improved operational control for end users.

Previous Release

Version: 1.0.4

📅 Release Date: 2025-11-11

🛠️ Bug Fixes & Updates

This release focuses on improving data integration between Excel and Salesforce, as well as adding new data transformation features to support more flexible data handling.

1. Function Fix – Data Filter Issue

Fixed an issue that occurred when applying data filters while loading data from Excel to Salesforce.

Filtering now works correctly and loads only the intended data set into Salesforce.

2. Function Add – New Transformations

Added two new Data Conversion transformations to improve data consistency and flexibility:

  • Convert Zero To Null
  • Convert Zero To Empty

These transformations convert numeric values equal to zero into either null or empty, helping maintain consistency and ensuring smooth data exchange across various systems.

✨ ExcelTL 1.0.4 expands transformation flexibility and strengthens data integration accuracy, enabling seamless synchronization between different systems.

Version: 1.0.3

📅 Release Date: 2025-11-03

🛠️ Bug Fixes & Updates

This release focuses on improving job stability and fixing UI display issues, while also introducing a special announcement for new users.

1. Function Fix
  • Job Termination Handling
    Resolved an issue where certain jobs could terminate unexpectedly after prolonged execution.
  • Upsert Multiple Record (Bulk Mode)
    Fixed an issue that occurred when running Bulk mode. Bulk upsert jobs now execute smoothly and reliably.
  • String Manipulation Transformation
    Standardized the configuration and processing of string manipulation transformations by guiding users to add double quotes before and after the string when setting values in the Job configuration..
2. UI Fix – Realtime Log Viewer (Expand / Collapse View)
Fixed an issue where the Realtime Log View disappeared after toggling between Expand and Collapse modes.
The log viewer now restores correctly and maintains its display state as expected.
3. UI Update – Subscription Screen
Announced a special promotion:

🎉 Starter Plan is now free for 1 year for all new users.

This update is reflected directly in the Subscription screen.

✨ ExcelTL 1.0.3 continues to enhance user experience and operational stability, ensuring smoother ETL workflows and better visibility in job monitoring.

Version: 1.0.2

📅 Release Date: 2025-10-27

🛠️ Bug Fixes & Improvements

This release focuses on enhancing stability and consistency across ExcelTL Studio.

1. UI Improvements – Pagination We have refined the pagination display to ensure a cleaner, more consistent look across different tabs.
2. Function Fix – Schedule Job Fixed an issue where certain scheduled jobs were not executed as expected.
All scheduled jobs now run reliably according to their defined schedules.

Version: 1.0.1

📅 Release Date: 2025-10-10

🚀 New Features

Enhance automation, flexibility, and support accessibility in ExcelTL Studio.

1. Job Dependency
Link multiple jobs with conditional execution to build automated, reusable data pipelines.
Detail Guide
2. Variable
Define reusable values for files, SQL, and connections to make ETL jobs flexible, secure, and easy to maintain.
Detail Guide
3. Help Center
Create, track, and manage support cases directly within ExcelTL Studio.
Detail Guide

📝 Note

This release enhances job automation and configuration management for advanced ETL workflows. Existing users can upgrade directly from version 1.0.0 without compatibility issues.

Version: 1.0.0

📅 Release Date: 2025-08-01

🚀 New Features

Provide adapters for the most common data sources:

CSV Adapter
Extract/Load data from .csv files.
Excel Adapter
Support reading/writing data from .xlsx files.
Salesforce Adapter
Integration with Salesforce (REST/Bulk API).
PostgreSQL Adapter
Connect and manipulate data with PostgreSQL Database.
HTTP REST Adapter
Call RESTful APIs to extract/load data.
HTTP SOAP Adapter
Integration with SOAP services.
Amazon S3 Adapter
Upload/download and manage data on Amazon S3.