John Hammink Jammink2

Digital artist, content guy, studio musician. Evangelist.

Jammink2 / find_duplicate_emails.sql

Created September 16, 2016 00:22

SELECT email FROM <tbl_name> GROUP BY email HAVING COUNT(1) > 1 -- to find duplicate emails

Jammink2 / mailchimp2td_webhook.sh

Created September 16, 2016 00:17

https://in.treasuredata.com/postback/v3/event/<Your_TD_Database>/<Your_TD_Table>?td_write_key=<your_TD_API_Write_key>

Jammink2 / guess_issue_contacts2_sfdc.sh

Created August 9, 2016 00:31

td connector:guess -o sfdc_contact_output.yml sfdc_contacts.yml && td connector:issue sfdc_contact_output.yml --database sfdc2 --table contact

Jammink2 / scheduled_execution_example.sh

Created July 30, 2016 01:29

	## note: only an example! Please edit to conform to actual command line

	td connector:create \
	daily_sfdc_import \
	"10 0 * * *" \
	td_sample_db \
	td_sample_table \
	load.yml

Jammink2 / sfdc_accounts.yml

Created July 30, 2016 01:26

	in:
	type: sfdc
	username: "<my_username>"
	password: "<my_password>"
	client_id: "<my_client_id>" # your app's consumer key
	client_secret: "<my_client_secret>" # your app's consumer secret
	security_token: "<my_security token>" # your logged-in user's security token
	login_url: https://cs27.salesforce.com/
	incremental: false
	target: Account

Jammink2 / sfdc_contacts.yml

Last active July 30, 2016 01:28

	in:
	type: sfdc
	username: "<my_username>"
	password: "<my_password>"
	client_id: "<my_client_id>" # your app's consumer key
	client_secret: "<my_client_secret>" # your app's consumer secret
	security_token: "<my_security_token>" # your logged-in user's security token
	login_url: https://cs27.salesforce.com/
	incremental: false
	target: Contact

Jammink2 / guess_issue_accounts_sfdc.sh

Last active August 2, 2016 22:17

td connector:guess -o sfdc_account_output.yml sfdc_accounts.yml && td connector:issue sfdc_account_output.yml --database sfdc --table account

Jammink2 / guess_issue_contacts_sfdc.sh

Last active August 2, 2016 22:06

td connector:guess -o sfdc_contact_output.yml sfdc_contacts.yml && td connector:issue sfdc_contact_output.yml --database sfdc --table contact

Jammink2 / Account_Coverage_by_region.csv

Last active August 3, 2016 00:24

Jammink2 / calculate_salesforce_account_coverage.sql

Last active August 2, 2016 23:33