Current Version 3

Upcoming

Changes to LIDO schema (small version): Element Point of complex type gml now expanded to full GML type; elements LineString and Polygon removed

Fixes

Bugfix for "remove cached objects" in system administration

Bugfix in QueryTool for search fields with no label defined (XPath used instead now)

Version 3.6.3 [2016-08-08]

DwC archive generation: ABCD node Licenses will now be tranferred into an intellectualRights paragraph in the EML document if provided.

Fix/change for dbmod_oracle.py: Paging is now faster

New "reset" function for archiving: If the archiving thread is killed for some reason, this allows to reset the archiving process by removing the proc file

Version 3.6.2 [2016-07-21]

Debug output now contains INFO items on time required for SQL execution and XML creation.

Changes in DarwinCore transformation:

Transformation streamlined

IdentificationQualifier is now correctly filled from ABCD field

GatheringAgents are now ordered by sequence (if they are mapped as separate gathering persons and the sequence attribute is mapped)

If type status information are provided with a typified name, they are now assigned to the respective identification result (if no typified name is given, they are grouped and assigned to the preferred identification in the occurrence core)

Fixed the issue that one of the identifications was lost if identical scientific names were provided for both a preferred and a non-preferred identification

Fixed the issue that higherClassification contained double entries if higher taxa were provided for identifications with empty scientific name

Fixes

Bugfix in metadata retrieval for dbmod_pymssql

Duplicate slash in access point URL removed in case a slash was specified at the end of base URL

Version 3.6.1 [2016-03-14]

New experimental dbmod added for text files: Allows to publish data directly from csv files (for example, the contents of a DarwinCore archive).

DarwinCore Archives: Field higherClassification is now also filled with higher taxa that don't have a rank specified.

Fixes

Unhandled exceptions in manual query form removed (occurred when incorrect data source name or no parameter at all was given).

Bugfix for XML archiving (occurred when configuration parameter xml_retries not present in config.ini).

dbmod_pymssql2012/odbc_tsql_2012 renamed to 2012+, because they also work with SQL Server 2014.

Warning Destination hostname could not be determined removed.

Archives that have been manually moved/renamed/deleted in the file system will now be automatically removed from the Provider Software.

Mapping editor doesn't run into an exception if a mapping contains more than five elements and issues a warning instead.

In the DB structure editor, trailing $ characters in table/view names are removed for creating the alias.

Version 3.5.3 [2015-01-23]

QueryTool now uses libxml2/libxslt or 4Suite XML, whichever is installed. This allows the QueryTool to be used with Python versions later than 2.5, for which 4Suite XML is not available.

New experimental dbmod for Excel (ODBC).

Slight changes and fixes in mapping editor (pop-up window can now be closed with Return or Escape) and datasource overview of the configuration tool.

Fixes

In wrapper core for mandatory attributes: If unmapped, the respective element is now removed (used to be removed only if the mandatory attribute was mapped to an empty, i.e. NULL field).

for dbmod_odbc_tsql/dbmod_odbc_tsql_2012: In certain cases, SQL statements used to return no results for no reason. Parameters are now integrated into the statements instead of being passed separately, that fixed the issue.

CMF upgrades now also keep the static table definition.

Version 3.5.2 [2014-07-18]

Fixes

For metadata retrieval in DB package pymssql (table lists used to be empty for SQL Server 2005 installations).

Admin password removed from configuration dump in system administration.

For update hint (for the case that an installation was updated before the hint advised this).

DwC archiving

For duplicate identical identifications in the source ABCD document (used to quadruplicate the affected occurrences in the result DarwinCore archive).

EML document now also valid if some metadata elements in ABCD are empty.

Namespace prefix for ABCD 2.1 added.

Some content added to dummy files to force Winzip into extracting empty folders from the download archive.

Warning added to table setup if configured PKs/FKs do not exist in database any more.

Version 3.3.2 [2012-11-26]

Test version of new dataset inventory added: If ABCD 2.06/HISPID5 is mapped, it will list all datasets published by the web service with the respective XML/DwC archives, if present.

Bugfix: When on the DB Connection page of the config tool the Save button was pressed after the user had been logged out because of a long period of inactivity, the settings were lost. This has been fixed.

Version 3.3.1 [2012-11-09]

Archiving: Archive name is now set automatically by BioCASe; various smaller changes.

Upgrade feature changed; now possible to a schema with the same namespace. For example, an existing ABCD 2.06 schema mapping can now be upgraded to ABCD-EFG or ABCD-DNA and vice versa. More upgrade paths added.

Fixes

dbmod_odbc_tsql now lists tables of all schemas (not only dbo)

dbmod_oracle/oracle now use correct format for date/datetime conversion

base_dbmod: Bugfix for filter parameters with unicode characters (used to break the request in certain cases)

