Monday, May 26, 2014

Google Drive - Surveys and public spreadsheets

A real quick how to on setting up a spreadsheet for public editing and setting up a quick form for data entry....

Public Spreadsheet


  1. go to drive.google.com
  2. click create and make a new spreadsheet
  3. Top left will say "untitled spreadsheet" - click there and give it a name.
  4. Edit your spreadsheet as required
  5. Goto File menu then select Share...
  6. Middle of the pop-up should say "Private only me" with a link to the right "change"
  7. Click change 
  8. Change to visibility to "Anyone with the link"
  9. Change access to "can edit"
  10. Click save
  11. Click gmail icon near the top to email out the link


Forms

Sometime you want to get one-way input...  Fairly straight forward - it's less steps


  1. go to drive.google.com
  2. click create and make a new form
  3. It will pop up to ask for a title and a template
  4. Add questions for everything you want to track some tips:
    1. Make sure to pay attention to the "required question" option on each question
    2. Don't forget to ask for the name
    3. Multiple choice works even for yes/no/maybe questions as it forces one answer
  5. Click send form when finished
  6. It will ask for a email to send to and then click done.
  7. It will automatically create a spreadsheet to store all the responses



Sunday, May 25, 2014

Quickstart for IPXCore VPS

I've had an IPXcore VPS for a while.  Very happy.

Helping a friend, figured I would right down the steps to get setup as a VPN server.

1.) Subscribe to VPS, rebuild with Debian 7 Minimal.  Setup a dns name (see freedns.afraid.org is you don;t have a DNS host)

2.) Fix /etc/apt/sources.list - default uses german mirrors...

Cut and paste this into a root shell:

sed -i.bak 's/^/##/;1s/^/deb http:\/\/ftp.us.debian.org\/debian wheezy main contrib non-free\ndeb http:\/\/security.debian.org\/ wheezy\/updates main contrib non-free/' /etc/apt/sources.list

3.) Update aptitude database and any security patches...

apt-get update && apt-get upgrade

4.) Install a few required apps

apt-get install wget openssl openvpn

5.) Run the Openvpn help script from IPXCore per http://ipxkb.info/auto-install-openvpn-on-debian/

wget http://ipxcore.com/openvpn-debian-install.sh
chmod +x openvpn-debian-install.sh
./openvpn-debian-install.sh

6.) Get your keys by using scp... syntax is "scp root@x.x.x.x:/root/keys.tgz ."

Tips:

To use with Tunnelbrick on OSX, create a folder named after your vpn, extract all the files expect client1.csr from keys.tgz file into the root of the new folder (i.e. don't preserver the path /etc...).   Rename the folder and ann a ".tlbk" extension (this will convert it to a package).  Double click on the tlbk file to install profile.

[more after I test]