Release Notes

v4.0 (Feb 26, 2024)

This is a new major release. Please follow the detailed upgrade instructions below according to your installation (default, airgapped, or Kubernetes).

Changes:

  • [4.0.0] Faster navigation and workbook processing.
  • [4.0.0] Git integrations now show detailed error messages on the landing page.
  • [4.0.0] Syntax highlighting for Power Queries and CustomUI.xml.
  • [4.0.0] When a project is processing new workbooks, its progress is now shown under Settings > Project Status.
  • [4.0.0] The text comparison view now scrolls in sync when using the split view.
  • [4.0.0] URLs have been changed. If you are using bookmarks etc. to a specific project or file, you may have to update them.
  • [4.0.0] Bug and security fixes.
  • [4.0.1] External Git repos are now synced with only the latest 2 commits when you first add them. You can change this by going to Settings > Manage Projects and clicking on the "Edit" icon of the respective project.
  • [4.0.1] Power Query errors don't stop a file from processing the rest anymore.
  • [4.0.1] There is now a scheduled job to prevent storage size from growing over time.

NOTE:

  • The upgrade will log you out of the xltrail web app if you were logged in.
  • The repositories will be reprocessed, which may take a while.

Upgrade instruction for the default installation

  1. Make a snapshot of your VM so that you can revert back in case something goes wrong during the upgrade.
  2. Upgrade the xltrail CLI:

     curl -sSL https://www.xltrail.com/cli -o /usr/local/bin/xltrail
     chmod +x /usr/local/bin/xltrail
    
  3. Run the update:

     xltrail update
    
  4. Wait for processing to finish

    The update will automatically trigger a reprocessing of all projects. This may take up to a few hours.

  5. Clean up

    Once everything looks good, you can delete the following folders in your DATA_DIR (by default under /var/lib/xltrail):

    • frontend
    • minio2
    • source/git
    • source/xltrail

Upgrade instruction for Kubernetes Helm chart installations

  1. Make a snapshot of the PVC xt-source-xltrail-volume-xt-git-web-0 for backup purposes.

  2. Update the local helm repo:

     helm repo add xltrail https://xltrail.com/charts
     helm repo update
    
  3. Export the values.yaml file of the new version:

     helm show values xltrail/xltrail > values.yaml
    

    Update it by copying over the respective values from the previous version of values.yaml. We are happy to help you with that.

  4. Set the current context to the namespace where you installed xltrail (usually xltrail):

     kubectl config set-context --current --namespace=xltrail
    

    Alternatively, make sure to add -n xltrail (or whatever the name of your namespace is) to the following commands.

  5. Make PVC bigger:

    Make the xt-source-xltrail-volume-xt-git-web-0 PVC as big as the xt-source-git-volume-xt-git-web-0 PVC. The latter will be deleted eventually. In the following command, replace 100Gi with the desired size.

     kubectl patch pvc xt-source-xltrail-volume-xt-git-web-0 -p '{ "spec": { "resources": { "requests": { "storage": "100Gi" }}}}'
    

    To check the size of your PVC, you can run:

     kubectl get pvc
    
  6. Uninstall the helm chart. This is required as otherwise StatefulSets can't be updated. Note that the PVCs/PVs will not be deleted by uninstalling the Helm chart.

     helm uninstall xltrail
    

    Check that there are no more pods:

     kubectl get pods
    
  7. Install the latest version of xltrail, pointing to the new version of values.yaml:

     helm upgrade --install xltrail xltrail/xltrail -f values.yaml
    
  8. Once that kubectl get pods shows that everything is up and running, migrate the drag-and-drop projects:

     kubectl exec -it svc/xt-web -c server -- python /server/scripts/k8s_repo_migration.py
    

    Note that it may take up to a few hours until all projects are reprocessed.

  9. Clean up: once everything works, you can remove the following two PVCs:

     kubectl delete pvc/xt-filestore-volume-xt-filestore-0
     kubectl delete pvc/xt-source-git-volume-xt-git-web-0
    

    You can also delete the snapshot of xt-source-xltrail-volume-xt-git-web-0 that you created at the beginning for backup purposes.