Bugfix for conversion of XML data type "date"

Version 3.3 [2012-10-04]

Archiving can now be triggered from outside the UI through a deep link (allows scheduling)

Local QueryTool: Umlauts in scientific names are now replaced with placeholder *

Version 3.2 [2012-07-09]

DarwinCore Archives fully integrated into config tool interface

Changes for XML archiving:

Log files are kept for old archives and can be viewed later even if a XML archive generation for the same file name was started, but was not finished successfully (in the past, this used to overwrite the old log file)

Log files of failed or cancelled archiving runs can be viewed later

If errors occur during archiving, the log output is less arcane now (e.g. when ceODBC is used)

Format of output changed

Fixes for page DB Structure:

DB graph generation works now also when IIS is used

No exception thrown in case there is no connection to the database

Other fixes:

Removing a schema mapping in the config tool doesn't break the Capabilities any more (PSF is updated to reflect this change)

When MySQL or Postgres is used, for Search requests the OFFSET SQL clause is used now for paging; this improves performance for harvesting large datasets considerably.

Support for DNA extension of ABCD (data model for the DNA Bank network) added

Mapping Editor shows XML Path for current element

Deleted datasources and schemas will now be moved to a recycle bin and can be restored later.

Several confirmation dialogs and smaller changes in UI.

mxODBC package (not free for academic use any more) replaced with Open Source package ceODBC

"Mapping Test" in mapping editor now uses the Query Forms, which are more reliable.

Bugs fixed:

Session management: User gets logged out only when inactive for more than 30 mins.

Bugfix for unicode characters in mapped literals.

Mapping editor: Added elements do not disappear temporarily any more.

Subversion users: BPS now can handle write-protected svn folders when removing a datasource.

Graphviz dot binary now works also when installed in a folder with a name containing spaces

Creating multiple mapping files for same namespace will be prevented now

Display issues for paths containing "\b" and "\t"

Filters combining two comparison operators that always evaluate to FALSE with OR will now be compressed correctly to FALSE, not TRUE. This prevents the Provider Software from returning any results if, for example, the filter of a Search request combines two LIKE-operators on unmapped concepts with the logical operator OR.

Version 2.5.4 [2010-09-14]

Withdrawn; changes included in version 2.6

Version 2.5.3 [2010-05-12]

Support for HISPID5 added

Bugfix CMF upgrade

Bugfix QueryTool (Stylesheet transformation error)

Version 2.5.2 [2009-10-01]

Bugfix QueryTool (Unicode conversion error)

Version 2.5.1 [2009-01-25]

Security Bugfix (database credentials removed from debug output)

Version 2.5.0 [2008-04-29]

replaced XSLT library, mx.DateTime & PyXML with 4suite & python native libraries (ElementTree, datetime). No external libraries are required anymore, just 4suite for xslt processing if you want to use the querytool (and you dont need to install the horrible libxml2 anymore)

removed all metakit lib dependencies, thereby removing the concept finder window in the configtool. To select a new concept for mapping you can list all concepts of a schema or enter the xpath to one.

Introduced a new cache directory where all temporary files go like user session data, pickled CMFs or temporary configtool files. To remove any cached files you can now simply empty this one folder!

remove many old relicts that were never used like datasource metadata, system metadata, database autodiscovery, etc (all nice features to have for a future release, but they were never implemented so far)

Use a new config singleton based on some simple ini text files. Incl a new parameter "prettyprint" to format the output nicely

When creating a new datasource you can now select template datasources like Brahms6, a training db, ABCD2.06 metadata tables or NoDIT2

Allow special mappings (TotalMatchedRecords) to be displayed and saved correctly

Fixed minor display problems with attributes

fixed a serious new bug of the configtool that does not allow to add new tables to the db structure

Allow case insensitive like searches in oracle if wanted.

The performance debug logging works again

Version 2.1.0

CMF/schema version upgrade facility integrated into the configtool. By using Altovas mapforce to graphically map 2 schemas or versions of the same schema (e.g. ABCD 1.20 to ABCD 2.0, or ABCD1.20 to DarwinCOre and vice versa), it is now possible to upgrade your datasource configuration to support similar schemas. Thanks to Synthesys!

SPICE search: bug removed with genus search including the wildcard

SPICE: empty root element returned if no result was found. Debugging as html comments output was broken - fixed!

Version 1.5

Includes the fully working version 1.0 of the config-tool to edit WCF, PSF and CMF files. Structural CMF editing is not yet supported as well as guidance for ABCD.

template subdirectories renamed. Subdir "wrapper-skeleton" now contains the skeleton for new database directories, which comes without any CMF template. CMF templates are now hosted in the config-files subdirectory.

private config directory used now for wrapper_config.xml, providerlist.xml and all other future configuration files that should be private.