oeon

// Google Apps Script for creating Google Calendar events via Fulcrum Webhooks

// replace your Fulcrum API token here
var token = "";
var createEventId = "";

function doPost(e) {
  return handleResponse(e);
}

oeon

// Google Apps Script for creating Google Calendar events via Fulcrum Webhooks

// replace your Fulcrum API token here
var token = "";
// leave createEventId as an empty string. We'll get it in createEvent()
var createEventId = "";

function doPost(e) {
  return handleResponse(e);
}

oeon

ON('change', 'routing_options', () => {
  if ($routing_options == 'google') {
    if (LATITUDE() && LONGITUDE()) {
      OPENURL('https://maps.google.com/?q=' + LATITUDE() + ',' + LONGITUDE());
    } else {
      ALERT('No location provided!', 'A location is required to show Google Maps.')
    }
    SETVALUE('routing_options', null);
  } else if ($routing_options == 'mapsme') {
    let location = CURRENTLOCATION();

oeon

this has been slightly modifed for my use cases ~joe

I've had to deal with uploading big data csv files a lot. It's a pain when you encounter timeouts and upload limits, sometimes your only choice is to split the file into smaller files.

I want to show you how to do this in 3 easy steps with the Terminal!

Splitting the file:

split -l 10000 companies.csv ./split-files/chunk-

oeon

<iframe width=100% height=100% src="https://docs.google.com/spreadsheets/d/e/2PACX-1vQvHvzsKhqm4JLIJGhBcrYrZbcKQKHFzg1CBPggQ5CsCOUcvNGYcJE_qop1dOa5VoQN7Ekb84Tqbq02/pubhtml?widget=true&amp;headers=false"></iframe>

oeon

Keybase proof

I hereby claim:

• I am oeon on github.
• I am oeon (https://keybase.io/oeon) on keybase.
• I have a public key ASBW-ZRiTH19DIblcsIb3JYMvdRsa5-xRWBdXcAPL8nnTQo

To claim this, I am signing this object:

oeon

var stop = new Date($stop_date.getFullYear(), $stop_date.getMonth(), $stop_date.getDate(), $stop_time.slice(0, 2), $stop_time.slice(3, 5), 0);
SETRESULT(stop.getTime());

oeon

var start = new Date($start_date.getFullYear(), $start_date.getMonth(), $start_date.getDate(), $start_time.slice(0, 2), $start_time.slice(3, 5), 0);
SETRESULT(start.getTime());

oeon

get source code http://trac.osgeo.org/gdal/wiki/DownloadSource let's use GDAL 1.10.1 for this example.

here's the page on BuildingOnUnix http://trac.osgeo.org/gdal/wiki/BuildingOnUnix

here's the page for MrSID / GDAL http://trac.osgeo.org/gdal/wiki/MrSID

get the DSDK from LizardTech https://www.lizardtech.com/developer/ - version I used was MrSID_DSDK-8.5.0.3422-linux.x86-64.gcc44 I made a folder /home/oeon/local/src and put it there. I also extracted my GDAL src code there.

i made a folder /home/oeon/local/gdal1101

oeon

#!/bin/bash
for file in *.csv
do
    # 1i means insert before line 1
    gsed -i 1i"animals,numbers,colors" $file
    echo "inserted header in $file!"
    gsed -i "s/^\xef\xbb\xbf//" $file
    echo "removed BOM in $file!"
done