Bugfix Release

Welcome to the monthly bugfix update to Cells.

This release fixes minor issues in various fields:

• TLS: Make TLS support more flexible for database connections (Mongo and MySQL)
• API: Fix ListBucket API for aws-sdk-v2
• UX: Fix blinking and somewhat disappearing modals after login or when switching language on login screen
• [ED] Fix dashboard graphs missing informations
• [Cells Flows] Add wildcard support on Users attributes filtering

Change log

You can find a summary of the change log here.

Minor bugfixes

Minor release for bug fixes.

• An unreleased handle could prevent liberating disk space when purging activities and compacting DB.
• Better handling of "zero" value edge-case in UX for metadata Integer type.
• Possible nil ref in handler-path-multiple-root could put Websocket service down.
• Updated misc context metadata for specific logging and errors.

Change log

You can find a summary of the change log here.

Bugfix release

This is a small bugfix release:

• Pass user interface language setting to Collabora Online editor, as it no longer detects it automatically.
• Fix Windows-related issues caused by recent Go language updates (Cells Home).
• Update various dependencies.
• [ED] Restrict the Daily Snapshots flow concurrency to avoid exhausting resources.

Change log

You can find a summary of the change log here.

Feature Release

This release ships new interesting features, an important upgrade of Cells Flows User Interface, bugfixes and more.
Note that several GO and JS dependencies where updated to include latest security updates.

Features

Serve static sites via Public Link

The webDAV feature introduced in version 4.3 for Public Links (like /public/{link-hash}/dav/) is now even more powerful: we introduce DirectoryListing and DirectoryIndexes feature, similar to Apache or other web servers, for serving a listing or any custom HTML file when browsing a folder. This gives the ability to fully serve an independent static html site, where relative resources (images, css) are loaded with correct content-type from the public link folder.

Note that script execution is fully disabled (using Content-Security-Policy) as this is served on the same domain.

Environment Variables Documentation

All ENV variables that are not bound to command flags are now properly documented in the command line tool.

Below is an extract from ./cells start --help:

  4. Other environment variables (development or advanced fine-tuning)

  - CELLS_DAV_MULTIPART_SIZE (20): Default part size used to automatically chunk DAV uploads, in MB
  - CELLS_DEFAULT_DS_STRUCT (false): Create default datasources using structured format instead of flat
  - CELLS_ENABLE_FORMS_DEVEL (false): Display a basic UX form with all possible fields types in the UX (for React developers)
  - CELLS_ENABLE_LIVEKIT (false): Enable experimental support for video calls in the chat window, using a livekit-server.
  - CELLS_ENABLE_SIMDMD5 (false): Empty is false by default, if set this will switch the md5 hasher to simd implementation
  - CELLS_ENABLE_WIP_LANGUAGES (def): Display partially translated languages in the UX language picker.
  - CELLS_JOBS_LOG_LEVEL (info): Log level used for scheduler jobs - to be used carefully as it may produce a large volume of logs.
  - CELLS_MINIO_STALE_DATA_EXPIRY (48h): Expiration of stale data produced by objects upload parts
  - CELLS_TRACE_FATAL: Better display root cause of process crashes
  - CELLS_WEB_RATE_LIMIT (0): Http API rate-limiter, as a number of token allowed per seconds. 0 means no limit.

Material Design Icons update

The UX now ships the latest Material Design Icons library v7, providing many more icons.

[Enterprise] Cells Flows

• Full rework of the UX. Much cleared, zoom/move with mouse, two levels of details.
• New action to schedule an arbitrary flow to run once at a given date/time (reminders!)
• Simplify concurrent data processing with ability to merge back Rows directly in a dedicated Variable.
• Clean AutoClean jobs even if not AutoStart.

Other bugfixes and minor improvements

• Enable alternative md5 hashing mechanism (using minio/md5simd package) for platforms handling huge files.
• Fixed an issue in WebDAV API when a folder would contain a "._" file
• WebDAV upload stream converted to multipart was rewritten
• Better UX checks when creating empty file, new directory or renaming a file
• Console > Uploaders settings: prevent setting wrong size for multipart size (must be a multiple of 10MB)
• Console > Uploaders settings: set a 400GB upload size limit by default
• JS libraries: Updated OpenLayers, momentjs replaced with dayjs, PDF viewer provides a setting to fully disable script execution (although sandboxed by default).
• New configurations for settings public links base URI (/public) and public dav URI (/public/{linkID}/dav)

Change log

You can find a summary of the change log here.

First release candidate for next release

Features, improvements and security fixes.

Security

We have updated several dependencies in both Go and JS code to include latest security fixes.

Bugs and minor improvements

• Fixed an issue in WebDAV API when a folder would contain a "._" file
• WebDAV upload stream converted to multipart was rewritten
• Better UX checks when creating empty file, new directory or renaming a file
• Console > Uploaders settings: prevent setting wrong size for multipart size (must be a multiple of 10MB)
• Console > Uploaders settings: set a 400GB upload size limit by default
• JS libraries: Updated OpenLayers, momentjs replaced with dayjs, PDF viewer provides a setting to fully disable script execution (although sandboxed by default).
• New configurations for settings public links base URI (/public) and public dav URI (/public/{linkID}/dav)