Upgrade instructions for airgapped ("offline") installations

  1. Make a snapshot of your VM so that you can revert back in case something goes wrong during the upgrade.
  2. Upgrade the xltrail CLI:

     curl -sSL https://www.xltrail.com/cli -o /usr/local/bin/xltrail
     chmod +x /usr/local/bin/xltrail
    
  3. Run xltrail backupdb. This is required as the database will be upgraded to a new version.

  4. Edit /etc/xltrail/xltrail.conf and add the new line POSTGRES_VERSION=16.0.
  5. Download the new application bundle:

     curl -L "https://xltrail-airgap-stable.s3.amazonaws.com/xltrail-latest.tar.gz" -o xltrail.tar.gz
    
  6. Install xltrail (but cancel when it shows Finalizing..., see next step):

     xltrail install -f ./xltrail.tar.gz
    
  7. When the installation process shows Finalizing..., cancel by hitting Ctrl+C as we first need to restore the database.

  8. Stop xltrail:

     xltrail stop
    
  9. Restore the database:

     xltrail restoredb
    
  10. Start xltrail:

    xltrail start
    
  11. Wait for processing to finish

    The update will automatically trigger a reprocessing of all projects. This may take up to a few hours.

  12. Clean up

    Once everything looks good, you can delete the following folders in your DATA_DIR (by default under /var/lib/xltrail):

    • frontend
    • minio2
    • source/git
    • source/xltrail

v3.5.4 (Aug 17, 2022)

  • [Bug Fix] Fixed a bug with Active Directory/LDAP configuration when used with TLS.

v3.5.3 (May 22, 2022)

  • [Bug Fix] This fixes parsing errors with certain workbooks.

v3.5.2 (Mar 13, 2022)

  • [Bug Fix] Deleted and readded files were showing a 'processing' badge.
  • [Bug Fix] Syncing wasn't restarted after editing credentials of Git integrations.

v3.5.1 (Feb 18, 2022)

  • [Enhancement] Autorefresh landing page and workbook view during processing.
  • [Bug Fix] Git integrations now default to main branch.
  • [Bug Fix] Various bug and security fixes.

v3.5.0 (Jan 5, 2022)

  • [Feature] Added password reset feature (requires setting up SMTP settings).
  • [Bug Fix] Various bug fixes.

Upgrade instructions for users of the Kubernetes Helm chart only:

If you rely on a values.yaml file for your settings, you need to change the imageTag under minio as follows:

imageTag: RELEASE.2021-12-10T23-03-39Z

v3.4.10 (Nov 23, 2021)

  • [Bug Fix] Switching between branches on the VBA view wasn't always updating the content correctly.
  • [Bug Fix] If a comparison of a sheet is bigger than what xltrail can handle, there is now a proper error shown.
  • [Bug Fix] Fixed an error that would prevent the URL from specific comparisons to be used directly.

v3.4.9 (Oct 19, 2021)

  • [Bug Fix] Fixed a bug with disconnects when using externally hosted databases.
  • [Bug Fix] Fixed a bug that prevented the correct display of the History page under certain circumstances.

v3.4.8 (Sep 14, 2021)

  • [Bug Fix] Fixed a bug that caused the Permissioning menu on airgapped systems to be hidden.

v3.4.7 (Aug 22, 2021)

  • [Bug Fix] Fixed a bug with the xltrail encrypt command.

v3.4.6 (May 31, 2021)

  • [Bug Fix] Fixed a bug when using ssh keys to connect with Git repos that was introduced with 3.4.5.

v3.4.5 (May 6, 2021)

  • [Enhancement] Self-hosted installations: faster downloads due to smaller and fewer Docker images.

v3.4.4 (May 5, 2021)

  • [Bug Fix] This is a bug fix release.

v3.4.3 (Apr 9, 2021)

  • [Feature] Published Helm chart for installation into a Kuberentes cluster.

v3.4.2 (Mar 24, 2021)

  • [Bug Fix] Changes in formulas with named ranges are now properly shown in the diff view.

v3.4.1 (Feb 12, 2021)

  • [Bug Fix] This is a bug fix release.

v3.4.0 (Jan 18, 2021)

  • [Enhancement] Added support for the new lambda functions, thereby renaming Named Ranges to DefinedNames.
  • [Bug Fix] Various bug fixes.

v3.3.1 (Dec 22, 2020)

  • [Enhancement] Improved Secrets handling.

v3.3.0 (Dec 18, 2020)

  • [Feature] New Secrets section under Settings that allow you to add passwords to be able to display password-protected workbooks.

v3.2.1 (Dec 15, 2020)

  • [Bug Fix] In the diff view of the grid, sometimes the row or column label was off.
  • [Enhancement] When you download files from the history, they now have again the version number in the file name like it used to be the case pre v3.0.
  • [Bug Fix] LDAP users can now be deleted.

