Selected Topics (full reference)

  • Supported databases
  • Database structure
  • System requirements
  • Installation
  • Application platforms
  • Data import
  • Application customization
  • Views
  • Security
  • Molecular Laboratory (LIMS)
  • Win Mapping (GIS)
  • Web Mapping (Google/Bing)
  • Dashboards
  • Reporting
  • GBIF
  • INaturalist
  • iBOL BOLD
  • Data Package - frictionlessdata.io

Version History

23.2 (18 Aug 2023)

Locality & Location Updates

  • Additional Locality Fields
  • LocalityVisit multiple People link
  • LocalityVisit.Rain
  • LocalityVisit.TaxaCount, IndividualCount
  • LocalityVisit.Url
  • LocalityVisitTargetSpecies

Occurrence Updates & Additions

  • Additional occurrence fields (brood, genotype, birthdate, deathdate)
  • Occurrence.CurrentIdentification update fix
  • Occurrence.Diameter
  • Occurrence.Rain
  • Occurrence.Temp
  • Occurrence.Store
  • Occurrence.Sublocality
  • Occurrence.VerificationStatus on autocreate disabled

Seed & Storage Calculations Fixes

  • Seed cryo calculations
  • Seed quantity calculations fixes
  • Seed Storage Allocation calculations redesign
  • Seed storage divider calculations fixed
  • Seed viability test calculations fix
  • Task SeedQuantity DateCompleted setting fixed

Documentation & Reporting

  • Docs generation, Docs generation fixes
  • Report copies printing speed fixed
  • Report multiple copies for collection object store

Model & Data Adjustments

  • New entity: Individual
  • Organization.EORINumber
  • Person identifier model
  • Resource, ResourceIdentifier, ResourceIdentifierPerson
  • Sex enum extended with Queen, Worker
  • TaxonomicName.SeedShortLived
  • TaxonomicNameList
  • TemperatureRegime.AfterRipening added

System & Technical Adjustments

  • Blazor anonymous login
  • Query builder improvements, grid options, exporting
  • SQL datasource timeout

Miscellaneous

  • Checklist model, CheckListItem log fields
  • Easytest config
  • GBIF checklist, GBIF publish fixes for occurrence
  • GBIF publishing fixes, GBIF publishing: checklist
  • ISS, ISS removed
  • ListView data access mode UI switch
  • Store collection objects stores aggregated removed
  • Store container counting tweak
  • Store.DisplayName update optimized
  • Store.UpdateDisplayName returned
  • Transaction object count fixed
  • Transaction.Purpose assignment from Transfer fixed
  • Transfer and Transaction Purpose Other appearance rule fixed

23.1 (19 Mar 2023)

Collection Objects

  • CollectionObject Active, Cryo, Base locations calculated fields added
  • CollectionObject LastAcceptedTest
  • CollectionObject null ref check
  • CollectionObject seed sampling quantities limits settings added
  • CollectionObject viability test prohibited warning
  • CollectionObject.GermplasmType (Term)
  • CollectionObject.IsQuarantined inheritance
  • CollectionObject.NumberOfSamples .ParentConsignment
  • CollectionObject.OriginalDateStored (calculated from CollectionObjectStore.Date)
  • CollectionObject.OtherId1
  • CollectionObject.OtherId2
  • CollectionObject.RemovedFromActiveManagement fields
  • CollectionObject saving optimization
  • CollectionObject.UpdateThumbnail check for empty is added
  • CollectionObject.ViabilityTest special handling on save
  • CollectionObject: CultivatedCollector, CultivatedOrganization fields added
  • CollectionObjectBatch.Collection
  • CollectionObjectStore.Date
  • CollectionObjectStore validation and free space calculation
  • CollectionObjectStore.IsEmpty and simpleAction_EmptyStore

Consignment Updates

  • Additional Consignment fields
  • Consignment model fixed
  • Consignment restriction inheritance
  • Consignment saving/refreshing when child collection object is created
  • Consignment total item count
  • Consignment.LegalOwner assignment
  • Consignment,AquisitionType, LegalOwner
  • Copy department from consignment

