17 August 2014

Take Control of your Contacts

Or: Easily Transfer Contacts from an iPhone to Another and Never Lose them again.

Most of the time your contacts outlast your phone so you will always need to transfer them.

The best way to ensure you never lose your contacts is to use a free on-line mail service like gmail (or any of the major providers yahoo, hotmail etc) to keep all your contacts safe.

Simply add the account with all your contacts to your phone, most providers allow for seamless 2-way-sync, i.e. you add a contact on your phone, its saved in the cloud also and vice versa from cloud to your phone.

So now your phone just becomes a device that's looking to the cloud for all the contacts, and you never really store any contacts on the phone itself. When you get a new phone just add the account again and you will have all your contacts.

Great. But what if you didn't do this before you lost your phone. Here is how to recover contacts from an iPhone to any other phone. 

I use iExplorer by Macroplant ; they offer a free version or paid version for $40. There are probably other free apps available too. 

Using iExplorer the contacts download as a series of .vcf files. To easily upload these into gmail contacts, just combine into a single file using a cmd prompt

In gmail contacts click "More > Import" and choose the file you created.

Thanks to TTUK for the tip about concatenating vcf files.

26 July 2014

phpmyadmin mcrypt issue / Ubuntu Server 14.04 / Fixed

myphpadmin says: "The mcrypt extension is missing. Please check your PHP configuration"

apt-get purge libapache2-mod-php5 php5 
apt-get install libapache2-mod-php5 php5

sudo apt-get install php5-mcrypt
sudo php5enmod mcrypt 
sudo service apache2 restart

08 April 2014

SSRS 2008 R2 Report parameters for MySQL datasources

If you are using MySQL databases in SSRS you have to manually add the parameters.

For a date range

Manually add two parameters
@start (date/time)
@end (date/time)

Go into dataset properties
Updated the query with appropriate where clause:

e.g. WHERE table.date between @start and @end

# The system gives an error warning about defining the parameters, ignore this.

Define parameters in dataset properties
link parameter name "@start" with Parameter Value "@start" and same for @end

03 April 2014

RS-232 temp/rh logging

Setup RS-232 connection between a Rotronic temp sensor and a Rasberry Pi.

Next step is to write an integration script to import the data into a MySQL database..

18 March 2014

Fix vTiger "SMTP Connect() failed" Error

Just need to update a setting in vtigercrm/modules/Emails/class.phpmailer.php

function IsSMTP() {
$this->Mailer = "smtp";

function IsSMTP() {
$this->Mailer = "sendmail";

Thanks Nathan79

15 March 2014

Life Keeper Install Notes

Install SQL

SQL install on C:\
Data on E:\
Logs on F:\

Restore db, add logins

IIS, export the metabase to other nodes, don't use shared config
Ensure admin password is the same on all nodes

Ensure ASP.NET v4 installed (not 4.5)

SSRS Access Logs - Big Brother is Watching

T-SQL is
Use ReportServer
select * from ExecutionLog3 order by TimeStart DESC

Source here

Fix Blogger 'Seatch this site' bug

Fix with a simple HTML gadget on the layout using this code: Thanks David J. Schmidt

01 February 2014

SSH Handy Shortcuts

File/Disk Browsing
Lists summary size (-s) in Gb/Mb/Kb (-h) units for all sub-directories of the current path (./*)
# du -sh ./*

Show everything, human readable file sizes, in a list
# ls -lah

Use the | after the first command to pipe the output to the next command e.g. Show all processes with the string apache in the command
#ps | grep apache

Is a pretty handy tool if you do much work via an SSH terminal

Launch app
# screen

Detach current screen
Ctrl-a d

List screens running
# screen -ls

Reattach a single screen
# screen -R

# ifconfig
# sudo iwlist wlan0 scan

25 January 2014

Canon 350d Body for Sale - £110 + Delivery

In full working order with some typical signs of usage on the body. Overall condition is good, no faults, takes great pictures.

Canon 350d Camera body
2 batteries (Canon NB-2LH 720mAh & Jessops NBL2 630mAh)
Battery Charger Unit with UK 3 pin plug
Canon EOS DIGITAL neck strap
4GB Compact Flash card
USB cable

All you need is a Lens!

£110 + Delivery

Photos of the Camera

These photos below were taken with the Camera

Also listed on Amazon here