Difference between revisions of "DWB clients for beta testing"

New features and fixes:

• Datawithholding reason for contact information

• Datebase updates:
  • Update database to version 02.01.09 Datawithholding reason for contact information

Updated content

New features and fixes:

• Message for missing source of country list included

• Transaction
  • Forwarding bugfix
  • Reminder bugfix
  • Bugfix query
  • Bugfix adapting the interface when changing the type
  • Taxonomic names in letters without year
  • Bugfix for list in sending letter with type informations
  • New column MaterialSource
  • New type removal

• Table editors:
  • CollectionSpecimenReference
  • Bugfix for optimized query getting values from system table #ID (sorting)
  • Bugfix for optimized query: reset system table #ID after changing database
  • Editor for IdentificationUnitGeoAnalysis
  • Geography shown in table (read only)
  • Table editors for event method and event method parameters
  • Export to SQLite
  • Lookup tables with display values for optimized version

• Import wizard
  • Bugfixes for attachment etc.
  • Separate window to inspect schema
  • Tables CollectionSpecimenReference and ExternalIdentifier included
  • Start screen showing the current step
  • Description with display texts for values selected in interface settings

• Export wizard
  • Wizard for transaction

• Permission
  • Disabling outdated client

• Stable identifiers - Administration of basic URL and type

• Query
  • Bugfix in optimized query for missing entries
  • Additional display column Last update
  • Saving queries - beta version for optimized queries Manual
  • Including data from ReadOnly Projects noch testen, Manual

• Label
  • Printing of QR-Codes noch testen, Manual

• Archive
  • Tables CollectionSpecimenReference and ExternalIdentifier included

• Maintenance
  • Check geography - synchronize values and cached values noch testen, Manual

• Collection event
  • Query column CollectorsEventNumber added

• Export wizard
  • Tables CollectionSpecimenReference and ExternalIdentifier included
  • Webservice CatalogueOfLife 2 - bugfix adding values

• Replication
  • Tables CollectionSpecimenReference and ExternalIdentifier included
  • Tool for synchronizing RowGUIDs added noch testen, Manual

• ExternalIdentifier
  • new form for type administration

• Methods
  • ParameterID displayed

• Maintenance
  • Retrieval for TK25 coordinates for linked server included
  • Synchronization of Taxa via text: Datasource ist kept in case of error + Bugfix
  • Synchronization of Sampling plots: Using temporary table for better performance noch testen

• Cache database
  • Inclusion of DiversityAgents as datasource
  • Checking transfer filter before transfer
  • Feedback button in transfer filter form
  • Tutorial for basic steps Manual

Please create a backup of your database if you did use annotations for references and identifiers as these will be transferred into new tables. References for collection events can not be transferred and should be entered in the table CollectionEvent directly

• Database updates
  • • Version 02.05.86: ProjectDataLastChanges, ExternalIdentifierType, Transfer into ExternalIdentifierType, ExternalIdentifier, Transfer of Annotation into ExternalIdentifier, Clear AnnotationType_Enum if possible
    • Version 02.05.87: CollectionSpecimenReference + log + Trigger
    • Version 02.05.88: Transfer of Annotation into CollectionSpecimenReference, Clear AnnotationType_Enum if possible
    • Version 02.05.89: Views for ExternalIdentifier (Transaction, Event, Specimen, Unit, Part)
    • Version 02.05.90: Columns StableIdentifierBase and StableIdentifierTypeID in Table ProjectProxy, function StableIdentifier
    • Version 02.05.91: Type removal for transaction, trgDelCollectionSpecimenReference - Bugfix, column MaterialSource in table Transaction ( + log and triggers) MaterialSource in view TransactionList and in functions TransactionChildNodes, TransactionChildNodesAccess, TransactionHierarchy, TransactionHierarchyAccess, TransactionHierarchyAll
    • Version 02.05.92: New views to allow access to read only datasets: CollectionSpecimenID_AvailableReadOnly, CollectionSpecimenID_Available CollectionSpecimen_Core2
    • Version 02.05.93: New view ProjectListNotReadOnly, CollectionEventID_AvailableNotReadOnly, CollectionEvent_Core2 noch testen