Viability Tests

  • Viability Test delete replicates confirmation message
  • Viability test replicate validation
  • Viability test speed improvement
  • Viability test: default replicate creation and handling
  • ViabilityTest calculations
  • ViabilityTest passfail
  • ViabilityTest replicate setup
  • ViabilityTest treatments and timepoint
  • ViabilityTest validation improved

Transaction Collection Objects

  • Transaction CollectionObjects validation
  • TransactionCollectionObject cloning
  • TransactionCollectionObject nested listview records validation
  • TransactionCollectionObject noncloneable fields
  • TransactionCollectionObject Quantity AppearanceRule
  • TransactionCollectionObject seed fields
  • TransactionCollectionObject.Date autofill

Seed Calculations and Tasks

  • Seed calculations
  • Seed counting fields interaction
  • Seed object store
  • Seed quantity warnings
  • Seed store suggest

Miscellaneous

  • Web Client Mapping
  • Additional restrictions
  • Availability Status - Update When Original Date Stored Populated
  • Bionomia
  • Calculations.CalculateSentAmount
  • CustomEditorAliases
  • DataSource builder (renamed from Query)
  • Department, address autofill for Transfer, Transaction
  • Design Child Storage
  • Diagram
  • Docs generation
  • Duplicate.Store
  • EarthCapeManager application
  • Enum TransactionPurpose.Conservation added
  • Species+
  • GBIF publishing working for occurrence and images
  • GIS, Win MapProject saving when closing map window
  • Importer Beta module added
  • ImportData action added back to win project as an additional import option
  • InternalTransfer: Transaction
  • Lab model
  • LastBestTest
  • Logistics view models
  • MapControl speed up
  • Multi Storage improvements
  • New object dropdown removed lab objects
  • New object list edited
  • Organization.Department
  • Poisonous warning on consignment
  • Query builder test
  • Query builder
  • Query builder results grid
  • Query Builder settings controlled table and column list
  • Restrictions appearance rules
  • RestrictionType1 updated
  • Settings.TaskDateCompleted for all task subtypes
  • Task duration defaults
  • Task duration options
  • Task end date
  • Task navigation model
  • Task StartDate and Date Completed auto fill and settings
  • Task temp av, min, max fields added
  • Transaction and Transfer AssignedToUser2
  • Transaction.Type
  • Vernacular names
  • WebAPI objects
  • Win encrypt config connection string
  • Win Gantt Editor test
  • Zenodo publishing (collection object)

22.3 (13 Jun 2022)

Collection Objects & Sequences

  • Collection.Order
  • CollectionObject. Sequences
  • CollectionObject.Sequences and Sequence fields, sequence related objects
  • CollectionObject id generation
  • CollectionObject Importer properties: ImportedUpdateBy, ImportedUpdateOn, UpdatedByImport, ImportedBy, ImportedOn, CreatedByImport
  • CollectionObjectDamage.FungalContamination
  • CollectionObject.HasSporePrint
  • Collection Object Save and CLose, Save and New handling
  • Sequence fields
  • Sequence - CollectionObject associations
  • Sequence.DDBJ
  • Sequence and win editors for repositories links, BOLD, ENA, GenBank, Unite

Occurrence Details & Adjustments

  • Occurrence.SubstrateText
  • Occurrence.Restrictions
  • Occurrence import field attributes
  • Occurrence/Identification.TaxonomicNameId
  • Occurrence.PublicComment
  • Occurrence.Substrate
  • Occurrence.LabelText size unlimited
  • Occurrence: Pick Substrate and other Name fields

Identification Fixes and Adjustments

  • Identification.CollectionObjectInspected -> occurrence fix
  • Identification.DetailView Occurrence added
  • Identification.Occurrence populate from CollectionObjectInspected
  • Identification.IsOriginal

Importer Adjustments

  • General fixes
  • Ignore duplicates option
  • SpreadsheetImport.Errors added to import snapshot
  • fixing populating keys
  • Coordinates recalculation on import
  • Multiple records error message
  • Cell change light blue
  • AvailableFields adds occurrence if collection object
  • multiple handling improved
  • SelectFromDuplicates action added

