Aknik aknik

Script to sync a Google SpreadSheet to a Fusion Table

Save for a few legacy projects that still use Fusion Tables I don't actively use this script anymore. This update hopefully solves the OAuth issue that cropped up once Google depcricated the Client Login method used by the prior version.

As always, your mileage may vary, and I welcome someone -- Google or otherwise -- to offer a long-term maintained solution.

The following is largely cribbed from a Google example here. I try to explain some of the API settings that must be enabled in the Developer's Console and elsewhere

	https://code.google.com/p/android/issues/detail?id=32696#c5

	If you have a certificate that is not
	trusted by Android, when you add it, it goes in the personal cert store.
	When you add a cert in this personal cert store, the system requires a
	higher security level to unlock the device. But if you manage to add your
	cert to the system store then you don't have this requirement. Obviously,
	root is required to add a certificate to the system store, but it is quiet
	easy.

	function onOpen() {
	var ui = SpreadsheetApp.getUi();
	ui.createMenu('Custom functions')
	.addItem('Look up fragrance notes', 'getFragranceNotes')
	.addToUi();
	}

	function getFragranceNotes() {
	var ss = SpreadsheetApp.getActiveSpreadsheet();
	var allSheets = ss.getSheets();

	netSSID = 'testSSID' #Network name here
	iface = 'wlan0mon' #Interface name here

	dot11 = Dot11(type=0, subtype=8, addr1='ff:ff:ff:ff:ff:ff',
	addr2='22:22:22:22:22:22', addr3='33:33:33:33:33:33')
	beacon = Dot11Beacon(cap='ESS+privacy')
	essid = Dot11Elt(ID='SSID',info=netSSID, len=len(netSSID))
	rsn = Dot11Elt(ID='RSNinfo', info=(
	'\x01\x00'
	'\x00\x0f\xac\x02'

	#!/usr/bin/env python
	# -- coding: UTF-8 --
	#
	# source: https://www.4armed.com/blog/forging-wifi-beacon-frames-using-scapy/
	#
	# requires:
	# radiotap supported wifi nic/driver (frame injection) (works fine with Ralink RT2571W)
	# iwconfig $iface mode monitor
	# iw dev $iface set channel $channel
	# or

	uci set wireless.radio1.country='US'
	uci set wireless.radio1.txpower='30'
	uci set wireless.radio1.htmode='HT20'
	uci set wireless.radio1.channel='auto'
	uci set wireless.@wifi-iface[1]=wifi-iface
	uci set wireless.@wifi-iface[1].ssid='..............'
	uci set wireless.@wifi-iface[1].encryption='psk'
	uci set wireless.@wifi-iface[1].device='radio1'
	uci set wireless.@wifi-iface[1].mode='sta'
	uci set wireless.@wifi-iface[1].key='H3EUA3DkNPaCcEe4NMtM'

	To solve this open terminal and switch to root or a super user and type

	echo 'kernel.unprivileged_userns_clone=1' > /etc/sysctl.d/00-local-userns.conf

	service procps restart

	sudo pip3 install objection
	sudo apt install openjdk-8-jdk-headless zipalign aapt android-tools-adb android-tools-fastboot

	uci set wireless.radio1.country='US'
	uci set wireless.radio1.txpower='30'
	uci set wireless.radio1.htmode='HT40'
	uci set wireless.radio1.channel='auto'
	uci set wireless.@wifi-iface[1]=wifi-iface
	uci set wireless.@wifi-iface[1].ssid='.........'
	uci set wireless.@wifi-iface[1].encryption='psk2+ccmp'
	uci set wireless.@wifi-iface[1].device='radio1'
	uci set wireless.@wifi-iface[1].mode='sta'
	uci set wireless.@wifi-iface[1].key='..................'

	#/bin/ash
	# Script para openwrt ,shell ash, evitando usar bash (sin arrays)

	NUMBER=$(head /dev/urandom \| tr -dc "12345" \| head -c1)
	echo $NUMBER
	List="WLAN_ JAZZTEL_ TPLINK_ FDE- MOVISTAR_"
	W=$(echo $List \| cut -d" " -f$NUMBER)

	ifdown wwan

Aknik aknik

Script to sync a Google SpreadSheet to a Fusion Table

Create your spr