Dan Sloane dansloane

## gist:6f20a3bc8c647fea7cf0

      
              1 file
            
          
              1 fork
            
          
                0 comments
              
            
              0 stars
            
          
                dansloane
                / gist:6f20a3bc8c647fea7cf0
            
            
              Last active
              August 29, 2015 14:02
            
              
                Install HMRC Basic PAYE Tools 2014 on Ubuntu 14.04LTS 64bit
              
          
    What I did

Download the 2014 Linux edition of the tools from here:
http://www.hmrc.gov.uk/payerti/payroll/bpt/paye-tools.htm#b
wget https://www.gov.uk/government/uploads/uploaded/hmrc/payetools-rti-14.0.14063.106-linux.zip


## im_trim.txt
When using IM trim to autocrop an image, the result includes a PNG offset.   Use +repage to fix this.

 convert inputimage.png -trim +repage outputimage.png

## gist:857f3f0f5313a487c351
adb shell ls /sdcard/gps*.trace | tr '\r' ' ' | xargs -n1 adb pull

Source: http://stackoverflow.com/a/11250068

## caxton2xero.py
#!/usr/bin/python

# caxton2xero.py
# converts a Caxton Pre-paid card statement to CSV for Xero upload
# dms/ssq/29.09.2014

# Caxton pre-paid Visa card only have 'XLS' output, which is actually HTML
# Xero can import statements using QIF or CSV in a particular format
#  http://help.xero.com/help/bankaccounts_details_importtranscsv.htm
#

## square_vid_ffmpeg.txt
# Sources
# http://hamelot.io/visualization/using-ffmpeg-to-convert-a-set-of-images-into-a-video/
# http://stackoverflow.com/a/20848224

# Tested on OS X with ffmpeg 3.0.2 via Brew
# PNG image sequence was 875x875

ffmpeg -r 25 -f image2 -s 874x874 -i paddedtofive_%05d.png
  -vcodec libx264 -crf 25
  -pix_fmt yuv420p

## ShellyCUE.vb


Global Function SetAllShellys (state As Byte)
// dms/ssq/23.10.2022: Set all Shellys to a given state
// 0 = Off
// 1 = On
// 2 = Toggle current state

	Var shellyDevice As Long := 0
	Var shellyIP[16] As Text[15] :=
	When using IM trim to autocrop an image, the result includes a PNG offset. Use +repage to fix this.

	convert inputimage.png -trim +repage outputimage.png
	adb shell ls /sdcard/gps*.trace \| tr '\r' ' ' \| xargs -n1 adb pull

	Source: http://stackoverflow.com/a/11250068
	#!/usr/bin/python

	# caxton2xero.py
	# converts a Caxton Pre-paid card statement to CSV for Xero upload
	# dms/ssq/29.09.2014

	# Caxton pre-paid Visa card only have 'XLS' output, which is actually HTML
	# Xero can import statements using QIF or CSV in a particular format
	# http://help.xero.com/help/bankaccounts_details_importtranscsv.htm
	#
	# Sources
	# http://hamelot.io/visualization/using-ffmpeg-to-convert-a-set-of-images-into-a-video/
	# http://stackoverflow.com/a/20848224

	# Tested on OS X with ffmpeg 3.0.2 via Brew
	# PNG image sequence was 875x875

	ffmpeg -r 25 -f image2 -s 874x874 -i paddedtofive_%05d.png
	-vcodec libx264 -crf 25
	-pix_fmt yuv420p


	Global Function SetAllShellys (state As Byte)
	// dms/ssq/23.10.2022: Set all Shellys to a given state
	// 0 = Off
	// 1 = On
	// 2 = Toggle current state

	Var shellyDevice As Long := 0
	Var shellyIP[16] As Text[15] :=