Release Notes for Workspaces

When the user is converting a flat file to a dataset, they have the option to select one of their suitable columns as a primary key or they can chose to let the workspace set an index column as the PK.

It is currently planned to improve the integration of the Blob store in an upcoming release.

This enhancement made a change which ensures that only users who are logged onto a VM are shown as being logged on.

The Data Ingest report can be accessed from the summary tab in the workspace or the activity tab of the dataset itself.

• Users can only see items that they have access to, based on their role.
• When the user uploads data or uses Airlock, this is shown as a full screen overlay.
• A new style is used consistently in all of the launchers.
• The actions (Airlock and Refresh) are only shown when they can be used and are only active when at least one item is selected.
• A full screen toggle button has been added which hides the Ribbon so that the user has more space to work on screen.
• In focused mode, only the selected panel is shown.
• In tabbed mode, all active panels are stacked and can be easily accessed.
•  In developer mode, three panels are shown at once. By default, the file list and R console are shown on the right hand side of the screen.
• In order to gain more working space on screen, the user can a) hide the labels in the Ribbon b) hide the Ribbon.

• • All panels which were available in the old layout have been updated except Airlock and Data Upload which are now shown as overlays.
  • Some panels which have editable data will now show a pop-out warning if the user tries to close the panel without saving any changes.
  • Panels can be maximised in any view.
  • The styling has been improved.
  • New panels open relative to the currently active panel.

Note: although Data Upload shows in an overlay, there is no functionality in the new layout; the user must revert to the classic layout to upload data.

• The breadcrumb navigation takes the user as high up the directory as the root folder, (Datafiles/Documents/Scripts).
• The list of files is ordered with folders first, then files.
• Pagination is now supported; there are a maximum of 20 items per page and a scroll bar will appear when necessary.
• A lock symbol is shown on locked files.
• The list of options in the tools menu is dependent on the user's rights and the item selected.
• The list can be refreshed using the icon in the Ribbon.
• The list can be filtered by name using the Omnisearch function.
• Sort functionality is available on `Name` and `Updated On`.

• The total number of files
• The number of files which are on display
• The number of files which are currently selected

Note: renaming a resource which is open is currently not supported

• Query -> SQL scripts
• Scripts -> R script
• Scripts -> Python scripts
• Mini-apps -> Develop mini-apps

• The data list is ordered by file name.
• Support for pagination.  There is now a maximum of 20 datasets per page and a scroll bar will appear when necessary.
• The Tools options available to the user are based on their user role.
• Refresh and Airlock functionality are supported via Ribbon Actions.
• The user can use the Omnisearch facility to filter their dataset by name.
• Navigation to another data list view does not leave the page, just changes the content of the table.
• Sort functionality available on `Name` and `Created On`.

• Updated syntax highlighting for core file types: .R, .sql, .txt, .md, .Rmd, .Rnw (in the background we also support .py, .sh)
• Option to display the editor in a Dark Theme / Change the font size / Toggle display of line numbers
• Code Completion
• Auto-indentation
• Real-time error highlighting in script editor/console
• Bracket detection
• Code folding
• Keyboard shortcuts
• Unknown variable/keyword highlighting
• Block commenting

Please send us your feedback on the editor – we are working on a knowledge base article detailing all the available functionality.

• The current Workspace name.
• Search: either searches the knowledge base or filters the Workspace list.
• User menu: displaying user's name, tenancy and profile image. New notification count will also be displayed on the profile image. The menu also gives access to:
  • Notifications
  • Profile
  • Privacy
  • Terms and Conditions
  • Feedback
  • Sign-out

• Workspace Name.
• Workspace Owner with profile image.
• The user's role within the Workspace.
• Workspace description with Rich Text markup.
• Tags – including adding/editing tags.
• Workspace Invitation controls.

The Workspace also provides a quick drop down filter to quickly filter on:

• Show All Workspaces.
• Show invited Workspaces.
• Show Workspaces in error (Tenant Admin only)

Search: either searches the knowledge base or filters the Workspace list.

Tenant Administrators will also be able to manage Workspaces and users through the new top ribbon menu instead of the now deprecated side bar. A number of features have been removed:

• Activity stream in sidebar removed.
• No Support for viewing member list.
• No support for Workspace image display in card view.

• Read
• Create/Write
• Delete