TransactionCollectionObject Adjustments

  • TransactionCollectionObject Find Items
  • TransactionCollectionObject non cloneable fields
  • TransactionCollectionObject controller adjustment
  • TransactionCollectionObject made clonable
  • TransactionCollectionObject Set Status TargetViewSetting=Nested
  • TransactionCollectionObject view added to navigation

Miscellaneous Adjustments and Additions

  • Net 6 migration
  • New entity: LifeStage, Occurrence.LifeStage
  • Model: listview reset filter for lookups
  • TemporaryNameReason.AwaitingImport added
  • ExColl.Person
  • Transfer.ReceiptAckDate
  • TransactionDueDateExtension update
  • Document update Country from org
  • SpecialCharacters model
  • SpecialCharacters form as separate window
  • Win MapWindow pushpin re-center on update
  • LocalityVisit model
  • LocalityVisit Consignments, Documents
  • Filter by list, add objects verify
  • SpecimenType.Allotype added
  • Substrate model
  • Substrate, SubstrateQualifier
  • Term, ObjectQuality log fields missing
  • GBIF lookup taxonomy, settings. GBIFDefaultDataset
  • Win: value mouse wheel removed from TextEdit
  • TaxonomicName fields visibility
  • LoanReturn small adjustment
  • Party.FirstAddress editable
  • AD user creation
  • CurrentObject fix for InstantFeedbackView
  • Updater, admin user creation
  • Model, Rule ConsignmentExchangeAgreementMissingWarning
  • Model TransactionCollectionObject_listview
  • Model: PostalCourierService
  • Model: Identification list view
  • Transfer Assign user only for shipment
  • Type designations remove - update object

22.2 (09 Mar 2022)

  • new web client (blazor)
  • new api client (webapi)
  • CollectionObject LegalOwner settings,OwnOrganization null check emeyke

22.1 (22 Feb 2022)

Transaction Adjustments & Fixes

  • Transaction New action list fixed
  • TransactionCollectionObject.Status SetStatus action list fixed
  • Transaction item count calculation fixed for Donation
  • Transaction item count excludes cancelled and rejected
  • Transaction updates
  • TransactionCollectionObject.Transfers -> Aggregated
  • TransactionCollectionObject.MultipleCountries
  • TransactionCollectionObject.CountryUnknown=true by default
  • TransactionCollectionObject.Status enhancement (lost, returned)
  • TransactionCollectionObject.Identifiers
  • TransactionStatus.Recalled DispatchType.Email
  • TransactionPurpose.ReturnToOwner
  • TransactionDueDateExtension auto-update
  • Transaction Return polishing
  • Transaction Due date extension
  • Transactions and Transfers improvements
  • Transfer Items Count for Acquisitions and Incoming Borrows
  • Transfer.Direction
  • TransferPackage.CalcVolumetricWeight fix
  • New TransferTransactionObject
  • Borrow from Transfer fix
  • DueDateExtensionStatus

Occurrence Adjustments & Updates

  • Occurrence Update Restrictions
  • Occurrence.Tdwg lookups
  • Occurrence TDWG levels refresh and logic
  • Occurrence.Reference/Dataset/RecordSets added
  • Occurrence.AttachmentCount
  • Occurrence restrictions inheritance

CollectionObject Adjustments & Fixes

  • CollectionObject.Occurrence.Date partial date formatting fixed
  • CollectionObject.AvailabilityStatus->DisposedDonated if in Donation
  • CollectionObject.AvailabilityStatus update from TransactionCollectionObject
  • CollectionObject.ContainerVolume

Reporting Adjustments

  • Multiple copies print fix
  • Multiple copies report print fix
  • Report save document name
  • Report.Team

Person & Organization Adjustments

  • Person org dependent lookups
  • Person lookup list view filter by org
  • Organization-Person autofill fixed

Miscellaneous Adjustments & Fixes

  • Display users with access action disabled by default
  • Display user roles
  • ConsignmentDisposal.Destroyed added
  • Min, Max values model extension
  • PostalAddress text line fix
  • Grid Export text, CSV Unicode
  • Spreadhseet datatype autofill
  • MDO list view config
  • Return functionality adjustments

22.0 (10 Jan 2022)

