5.4

Note

As of version 5.4 of Colectica desktop tools, .Net version 4.5 or higher is required and Windows XP is no longer supported. As of version 5.4.6799, .Net version 4.6.1 or higher is required for all software.

5.4.6799

Wednesday, August 1, 2018

Colectica Designer

Added

  • In multiple reference pickers, filter items by text
  • Edit the version attribute of User IDs
  • Custom Fields can now have Date values
  • Command to undeprecate a set of items
  • Command to create a branch of an item (duplicates an item and replaces it within the parent)
  • Support dcterms accessRights

Changed

  • Use .NET Framework 4.6.1
  • DDI 2 import improvements
    • Import Subjects into StudyUnits
    • Don’t add QuestionScheme to ResourcePackage so many times
    • Give names to VariableScheme and QuestionScheme
  • SPSS import
    • Sort character value labels
    • Support SPSS version 25
  • Import Stata version 15 format 119 files
  • When an NCube preview cannot be created, show a message instead of an incorrect preview
  • Links view
    • Show Variables, Questions, and other items that reference Concepts
    • Show Represented Variables that reference Questions
  • Serialize Group attributes in DDI 3.2
  • Import from Excel without relying on ADODB being installed
  • For text columns that actually have numbers, compute Min and Max values

Fixed

  • Additional French translations
  • Fix to allow selecting new items in multiple reference pickers
  • When editing a User ID, correctly mark the item as changed
  • Do not include duplicate user interfaces languages in the User Interface Language dropdown
  • All item set views now include a vertical scroll bar when necessary
  • Allow duplicating Logical Records and other child types within Studies
  • Fix error when comparing two items that cannot be found on a remote repository
  • Populate CategorySchemes used by Questions
  • Allow typing values for properties that DDI specifies as controlled vocabularies
  • When a variable that doesn’t have any stats is selected, don’t continue to show the last selection’s stats

Colectica Portal

Added

  • Show Custom Fields that use a code list for the value choices
  • API authentication via Open ID Connect
  • Show information about elastic indices in the admin area
  • Home page can be redirected to any URL via config

Changed

  • Redis is no longer a dependency
  • Improved item page styles
  • Improved page load times for large items
  • Single variable statistics
    • For variable frequencies, show both % of total and % of valid, with graphical bar for each
    • When mean and other descriptives have decimals, show up to two decimal places
  • Concordance view
    • Show tables of frequencies instead of unlabeled charts
    • When no concordance information is found, the Variables list is no longer automatically selected
    • Concordance tables are now built based on either Conceptual Variable or Represented Variable
    • Build code comparison tables based on representation type, not only variable statistics
  • Do not cache concordance tables, since the cached tables were not correctly invalidated
  • The concordance details views in explore/ and on individual variable pages are now consistent
  • Improved Markdown processing

Fixed

  • Show Custom fields on all item pages
  • Don’t include deprecated datasets in concordance tables
  • When an error occurs while loading the explore/data view, do not show the progress indicator forever
  • Correct ordering for datasets in concordance views

Colectica Repository

Changed

  • GetRepositoryStatistics returns the number of bytes used by the database

Colectica for Excel

Changed

  • Import datasets too wide for Excel into multiple sheets
  • Improve import speed

Colectica Questionnaires

Added

  • Create a PDF for an individual Sequence
  • Button to merge content from multiple languages (F12 mode only)

Changed

  • Use .NET Framework 4.6.1
  • Display error information when launching a Blaise survey fails
  • Show Custom Fields on the main question form instead of the Attributes tab
  • Autosave before opening a new instrument, not afterwards
  • Do not allow loading unsupported instruments (that is, instruments without the proper DDI structure)
  • Improved Blaise compatibility detection

Fixed

  • Don’t lock up the user interface when loading instruments
  • Correctly propagate versions of displayed items after saving
  • Always show question text in the flowchart, even when a non-default language is selected
  • Use the system language for an instrument’s default language, not en-US
  • Don’t mark items with Custom Fields as changed when the are opened
  • Don’t flash a red (invalid) banner for items with conditionals when loading a sequence

5.4.6541

