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: Lims2Fims, Collection, Part, Transaction, Regulations, Customize, Table editor, Maintenance regulations, Modules, Part description

New features and fixes:

• Message for missing source of country list included
• Stable identifiers - Administration of basic URL and type
• Deleting specimen with optional removal of collection events
• Copy datasets with optonal inclusion of tables
• Labelprint - warning if LabelTemplates.xslt is missing
• Bugfix setting control sizes for superior data (event, unit)
• Inclusion of end date in display text of hierarchy tree
• TK25 - updated form for getting the coordinates noch testen
• Bugfix in query of gazetteer data noch testen
• Bugfix for display of collection date in tree
• Display first method and parameter for empty analysis in tree noch testen
• Statistics - changed message and disabled controls if access to cache database is not available noch testen
• Remote source taxon names extended with typification and list information like analysis, distrbution etc.,
• Shift of coordinates in GIS editor due to changes in GoogleMaps API: Bugfix
• Customize display text of subcollection content

• Adaptions to read only projects
  • Allow annotations for read only data
  • Separate list for read only projects
  • Managing controls according to read only

• Collections
  • Display of subcollection content in tree
  • Label printing for collections

• 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
  • Document with types
  • Date supplement inculded
  • Printing documents for return: Bugfix (Wrong inclusion of display order of units) noch testen
  • Inventory: additional fields and data ranges included noch testen

• 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
  • Display row numbers noch testen
  • Removing values: Bugfix

• 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
  • Suppressing import of dependent tables if parent tables contain no data
  • Bugfix updating tables with preset column values
  • Annotations and external identifier for event, part and unit noch testen
  • Updating tables with prefixed key values (e.g. LocalisationSystem): Bugfix
  • Part description included in specimen import

• Export wizard
  • Wizard for transaction
  • Part description included in specimen and part export
  • Tables CollectionSpecimenReference and ExternalIdentifier included
  • Webservice CatalogueOfLife 2 - bugfix adding values

• Permission
  • Disabling outdated client
  • Restriction of data from projects with read only access to addition of annotations

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

• Label
  • Printing of QR-Codes

• Archive
  • Tables CollectionSpecimenReference and ExternalIdentifier included
  • Export of tables Annotation and ExternalIdentifier: Bugfix noch testen
  • Export as background process: Bugfix

• Collection event
  • Query column CollectorsEventNumber added

• Replication
  • Tables CollectionSpecimenReference and ExternalIdentifier included
  • Tool for synchronizing RowGUIDs added

• ExternalIdentifier
  • new form for type administration

• Regulations
  • new form for type administration

• Methods
  • ParameterID displayed
• Parts
  • Descriptions linked to DiversityScientificTerms
  • New material category DNA lyophilised

• 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
  • Synchronization of higher taxa: optimized performance
  • Check geography - synchronize values and cached values Manual
  • Entering regulation hints e.g according the Nagoya protocol noch testen, Manual: Maintenance regulations
  • Saving result of synchronisation with taxon sources noch testen
  • Synchronisation with linked taxa: Bugfix (tax. group has not been used for linked and local sources) noch testen
  • Synchronisation with linked taxa: Restriction to same genus and species Manual: Maintenance

• Cache database
  • Inclusion of DiversityAgents as datasource
  • Checking transfer filter before transfer
  • Feedback button in transfer filter form
  • Tutorial for basic steps
  • Transfer to Postgres in temporary table first and afterwards in primary table (avoiding empty tables)
  • Transfer of sources to Postgres restricted to source views noch testen
  • Transfer includes optional test for updates in source resp. cached data noch testen

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
    • Version 02.05.94: ProjectList including ReadOnly, new table CollectionSpecimenPartDescription + log + trigger, new column DocumentType in table TransactionDocument noch testen
    • Version 02.05.95: CollectionSpecimenID_ReadOnly - Bugfix, Descriptions for Recordbasis (as available), StableIdentifier - Bugfix noch testen
    • Version 02.05.96: Views Identification_Core2 & IdentificationUnit_Core2,GRANTs for ExternalIdentifier, CollectionSpecimenProcessingMethodParameter - RowGUID, procCopyCollectionSpecimen2 noch testen
    • Version 02.05.97: TransactionList, TransactionChildNodes, TransactionHierarchy: inclusion of DateSupplement; MaterialCategory DNA, lyophilised; ExternalIdentifierType: 2 master types - ID & Regulation; Function CollectionHierarchySuperiornoch testen
    • Version 02.05.98: CollectionSpecimenProcessing - remove default for ProcessingDate, Grants for CollectionSpecimenPartDescription noch testen

