Google Sheets - How to grab the sheet as a CSV

                                                    Google Spreadsheets




Very quick tip to get the url for a google spreadsheet in csv format is easy.


when you are in sheets click file and then publish to the web.

copy and paste the URL given and then add /export?format=csv


Example:

https://docs.google.com/spreadsheets/d/1_svvemcpnvbsWolXs3KR0A3in8zf9U3xI6Ms9Pq_vHs/

becomes

https://docs.google.com/spreadsheets/d/1_svvemcpnvbsWolXs3KR0A3in8zf9U3xI6Ms9Pq_vHs/export?format=csv


now it's ready to be downloaded and imported in to a mysql database :)

Share remote keyboard and mouse on to your raspberry pi

This is a little heads-up for those of you (includes me) that don’t want to dedicate a mouse and keyboard to their Pi and would rather use their laptop’s mouse and keyboard. This is a bit different from running remote desktop software, since what I actually want to do is to take use of my newly installed mini LCD monitor for my Pi. Another reason for this is to keep the USB ports free. Surely there are micro wireless keyboards as well such as this one offered by Adafruit but I was not in a spending mood 

So my research ended up with installing Synergy on my Windoes 7 laptop and my Raspberry Pi. Synergy software is pretty amazing, here is what it is about:

Synergy lets you easily share your mouse and keyboard between multiple computers on your desk, and it’s Free and Open Source. Just move your mouse off the edge of one computer’s screen on to another. You can even share all of your clipboards. All you need is a network connection. Synergy is cross-platform (works on Windows, Mac OS X and Linux).

The good thing is that it is cross platform, plus it is open source. Installing it on my Windows laptop was easy. To get it on your Raspberry Pi simply use

sudo apt-get install synergy

You need to make sure it runs on startup, the Wiki on the Synergy site has some tips.

Running it is simple:

/usr/bin/synergyc --daemon YOUR_SERVER_IP

So now it acts as extended desktop, by moving the mouse all the way to the right, I can see it appear on my Raspberry Pi’s display. Even the clipboard gets transferred, so quite neat indeed.

taken from http://raspberry-pi-how.blogspot.co.uk/

Enable Crontab Logging On Raspberry Pi

Enable crontab logging in Debian Linux

By default the logging for the cron demon is not active in Debian Linux. To activate it, please open the file /etc/rsyslog.conf via

vi /etc/rsyslog.conf

and uncomment the line

# cron.*                          /var/log/cron.log

After that you need to restart rsyslog via

/etc/init.d/rsyslog restart

and you will find the cron logs in /var/log/cron.log

taken from: http://happy-coding.org/enable-crontab-logging-in-debian-linux/

Let Website Guests Notify you via SMS

Call Back Request

Name:
Number:

Simply go to https://github.com/txt3rob/SMS-PI/tree/master/PHP/Callback

Alter the following lines to suit your needs.

callback.php

Edit this and fill in the below
// Number you wish to text when you want this to send a SMS
$number = "077777777";
// Your SMSPI.co.uk HASH
$hash = "YOURSMSPIHASH";
//Website URL
$webpage = "example.com"


Everything should work fine but any issues please contact me on twitter @smspiuk or info@smspi.co.uk

Donations via PayPal are welcome to txt3rob@gmail.com

and job is a gooden!

Log Uptime

The command "uptime" you can see how long your raspberry pi is up. Shut it down, or pull the power will you trow back to zero :)

The program "uptimed" will log all the uptimes and can show the longest uptme and other time stats.

How to install?

sudo apt-get update
[enter]
sudo apt-get install uptimed
[enter]

See your uptime start with command:"uprecords"

My current stats:

Taken From:

http://raspberrypihelp.net/tutorials/55-raspberry-pi-uptime-logger

DLINK NAS - Free SMS notifications UKONLY

• Register at http://www.smspi.co.uk and get your hash.
• Log into the NAS Web UI (i.e. enter the DNS-345 IP address in a browser)
• Navigate to Management > System Management > Notifications
• Expand SMS Settings
• Check the Enable SMS Notifications checkbox
• Click Add next to SMS service provider
• Welcome: Click Next
• Step 1: Enter a name of your choice in Provider Name and copy the following URL into the SMS URLtextarea: http://www.smspi.co.uk/api/?to=Phone_number&message=Message_content&hash=what ever your hash is
• Click Next
• Step 2: Next to each URL variable, select the following options from the appropriate dropdown menus:
  • user=Username = Username
  • password=Password = Password
  • api_id=Other = Other
  • to=Phone_number = Phone number
  • text=Message_content = Message content
• Click on Finish
• Enter your mobile phone number into the field next to Phone number1((to)).
• Click Test SMS and the NAS will display an affirmation message if the settings are correct and you will receive an SMS
• Click Save Settings

Mysql Backup to Dropbox

Go to the following link to download the scripts:https://github.com/txt3rob/Dropbox-Mysql-Upload

Mysql Backup To Dropbox

This script you will need to run once manually to link to your dropbox folder.
To Run

chmod 777 backupsql.sh
./backupsql.sh

Once it's confirmed working then add it to the crontab.
Dropbox uploader script originally from - https://github.com/andreafabrizi/Dropbox-Uploader/
You will need to alter the following in backupsql.sh

MYSQLUSERNAME="USERNAME"
MYSQLPASSWORD="PASSWORD"
BACKUPPATH="/LOCALPATH/$TIMESTAMP"
DATABASE="DATABASE NAME"
DROPBOXPATH="/PATH ON DROPBOX/"

It's set to delete files older than 5 days.
You can alter this by changing the following line:

dropbox_uploader.sh delete $DROPBOXPATH/mysql_db_backup-`date +%d-%m-%y-%H --date 'now -5 days'`.bz2

For adding to the crontab you can easily use the following site to generate how often you wish for it to run
http://www.easycron.com/generator/crontab
All should be easy to work out.
Any issues please email me txt3rob@gmail.com