CKAN extension for DCAT-AP Switzerland, templates and different plugins for opendata.swiss.

This extension is deprecated. See https://github.com/opendata-swiss/ckanext-switzerland-ng for the current code.

• CKAN 2.6+
• ckanext-scheming
• ckanext-fluent

To generate a new ckanext-switzerland.pot file use the following command:

vagrant ssh
source /home/vagrant/pyenv/bin/activate
cd /var/www/ckanext/ckanext-switzerland/
python setup.py extract_messages

Or follow the official CKAN guide at https://docs.ckan.org/en/latest/extensions/translating-extensions.html

All translations are done via Transifex. To compile the po files use the following command:

python setup.py compile_catalog

This extension currently provides two paster commands:

Datastore currently does not delete tables when the corresponding resource is deleted. This command finds these orphaned tables and deletes its rows to free the space in the database. It is meant to be run regularly by a cronjob.

paster --plugin=ckanext-switzerland ogdch cleanup_datastore -c /var/www/ckan/development.ini

This commands deletes the harvest jobs and objects per source and overall leaving only the latest n, where n and the source are optional arguments. The command is supposed to be used in a cron job to provide for a regular cleanup of harvest jobs, so that the database is not overloaded with unneeded data of past job runs. It has a dryrun option so that it can be tested what will get be deleted in the database before the actual database changes are performed.

paster --plugin=ckanext-switzerland ogdch cleanup_harvestjobs [{source_id}] [--keep={n}}] [--dryrun] -c /var/www/ckan/development.ini

The plugin implements a Swiss version of the Dcat Harvester.

The Swiss Dcat Harvester offers a validation where the data is tested against a shacl shape graph.

• the validation currently uses https://jena.apache.org/documentation/shacl/index.html
• these parameters need to be in the ckan configuration file:

ckanext.switzerland.shacl_command_path = /opt/apache-jena-3.13.1/bin/shacl
ckanext.switzerland.shacl_results_path = /home/liipadmin/shaclresults
ckanext.switzerland.shacl_shapes_path = /home/liipadmin/shaclshapes

The validation is implemented as a command:

paster --plugin=ckanext-switzerland ogdch shacl_validate {source_id} [--shapefile={shapefilename}}] -c /var/www/ckan/development.ini

The command /opt/apache-jena-3.13.1/bin/shacl from https://jena.apache.org/documentation/shacl/index.html is expected to be implemented at ckanext.switzerland.shacl_command_path

All shacl shapes are expected to be in ckanext.switzerland.shacl_shapes_path

• the default shapefile is ech-0200.shacl.ttl from https://github.com/factsmission/dcat-ap-ch-shacl

There are 3 output files written to ckanext.switzerland.shacl_results_path:

• they are gathered under a directory <harvest_source_id>
• data.ttl is the harvest source serialized as turtle
• result.ttl is the raw output of the apache-jena shacl validation command
• result.csv is a csv file with all shacl validation errors

The csv file has the following headers:

• sh_focusnode : SHACL.focusNode
• sh_path : SHACL.resultPath
• sh_severity : SHACL.resultSeverity
• sh_constraint : SHACL.sourceConstraintComponent
• sh_message : SHACL.resultMessage
• sh_detail : SHACL.resultDetail
• sh_shape : SHACL.sourceShape
• sh_value: SHACL.value
• harvest_source_id: harvest_source_id
• parseerror: parse errors that occurred

To install ckanext-switzerland:

1. Activate your CKAN virtual environment, for example:

   . /usr/lib/ckan/default/bin/activate

2. Install the ckanext-switzerland Python package into your virtual environment:

   pip install ckanext-switzerland

3. Add switzerland to the ckan.plugins setting in your CKAN config file (by default the config file is located at /etc/ckan/default/production.ini).

4. Restart CKAN. For example if you've deployed CKAN with Apache on Ubuntu:

   sudo service apache2 reload

This extension uses the following config options (.ini file)

# the URL of the WordPress AJAX interface
ckanext.switzerland.wp_ajax_url = https://opendata.swiss/cms/wp-admin/admin-ajax.php

# number of harvest jobs to keep per harvest source when cleaning up harvest objects   
ckanext.switzerland.number_harvest_jobs_per_source = 2

# piwik config
piwik.site_id = 1
piwik.url = piwik.opendata.swiss

To install ckanext-switzerland for development, activate your CKAN virtualenv and do:

git clone https://github.com/ogdch/ckanext-switzerland.git
cd ckanext-switzerland
python setup.py develop
pip install -r dev-requirements.txt
pip install -r requirements.txt

To update the Format-Mapping edit the mapping.yaml, following the YAML-Syntax. You can check if your changes are valid by pasting the contents of the required changes into a Syntax-Checker, e.g. YAML Syntax-Checker. Submit a Pull-Request following our Contribution-Guidelines.