Transaction Adjustments & Improvements

  • Transaction loan workflow and calculations
  • Transaction, consignment, shipment additional fields
  • TransactionRequestorType
  • TransactionPurpose extended
  • TransactionFamily
  • Transaction item count
  • Transaction data sheet
  • TransactionCountries and Families
  • TransactionDocuments and attachments
  • Handle empty transaction objects as acquisitions
  • Make return from within transaction objects via consignment
  • Transactions/Transfers improvement
  • Transfer packages count fix
  • Transfer returns
  • Settings add option for common id generator for transfers and transactions
  • Consignment and Shipment are now Transfer subclasses
  • Consignment restrictions approval
  • Consignment restrictions inheritance
  • Consignment Documents
  • Consignment fields
  • Team Consignment batch
  • Team transactions
  • State machine enabled
  • State machine PDF generation

CollectionObject Adjustments

  • CollectionObject.ObjectCount
  • CollectionObjectBatch fields
  • CollectionObject remember values for Accession and Availability status and preparation method
  • CollectionObject Legal Owner Country fixed
  • ColectionObject Loan status update

Occurrence Adjustments & Updates

  • Occurrence restrictions inheritance
  • Occurrence LatLong rules
  • Occurrence.CITESControlled
  • TDWG geography on occurrence
  • TDWG autofill

Logistics & Shipping Adjustments

  • Logistics improvements
  • Document generation
  • LoanReturn barcode scanning automation
  • Shipment autofill organization and address when created from transaction
  • Shipment dimensions and volumetric weight
  • Shipment packages calculations fixed

Document & Reporting Adjustments

  • DocumentType
  • DocumentStorage object
  • Win Report preview can save document as PDF to object
  • Print Multiple report copies (win)
  • State machine report

Personnel & Organization Adjustments

  • JobTitle object
  • Organization.Attention
  • Teams and TeamUsers
  • PostalAddress fields adjustments
  • PostalAddress formatting
  • PostalCourier and PostalCourierService

Miscellaneous Adjustments & Fixes

  • AD TEST installer
  • CITES fields
  • Donation and Sample transactions
  • Permit object added
  • TypeDesignation hierarchy
  • Loan additional fields
  • Settings.OwnOrganization
  • Importer ProjectObject auto association (Spreadsheet.Project)

21.8 (28 Sep 2021)

  • CollectionObject and Occurrence to replace Unit
  • CollectionObject, Occurrence, Consignment restrictions
  • Collection specific CatalogueNumber generation logic settings
  • Condition checks
  • Agreement, License, Permit Document objects
  • Transactions improvements
  • Identification object extension
  • CatalogueNumber input masks options
  • Win Client mapping libraries updated
  • CollectionObject StorageName handling
  • Deaccession and Destruction processes
  • Import Spreadsheet improvements (field matching logic settings)
  • CollectionObject Availability Status
  • State Machine module
  • TDWG geographic objects
  • Imported spreadsheet snapshot stored and linked to data
  • Collection Object damage
  • User customizable view variants
  • Connection string encryption
  • Separate installer for EasyTest client deployment

21.7 (31 Jan 2021)

  • Build pipeline improvements
  • Organization-Project links
  • MySQL lower case provider
  • Web map shows geometries
  • Active Directory Win Client dedicated installer
  • Spreadsheet improvements

20.5(6) (14 Nov 2020)

  • Middle tier application (Application Server)
  • Import Spreadhseet
  • Settings added
  • Logistics improvements (consignments, shipments, loans, borrows)
  • Doc generation
  • Core libraries updates
  • Bug fixes

20.4 (23 Apr 2020)

  • TaxonDistribution
  • DataPackage export metadata extended
  • BOLD DataPackage improvements
  • Zenodo publish speciment (experimental)
  • LocalityVisit fields added

20.3 (02 Mar 2020)

  • Web map: coloured Unit pins by UnitType
  • Web forms: grid lookup dropdowns
  • Unit tasks
  • Win: UnitTask Gantt view
  • People: Import VCF (Win only)

20.1.4 (10 Feb 2020)

  • Zenodo file upload: improved reference and metadata
  • Dataset specific view management: autolink new unit to current dataset