• CacheDatebase updates:
  • Database
    • Version 01.00.17: Tables Agent and AgentContactInformation, procTransferAgent, procTransferAgentContactInformation noch testen
    • Version 01.00.18: IncludeInTransfer in tables AgentSource, GazetteerSource, ScientificTermSource and TaxonSynonymySource noch testen
    • Version 01.00.19: procProjectName, procUnitIDforABCD, Grant noch testen

• • Schema updates
    • Version 00.00.15: CacheCollectionSpecimenReference, procPublishCollectionSpecimenReference noch testen
    • Version 00.00.16: CacheIdentificationUnitGeoAnalysis, procPublishIdentificationUnitGeoAnalysis noch testen
    • Version 00.00.17: CacheExternalIdentifier, procPublishExternalIdentifier noch testen
    • Version 00.00.18: StableIdentifier in CacheIdentificationUnitInPart, procPublishIdentificationUnitInPart, CacheIdentificationUnit and procPublishIdentificationUnit noch testen
    • Version 00.00.19: procPublishCollectionSpecimen inclusion of ExternalDatasourceID, CacheCollectionExternalDatasource, procPublishCollectionExternalDatasource noch testen
    • Version 00.00.20: procPublishCollectionEvent: DataWithholdingReasonDate + Bugfix noch testen

• Cache database for Postgres:
  • Database:
    • Version 00.00.08: Tables Agent and AgentContactInformation noch testen

• • Schema updates:
    • Version 00.00.09: CacheCollectionSpecimenProcessing_pkey noch testen
    • Version 00.00.10: CacheExternalIdentifier, CacheIdentificationUnitGeoAnalysis, CacheCollectionSpecimenReference noch testen
    • Version 00.00.11: StableIdentifier in CacheIdentificationUnitInPart and CacheIdentificationUnit noch testen
    • Version 00.00.12: CacheCollectionSpecimenReference - bugfix, new table CacheCollectionExternalDatasource, CacheCollectionSpecimen adding ExternalDatasourceID noch testen

• • Packages
    • GUC
      • Version 5: Updated views noch testen

New features and fixes:

• Table editors:
  • Optional export of related table entries to tab separated file
  • Show names of related table entries, e.g. descriptor_name instead of descriptor_id
  • Show restricted values as combo box entries
• Document generator:
  • Enancement of MediaWiki generator: resource links and details for categorical states
  • New HTML generator for project data:
    • Descriptor trees
    • Descriptor data
    • Descriptor applicabilities
• Resource editing:
  • New functions for sorting and renumbering of resource entries
  • New menu tool bars for resources and resource variants
• Description editing:
  • New sequence import and export functions for FASTQ data format
  • New sequence import and export for sample data
• Correction of abbreviations: Nr. -> No.
• Miscellaneous error corrections

New features and fixes:

• Enhanced form "Set taxon links"
• Prevent changes in scope table for proxy links to avoid interference with quiz application
• New form "Set taxon links" to supply quiz related data
• SDD import restores original resource/resource variant structure

New features and fixes:

• Table ProjectIdentifier
• Table ProjectReference - new Column Citation
• Table editors for ProjectLicense, ProjectReference and ProjectIdentifier

• Database update to version 2.1.5: ProjectIdentifierType, -log and triggers, ProjectIdentifier, -log and triggers,

New features:

• Obsolete database column removed to avoid error logs.
• New update script for database.

New features and fixes:

• Import wizard: Bugfix importing analysis
• Insert of hierarchy after setting of genus noch testen, Manual
• Selection of Genus restricted to selected project noch testen, Manual
• Dropdownlist for selection of hierarchy expanded by rank and project noch testen, Manual
• BasionymAuthorsYear and CombiningAuthors available for zoological names noch testen, Manual
• References for synonyms and accepted names linked to DiversityReferences noch testen, Manual

• Database Updates
  • Update to database version 02.05.23: Adding BasionymAuthorsYear to table TaxonName (+ log, Trigger), Transfer of YearOfPubl into BasionymAuthorsYear for recombinations of zoological names noch testen
  • Update to database version 02.05.24: HierarchyCache - Bugfix noch testen