• CacheDatebase updates:
  • Database
    • Version 01.00.17: Tables Agent and AgentContactInformation, procTransferAgent, procTransferAgentContactInformation
    • Version 01.00.18: IncludeInTransfer in tables AgentSource, GazetteerSource, ScientificTermSource and TaxonSynonymySource
    • Version 01.00.19: procProjectName, procUnitIDforABCD, Grant dbo to CacheAdmin
    • Version 00.00.20: adding missing views and extending with column LogCreatedWhen to enable filter for updates: ViewAnalysis, ViewAnnotation, ViewCollection, ViewCollectionAgent, ViewCollectionEvent, ViewCollectionEventLocalisation, ViewCollectionEventProperty, ViewCollectionProject, ViewCollectionSpecimen, ViewCollectionExternalDatasource, ViewCollectionSpecimenImage, ViewCollectionSpecimenPart, ViewCollectionSpecimenProcessing, ViewCollectionSpecimenReference, ViewCollectionSpecimenRelation, ViewExternalIdentifier, ViewIdentification, ViewIdentificationUnit, ViewIdentificationUnitAnalysis, ViewIdentificationUnitGeoAnalysis, ViewIdentificationUnitInPart, ViewMetadata, ViewProcessing

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

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

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

• • Packages
    • ABCD
      • Bugfix in skript ABCD_000007_to_000008
    • FloraRaster
      • Version 4: Extendig views for analysis: ..._EndemismusFuerBayern, ..._RoteListeBayern2003, ..._RoteListeDeutschland1996, ..._SchutzsstatusInBayern, ..._Schutzverordnung, ..._VerantwortungBayerns, ..._VerantwortungDeutschlands
    • GUC
      • Version 5: Updated views

New features and fixes:

• New form "Export questionaires" for generation of description data as HTML form
  • Generate questionaires for selected descriptions and index page
  • Generate empty questionaire for new items
  • Individual adjustment of colors for HTML pages
  • Layout improved
  • Bubble help for descriptor notes, descriptor status data and statistical measures
  • Download of entered data as text file to overcome length problem with mail transfer
• Document generator
  • Individual adjustment of colors for HTML pages
• Import wizard:
  • Import of resource data improved to support re-import of review data
• Database documentation:
  • Semantic MediaWiki generator corrected
• 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 ReferenceType
• Table editors for ProjectLicense, ProjectReference and ProjectIdentifier
• Deleting empty data: Bugfixes noch testen
• Adapting form to read only access noch testen

• Database update to version 2.1.5: ProjectIdentifierType, -log and triggers, ProjectIdentifier, -log and triggers
• Database update to version 2.1.6: Change Citation in table ProjectReference into ReferenceType

New features and fixes:

• Import wizard noch testen, Manual
• Periodicals - bugfix
• Adaption to read only access noch testen
• Database updates
  • Version 02.00.08: Workbench_ISO_Language_Enum bugfix, ViewBaseURL, ViewDiversityWorkbenchModule

New features and fixes:

• Client adapted to read only access

• Database updates:
  • Version 1.0.7: Grants for editor and user

New features and fixes:

• Import wizard: Bugfix importing analysis
• Insert of hierarchy after setting of genus Manual
• Selection of Genus restricted to selected project Manual
• Dropdownlist for selection of hierarchy expanded by rank and project Manual
• BasionymAuthorsYear and CombiningAuthors available for zoological names Manual
• References for synonyms and accepted names linked to DiversityReferences Manual
• Changed display for synonyms and accepted names esp. for ignored data Manual
• Query for reference for synonyms - bugfix
• Form and menu accessibility for read only access - Bugfix noch testen

• 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