v3.2.0 (Nov 12, 2020)

  • [Enhancement] xltrail now also tracks cell notes and comments.
  • [Bug Fix] After resyncing a project it could happen that the history page threw an error.

v3.1.4 (Oct 14, 2020)

  • [Enhancement] Allow to mount the application on a specific endpoint by defining a BASE_URL in the config.

v3.1.3 (Oct 13, 2020)

  • [Bug Fix] Bug Fixes

v3.1.2 (Oct 12, 2020)

  • [Bug Fix] Fixed a bug with CA Certificates used for remote Git repos

v3.1.1 (Sep 28, 2020)

  • [Bug Fix] Prevent occasional hanging during xltrail start
  • [Enhancement] The upload warning about new versions with a different name can now be muted under Settings > Drag & Drop
  • [Bug Fix] Various bug fixes

v3.1.0 (Sep 16, 2020)

  • [Feature] xltrail now also tracks the CustomUI.xml file which is used to define Ribbon add-ins.
  • [Enhancement] Very large Excel files now keep memory consumption under control resulting in faster processing times and preventing out-of-memory issues.
  • [Bug Fix] Various bug fixes

v3.0.2 (Aug 26, 2020)

  • [Bug Fix] Fixed an issue that caused a few Power Queries to be read incorrectly.

v3.0.1 (Aug 12, 2020)

  • [Bug Fix] Various bug fixes.

v3.0.0 (July 16, 2020)

UPGRADE INSTRUCTIONS:

  • Since this is a major release, please make a backup of your VM before you upgrade so you can roll back in case something goes wrong during the upgrade.
  • After upgrading, your repositories will be re-processed so you will need to plan in some time until everything is available again.
  • Make sure to upgrade the xltrail CLI to the latest version by running (as root):
      curl -sSL https://www.xltrail.com/cli -o /usr/local/bin/xltrail
      chmod +x /usr/local/bin/xltrail
    
  • If you upgrade from a version below v2.10.0 and use xltrail with SSL enabled, make sure to perform the required change as mentioned under v2.10.0 release notes below.

CHANGES:

  • [Feature] xltrail now additionally tracks named ranges, power queries and properties
  • [Enhancement] Drag-and-Drop project now allow multi-line commit messages
  • [Bug Fix] Various bug fixes

v2.12.2 (March 2, 2020)

  • [Enhancement] Deleting a project now requires to confirm the action.
  • [Bug Fix] Some bugs were fixed that sometimes occurred during the initial processing of the Excel file.

v2.12.1 (February 17, 2020)

  • [Bug Fix] Fixed a bug that could occur when Git repos contain spaces.

v2.12.0 (January 10, 2020)

  • [Enhancement] When comparing (any) two versions of a file, there is now a summary at the top.
  • [Enhancement] Line numbers can now be hidden for VBA modules so it is easier to copy/paste.
  • [Enhancement] When hovering over a version on the "History" page, there are two buttons appearing: Compare From/Compare To.
  • [Enhancement] On the History page, when clicking in the From/To boxes, there is now a dropdown with the Git branch names.

v2.11.0 (December 20, 2019)

  • [Enhancement] Faster diffs.
  • [Bug Fix] Various bug fixes.

v2.10.0 (November 17, 2019)

Maintenance release.

UPGRADE INSTRUCTIONS:

If you use xltrail via https you'll need to change your /etc/xltrail/xltrail.conf:

Old:

HTTPS_ENABLED=1
SSL_CERTIFICATE_KEY=/path/to/dir/privkey.pem
SSL_CERTIFICATE=/path/to/dir/fullchain.pem

New:

HTTPS_ENABLED=1
SSL_DIR=/path/to/dir
SSL_CERTIFICATE_KEY=privkey.pem
SSL_CERTIFICATE=fullchain.pem

v2.9.2 (November 6, 2019)

  • [Bug Fix] Fixed a bug with the new ssh key functionality.

v2.9.1 (October 30, 2019)

  • [Bug Fix] Fixed a bug with the new ssh key functionality.

v2.9.0 (October 28, 2019)

  • [Enhancement] Allow to connect to Git repositories via ssh (via deploy keys), see here.

v2.8.3 (August 29, 2019)

  • [Enhancement] LDAP_BIND_PASSWORD can now be stored encrypted in the config file.
  • [Enhancement] Setting up internal users requires now to confirm the password.

v2.8.2 (July 15, 2019)

  • [Enhancement] Allow to add CA certificates via the CA_CERTIFICATES setting.

