Ekin tertek

Installing ODK Central on Windows 10

This guide helps you to setup ODK Central on Windows 10 whereby OS specific problems are being fixed.

Manual Install

Example package with structure:

project
│   composer.json
│   ...
│
└───packagename
│   │   composer.json
│   │
│ └───src

Important

This gist is not updated. Please read the comments below.

Download latest release (currently 1.0.11) for Windows for your version of PHP and the correct format (ts or nts) from PECL
Unzip downloaded package and copy the files php_pcov.dll and php_pcov.pdb to your PHP extensions directory, e.g. C:\bin\php\php-7.4.27-Win32-vc15-x64\ext\
Modify your php.ini so that PCOV is loaded. Therefore add extension=pcov:

	SELECT d.record, d.field_name, d.value, dqr.comment, dqr.ts as `Time Raised`, u.username as `User Assigned`, dqr.response
	FROM `redcap_data` as d

	LEFT JOIN `redcap_data_quality_status` as dqs ON d.record = dqs.record AND d.field_name = dqs.field_name
	LEFT JOIN `redcap_data_quality_resolutions` as dqr ON dqr.status_id = dqs.status_id
	LEFT JOIN `redcap_user_information` as u ON dqs.assigned_user_id = u.ui_id

	WHERE
	# exclude unneeded fields
	d.field_name NOT LIKE "%_complete"

	python:
	#!/usr/bin/env python
	import requests
	data = {
	'token': '<PLEASE INSERT API TOKEN HERE>',
	'content': 'record',
	'format': 'csv',
	'type': 'flat',
	'csvDelimiter': '',
	'records[0]': '1',

	function makeThumb(page) {
	// draw page to fit into 96x96 canvas
	var vp = page.getViewport({ scale: 1, });
	var canvas = document.createElement("canvas");
	var scalesize = 1;
	canvas.width = vp.width * scalesize;
	canvas.height = vp.height * scalesize;
	var scale = Math.min(canvas.width / vp.width, canvas.height / vp.height);
	console.log(vp.width, vp.height, scale);
	return page.render({ canvasContext: canvas.getContext("2d"), viewport: page.getViewport({ scale: scale }) }).promise.then(function () {

	RewriteEngine On

	# Rewrite Rules needed for pretty URLS for the Modules API

	# Add trailing slash to all requests within /api directory
	RewriteCond %{REQUEST_URI} !(/$\|\.)
	RewriteRule (.*) %{REQUEST_URI}/ [R=301,L]

	# Route URL Query parameters to pretty URls with "endpoints" - DO NOT CHANGE THE ORDER - can break things
	RewriteRule ^v1/$ ?NOAUTH&pid=472&type=module&prefix=em_submission_module&page=module-repo-api

	# Clear Build Cache
	# https://docs.docker.com/engine/reference/commandline/builder_prune/
	$ docker builder prune

	# Remove Image
	# https://docs.docker.com/engine/reference/commandline/image_rm/
	$ docker image rm IMAGE

	# Run docker build with output to console
	# https://stackoverflow.com/a/69524819/3127170

	delete from redcap_external_module_settings
	where `project_id`= 14 and `external_module_id` = 9
	and `key` <> "enabled"