Shane Dunn ShaneDunn
ShaneDunn
/ flow_grapeweb_v301_dbw.json
Created
October 22, 2024 05:36
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [ | |
| { | |
| "id": "667fdf0f9a80a951", | |
| "type": "tab", | |
| "label": "GrapeWeb v3", | |
| "disabled": false, | |
| "info": "", | |
| "env": [] | |
| }, | |
| { |
ShaneDunn
/ download.sh
Created
July 21, 2017 02:53
Download "Largest FREE Microsoft eBook Giveaway" curl script
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| curl –compressed -sD – -L -e “http://google.com” -A “Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)” “https://blogs.msdn.microsoft.com/mssmallbiz/2017/07/11/largest-free-microsoft-ebook-giveaway-im-giving-away-millions-of-free-microsoft-ebooks-again-including-windows-10-office-365-office-2016-power-bi-azure-windows-8-1-office-2013-sharepo/” | grep -E -i “PDF” | sed -n ‘s/.*href=”\([^”]*\).*/\1/p’ |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * Logging and configuration functions adapted from the script: | |
| * 'A Google Apps Script for importing CSV data into a Google Spreadsheet' by Ian Lewis. | |
| * https://gist.github.com/IanLewis/8310540 | |
| * @author [email protected] (Ian Lewis) | |
| * @author [email protected] (Shane Dunn) | |
| * De Bortoli Wines July 2017 | |
| */ | |
| /* =========== Globals ======================= */ | |
| /** |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * Logging and configuration functions adapted from the script: | |
| * 'A Google Apps Script for importing CSV data into a Google Spreadsheet' by Ian Lewis. | |
| * https://gist.github.com/IanLewis/8310540 | |
| * @author [email protected] (Ian Lewis) | |
| * @author [email protected] (Shane Dunn) | |
| * De Bortoli Wines July 2017 | |
| */ | |
| /* =========== Globals ======================= */ | |
| var CONFIG_SHEET = 'Configuration'; |
ShaneDunn
/ fill_weight_adjust_doc.gs
Last active
June 30, 2017 05:13
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* =========== Setup Menu ======================= */ | |
| /** | |
| * Create a Menu when the script loads. Adds a new csvconfig sheet if | |
| * one doesn't exist. | |
| */ | |
| function onOpen(e) { | |
| var ui = SpreadsheetApp.getUi(); | |
| // Or DocumentApp or FormApp. | |
| ui.createMenu('DBW Menu') | |
| .addItem('Weight Adjustment Report', 'createReport') |
ShaneDunn
/ update_calendar.gs
Created
February 4, 2017 07:49
A google script to take spreadsheet events (a Football Draw) and load them into the google Calendar
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //add a menu when the spreadsheet is opened | |
| function onOpen() { | |
| var ui = SpreadsheetApp.getUi(); | |
| // Or DocumentApp or FormApp. | |
| ui.createMenu('Calendar Menu') | |
| .addItem('Update Calendar', 'pushToCalendar') | |
| .addToUi(); | |
| } | |
| //push new events to calendar |
ShaneDunn
/ load_old_ncc_data.gs
Last active
November 13, 2016 00:59
A script to automate data load from existing National Cold Call spreadsheet.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * == A script to automate data load from existing National Cold Call spreadsheet. == | |
| * | |
| * Adapted from and using the logging and configuration functions from the script: | |
| * 'A Google Apps Script for importing CSV data into a Google Spreadsheet' by Ian Lewis. | |
| * https://gist.github.com/IanLewis/8310540 | |
| * @author [email protected] (Ian Lewis) | |
| * @author [email protected] (Shane Dunn) | |
| * De Bortoli Wines Nov 2016 | |
| */ |
ShaneDunn
/ visched_api_access.sh
Last active
June 29, 2016 02:18
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| curl -H "Content-Type: application/json" -X POST -d '{"authentication": {"username": "sdun","password": "xxxx"},"call": {"library": "dbgmvint.p", "procedure": "getVintage"}}' http://visched-dev.debortoli.private:3000/qad | |
| curl -H "Content-Type: application/json" -X POST -d '{"authentication": {"username": "****","password": "****"},"call": {"library": "dbgmblock.p","procedure": "getSingleBlockDetail", "filters": [{"procedure": "getSingleBlockDetail", "block_ids": [337, 339, 1150]}]}}' http://visched-dev.debortoli.private:3000/qad | |
| curl -H "Content-Type: application/json" -X POST -d '{"authentication": {"username": "****","password": "****"},"call": {"library": "dbgmblock.p","procedure": "setActualBlockTest", "action": [{"procedure": "setActualBlockTest", "block_id": 337, "date": "2015-01-05", "sequence": 43200, "source": "V"}]}}' http://visched-dev.debortoli.private:3000/qad | |
| curl -H "Content-Type: application/json" -X POST -d '{"authentication": {"username": "****","password": "****"},"call": {"library": "dbgmb |