Tuesday, January 9th, 2018

  • Colectica for Excel
    • Right click, Copy selected Excel cells to clipboard as a Markdown table
    • Don’t allow spaces (or other invalid excel name characters) in agency id options model
    • Much faster reading of large datasets
    • ignore exit code x666 in excel bootstrapper, newer version of vc++ redist installed
  • Colectica Questionnaires
    • New Products Colectica Questionnaires and Blaise Colectica Questionnaires
    • use SHA256CryptoServiceProvider instead of SHA256Managed for use in restricted FIPS environments
    • In expression editor, allow comparing a variable to Is{Attr} or IsNot{Attr}
    • Numeric types: only two types, Integer or Decimal; specify range and precision
    • Set maximum length of text questions; otherwise assume “OPEN” not “STRING”
    • For editing code lists, do not enter number; instead, enter category name and category label
    • Don’t show items with no name or label in the item picker
    • Watermarks for name and label entry boxes for code list
    • ensure identifiers are valid and are treated case-insensitive
    • Copy isArray across parameters when present
    • Support SET OF and SET [x] OF at the field level for enumeraions
    • Use IN operator when enumerations are a set
    • Trace inparameters back to source when determining enumeration choice type, as parameter chains aren’t currently updated always
    • Include DDI urn in type and field comments
    • Use tContinue in Statements and empty enumerations
    • Support for Roles text
    • Use HELP role for interviewer instructions
    • Use WATERMARK role for numeric ranges
    • Added time picker for Time type values
    • Update date and time expression generation
    • Don’t show value chooser in expressions when the operator is a special value (empty, dk, rf…)
    • Expand special answer choices available in expression editor
    • Don’t add LANGUAGE and ROLE settings to Blocks, only a DATAMODEL
    • Fix: better creation of dotted field names to nested blocks for expressions
    • Upgrade MahApps
    • Added filter logic completeness checks
    • Remove filter logic when incomplete
    • Option to revert filter logic when incomplete if previously valid
    • Handle AND and OR changes when removing logic groups and logic statements
    • Default combiner when adding additional logic groups and statements
    • write DDI identifier to Blaise identifier mapping files on code generation
    • Properly escape string literals in expressions
    • use tContinue with EMPTY for statements and zero length enumerations
    • in Blaise->DDI cap maximum allowed elements in a set to the enumeration size
    • in Blaise->DDI fall back to integer when min and max values clash
    • in identifier creation, Blaise reserved words are not allowable as identifiers
    • fallback to real when decimal positions are declared instead of integer
    • Updated icons, Picture to indicate question type and statement
    • In code list editor, if a name was entered, put focus on name field
    • Don’t create flowcharts with no edges.
    • Validation, “select up to” should be greater than zero and less than or equal the number of choices
    • Validation, min and max in numeric types, min should be less or equal to max
    • Optional command line argument to fetch and open a specific remote instrument
    • Edit custom fields on Questions
    • Show Instruments with updates, and update them before opening
    • Show an indicator when an item has InParameters
    • Editors for InParameter alias, description, and binding
    • Secret debug mode. Press F12 to enter Questionnaires debug mode
    • hard and soft edit checks in Blaise generation
    • changed TypeQuestionContainer to TypeChildContainer, use for any non-sequence condition
    • update OutParameter chains with new aliases and array status when a question name and code selection style changes
    • Move editcheck attribute definitions to Model.Ddi
    • for window title, use display label from vm.Item instead of construct, since different vms can be specified
    • Set corresponding AddBelow and AddAbove to null on begin add, to ensure all return paths leave valid state for next execution
    • Don’t allow cyclic nesting in scoped sequences when adding from repository, or children sequences added from repository
    • Change HasSingleChild to IsConditionalChildContainer, and check for TypeChildContainer instead of one item in the sequence
    • Use correct view models when EditItemDetails of CustomIfElseActivityViewModel
    • Plaintext condition descriptions, instead of or in addition to the expression builder
    • Create, edit, and remove repository connections
    • Show Sequence info, not Branch info, for sequences surrounded by DisplayLogic
    • new parameter chainer algorithm, remove recursion and follow higher scopes
    • Allow chainer actions to remove paths
    • new versionOf and GetReferenceableId shortcuts
    • use Best instead of Current text in instrument analyzer
    • display conditional synopsis in flowchart
    • place blocks and types in the main datamodel (allows use of automatic input parameters)
    • BuildDescriptionComments for datamodel and blocks
    • Allow Specification-only expressions
    • Implement CanPublish on BlaisePublisher, to not allow if there are spec-only or incomplete expressions
    • Show different colors and icons for spec-only and invalid expressions
    • initialize expressions in edit checks
    • remove unused input parameters when expressions change in display logic and items
    • re-initialize expression models when binding chains change
    • detect when a subject is not bound to an expression, publication check and signal in ui
    • detect code list changes in either subjects or their value source parameters
    • traverse output chains and update value representations when code lists change/version
    • warn/block blaise publication when the user only used text specification or did not complete expressions in conditions and edit checks
    • warn/block blaise publication when there are no asked questions
    • Upgrade to Caliburn 3.2 and new MaterialDesign
    • Search ItemPicker by QuestionSchemes not just QuestionGroup
    • Updating and branching out-of-date items on the design surface
    • Text boxes now grow with size of text
    • Allow editing the code value for multiple choice questions
    • In Blaise expression writer, write the Expressions human readable description as a comment above the actual expression
    • Verify Send Feedback sends the feedback
  • Colectica Designer
    • Import code lists during variable import, RedCAP style
    • Fix Blaise generation issue with re-used questions
    • Automatically remove hyphens when using DDI content for DATA MODEL, BLOCK, and TYPE names
    • Don’t include empty codes/categories in Blaise TYPE definitions
    • Split Blaise 4 and Blaise 5 code generators
    • Calculate Quartiles
    • Multi Reference custom field
    • Enforce agency id formatting rules in its text entry box in Designer
    • Default file extension for queXML
    • REDCap and queXML updates
    • Show display logic as a filter in Paper Form
    • Fix missing textbox images in Paper Form
    • show ConceptualVariableScheme in ConceptualComponentView
    • upgrade sqlite to 1.0.105.2
    • Write a questionnaire ID based on a “quexml” UserID, or otherwise randomly generated
    • editor for Question.RepresentedVariables
    • Store the SPSS format type as a UserAttribute
    • Don’t show duplicate SourceQuestions info when qstnLit is present in reports
    • Fix fonts in reports
    • 0-padding for SPSS_FMT_N variables in reports
    • set navigator node identity to the whole composite id string to show duplicate items in schemes
    • For delimited import, allow custom mapping code instead of only setting simple properties with reflection
    • Import additional, nested properties on variables (min, max, maxlength)
    • Use custom mapper to create categories for imported codes
    • Options framework for Designer addins, and show addin options editors in the ribbon
    • improved schema table generation on data readers
    • Fix french translation display in some environments
    • When Min and Max are mapped during import, don’t force the type to Numeric
    • Track the SAS StorageWidth on import
    • Support ** operator in Blaise
    • Don’t initialize new checkouts with child items
    • Default NewCheckout dialog to Series not DdiInstance
    • Calculate system missing frequencies for numeric
    • ControlConstructScheme and ControlConstructGroup editor
    • Ensure pre-configured Quality Statement templates work according to documentation
  • Colectica Portal Core
    • Improve starter templates
    • Show classification families, series, and details in Portal
    • Fix: When a type is set not to be searchable, don’t show it on the all items search page popup
    • conditional display in flowcharts
    • show External Aids and indicators on questions
    • Add css classes to property term names, so customizable tooltips can be added
    • hierarchical lists for variable lineage and concordance views
    • Allow injecting CSS and scripts into the layout via partials and ViewComponents
    • Search questions by instruction text and response domain-code list-category text
    • Option to show a combined count for QuestionItem+QuestionGrid+QuestionBlock
    • variable lineage views
    • variable page concordance view
    • admin-selectable master templates
    • Validate templates before allowing them to be selected. Show error message when a template is missing required content.
    • Show an IfElse’s Description in addition to the Code
    • <div> with id for the variable concordance tree, to make it easy to hide
    • Horizontal X axis labels on comparative chart
    • Filter /explore view by SetRoots (series) and LifeStages
    • Page the item lists in /explore
    • Choose from nested topics on the search PageNumber
    • Show selected topics in query summary, Show counts next to each search option.
    • index concepts related to QuestionItems
    • Don’t use empty site map priorities, or Google complains
    • In variable lineage view, show relationships going upward
    • Don’t load theme CSS in admin area
    • Show parent context in variable lineage and concordance views
    • Allow custom pages
    • Help and navigation links
    • Code comparison and comparative charts on ConceptualVariable page and in “concordance variables” views
    • Show ComputationItems in the flowchart
    • More divs for more flexible theming of top navigation
    • Prefer the Synopsis when available, for friendly display of conditions
    • Display info about all response domains in each dimension-item-intersection cell
    • Show response domain details even when not in tabular view
    • “Load more results” link at bottom of /explore lists
    • Show relationship custom fields
    • Improve /explore details view when not all variable have statistics
    • Don’t show chart legend when it overlaps the chart
    • Build concordance table based off PhysicalInstances, not StudyUnits
    • For box plot, don’t show x-axis label; the labels are in the legend
    • Don’t process Markdown for variable labels
    • Links to conceptual and represented variables in relationships
    • Configure whether to use line charts or bar charts for frequencies
    • Fix ordering of PhysicalInstances in grouped bar charts
    • Show File Name on Variable page
    • Show legend under the chart
    • In data extracts, only include identifier variables if at least one row has a value for that identifier
    • Show LogicalProducts and ConceptualComponents in Group and SubGroup views
    • razor view compilation
    • use Npgsql ValueGenerationStrategy instead of Npgsql ValueGeneratedOnAdd
    • Show synopsis in Portal flowchart
    • Set expirations on cookies that indicate whether tours have been displayed
    • Use a custom cookie with a rolling expiration date to track basket IDs
    • Use redis instead of Session variables to store basket info
    • Portal view for Question.RepresentedVariables
    • IDs for some elements, to make styles easier to modify with CSS
    • Extract the item page’s sidebar into an included file, so it is easy to override
    • Show OtherInterviewerInstructions
    • When searching for all item types, exclude types that are disabled in the settings
    • Show a nice message on Explore page when Javascript is turned off.
    • Portal views for ProcessingEvent, ProcessingEventScheme, ConceptualComponent, and ConceptualVariableScheme
    • Show OtherMaterials for all types
    • Portal views for all group and scheme types
    • Option for number of search results on a page
    • Show date and time in the revision history, and improve the styles
    • Indicate comments on the version of the item being displayed vs on other versions
    • StudyUnit page: show DataCollection information directly on this page. Require less clicking through to sub-pages of other item types
    • Show times in browser-local time with time tag
  • Colectica Repository and Portal
    • index userids, and allow search facets of userids
    • add support for Azure Postgresql database
    • Import fragments in batches in repository importer
    • added non-fulltext search ability to all supported databases, use non-fulltext search for UserId text types
    • upgrade Oracle managed provider and postgresql
    • Better searching in sqlite wrt Case-insensitive matching of Unicode characters
    • explicitly opt in to TLS 1.1 and 1.2
    • When populating duplicate repository metadata items, ensure duplicates are also populated in case someone is requesting the same item multiple times in one call
    • Allow nested anchor links in old portal to load child items without versions specified
  • Colectica SDK and tools
    • In PDF reports, replace DDI 2 CustomField titles with human-readable versions
    • Extension methods to set and get CustomFields
    • Upgrade to .NET 4.5
    • don’t allow control characters in multilingual strings
    • support for DDI subgroups
    • RepresentedVariableScheme, NCubeScheme in LogicalProduct
    • track parents in child item collection for better reporting
    • add Represented Variables to questions, so we can talk about common data elements
    • don’t require SimilarConcept to have a Difference of rdf:type
    • .net standard 2.0 build of Algenta.Colectica.Model
    • .net standard 2.0 build of Algenta.Colectica.Model.Ddi
    • compare dirty items by complete identifier
    • New GUI library for the SDK
    • Check KeysWithValuesInAnyAudience instead of KeysWithValues for default best culture. It is what HasValues uses
    • new set populator that gets ids for the whole set, retrieves all items, and then populates the graph
    • UserID serialization for Code