Features

• New Public Links features to enable DirectoryListing, DirectoryIndexes and define custom index files. This gives the Public Links + WebDAV combination the ability to fully serve a dedicated minisite.
• Register every ENV variables that are not bound to command flags for a better documentation (see ./cells start --help)
• Enable alternative md5 hashing mechanism (using minio/md5simd package) for platforms handling huge files.

[Enterprise] Cells Flows

• Full rework of the UX. Much cleared, zoom/move with mouse, two levels of details, nice!
• New action to schedule an arbitrary flow to run once at a given date/time (reminders!)
• Simplify concurrent data processing with ability to merge back Rows directly in a dedicated Variable.

Change log

You can find a summary of the change log here.

Cells Flows New Features

This release mostly focuses on Cells Flows new actions and usability improvements.

Cells Flows

Our no-code workflow engine ships many new interesting features, actions, and templates.

Handling Structured Data

Flows that manipulate structured data can easily become quite complex. Whether data comes from an external Rest API, from successive SmartForms submissions, or from platform usage statistics, transforming and creating "views" was previously doable in JSON only.

Meet the new Actions to Load/CRUD/Persist an SQLite database: automatically generate an SQL schema from an incoming JSON, feed with this data, and then perform complex SQL Queries to build dedicated views of the data.

The new SheetViewer (on the user side) is a complementary tool allowing the direct preview of the tables' contents (supports SQLite, CSV, and JSON out-of-the-box).

Finally, a new Javascript Action comes in handy as an Anko-Script replacement, for performing any kind of scripting operations in Javascript, and the new DataSelector (see below) ease creating loops for pipelining chunks of data.

Documents Generation: PDF, MD, DOCX Actions

Based on the powerful PDFCpu, the new PDF Action provides the ability to split, join, and watermark PDF pages (more operations to come). A ready-to-use PDF Flow template exposes this action as end-user's operations, via Webhooks.

Another new interesting action is the DOCX Placeholders replacement: create any DOCX file containing your own placeholders (defined as {keyName}) anywhere in text, header, titles, etc... and replace them with custom values to create new document on the fly.

Finally, the new Markdown Action provides out-of-the-box markdown transformation to HTML or PDF. The latter could already be done using existing actions and external docker tool, but that one does not require any additional tool.

Cells Flows Better Usability

• New DataSelector similar to other "Queries" components, but applied to any arbitrary input (JSON) to loop over rows. It uses JSONPath to select rows inside incoming data, and can assign each row to a JsonBody or a Variable.
• New Flows Metadata provide additional usage instructions, icon, label, etc to Flows. All existing templates now use this to provide more "How To Use" instructions.
• Actions Parameters Forms better shows fields "long description" in a tooltip, for better usability.
• Hit Ctrl+S to save Flow while editing
• Inputs/Outputs Normalization: all actions that are data-oriented should provide a generic way of getting input (from a node path, as raw binary, from a variable, etc) and passing their output to the next steps.

Cells Enterprise Features

• Security Policies are now more dynamic than ever: rules' conditions can use GO-Template to make reference to the current context variables. This allows for example the usage of the current user login as a comparison value to show/hide some data.
• Override any internal action behavior: a new configuration section provides the ability to change the generic behavior of any actions, a.k.a the context in which they are displayed or not.

Other Minor Fixes

• Updated Markdown Viewer for more Markdown extension support. In Source Editor, the split-screen between the Source and the Markdown preview can now be resized.
• Fixed a regression that prevented unknown files from being opened with any user-chosen editor
• Fixed many glitches in the generic Form library

Change log

You can find a summary of the change log here.

Feature Release

This new release brings many improvements, both under the hood and for the end users.

Welcome Go 21!

The binaries are now built using Go21, and this breaks compatibility with Go19: make sure to update your toolchain!

It allowed us to update a couple of dependencies in the meantime, including CaddyServer and QUIC.

Public Links Direct Download

Accessing programmatically to a file shared via a Public Link (as a file or inside a shared folder) was previously sub-optimal, as one had to guess the shared workspace "slug" and create a token to build the download URL. We added a WebDAV layer served at https://yourdomain/public/{unique-hash}/dav/ to provide simpler access.

If the link is fully public, the GET request can be sent as is, with the path to the file, e.g. https://yourdomain/public/{unique-hash}/dav/my-shared-photo.jpg .

If it is password-protected, use a Basic-Authentication header, setting anything as the username, and the link password as the password.

Cells Enterprise Improvements

Cells Flows

Our no-code workflow engine ships many new interesting features, actions, and templates:

• Persist ACL Action did not correctly report errors
• Anko ListPolicyGroups function had a filter typo
• New Template for changing a user identifier inside all services
• New User Load Permissions actions for export/reporting purposes
• Flow-level parameters now support more field types (same as metadata types), allowing to building rich forms for webhooks.
• Usermeta Update action properly update "Tags" fields known values.
• Webhooks buttons should be disabled if corresponding job is inactive

Storage Reporting More Accurate

