netsensei

Open Refine Tips & Tricks

Asorted commands, formula and such

This gist contains a list of tricks, commands and formula I collected while working with Open Refine.

Merging datasets based on a common key column

See this blogpost: Merging Datasets with Common Columns in Google Refine

netsensei

var urls = ['url', 'url2'];
artoo.ajaxSpider(
  function(i) {
    return urls[i];
  },
  {
    process: function(data, i) {
      var inv = $(data).find('.classname').text();
      var url = urls[i];
      return [url, inv];

netsensei

/**
 * Class GoogleMapAdjust
 *
 * Adjusts latitude & longitude coördinates by pixel offsets.
 *
 * This class takes a coordinate, converts it to a pixel value, calculates the
 * offsetted value and converts back to the coordinate.
 *
 * Primary use case: offset the center of a Google Map canvas from a marker
 * position on your map. This is useful if you don't want markers to be shown

netsensei

<?php
/**
 * Implements hook_node_view().
 * 
 * Using Taxonomy Menu and you want your breadcrumbs / active trail to follow suit?
 * This snippet will handle that so that your breadcrumbs can / might look like this:
 *  
 *   home >> term A >> subterm B >> node title
 *    
 * How to use:

netsensei

## Skeleton config file for RetroArch

# Save all save files (*.srm) to this directory. This includes related files like .bsv, .rtc, .psrm, etc ...
# This will be overridden by explicit command line options.
# savefile_directory =

# Save all save states (*.state) to this directory.
# This will be overridden by explicit command line options.
# savestate_directory =

netsensei

artoo.scrape('form#system-modules table tr:has(td input[type=checkbox]:checked)', {
	title: {sel: 'td:nth-child(2) label'},
	version: {sel: 'td:nth-child(3)'},
	description: {sel: 'td:nth-child(4)'}
}, artoo.saveCsv);

netsensei

var term = require('hypernal')()
var tablify = require('tablify').tablify
var request = require('browser-request')
var url = require('url')
var moment = require('moment')

term.appendTo(document.body)

// style fake terminal
var termEl = term.term.element

netsensei

<?php

/**
 * @file
 *  Command All Field Labels
 *
 *  Field labels can be pesky to maintain. Take control back over your field
 *  instance labels. Set field instance labels in bulk with this drush command.
 *
 *  Show a single field instance label for a specific view mode

netsensei

var gulp = require('gulp');
var concat = require('gulp-concat');
var sass = require('gulp-sass');
var minifyCss = require('gulp-minify-css');
var rename = require('gulp-rename');
var gulpBowerFiles = require('gulp-bower-files');

var paths = {
  sass: ['./scss/**/*.scss'],
  scripts: ['./app/**/*.js', './app/*.js']

netsensei

(function (root, factory) {
  'use strict';
  if (typeof define === 'function' && define.amd) {
    // AMD. Register as an anonymous module.
    define(['moment'], factory);
  } else if (typeof exports === 'object') {
    // Node. Does not work with strict CommonJS, but
    // only CommonJS-like environments that support module.exports,
    // like Node.
    module.exports = factory(require('moment'));