v2.8.1 (July 10, 2019)

  • [Enhancement] Support for advanced LDAP settings.

v2.8.0 (July 9, 2019)

Note that this upgrade will trigger a reprocessing of all your workbooks which may take a while.

  • [Enhancement] When diffing sheets/cells, xltrail now compares the values of the cells by taking into account the cell style. This means e.g. that dates will be formatted as dates instead of a number, and a change from 100 to 100.00 or from 0.25 to 25% will show up as change. Generally speaking, values will be compared as they appear in Excel. No changes for formulas.
  • [Enhancement] Enterprise plan only: In addition to User permissions, you can now also handle Group permissions.
  • [Bug Fix] Resolve an LDAP bug that could happen with certain AD setups.

v2.7.4 (July 1, 2019)

  • [Bug Fix] Resolve an LDAP bug that could happen with certain AD setups.

v2.7.3 (June 28, 2019)

  • [Bug Fix] Bug fixes with regards to branch dropdown and comparison

v2.7.2 (June 24, 2019)

  • [Enhancement] Self-hosted only: Enabled log rotation to prevent containers from growing too much in size.

v2.7.1 (June 21, 2019)

  • [Bug Fix] This fixes a bug in the differ that was introduced with 2.6.3.

v2.7.0 (June 20, 2019)

  • [Enhancement] Enterprise plan only: User permissions can now be handled via settings.
  • [Enhancement] Better navigation back from the sheet diffs to the list of changes.

v2.6.3 (June 10, 2019)

  • [Bug Fix] If the sheet differ encounters an error, it will now be displayed.

v2.6.2 (June 4, 2019)

  • [Enhancement] For drag-and-drop projects, the default version comment is now set to the name of the uploaded file.

v2.6.1 (May 16, 2019)

  • [Enhancement] The change view from the current to the previous version is now directly accessible by clicking the version message in the gray box.
  • [Enhancement] Changes in contiguous cells, rows and columns are now shown as one change only in the list of changes
  • [Bug Fix] Sometimes, the initial project creation got stuck

v2.6.0 (Apr 26, 2019)

  • [Enhancement] Drag and drop projects now ask for a confirmation when you upload a new version of an Excel file with a completely different file name.

v2.5.0 (Apr 17, 2019)

  • [Enhancement] The latest version of the workbook can now be downloaded from the landing page.
  • [Enhancement] The drag and drop interface now accepts workbooks that are bigger than 50 MB.
  • [Enhancement] Improved handling of long running diffs.
  • [Enhancement] Enterprise only: The LDAP setup is now much more flexible, see here (requires the new installer).
  • [Feature] Enterprise only: Project permissions have been introduced to lock down access of certain projects to specific users/groups.

v2.4.0 (Mar 22, 2019)

  • [Enhancement] The comparison view now shows a list of the cell changes. You can still switch to the full sheet view to get the context.

v2.3.0 (Mar 15, 2019)

  • [Enhancement] Drag and drop projects now allow to delete workbooks. Users with links to old versions will still be able to look at them though.
  • [Enhancement] On the history page, versions to compare can now be easily swapped from left to right and vice versa
  • [Bug Fix] Various bug fixes

v2.2.1 (Feb 27, 2019)

  • [Bug Fix] LDAP fixes
  • [Bug Fix] Scrollbar issues were resolved
  • [Enhancement] Various workflow enhancements for drag and drop projects
  • [Enhancement] Errors of past versions are not shown anymore on the landing page, but only on the history page

v2.2.0 (Feb 6, 2019)

  • [Enhancement] Git repos can now also be added from the landing page like drag-and-drop projects.
  • [Bug Fix] Admin users can now be deleted again.

v2.1.1 (Feb 1, 2019)

  • [Bug Fix] Enterprise only: A bug that was leaving zombie processes has been resolved.

v2.1.0 (Jan 18, 2019)

  • [Feature] New REST API to get meta information about the workbooks, see the docs for details.

v2.0.0 (Jan 5, 2019)

  • [Feature] In addition to integrating with external Git repositories, xltrail now allows to create Projects without any dependency on an external system. New workbook versions can be added via drag and drop.

v1.9.5 (Oct 26, 2018)

  • [Bug Fix] Fix horizontal scrollbar on sheets

v1.9.4 (Oct 25, 2018)

  • [Enhancement] The sheet formula bar can now be expanded to show longer formulas
  • [Enhancement] Enterprise only: All ports used by xltrail can now be changed in the Management console