Locally stored DAO (BoltDB/Bleve) correctly reports their disk usage, and this is now aggregated and displayed in the Audit > Storage dashboard.

Minor Fixes

• Metadata grouping feature introduced in previous version was improved: groups are supported in the search engine, and groups expand/collapse status is remembered locally in the browser.
• Fixed various scrolling issues
• [Ent] SFTP Gateway: failed to download files when using FileZilla client
• [Ent] Fixed missing audit logs in some places
• [Ent] Cannot edit "Site" value for native connector
• [Ent] A clearer message is shown when the license is expired
• [Ent] Security Policies rules editor had glitches

Change log

You can find a summary of the change log here.

Hotfix Release

Fix annoying Search Engine UX issue when dealing with specific metadata types

Change log

You can find a summary of the change log here.

Bugfix Release

This feature release includes many interesting improvements, as well as a traditional batch of bug fixes.

Features

Files and Metadata

• Metadata Grouping: User metadata fields can now be grouped into categories and subcategories, which can improve the display when defining a large number of them.
• Memory Footprint Improvement: The memory footprint has been significantly improved during the synchronization of large structured data sources (-25% memory usage).
• Mounted FS Datasource: A new environment variable has been added to allow cross-mounting of data sources. This is not recommended for production use, but it can be useful for temporarily importing data.

Cells Flows

• Import/Export Flows: Flows can now be imported and exported by directly uploading and downloading JSON files.
• New "Logging" Action: A new "logging" action has been added to Cells Flows, which provides advanced options such as audit logging and metrics.
• Improve GoTemplate/Anko Playground: Save edited values locally - Updated sprig library for GoTemplates functions.
• Glitches in the display of queries in Cells Flows have been fixed.
• Multiple selectors stacked on one action in Cells Flows have been fixed.

Command Line

• New command to capture structured datasource sides: A new CLI command has been added to capture both sides of a structured data source (S3 storage vs. SQL index) in a BoltDB or JSON format. This can be helpful for debugging synchronization issues.
• New command to change user login: A new CLI command has been added to change a user's login. This change will be applied to all services that use logins as keys internally.
• Improved profiling output folder names: The names of the profiling output folders have been improved.

Fixes

• GRPC Broker: The GRPC Broker no longer federates all subscribers into a single stream. Instead, it creates a separate stream for each subscription. Although it opens a bit more connections between processes, this change fixes the "stream stuck after 30s" error.
• Unclosed Stream: The unclosed stream in the NodesClient library has been fixed (PostNodesChanges).
• The hard-coded "1-hour" timeout in the resync action has been removed.
• Quota: The cache has been shortened and the i18n explanation string has been fixed.
• Material Table: The multi-selection mode has been fixed.
• Users Service: A possibly ignored error in the update user transaction has been fixed.
• A possible race condition would show an error while deleting a public link (although correctly removed)
• Mailer: fixed a button display issue in Win10+Outlook App

Change log

You can find a summary of the change log here.

Release Candidate for 4.2.6

First Release Candidate for version 4.2.6. This feature release includes many interesting improvements, as well as a traditional batch of bug fixes.

Download, test, and share your feedback! As this is an RC, it's best to test in safe environments: use it at your own risk.

Features

• Metadata Grouping: User metadata fields can now be grouped into categories and subcategories, which can improve the display when defining a large number of them.
• Memory Footprint Improvement: The memory footprint has been significantly improved during the synchronization of large structured data sources (-25% memory usage).
• New Environment Variable: A new environment variable has been added to allow cross-mounting of data sources. This is not recommended for production use, but it can be useful for temporarily importing data.
• [Cells Flows] New "Logging" Action: A new "logging" action has been added to Cells Flows, which provides advanced options such as audit logging and metrics.
• [Cells Flows] Import/Export Flows: Flows can now be imported and exported by directly uploading and downloading JSON files.
• [CLI] New Command to Capture Structured Datasource Sides: A new CLI command has been added to capture both sides of a structured data source (S3 storage vs. SQL index) in a BoltDB or JSON format. This can be helpful for debugging synchronization issues.
• [CLI] Command to Change User Login: A new CLI command has been added to change a user's login. This change will be applied to all services that use logins as keys internally.
• Improved Profiling Output Folder Names: The names of the profiling output folders have been improved.

Fixes

• GRPC Broker: The GRPC Broker no longer federates all subscribers into a single stream. Instead, it creates a separate stream for each subscription. This change seems to fix the "stream stuck after 30s" error.
• Unclosed Stream in NodesClient Library: The unclosed stream in the NodesClient library has been fixed (PostNodesChanges).
• Hard-Coded "1-Hour" Timeout in Resync Action: The hard-coded "1-hour" timeout in the resync action has been removed.
• Quota: The cache has been shortened and the i18n explanation string has been fixed.
• Material Table: The multi-selection mode has been fixed.
• Users Service: A possibly ignored error in the update user transaction has been fixed.
• [Cells Flows] Query Display Glitches: Glitches in the display of queries in Cells Flows have been fixed.
• [Cells Flows] Multiple Selectors Stacked on One Action: Multiple selectors stacked on one action in Cells Flows have been fixed.

Change log

You can find a summary of the change log here.