7.4

Note

As of version 7.4, the .Net Core platform is upgraded from net6 to net8. The default docker port is now 8080. For users on SQL Server, the minimum supported version is now SQL Server 2016.

7.4.10293

August 9th, 2024

Colectica Repository and Portal

Added

  • Portal: show FundingPeriod property

  • Portal: date facet options on search page

  • Portal: On single item type search pages, only show custom facets when they support the item type. For the all-items search page, show a message indicating the facet may only be applicable to certain types.

  • Portal: site map at /sitemap_index.xml

  • Portal allow report generation in user specified languages

  • Repository (performance) use bulk streaming item registration for registeritems and transaction commits

  • Repository migrate SQL Server compatibility level to the level of the current database

  • Repository advanced search: index grantNumber as a locator

  • Repository advanced search: index TypeOfStudy/Group

  • Elasticsearch add date range custom field

  • Elasticsearch indexer use global scoped mutex so single instance is also assured when running on linux

  • Repository CLI: option to delete set of items, or only a single item

  • Repository add health checks for minimum free disk space on log and cache drive

  • Repository settings for minimum free disk space

Changed

  • Portal: within CollectionEvents, show links to other items in lists instead of headered tables, since the CollectionEvent already has a header

  • Portal variable page: Show a table of question details, including question text, instead of just linking the question name.

  • Portal display Frequency even when it is set to a weighted frequency

  • Portal StudyUnit and DataCollection pages: show links to QualityStatements

  • Repository store current feature list in the settings table on startup

  • changed platform to net8

  • Repository simple validation of declared language tag formats

  • Elastic when building an index with no languages saved yet, include en in addition to en-US to match defaults viewed in the Portal

  • add RevisionNumber.txt to linux packages

  • Portal Interviewer Instructions page: show OtherMaterials

  • Repository security upgrade for PostgreSQL client library GHSA-x9vc-6hfv-hg8c

  • Portal trust html files installed in a theme directory

  • Portal don’t process .html page block files for markdown

  • Portal: don’t process home page custom content through Markdown renderer, to match old behavior

  • Repository add logoff user menu item when using OpenID Connect

  • Repository don’t default Microsoft logging in serilog to Informational

  • Repository error message for advanced search enabled on sql server where it is not supported

  • Repository reuse existing repository transactions in streaming commit

  • Repository send back a nice problem details to Designer when a commit fails for an unknown reason

  • Portal dataset explorer view: load variable details and statistics on-demand, to use less memory

  • Portal: show the correct language for CodeValue properties that have a controlled vocabulary assigned

  • Portal elasticsearch handle date range searches without end dates indexed

  • Portal basket details page: localized date display

  • Portal admin added a button to request full reindex on Elasticsearch

  • Portal admin only show Elasticsearch status boxes if it is enabled

Fixed

  • Portal: When showing a code list as a classification, correctly find child items

  • Portal new user email confirmation: do not require log in before marking as confirmed

  • Portal: Fix Log Off link when a home page redirect is configured

  • Repository: upgrade dependencies to address CVEs in Microsoft dependencies

  • Repository use async instead of sync Disposing of XML writer on OAI get streaming records

  • Repository ensure OAI getrecord is asynchronously flushed before returning.

  • Repository install fonts package in docker build

  • Repository require LocalJwtProvider:SymmetricSecurityKey to be at least 32 characters (up from 16) due to updated Microsoft default security requirements

  • Repository work around PostgreSQL EF migrations when installing with specified custom PostgreSQL schema name (this is an unsupported use case, but issues can be reported)

  • Repository CLI: For the export command, show correct usage message for –file option

  • Repository use correct serilog DiskLocation property name in dist appsettings

  • Portal: Show children of code lists when the code list is marked as a Copenhagen mapping classification

Colectica Designer

Added

  • Floating license server

  • Designer improve speed of local item search

  • Designer: Add editor for FundingPeriod, Add FundingPeriod to generated documentation

  • Designer code list import: support multiple languages for category labels and descriptions

  • Designer DataRelationship/LogicalRecord editor: add all Variables from a VariableGroup command

  • Handle Stata v6 (1999) types and system missing values

  • SPSS performance allow skipping some comparisons when computing if a double is defined missing

  • SPSS performance implement whole case reading and decoding, reuse case buffer, 4x speed improvement vs reading each column

  • Designer advanced command to generate a survey instrument from a dataset

  • Designer: allow Generate DDI 2 command on StudyUnits and PhysicalInstances

  • Designer Series editor: edit TypeOfGroup controlled vocabulary property

  • Designer metadata input sheet import: FrequenciesForValid FrequenciesForInvalid columns to set checkboxes

  • Designer metadata input sheet import: Additivity column to set Stock, Flow, or NonAdditive

  • Designer experimental import modified checkout, detecting differences, for INSEE