v1.9.3 (Oct 19, 2018)

  • [Bug Fix] Fixed an issue with special characters in sheet names

v1.9.2 (Oct 18, 2018)

  • [Enhancement] Team members can now be added with admin privileges, i.e. they will be able to set up new repositories and team members.

v1.9.1 (Oct 13, 2018)

  • [Feature] New formula bar in the sheet view that makes it easy to see the whole formula of the active cell without having to change the width of the columns

v1.9.0 (Oct 12, 2018)

  • [Enhancement] Within diffs, the next/previous change button has been replaced with a list of changes for easier navigation

v1.8.3 (Sep 7, 2018)

  • [Bug Fix] Fixed an issue with Git repo synchronisation

v1.8.2 (Aug 24, 2018)

  • [Bug Fix] Various bug fixes

v1.8.1 (Aug 10, 2018)

  • [Bug Fix] Fixed an issue that prevented some branch names to work with the new branch comparison

v1.8.0 (Aug 9, 2018)

  • [Feature] New comparison tool on the History page: Compare any two commits or branches
  • [Enhancement] Individual VBA lines and cells/cell ranges can now be selected and shared via URL
  • [Enhancement] The repository names now show a link to the original Git repository when hovering over them
  • [Enhancement] A new summary of changes at the top of the diff view makes it easy to jump to the relevant changes
  • [Enhancement] You can now right click a cell on a sheet to copy its content
  • [Bug Fix] Various bug fixes

v1.7.2 (Aug 8, 2018)

  • [Enhancement] Enterprise only: You can now set the port on which xltrail runs

v1.7.1 (May 30, 2018)

  • [Bug Fix] Enterprise only: Resolved connectivity issues that could occur in rare cases

v1.7.0 (May 10, 2018)

  • [Enhancement] Search now allows to search for repositories
  • [Bug Fix] Various bug fixes

v1.6.3 (Mar 22, 2018)

  • [Bug Fix] Unknown named ranges were preventing sheet diffs to show correctly

v1.6.2 (Mar 15, 2018)

  • [Enhancement] Enterprise only: Log level can be set via the management console
  • [Bug Fix] Diff urls were sometimes causing issues

v1.6.1 (Mar 12, 2018)

  • [Enhancement] Enterprise only: Timeout can now be increased for complex sheet diffs via the management console
  • [Bug Fix] Allow @ in git user names

v1.6.0 (Mar 9, 2018)

  • [Enhancement] All diffs for a commit are now shown on a single page (via history page)
  • [Feature] Repo username and password can now be edited
  • [Bug Fix] Workbooks that were tracked via Git LFS were causing an error
  • [Bug Fix] Empty repos were causing an error

v1.5.1 (Feb 27, 2018)

  • [Bug Fix] Some VBA diffs were causing an error message when called from the history page
  • [Feature] Enterprise only: Improved installation size

v1.5.0 (Feb 21, 2018)

  • [Feature] xltrail now properly supports Git branches

v1.4.2 (Feb 21, 2018)

  • [Maintenance] Maintenance Release

v1.4.1 (Jan 2, 2018)

  • [Feature] Enterprise only: Allow to disable Git SSL certificates verification

v1.4.0 (Dec 18, 2017)

  • [Feature] Allow to change user passwords when using the internal user directory
  • [Bug Fix] Add a new repo: Don't hang when Git remote can't be validated

v1.3.1 (Dec 2, 2017)

  • [Enhancement] More prominent "Processing" badge
  • [Enhancement] Validate Git url

v1.3.0 (Nov 8, 2017)

  • [Feature] Enterprise only: LDAP/AD authentication for users
  • [Feature] Enterprise only: Show notification when updates are available
  • [Enhancement] Improved sheet diff algorithm
  • [Enhancement] Sheet diff caching

v1.2.1 (Oct 24, 2017)

  • [Bug Fix] Enterprise only: xltrail now works behind a proxy server

v1.2.0 (Oct 20, 2017)

  • [Feature] Enterprise only: Support Git remotes on file system
  • [Enhancement] Workbook size is now shown
  • [Enhancement] Better progress indication
  • [Enhancement] Show all Git versions in history
  • [Enhancement] Workbook vba/sheet search
  • [Enhancement] Collapsible sidebar
  • [Bug Fix] Memory issues with big workbooks are resolved

v1.1.0 (Sep 26, 2017)

  • [Enhancement] Show/sort VBA types analogous to VB Editor

v1.0.0 (Sep 22, 2017)

  • Initial release

results matching ""

    No results matching ""