Skip to content

Instantly share code, notes, and snippets.

View slaporte's full-sized avatar

Stephen LaPorte slaporte

105 followers · 82 following
View GitHub Profile
@slaporte
slaporte / Code.gs
Created November 15, 2020 00:46
Google Apps Script to send an email (from a Doc template) based on a response to a form. Used for Wiki Loves Monuments email confirmation.
/**
* Based on: https://github.com/googleworkspace/solutions/blob/master/content-signup/src/Code.js
*/
var EMAIL_TEMPLATE_DOC_URL = 'https://docs.google.com/document/d/***/edit?usp=sharing';
var EMAIL_SUBJECT = '[Response requested] Please confirm your Wiki Loves Monuments winners';
var CC_RECIPIENTS = 'lodewijk@effeietsanders.org, erinamukuta@gmail.com'
/**
* Installs a trigger on the Spreadsheet for when a Form response is submitted.
@slaporte
slaporte / 19th_century_history_candidates
Created January 23, 2013 08:39
This file has been truncated, but you can view the full file.
title id ah_current ah_assessment_average word_count cite_count cite_journal cite_book cite_web
Hardie Gramatky 5009744 NO B 733 5 0 0 1
Harry Crosby 179529 NO B 4791 37 0 8 22
Dallin H. Oaks 183662 NO B 1842 27 0 0 6
Charles Groves Wright Anderson 826250 NO B 1469 13 0 2 7
Raid at Combahee Ferry 9350667 NO B 2158 12 0 0 0
Luther Alexander Gotwald 18199681 NO B 9822 85 0 1 0
Virginia State University 586866 NO B 2266 31 0 0 31
Battle of the Ch'ongch'on River 25558340 GA GA 8473 234 0 0 2
Bothell, Washington 151275 NO B 2258 36 0 0 11
@slaporte
slaporte / vp_trends_2020.py
Created June 26, 2020 00:11
@slaporte
slaporte / actions.md
Last active March 8, 2020 00:34

Public

  • login
  • get default series
  • get list of all series
  • add frontend error log
  • view docs
  • view report
  • logout

Organizer

@slaporte
slaporte / montage-schema.sql
Created December 27, 2019 03:27
-- MySQL dump 10.16 Distrib 10.1.41-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: tools-db Database: s53490__montage
-- ------------------------------------------------------
-- Server version 10.1.39-MariaDB
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
@slaporte
slaporte / gist:a773b4f9a7d1b7fbda62f12507eb40be
Last active April 18, 2019 06:13
WLA-round-1-2019
Filename
À_bord_d'un_méthanier.jpg
Échassier_2_en_animation_lors_du_grand_spectacle_du_cinquantenaire_de_l'église_des_martyres_de_l'Ouganda_à_Dakar_(Sénégal).jpg
Échassier_en_animation_lors_du_grand_spectacle_du_cinquantenaire_de_l'église_des_martyres_de_l'Ouganda_à_Dakar_(Sénégal).jpg
3_picou_from_3_caminhu_in_the_direction_of_Asomada_city.jpg
Activité_sportive_à_l'UAC-Bénin.jpg
Après_la_pluie_dans_une_von_d'Ayimèvo.jpg
Artiste_danseur_contemporain_lors_du_grand_spectacle_du_cinquantenaire_de_l'église_des_martyres_de_l'Ouganda_à_Dakar_(Sénégal).jpg
Artiste_danseur_imitant_le_kankourang_des_rites_Diola_lors_du_grand_spectacle_du_cinquantenaire_de_l'église_des_martyres_de_l'Ouganda_à_Dakar_(Sénégal).jpg
Artistes_acrobates_2_lors_du_grand_spectacle_du_cinquantenaire_de_l'église_des_martyres_de_l'Ouganda_à_Dakar_(Sénégal).jpg
@slaporte
slaporte / montage-import-verification.md
Last active November 9, 2018 07:01

Verifying your imports in Montage

Did you import a list of files into Montage, but do not see the right number of entries in the round? Your source list may have had some improper files names, typos, or moved/deleted files. Here is what you can do:

  • If you need to confirm the import worked at all, look at the Audit Logs (if you have permission) by visiting https://tools.wmflabs.org/montage/v1/logs/audit?round_id=<ROUND ID>&limit=100
  • Get the list of round entries in your browser at https://tools.wmflabs.org/montage/v1/admin/round/<ROUND ID>/entries or download a CSV of the round entries at https://tools.wmflabs.org/montage/v1/admin/round/<ROUND ID>/entries/download
  • Compare your source list against the round entries, using a tool like this.
    • Are any of the filenames malformed in the source list?
    • Have any of the files moved? Been deleted?
  • Do you mistakenly include a full URL?
@slaporte
slaporte / gist:f18afef811f1b7a6a0e0d1f03a849bd5
Created February 18, 2018 05:34
WLA17 - Round II (minus Egypt)
filename
Cameroon_male_plumbier_at_work_04.jpg
Formation_eleves.jpg
Selling_red_palm_oil_in_a_market.jpg
Couturière_dans_son_atelier.jpg
Mechanic_at_work_2.jpg
Ouvrier_au_travail_au_port_de_Douala_2.jpg
Carpenter_at_work_2.jpg
Une_fermière_dans_sa_ferme_avec_de_gros_poulets.jpg
Ouvriers_Routiers_14.jpg
@slaporte
slaporte / FAs.md
Last active January 23, 2018 02:42
cat_contains_1800 cat_contains_19th_century cat_contains_history infobox_contains_1800 intro_p_contains_1800 title total_history_freq
2 1 0 False True Golding Bird 0.000487995315245
1 0 2 False False Pedro Álvares Cabral 0.00181268882175
1 0 0 True True Princess Alice of Battenberg 0.000224719101124
1 0 0 True True Stan Coveleski 0.00139508928571
0 0 0 False False Bryan Gunn 0.000414651002073
1 0 0 False True Guy Bradley 0.000303398058252
0 0 0 False False Audioslave 0.000673945275644
0 0 0 False False James Robert Baker 0.00108932461874
@slaporte
slaporte / gist:4c742d9fb5e8a618a103fb969a104667
Created January 18, 2018 21:31
create-table-dump
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `complete_log` (
`complete_log_id` int(11) NOT NULL AUTO_INCREMENT,
`complete_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`lang` varbinary(8) DEFAULT NULL,
`output` varbinary(4096) DEFAULT NULL,
`run_uuid` varbinary(36) DEFAULT NULL,
PRIMARY KEY (`complete_log_id`),
KEY `complete_timestamp` (`complete_timestamp`),