User Tools

Site Tools


Menu

 ?

About

Basic concepts and guidelines

User Guides

For users

For mappers

Technical

Learn about Dokuwiki

admin:generate_ckan_reports

This is an old revision of the document!


Generating CKAN reports

Who is this guide for

  • Monitoring and evaluation officer who produces data for reporting
  • Editor and data officer who assist with reporting
  • Program development officer who uses site analytics data for presentation and fundraising purposes

What this guide teaches

  • How to run a BASH script which gathers reporting data from the contents stored on the ckan instance
  • How to to clone a github repository

Things to know beforehand

  • This task requires some basic programming knowledge
  • How to edit a BASH source code file
  • How to execute a BASH script
  • In order to complete this task, you will need access to the password repostory on the rattic db instance maintained by Proteus

Installing python runtime on your machine

You can download and install the latest version of python from the official python site

Cloning or downloading the library of scripts from the data_workstream repostory

Within the data_workstream repository on the OpenDevelopmentMekong github organization, many different utility scripts and other pieces of code can be found and used for several purposes.

There are two ways to download them:

  1. Download the zip file from the following link. After downloading the .zip file, please extract it to the folder of your choice.
  2. Clone the code repository using your favourite git client (advanced)

Configuring the reporting parameters

The following parameters can be configured:

  1. DATE_FROM: The initial date of the timeframe to get the reports about (e.g: 2017-06-01)
  2. DATE_TO: The final date of the timeframe to get the reports about (e.g: 2017-12-31)
  3. PRIVATE: Whether to gather private or public records (e.g: True)
  4. FILE_NAME: The filename to store the results of the script.

In order to configure this parameters, the file datasets_by_taxonomy.sh needs to be opened with a text or code editor. The variables can be found on lines 5-8.

These parameters need to be adapted prior to the execution of the script to make sure that the results contained the wished data.

Executing the script

Once configured, the script can now executed. In order to do so:

  1. Make sure the file datasets_by_taxonomy.sh has execution permissions.
  2. Get the PostgreSQL Production password from the password manager system and copy it.
  3. Run the script via the following command:
./datasets_by_taxonomy.sh POSTGRESQL_PASS

where POSTGRESQL_PASS is the password copied on step 2

admin/generate_ckan_reports.1518791261.txt.gz · Last modified: 2020/06/23 15:03 (external edit)