Changed

  • Designer item picker: Allow searching within parent items tagged as “ShowInItemPickerNavigation”.

  • Designer item picker: Show error message when connecting to a repository results in an error

  • Designer item picker: Remember most recently used repository and navigation item

  • Floating license server log reason for JWT validation failure

  • Designer show up to 5 decimal places for weighted frequencies

  • Designer display Frequency even when it is set to a weighted frequency

  • Summary statistic calculation: don’t compute minimum and maximum for text variables

  • Designer: for Code variables with underlying text data, consider values missing based on the CodeList

  • Data performance don’t box and unbox values when reading rows from SAS

  • Designer item picker: don’t show total number of results

  • Designer Update from File command:

    • When removing variables, also remove from VariableGroups

    • When removing variables, also remove any VariableStatistics for that variable

    • Show user changes to be made and allow them to proceed or cancel;

  • Designer group views: sort items alphabetically by label or name.

  • Designer repository configuration: trim whitespace around URL and UserName.

  • Designer: Set default GuiLanguage to “en”

  • Designer metadata import command: trim whitespace from column headers

  • Remove Application Insights from desktop apps

  • dependency updates to allow running on net8

  • Designer remove Save Report button

  • Reporting use Best text instead of Current text in most locations

  • Designer statistics calculation: use populated code list to determine whether data are valid

  • Designer code value control: Only show combobox when fallback choices are specified

  • PDF generation: for datasets with Variable Groups, only output Variables once

Fixed

  • Stata handle invalid .dta files that have duplicate code values in the value label definitions

  • Designer single controlled vocabulary control: allow removing the value

  • Designer Parameters view: add a scroll bar and organize with tabs, to give more vertical space

  • Designer assign weight variable index correctly when using single column statistics computations

  • Designer stats calculation: don’t call GetDouble for missing text values

  • Handle text declared missing values on SPSS import

  • Designer CategoryGroup pseudo-classification correspondence map editor fixes

  • Designer fix when populating a sequence containing a coded question that has no code list

Colectica for Excel

Changed

  • Remove Application Insights from desktop apps

  • Excel update installer for new pdfsharp

Colectica Workflow

Added

  • Workflow use feature flags set for the source and target repository

  • add dockerfile for workflow web

  • Workflow task runner: process items in batches, instead of all at once, to reduce memory usage

  • Workflow Processes page: include process ID as hidden span

Changed

  • Workflow use global scoped mutex so single instance is also assured when running on linux

  • Workflow task runner: log before and after calling DeleteItemsAsync

  • Workflow: configure Serilog via appsettings, and use Serilog for request logging

  • changed platform to net8

  • Workflow replication: create checkout on target repository

  • Workflow task runner: When an exception occurs getting requests, don’t continue to process requests

Colectica Questionnaires

Changed

  • Questionnaires display logic editor: don’t show expression editor dropdowns when no subjects are available. Show a message instead.

  • Remove Application Insights from desktop apps

  • dependency updates to allow running on net8

  • Questionnaires: Hide “Tokens” button in Edit Check statements.

  • Questionnaires generate paper form in all instrument languages

Fixed

  • Questionnaires search into if/then/else and loops, not just sequences, when running FindNewSequenceViewModel after edits before returning not found

  • Questionnaires don’t drill into when encountering empty CustomSequenceViewModels

  • Questionnaires when looking for updated items, allow processing when duplicate items are present in the sequence

  • Questionnaires: fix for the parameter binding window failing to launch when a Code question did not have a code list assigned

  • Questionnaires allow selecting duplicate subjects to fulfill different inputs

Colectica SDK

Added

  • SDK add funding period to funding information

  • SDK add base Description to OtherMaterial

Changed

  • Repository CLI: command to update old PhysicalInstance CustomField VariableGroup references with real references

  • Net Core target changes from net6 to net8 due to upcoming end of life for Microsoft support

  • SDK performance: use hashset in metadata update builder

  • SDK allow get best culture to be local to a given asynchronous control flow

  • SDK enable warning as errors for Model and Model.Ddi

  • SDK fix identifiable objects not calling base methods for get/remove/replace children

  • SDK fix identifiable objects not using base custom fields and user attributes

  • SDK misc override fixes

  • SDK add documentation comments to all public and protected members

  • SDK add missing or extra arguments in documentation comments

Fixed

  • SDK don’t remove updated urn’s twice on import