David Wilkie dwilkie

dwilkie / .gitignore

Last active May 21, 2024 17:17

Bulk Download all Invoices from Wave

dwilkie / twiml.xml

Last active July 12, 2024 14:54

	<Response>
	<Say voice="Polly.Aditi">Hello</Say>
	</Response>

dwilkie / record.xml

Created April 3, 2024 15:25

TwiML record

	<Response>
	<Say voice="Polly.Russell">Hi Jen please leave a message after the beep</Say>
	<Record action="https://somleng-recordings.free.beeceptor.com"/>
	</Response>

dwilkie / rayo.md

Created January 30, 2024 07:16

Rayo Commands

Start FreeSWITCH Console

$ fs_cli -p secret

dwilkie / tcpdump.sh

Last active January 24, 2024 13:27

Docker tcpdump

	sudo docker run -it --rm --net container:59da80a76475 nicolaka/netshoot # Replace 59da80a76475 with the running container ID
	tcpdump -Xvv -i eth0 -s0 -w capture.pcap
	curl -F "[email protected]" https://file.io

dwilkie / import_stories.rb

Last active January 14, 2022 11:45

Import UNICEF IF Workplan into Pivotal Tracker

	## import_stories.rb

	# Imports stories from the UNICEF Workplan into Pivotal Tracker from CSV file.

	### CSV file format

	# Export the UNICEF worklplan as CSV.

	### Usage

dwilkie / import_contacts.rb

Last active December 9, 2021 08:51

Import contacts into SCFM

	## import_contacts.rb

	# Imports contacts into SCFM from CSV file.

	### CSV file format

	# CSV File must have a `phone_number` or `telephone_number` column
	# which contains the phone number of the contact. The phone number
	# must be in international E.164 format. All other additional columns
	# are added to the contact's metadata with the key being the column header

dwilkie / unicef_metrics.rb

Last active November 2, 2021 08:34

UNICEF Metrics

	start_time = Time.new(2020, 10, 1).beginning_of_day
	end_time = Time.new(2020, 12, 31).end_of_day

	completed_calls = PhoneCall.completed.where(created_at: start_time..end_time).joins(:call_data_record)

	number_of_unpaid_users = User.count # SCFM only for now
	number_of_calls = completed_calls.count
	number_of_minutes = completed_calls.sum("call_data_records.bill_sec") / 60
	number_of_users = (completed_calls.pluck(:to) + completed_calls.pluck(:from)).uniq.count

dwilkie / migrate_from_refile_to_activestorage.rb

Last active May 17, 2023 20:26

Migrate from Refile to ActiveStorage

	CallDataRecord.find_each do \|cdr\|
	next if cdr.file.attached?

	cdr_url = "https://s3-ap-southeast-1.amazonaws.com/cdr.somleng.org/store/#{cdr.file_id}"
	cdr.file.attach(
	io: open(cdr_url),
	filename: cdr.file_filename,
	content_type: cdr.file_content_type
	)
	end

dwilkie / elastic_beanstalk_db_backup.sh

Last active May 8, 2022 08:24

Elastic Beanstalk pg_dump

	# On Elastic Beanstalk machine

	yum install -y https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-6-x86_64/postgresql11-libs-11.4-1PGDG.rhel6.x86_64.rpm
	yum install -y https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-6-x86_64/postgresql11-11.4-1PGDG.rhel6.x86_64.rpm
	yum install -y https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-6-x86_64/postgresql11-server-11.4-1PGDG.rhel6.x86_64.rpm

	pg_dump --version

	EB_SUPPORT_DIR=$(/opt/elasticbeanstalk/bin/get-config container -k support_dir)
	EB_SCRIPT_DIR=$(/opt/elasticbeanstalk/bin/get-config container -k script_dir)