Skip to content

Instantly share code, notes, and snippets.

View google-app-script-sheets-text-to-column.js
/* lifted from http://storage.pardot.com/10212/69581/text_to_columns_script.txt */
/**
* Retrieves all the rows in the active spreadsheet that contain data and logs the
* values for each row.
* For more information on using the Spreadsheet API, see
* https://developers.google.com/apps-script/service_spreadsheet
*/
function readRows() {
var sheet = SpreadsheetApp.getActiveSheet();
var rows = sheet.getDataRange();
@HeatfanJohn
HeatfanJohn / rd.md
Created Nov 10, 2015 — forked from diego898/rd.md
Enable Concurrent Remote Desktop Users in Windows 8.1 x64
View rd.md

thanks to @neurodyne and this link for updated instructions

This works with the following versions of termsrv.dll

x64 - termsrv.dll - 6.3.9600.17095

Find Replace
39813C0600000F849E310500 B80001000089813806000090
090085C07F078BD8 090085C090908BD8
@HeatfanJohn
HeatfanJohn / profile
Created Jun 9, 2016
My NexthingCo CHIP /etc/profile
View profile
# /etc/profile: system-wide .profile file for the Bourne shell (sh(1))
# and Bourne compatible shells (bash(1), ksh(1), ash(1), ...).
if [ "`id -u`" -eq 0 ]; then
PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin"
else
PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/local/games:/usr/games"
fi
export PATH
@HeatfanJohn
HeatfanJohn / 4.4.11 Custom Kernel boot failure
Created Sep 26, 2016
4.4.11 Custom Kernel boot failure
View 4.4.11 Custom Kernel boot failure
U-Boot SPL 2015.10 (Dec 22 2015 - 20:46:00)
DRAM: 512 MiB
CPU: 1008000000Hz, AXI/AHB/APB: 3/2/2
U-Boot 2015.10 (Dec 22 2015 - 20:46:00 +0000) Allwinner Technology
CPU: Allwinner A13 (SUN5I)
I2C: ready
DRAM: 512 MiB
@HeatfanJohn
HeatfanJohn / 4.3.0 Clean boot
Created Sep 26, 2016
4.3.0 NTC CHIP Clean boot log
View 4.3.0 Clean boot
Environment size: 2921/4194300 bytes
=> printenv bootcmd
bootcmd=gpio set PB2; if test -n ${fel_booted} && test -n ${scriptaddr}; then echo (FEL boot); source ${scriptaddr}; fi; mtdparts; ubi part UBI; ubifsmount ubi0:rootfs; ubifsload $fdt_addr_r /boot/sun5i-r8-chip.dtb; ubifsload $kernel_addr_r /boot/zImage; bootz $kernel_addr_r - $fdt_addr_r
=> setenv bootcmd=gpio set PB2; if test -n ${fel_booted} && test -n ${scriptaddr}; then echo (FEL boot); source ${scriptaddr}; fi; mtdparts; ubi part UBI; ubifsmount ubi0:rootfs; ubifsload $fdt_addr_r /boot/sun5i-r8-chip.dtb.bak; ubifsload $kernel_addr_r /boot/zImage.bak; bootz $kernel_addr_r - $fdt_addr_r
## Error: illegal character '='in variable name "bootcmd=gpio"
(FEL boot)
## Executing script at 43100000
Wrong image format for "source" command
device nand0 <sunxi-nand.0>, # parts = 5
@HeatfanJohn
HeatfanJohn / NTC CHIP 4.4 Panic
Created Sep 26, 2016
NTC CHIP 4.4 Kernel Panic
View NTC CHIP 4.4 Panic
[33290.435000] fe00: 00000031 c0215618 dfe593c0 400f0093 dfe593c0 00000017 dfe593c0 400f0093
[33290.435000] fe20: 00000000 db010300 00000031 db4e7700 d8e3fc80 dfe5cc00 00000000 cf0efe58
[33290.435000] fe40: c029d0f4 c029cae8 200f0093 ffffffff 00000000 db010300 dfe593c0 dfe5c544
[33290.435000] fe60: 00000000 c029d588 00000000 400f0093 00000000 dfe5c534 00000000 c0261c54
[33290.435000] fe80: c043b9e7 200f0013 00000000 c0fba580 c0fba4bc db4c0c00 00000031 c089ea4c
[33290.435000] fea0: db4e7700 db4c0c00 db4e7744 dfe5c518 00000001 0003b920 d8e3fc80 c089ebfc
[33290.435000] fec0: cf062ac0 c0fbe828 00000000 db1f2a80 cf062d54 1eea6000 cf0eff24 c0a5f644
[33290.435000] fee0: 00000010 dfe5c534 d8e3fc80 dfe5cc00 dfe60000 00000000 00000000 d8e3fc80
[33290.435000] ff00: dfe5cc00 c0260e94 dfe5cc00 dfe5cc14 cf0ee000 dfe5cc00 d8e3fc98 dfe5cc14
[33290.435000] ff20: cf0ee000 00000008 c10b5eb4 d8e3fc80 dfe5cc00 c02611ac c0fba100 d8e3fc80
@HeatfanJohn
HeatfanJohn / install_start_stop_daemon.sh
Created Sep 29, 2016 — forked from yuuichi-fujioka/install_start_stop_daemon.sh
install start-stop-daemon to centos, fedora, redhat.
View install_start_stop_daemon.sh
#!/bin/bash
cd /usr/local/src
wget http://developer.axis.com/download/distribution/apps-sys-utils-start-stop-daemon-IR1_9_18-2.tar.gz
tar zxvf apps-sys-utils-start-stop-daemon-IR1_9_18-2.tar.gz
cd apps/sys-utils/start-stop-daemon-IR1_9_18-2
gcc start-stop-daemon.c -o start-stop-daemon
cp start-stop-daemon /usr/sbin/
View DesignWeek1_.idea_misc.xml
<?xml version="1.0" encoding="UTF-8"?>
<project version="4">
<component name="ProjectRootManager" version="2" languageLevel="JDK_1_8" default="true" project-jdk-name="1.8" project-jdk-type="JavaSDK">
<output url="file://$PROJECT_DIR$/out" />
</component>
</project>
View Pi Zero Setup
# Add the following to the bottom of /boot/config.txt
dtoverlay=dwc2
enable_uart=1
# Change /boot/cmdline.txt to:
dwc_otg.lpm_enable=0 console=serial0,115200 console=tty1 root=PARTUUID=161df949-02 rootfstype=ext4 elevator=deadline fsck.repair=yes rootwait modules-load=dwc2,g_multi
# Or for initial boot:
dwc_otg.lpm_enable=0 console=serial0,115200 console=tty1 root=PARTUUID=402e4a57-02 rootfstype=ext4 elevator=deadline fsck.repair=yes rootwait modules-load=dwc2,g_multi quiet init=/usr/lib/raspi-config/init_resize.sh splash plymouth.ignore-serial-consoles
View noip setup instructions
wget http://www.noip.com/client/linux/noip-duc-linux.tar.gz
tar xf noip-duc-linux.tar.gz
rm noip-duc-linux.tar.gz
cd noip-2.1.9-1/
make
# Use sed to add the following after #! /bin/sh in debian.noip2.sh
sed -i -f - debian.noip2.sh <<EOF
2 i\\