Note: this feature adjusts data in the workspace. It does not change the existing data in other columns. It adds a new index column in a dataset according to database management best practice. The user is given an informational message of this change. The user can alter the table to remove the sequence using SQL if necessary.

This change only applies when the dataset is stored in the workspace database. CSV files are not affected.

This enhancement ensures that Management API support tool actions are now audited;

• list failed tasks
• retry failed tasks
• create users e.g. tenant admin
• create tenants

The audit will include all actions and options that were supplied.

The audit will be routed to the hub workspace destination and include the logged in user.

When a user is in the Observer role, that information is now omitted as they cannot upload data to the workspace.

Contributors will receive different information from Administrators and Standard Users due to the variation in their available upload options.

Note: this does not apply at RSRCH.

The following templates will now be available:

• Blank single file (New default)
• Example single file (New)
• Dynamic plot with ggplot
• Dynamic plot with ggvis
• Blank multi-file

In both cases, the R code will be executed in an open R console. If there is no R console session, a new one will be created. These additions provide a smoother and more intuitive workflow.

The user could reload this changed data by pressing the reload button. However, if the data is sufficiently large, the reload action could conflict with the existing background loading process which was still in progress, resulting in 2 load actions corrupting the data displayed.

This bug fix stops this corruption and reloads the data cleanly.

These messages do not interrupt the display of data. Editing data will automatically dismiss the messages. A user-interrupting modal dialog will still be presented if the user loses connection to the workspace.

Suspended users are not removed from workspaces but cannot be invited into new workspaces and their roles cannot be changed within existing workspace memberships.

When a user account no longer needs to be suspended it can be re-enabled, at which point these users can access existing services.

All suspension and re-enablement actions are audited in the workspace audit log and an email notification informs the user their account has been either suspended or re-enabled.

Note that when a user's account is re-enabled they will need to re-configure their two-factor authentication security service using Duo.

This enhancement facilitates self-service management of the workspace firewall. In this release, the change affects consumers of the platform Management API, such as users of the RSRCH portal. Administrators of workspaces using the portal can open the network of their virtual desktops with up to 30 firewall rules within some constraints:

• The rules are from a pre-approved list of ports and protocols but can be to any external service.
• Only outbound connections are permitted; this means that a network connection must be initiated within the workspace and external clients cannot reach the workspace directly.
• All firewall changes are audited.
• All firewall changes are subject to monitoring and audit by hub administrators.

This is a security enhancement. At one of our hubs, multiple brute force attempts at unauthorised access to the workspace SFTP service have been observed. As a result, a configuration is being deployed to detect this kind of access and deny access from the originating internet address (IP) for a period of 30 minutes. The configuration will deny access where in a short period of time there are:

• Three attempts to authenticate a user account that doesn't exist, or
• Three attempts to authenticate a system account (root), or
• Five attempts to authenticate a user that does exist

If users experience difficulties with this configuration, Aridhia's service desk team should be contacted.

The Data Table Editor is designed to work with a specific data structure known as a 'data frame' whereby each row represents a study record and each column is an identifier, a variable or an outcome measure in that study. This allows users to manually prepare data, including:

• Editing data tables inline, in a point and click manner.
• Manually transcribing or modifying data by creating new tables directly into the workspace in cases where no alternative electronic data capture tool exists.
• Loading and editing existing data frames.

Key features of this initial Data Table Editor release include:

• Access as an integrated web workspace functionality.
• Load existing data from workspace CSV files, database tables and views.
• Load table sizes up to 10,000 rows by 100 columns.
• Create data tables from scratch.
• Set column types (integer, decimal, text, Boolean, dates and times) with in-line validation.
• Add new rows and new columns to existing data tables.
• Undo or redo of actions (up to the memory limit of the user's browser).
• Save edited data table as workspace CSV file or database table.
• Move through paginated view of data table.
• Navigate table with keyboard (arrow and tab keys etc.)
• Hide, modify and delete columns.

Future iterations are expected to feature analytical modules optimised for the biomedical field.

More detail on using the Data Table Editor can be found at knowledgebase.aridhia.io/article/using-the-data-table-editor/

Please provide feedback on performance via support@aridhia.com

Not all the Workspaces customers have implemented a Healthcare Landing Zone. In those cases, the option to upgrade a workspace with DSA functionality will not be available.