Skip to content

Instantly share code, notes, and snippets.

View felixlohmeier's full-sized avatar

Felix Lohmeier felixlohmeier

View GitHub Profile
@felixlohmeier
felixlohmeier / bash-refine.md
Last active April 12, 2022 05:27
How to control OpenRefine 3.3+ with cURL (and jq) in Bash scripts

How to control OpenRefine 3.3+ with cURL (and jq) in Bash scripts

tested on Fedora 32 with bash 5.0.17 and curl 7.69.1

Quick start

  1. Clone this gist
git clone https://gist.github.com/d76bd27fbc4b8ab6d683822cdf61f81d.git bash-refine
#!/bin/bash
# demo script for using json in bash script
# download links
jq_url="https://github.com/stedolan/jq/releases/download/jq-1.6/jq-linux64"
client_url="https://github.com/opencultureconsulting/openrefine-client/releases/download/v0.3.8/openrefine-client_0-3-8_linux"
openrefine_url="https://github.com/opencultureconsulting/OpenRefine/releases/download/2017-10-28-with-pr1294/openrefine-linux-2017-10-28-with-pr1294.tar.gz"
# install jq
if [ ! -f "jq" ]; then
@felixlohmeier
felixlohmeier / christmas-gifts.csv
Created February 20, 2020 20:10
jython-cross.py: OpenRefine text transform to join multi-valued cells with multi-valued cells from another project (Python / Jython)
gift recipient
lamp mary
clock noël,sørina
sweets mary,noël
wine sørina,anonymous
cheese peter
@felixlohmeier
felixlohmeier / openrefine-webserver-install.md
Last active January 17, 2024 10:14
How To Install OpenRefine on a web server with Ubuntu 22.04

How To Install OpenRefine on a web server with Ubuntu 22.04

OpenRefine is intended to be installed locally as a desktop application. Due to the client-server architecture it is also possible to install OpenRefine on a web server to share it with multiple users. This can be useful despite the missing user administration, e.g. temporarily for a workshop or permanently in a protected network.

Security warning

Can I somehow host OpenRefine for others to access ?

@felixlohmeier
felixlohmeier / lobid-gnd-reconciliation-data.csv
Last active August 19, 2019 13:13
Automate GND reconciliation for OpenRefine
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 1 column, instead of 2. in line 2.
name;beruf;ort
J. Weizenbaum;Informatiker;Berlin
Twain, Mark;Schriftsteller;
Kumar, Lalit;;
Jemand;;