20.1.2 (31 Jan 2020)

  • Win Client:
    • preliminary data package export
    • Zenodo file attachment upload
    • overall performance enhancements
    • application startup time improved.
    • enhanced find panel capabilities
    • collapsible layout group option
    • custom configurable data entry wizards
  • Web Client:
    • overall performance enhancements
    • friendly URLs (e.g. /Dataset_DetailView/1e8adc1c-4875-4061-8ba4-29d5cb4aeafa/)
    • table batch editing
    • user registration from login screen

18.3.2 (29 Oct 2019)

  • GBIF Occurrence download for TaxonomicName
  • GBIF Occurrence download for Dataset
  • INaturalist observation upload

18.3.1 (30 Sep 2019)

  • Project GrSciColl download from GBIF
  • BOLD record download (beta)
  • Labbook rich text editor word wrap removed
  • Win Client GIS: converting geographical coordinate strings from several formats to decimal degrees
  • Lab Sequence object
  • Win Client list view horizontal scrolling enabled
  • Generating dataset specific unit views depending on used fields (beta)

18.3.0 (11 Sep 2019)

  • GBIF publishing via Zenodo
  • INaturalist download individual units by INatId
  • INaturalist download project to record set
  • Predefined DwC listview geodeticDatum
  • TaxonomicName: GBIF update status only
  • TaxonomicName: update parent fields
  • Tools/dataset - add contributors
  • Units: Export DwC-A from Win Client
  • Basic Search Units form
  • Dataset: publish metadata fields
  • DwC dynamicProperties configuration via model
  • DwC-A export encoded
  • Fields: Dataset.GBIFProjectCode
  • Fields: Dataset.Keywords
  • Fields: Lab PcrDnaExtract.Store
  • Fields: Locality.Type
  • Fields: Project.GbifCreatedBy
  • Fields: Unit.BoldBin, Unit.BoldSent
  • Fields: Unit.Country/State/Province/Town fields added
  • Fixed: Unit Attachment filter list
  • Fixed: Unit impossible to clear date field

18.2.7121 (1 July 2019)

  • New: GBIF dataset publishing from both platforms.
  • New: DwC-A export

18.2.7101 (18 June 2019)

  • New: Win: Rich Text Mail Merge Templates.
  • Updated: Material Transfers (loans, gifts, exchanges)
  • Updated: Material Accessions/Deaccessions

18.2.7091 (6 June 2019)

  • New: Win: Darwin Core Archive export test version.
  • New: Lab: DnaExtract.StorePosition.
  • Fixed: Win: KML export fix.
  • Attachment logic reworked.

18.2.7071 (12 May 2019)

  • Lab: information messages when dna extracts created for selected units.
  • Lab: information messages when dna extracts added to a PCR run.
  • Lab: information messages when pcr products added to a sequencing run
  • Required field values for Name fields
  • Unique field value rule for UnitID field in Units
  • New: Web mapping Get current position command.
  • New: Win mapping: new map control (beta) that uses tiles from Open Street Maps and Bing as background.
  • Fixed: CreatedBy, CreatedOn, LastModifiedBy, LastModifiedOn are not updated in certain situations

18.2.7045 (16 April 2019)

  • New: Device and DeviceMeasurement objects
  • New: Lab: SequencingRun/Arrange Plate command creates well labels for sequencing lab submission sheet
  • New: Lab: SequencingRun samples batch update
  • New: Web: Lab and Logistics (material transfer) modules added
  • New: Web: Projects are now mappable
  • New: Lab: Sequencing run is treated as Tasks with according attriburtes
  • New: Web: Image attachments gets dynamic zoom preview
  • Fixed: Import/Export (IO) menu command missing
  • Fixed: CreatedBy, CreatedOn, LastModifiedBy, LastModifiedOn fields are excluded from record cloning
  • Fixed: Win/Lab:PCR run lab book word page displayed empty under certain conditions
  • Fixed: Lab: DNAExtract default property set to Code (required by excel importer)
  • Fixed: Win/Lab: PCR runs list takes long time to load
  • Removed preventing application of older ## run on a newer database
  • SQLite database configured as default for Windows Client

