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 python script which gathers reporting data from the contents stored on the ckan instance
  • How to to clone a github repository
  • How to install python runtime on any platform

Things to know beforehand

  • This task requires some basic programming knowledge
  • How to edit a python source code file
  • How to execute a python 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.

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