18.2.6955 (15 January 2019)

  • New: Draft Win Client documentation
  • New: Skins and svg icons in Windows Client
  • New: Lab: Improved labbook/notes page including word processor (RTF) page and spreadsheet editors in Windows client
  • Fixed: "Filter list" search in DnaExtracts
  • LocalityVisit own map preview in detail view (needs configuration via model editor)
  • Windows and web UI elements documentation
  • Lab: Primer.Gene property
  • Lab: RePcr action links new PCR product to source product
  • Lab: PCR run is treated as Tasks with according attriburtes
  • ProjectContact: Author list generation includes second option
  • Documentation re-generation in test functionality (blog post)
  • 10 November 2018

  • New: **Win client: **update navigation and icons

  • New: **Localization: **Russian language resources updated
  • Fixed: ENA linkout fixed in web client

19 October 2018

  • New: Event calendar
  • New: Task management
  • New: **GBIF (DwC) **unit view variant
  • New: Excel importer with fields mapping (win, web) and folder watching (win only).
  • New: Touch UI mode for windows client optimized for touch screen
  • New: SQLite database embedded with Windows Client and used by default with new installation

27 September 2018

  • New: **Sanger sequencing **automatic plate generation.
  • New: PCR protocol data type that can be linked to PCR run. Win Client only at this point.
  • Small fixes in GBIF taxonomy import

30 August 2018

  • New: **PCR run **lab book (rich text document) page on Win client.
  • New: Sequence run (Sanger) records with a list of amplified DNA extracts
  • New: Win Client: GIS Lat/Long recalculate command added
  • New: Tab pages with list inside the form view now show amount of records in captions
  • XML export files size can be smaller due to exclusion of empty fields option
  • v18.1 Numerous minor fixes and improvements

9 February 2018

  • New: DnaExtract search by providing a list of IDs
  • New: DnaExtract Comment field added
  • New: Win Client: GIS Lat/Long recalculate command added
  • New: Store and DnaExtract: created and last modified log fields are added
  • Fixed: DnaExtract Excel import failed
  • Fixed: Locality.Length field overwritten for point geometries
  • Tip: Searching large tables

7 January 2018

  • Updated: GBIF integration - Taxonomic name type gets additional field -GBIFValidTaxonomicName. Updates automatically when GBIF name checking picks up SYNONYM status.

17 October 2017

  • New: Data import:
    • Import command for web client
    • Storing import file in the database as attachment
    • Optional import GBIF backbone taxonomy for newly created taxonomic names on import
    • Check for non-existing fields and aborting if found
  • New: Create field command for win and web clients
  • New: Save view variants under user defined names
  • New: Reporting module for web client
  • New: Home page with editable content
  • New: Remember me option at login
  • New: Database usage statistics (hidden at this point)
  • New: Base map (Google and Bing) search (geocoding).
  • New: Create new record by clicking a map (Latitude and Longitude fields are populated) for Localities, Units, and Projects
  • New: Search/lookup drop down editors
  • New: Inline editing of Unit records in web client
  • New: Table view layout (e.g. column order and visibility) cloning and saving under user defined name.
  • Fixed: Hiding actions depending on object permissions
  • Fixed: Hiding linked objects without read permissions
  • Fixed: Web dashboards creation and saving

10 August 2017

  • New: Column customization on web client (screenshot)
  • New: Ctrl+click in web client navigation to open a section in new browser tab.
  • New: Anonymous (public) login and permission configuration
  • Minor fixes

July 2017

  • New: Email module
  • New: Sequencing - "Filter list" command
  • New: Locality object updates Lat/Long fields from Geometry (WKT) on saving
  • New: Navigation items open in new browser tabs when using Ctrl+Click
  • New: All passwords are encrypted and verified using RFC 2898 algorithm. This mode is FIPS-compliant.
  • New: WKT and Lat/Long fields synced automatically. Excel import can now use just Latitude and Longitude fields instead of WKT
  • New: Register new user (Default role is assigned) and reset forgotten password at login
  • Fixed: "Show units" did not work for Habitat, Brood and Dataset objects
In This Article
Back to top Copyright (c) 2006-2023 EarthCape OY. All rights reserved.