Salesforce, Python, SQL, & other ways to put your data where you need it

Need event music? 🎸

Live and recorded jazz, pop, and meditative music for your virtual conference / Zoom wedding / yoga class / private party with quality sound and a smooth technical experience

Tags

💬 EN

apex

Data Development and Integrations (official Salesforce Developers podcast appearance) (08 Mar 2021)
Workaround: Salesforce Flow Picklist-Related Invalid Type Error (06 Nov 2019)
Recalculating Salesforce Formula Fields in Apex (10 Sep 2019)
Recalcul des champs de formule Salesforce en Apex (10 Sep 2019)

api

WCOnline API explainer (20 Oct 2021)
Data Development and Integrations (official Salesforce Developers podcast appearance) (08 Mar 2021)
APIs are for admins: texting your colleagues with Salesforce Flow (Cactusforce 2021) (15 Jan 2021)
Study plan for GraphQL in Salesforce Marketing Cloud (15 Sep 2020)
Reading a datetime with miliseconds into an Oracle DATE (26 Aug 2020)
Set plugin names and default visibility in Canvas course navigation menus (16 Aug 2020)
Rate-limiting API requests in Python with a decorator (28 Jul 2020)
PL/SQL Nested Queries (14 Jul 2020)
Jitterbit Hosted API Tutorial: 302 Redirect with Cloud Studio (02 Apr 2020)
Jitterbit Hosted APIs: Hello World tutorials (02 Apr 2020)
Tutorial: Flow External Services for Salesforce Admins (30 Jan 2020)
Intro to HTTP (03 Jun 2019)
Tutorial: Flow Apex-Defined Data Types for Salesforce Admins (29 May 2019)
Intro to XML and JSON #7: Recap & Real World Use (26 Apr 2019)
Logging into Salesforce's Pardot API (w/ Python) (04 Apr 2019)
Intro to XML and JSON #2: Data's Shape (25 Mar 2019)
Intro to XML and JSON (16 Mar 2019)
Salesforce REST APIs: A High-Level Primer (14 Mar 2019)
Logging into Salesforce's Marketing Cloud API (w/ Python or Postman) (26 Feb 2019)
Cleaning bad Pardot data with Python (15 Feb 2019)

architecture

Skyvia test - Salesforce to database (28 Jun 2022)
Enterprise application diary (22 Jun 2022)
SFTP and SSH authentication patterns (28 Jan 2022)
SvelteKit Minimum Viable Build (10 Jan 2022)
But WHY do you need a database? (24 Sep 2021)
Next.js Minimum Viable Build (23 Aug 2021)
ETL QA is interpersonal communication (23 Aug 2021)
Next.js for novices and dabblers (22 Aug 2021)
Big Data: What to learn (02 Apr 2021)
A Lyris to Marketing Cloud imaginary architecture (15 Mar 2021)
Data Development and Integrations (official Salesforce Developers podcast appearance) (08 Mar 2021)
11ty Markdown -- group pets by color (08 Feb 2021)
Insert, update, and delete from a database to Salesforce (05 Feb 2021)
APIs are for admins: texting your colleagues with Salesforce Flow (Cactusforce 2021) (15 Jan 2021)
How to use Jekyll SSG with Headless CMS (02 Jan 2021)
Drupal vs. 11ty with kittens & puppies (05 Nov 2020)
Movable page builder components in Sanity CMS (27 Oct 2020)
Algolia attributes are flexible (15 Oct 2020)
Gatsby Cloud live previews for Sanity-based sites (21 Jul 2020)
Gatsby Minimum Viable Sanity Template (08 Jul 2020)
Sanity CMS Minimum Viable Build (07 Jul 2020)
Why WYSIWYG static site CMS's love Gatsby (24 Jun 2020)
Gatsby React WYSIWYG CMS-Friendly Markdown (22 Jun 2020)
Gatsby React Minimum Viable Markdown Template / Component (18 Jun 2020)
Gatsby Minimum Viable Build (09 Jun 2020)
Gatsby for novices and dabblers (09 Jun 2020)
Netlify CMS Jekyll Minimum Viable Build (21 Feb 2020)
Tutorial: Flow External Services for Salesforce Admins (30 Jan 2020)
Salesforce Spring '20 Community Guest User Apocalypse (08 Jan 2020)
Flow Invocable Apex with Any Salesforce Object Type (02 Jan 2020)
Tutoriel : types de données définis par Apex pour admins Salesforce (12 Jun 2019)
Intro to HTTP (03 Jun 2019)
Tutorial: Flow Apex-Defined Data Types for Salesforce Admins (29 May 2019)
Intro to XML and JSON #7: Recap & Real World Use (26 Apr 2019)
Intro to XML and JSON #2: Data's Shape (25 Mar 2019)
Intro to XML and JSON (16 Mar 2019)
Salesforce REST APIs: A High-Level Primer (14 Mar 2019)

astuces

Recalcul des champs de formule Salesforce en Apex (10 Sep 2019)

aws

Hello world, it's the AWS parameter store (26 May 2021)
Git and SourceTree setup with AWS federation on Windows (20 Feb 2019)

bases de données

ORA-29283 salut le monde (05 Oct 2020)
Pourquoi - et comment - apprendre PL/SQL (…T-SQL…PL/pgSQL…) (01 Nov 2018)

beginner

Connect to a database from Windows (25 Jan 2022)
Setting up Windows Store Python with Pandas in VSCode (01 Oct 2020)
Salesforce REST APIs: A High-Level Primer (14 Mar 2019)
Setting up Python on Windows with Anaconda (05 Mar 2019)
Setting up Python on Windows with Miniconda by Anaconda (04 Mar 2019)

canvas

Set plugin names and default visibility in Canvas course navigation menus (16 Aug 2020)

conferences

Virtual Conference Live Music (03 Jun 2020)

csv

Anonymous PL/SQL to write a CSV from SQL (05 Oct 2020)
Python Pandas For Excel on vBrownBag - show notes (21 Aug 2019)
Intro to XML and JSON #7: Recap & Real World Use (26 Apr 2019)
Intro to XML and JSON #6: JSON (26 Apr 2019)
Intro to XML and JSON #5: XML/CSV Conversions (03 Apr 2019)
Intro to XML and JSON #3: XML Items & Keys (03 Apr 2019)
Intro to XML and JSON #2: Data's Shape (25 Mar 2019)
Intro to XML and JSON (16 Mar 2019)
Modification des données CSV / XLSX en Python pour admins Salesforce : vidéo et notes (09 Feb 2019)
Python for Salesforce: List unique values found across similar Salesforce fields (31 Jan 2019)
Python pour Salesforce: Énumérer les valeurs uniques à travers plusieurs champs Salesforce (31 Jan 2019)
9 fév: Démonstration de Python pour admins Salesforce (FR) (24 Jan 2019)
Feb. 9: FRENCH-language demo of Python for Saleforce admins! (24 Jan 2019)
Proper-Casing CSV/XLSX Data With Python (10 Jan 2019)
Filter a large CSV file with Python (08 Jan 2019)
Filtrer un gros fichier CSV avec Python (08 Jan 2019)

custom metadata

Salesforce Custom Metadata vs. Custom Objects (18 Oct 2018)

databases

Can eProcurement reach Banner? (13 Aug 2022)
Jaggaer - Banner Sync Series (12 Aug 2022)
Transforming CommonApp into Salesforce EASY question responses (11 Aug 2022)
UNPIVOT to key-value pair in Oracle SQL (11 Aug 2022)
Skyvia test - Salesforce to database (28 Jun 2022)
Connect to a database from Windows (25 Jan 2022)
Read an NDJSON file with anonymous PL/SQL (21 Jan 2022)
But WHY do you need a database? (24 Sep 2021)
ETL QA is interpersonal communication (23 Aug 2021)
Big Data: What to learn (02 Apr 2021)
Anonymous PLSQL subquery from a file (23 Mar 2021)
Data Development and Integrations (official Salesforce Developers podcast appearance) (08 Mar 2021)
11ty Markdown -- group pets by color (08 Feb 2021)
Insert, update, and delete from a database to Salesforce (05 Feb 2021)
Drupal vs. 11ty with kittens & puppies (05 Nov 2020)
Ellucian Banner fan wiki, OMG (14 Oct 2020)
Anonymous PL/SQL to write a CSV from SQL (05 Oct 2020)
ORA-29283 hello world (05 Oct 2020)
Study plan for GraphQL in Salesforce Marketing Cloud (15 Sep 2020)
Reading a datetime with miliseconds into an Oracle DATE (26 Aug 2020)
PL/SQL Nested Queries (14 Jul 2020)
Recompile dependent PL/SQL code after changes (27 Apr 2020)
Every SQL Join You'll Ever Need (08 Nov 2018)
Why & How Should I Learn PL/SQL? (…T-SQL…PL/pgSQL…) (01 Nov 2018)

demandtools

Boolean 'OR' in DemandTools MassImpact formulas (07 May 2020)
Le 'ou' booléen aux formules MassImpact de DemandTools (07 May 2020)
XML for Salesforce Administrators: DemandTools Configuration (08 May 2019)

devops

Skyvia test - Salesforce to database (28 Jun 2022)
Pulumi & AWS minimum viable build (20 May 2022)
SSH or SFTP into a Linux server from a Windows machine with key-based authentication (17 May 2022)
Hello world, it's the AWS parameter store (26 May 2021)
Infrastructure as code homework #2 (16 Oct 2020)
Infrastructure as code homework #1 (21 Sep 2020)

digital garden

Choosing a headless CMS without losing your head (24 Aug 2020)

développement web

Qu'est-ce qu'un générateur de site statique ? (18 Aug 2020)
Qu'est-ce que l'hébergement web statique ? (18 Aug 2020)

eclipse

Migrating my Salesforce org backups from Eclipse to VSCode without messing up Git (07 Nov 2019)

excel

Door Prize: Excel VBA code for turning your ex-PMI into principal payments (13 Feb 2020)
Excel VBA code to compute when a mortgage will be free of PMI (Private Mortgage Insurance) (13 Feb 2020)
Python Pandas For Excel on vBrownBag - show notes (21 Aug 2019)
Intro to XML and JSON #7: Recap & Real World Use (26 Apr 2019)
Intro to XML and JSON #6: JSON (26 Apr 2019)
Intro to XML and JSON #5: XML/CSV Conversions (03 Apr 2019)
Intro to XML and JSON #3: XML Items & Keys (03 Apr 2019)
Intro to XML and JSON #2: Data's Shape (25 Mar 2019)
Intro to XML and JSON (16 Mar 2019)
Modification des données CSV / XLSX en Python pour admins Salesforce : vidéo et notes (09 Feb 2019)
Python for Salesforce: List unique values found across similar Salesforce fields (31 Jan 2019)
Python pour Salesforce: Énumérer les valeurs uniques à travers plusieurs champs Salesforce (31 Jan 2019)
9 fév: Démonstration de Python pour admins Salesforce (FR) (24 Jan 2019)
Feb. 9: FRENCH-language demo of Python for Saleforce admins! (24 Jan 2019)
Proper-Casing CSV/XLSX Data With Python (10 Jan 2019)
Filter a large CSV file with Python (08 Jan 2019)
Filtrer un gros fichier CSV avec Python (08 Jan 2019)

feuilles de calcul

Modification des données CSV / XLSX en Python pour admins Salesforce : vidéo et notes (09 Feb 2019)
9 fév: Démonstration de Python pour admins Salesforce (FR) (24 Jan 2019)
Filtrer un gros fichier CSV avec Python (08 Jan 2019)

flow

Data Development and Integrations (official Salesforce Developers podcast appearance) (08 Mar 2021)
APIs are for admins: texting your colleagues with Salesforce Flow (Cactusforce 2021) (15 Jan 2021)
Tutorial: Flow External Services for Salesforce Admins (30 Jan 2020)
Flow Invocable Apex with Any Salesforce Object Type (02 Jan 2020)
Workaround: Salesforce Flow Picklist-Related Invalid Type Error (06 Nov 2019)
Tutoriel : types de données définis par Apex pour admins Salesforce (12 Jun 2019)
Tutorial: Flow Apex-Defined Data Types for Salesforce Admins (29 May 2019)
Setting up VSCode to edit Salesforce metadata (10 Apr 2019)

git

A git feature commit squashing approach (03 May 2021)
Gatsby Cloud live previews for Sanity-based sites (21 Jul 2020)
Gatsby Minimum Viable Build (09 Jun 2020)
Netlify CMS Jekyll Minimum Viable Build (21 Feb 2020)
Git and SourceTree setup with AWS federation on Windows (20 Feb 2019)
Git brain dump (12 Feb 2019)
Telling Sourcetree about one of my GitHub repositories (12 Feb 2019)

graphql

Study plan for GraphQL in Salesforce Marketing Cloud (15 Sep 2020)
HowToGraphQL.com Notes (09 Aug 2020)
Gatsby Minimum Viable Sanity Template (08 Jul 2020)
Gatsby React Minimum Viable Markdown Template / Component (18 Jun 2020)

health

What is #FlattenTheCurve? Why is everything cancelled? (13 Mar 2020)

instructure

Reading a datetime with miliseconds into an Oracle DATE (26 Aug 2020)
Set plugin names and default visibility in Canvas course navigation menus (16 Aug 2020)
PL/SQL Nested Queries (14 Jul 2020)

integration

Can eProcurement reach Banner? (13 Aug 2022)
Jaggaer - Banner Sync Series (12 Aug 2022)
Transforming CommonApp into Salesforce EASY question responses (11 Aug 2022)
Skyvia test - Salesforce to database (28 Jun 2022)
SSH or SFTP into a Linux server from a Windows machine with key-based authentication (17 May 2022)
SFTP and SSH authentication patterns (28 Jan 2022)
Read an NDJSON file with anonymous PL/SQL (21 Jan 2022)
WCOnline API explainer (20 Oct 2021)
ETL QA is interpersonal communication (23 Aug 2021)
Anonymous PLSQL subquery from a file (23 Mar 2021)
A Lyris to Marketing Cloud imaginary architecture (15 Mar 2021)
Data Development and Integrations (official Salesforce Developers podcast appearance) (08 Mar 2021)
Insert, update, and delete from a database to Salesforce (05 Feb 2021)
APIs are for admins: texting your colleagues with Salesforce Flow (Cactusforce 2021) (15 Jan 2021)
Configuring public-private key pairs so 2 Linux machines can talk (16 Sep 2020)
Study plan for GraphQL in Salesforce Marketing Cloud (15 Sep 2020)
Reading a datetime with miliseconds into an Oracle DATE (26 Aug 2020)
Set plugin names and default visibility in Canvas course navigation menus (16 Aug 2020)
Rate-limiting API requests in Python with a decorator (28 Jul 2020)
PL/SQL Nested Queries (14 Jul 2020)
Jitterbit Hosted API Tutorial: 302 Redirect with Cloud Studio (02 Apr 2020)
Jitterbit Hosted APIs: Hello World tutorials (02 Apr 2020)
Tutorial: Flow External Services for Salesforce Admins (30 Jan 2020)
A Jitterbit Case Study: Higher Education Adventures in Salesforce (04 Nov 2019)
Solved: 2 Salesforce ETL Errors (01 Nov 2019)
Clearing A Jitterbit FillDataElements Error (31 Oct 2019)
S'occuper d'une erreur FillDataElements en Jitterbit (31 Oct 2019)
Better Salesforce Insert/Update Operations with Jitterbit Caching (28 Oct 2019)
Tutoriel : types de données définis par Apex pour admins Salesforce (12 Jun 2019)
Intro to HTTP (03 Jun 2019)
Tutorial: Flow Apex-Defined Data Types for Salesforce Admins (29 May 2019)
Intro to XML and JSON #7: Recap & Real World Use (26 Apr 2019)
Intro to XML and JSON #2: Data's Shape (25 Mar 2019)
Intro to XML and JSON (16 Mar 2019)
Salesforce REST APIs: A High-Level Primer (14 Mar 2019)

intermediate

SSH or SFTP into a Linux server from a Windows machine with key-based authentication (17 May 2022)
Check a URL with Selenium IDE (06 Apr 2022)
Data Development and Integrations (official Salesforce Developers podcast appearance) (08 Mar 2021)
Set plugin names and default visibility in Canvas course navigation menus (16 Aug 2020)
Dedupe Salesforce NPSP Emails with Python (23 Nov 2018)

jamstack

SvelteKit Minimum Viable Build (10 Jan 2022)
How I added Algolia search: front-end (04 Oct 2021)
Inspecting an existing 11ty project (04 Oct 2021)
Customizing Sanity Studio beyond the schema (27 Sep 2021)
Jekyll doesn't do components? Liar! (09 Sep 2021)
Learn static site generation with Stackbit (28 Aug 2021)
Next.js Minimum Viable Build (23 Aug 2021)
Next.js for novices and dabblers (22 Aug 2021)
Adding Tailwind to a Jekyll site on Windows (06 Jul 2021)
Jamstack live preview tooling (15 Jun 2021)
SEO savings, one bubble tea at a time (10 Jun 2021)
Tailwind JIT starter for Gatsby (07 Apr 2021)
Tailwind JIT starter for 11ty (play fast!) (19 Mar 2021)
Can 11ty host my podcast for free? (10 Mar 2021)
Stackbit can teach you web development (09 Mar 2021)
11ty Markdown -- group pets by color (08 Feb 2021)
Responsive, accessible navigation 5: HTML structure (08 Feb 2021)
Responsive, accessible navigation 4: Preventative troubleshooting (08 Feb 2021)
Responsive, accessible navigation 3: Constraining width (08 Feb 2021)
Responsive, accessible navigation 2: 11ty (08 Feb 2021)
Responsive, accessible navigation 1: Intro (08 Feb 2021)
5 things you need to know about Jekyll vs. 11ty Liquid includes (29 Jan 2021)
The first JavaScript I ever wrote (08 Jan 2021)
How to use Jekyll SSG with Headless CMS (02 Jan 2021)
How to break (and rebuild) the Jamstack (26 Dec 2020)
Hello World on Netlify Functions, Cloudflare Workers, & Vercel Functions (09 Dec 2020)
Passwordless Auth0 and Netlify functions: backend (07 Dec 2020)
Add users to Netlify Identity with Postman (07 Dec 2020)
A starter for Netlify Functions with 11ty (07 Dec 2020)
Drupal vs. 11ty with kittens & puppies (05 Nov 2020)
Movable page builder components in Sanity CMS (27 Oct 2020)
Algolia attributes are flexible (15 Oct 2020)
Sanity datatable serializer for 11ty sites (10 Sep 2020)
Choosing a headless CMS without losing your head (24 Aug 2020)
Why do bloggers love Markdown? Why use MDX? And other notes from MDXConf 2020 (24 Aug 2020)
Qu'est-ce qu'un générateur de site statique ? (18 Aug 2020)
Qu'est-ce que l'hébergement web statique ? (18 Aug 2020)
What is a static site generator? (18 Aug 2020)
What is static web hosting? (18 Aug 2020)
Heroku live previews for Gatsby + Sanity sites (17 Aug 2020)
Gatsby Cloud live previews for Sanity-based sites (21 Jul 2020)
Gatsby Minimum Viable Sanity Template (08 Jul 2020)
Sanity CMS Minimum Viable Build (07 Jul 2020)
Why WYSIWYG static site CMS's love Gatsby (24 Jun 2020)
Gatsby React WYSIWYG CMS-Friendly Markdown (22 Jun 2020)
Gatsby React Minimum Viable Markdown Template / Component (18 Jun 2020)
Gatsby Minimum Viable Build (09 Jun 2020)
Gatsby for novices and dabblers (09 Jun 2020)
Netlify CMS Jekyll Minimum Viable Build (21 Feb 2020)

jitterbit

Jitterbit Hosted API Tutorial: 302 Redirect with Cloud Studio (02 Apr 2020)
Jitterbit Hosted APIs: Hello World tutorials (02 Apr 2020)
A Jitterbit Case Study: Higher Education Adventures in Salesforce (04 Nov 2019)
Solved: 2 Salesforce ETL Errors (01 Nov 2019)
Clearing A Jitterbit FillDataElements Error (31 Oct 2019)
S'occuper d'une erreur FillDataElements en Jitterbit (31 Oct 2019)
Better Salesforce Insert/Update Operations with Jitterbit Caching (28 Oct 2019)

json

Intro to XML, JSON, & YAML: the book (04 Sep 2020)
Reading a datetime with miliseconds into an Oracle DATE (26 Aug 2020)
PL/SQL Nested Queries (14 Jul 2020)
Forcelandia 2019 XML & JSON Conference Talk Resources (31 Jul 2019)
Intro to XML and JSON #7: Recap & Real World Use (26 Apr 2019)
Intro to XML and JSON #6: JSON (26 Apr 2019)
Intro to XML and JSON #5: XML/CSV Conversions (03 Apr 2019)
Intro to XML and JSON #4: XML Values (03 Apr 2019)
Intro to XML and JSON #3: XML Items & Keys (03 Apr 2019)
Intro to XML and JSON #2: Data's Shape (25 Mar 2019)
Intro to XML and JSON (16 Mar 2019)

linux

SSH or SFTP into a Linux server from a Windows machine with key-based authentication (17 May 2022)
Hello world, it's the AWS parameter store (26 May 2021)
Infrastructure as code homework #2 (16 Oct 2020)
Infrastructure as code homework #1 (21 Sep 2020)
Configuring public-private key pairs so 2 Linux machines can talk (16 Sep 2020)

marketing cloud

A Lyris to Marketing Cloud imaginary architecture (15 Mar 2021)
Study plan for GraphQL in Salesforce Marketing Cloud (15 Sep 2020)
Logging into Salesforce's Marketing Cloud API (w/ Python or Postman) (26 Feb 2019)

minimum viable build

SvelteKit Minimum Viable Build (10 Jan 2022)
Next.js Minimum Viable Build (23 Aug 2021)
How to break (and rebuild) the Jamstack (26 Dec 2020)
Hello World on Netlify Functions, Cloudflare Workers, & Vercel Functions (09 Dec 2020)
Passwordless Auth0 and Netlify functions: backend (07 Dec 2020)
A starter for Netlify Functions with 11ty (07 Dec 2020)
Gatsby Minimum Viable Sanity Template (08 Jul 2020)
Sanity CMS Minimum Viable Build (07 Jul 2020)
Gatsby React Minimum Viable Markdown Template / Component (18 Jun 2020)
Gatsby Minimum Viable Build (09 Jun 2020)
Netlify CMS Jekyll Minimum Viable Build (21 Feb 2020)

music

Audient iD14 sound check for iOS and Windows (10 Jun 2020)
Virtual Conference Live Music (03 Jun 2020)
Writing & graphics for scheduled Facebook Live videos (21 Apr 2020)
Livestreaming Music Diary - Facebook Live (20 Apr 2020)

métadonnées personnalisées

Salesforce: métadonnées personnalisées v. objets personnalisés (18 Oct 2018)

pandas

Python Pandas For Excel on vBrownBag - show notes (21 Aug 2019)
Modification des données CSV / XLSX en Python pour admins Salesforce : vidéo et notes (09 Feb 2019)
Python for Salesforce: List unique values found across similar Salesforce fields (31 Jan 2019)
Python pour Salesforce: Énumérer les valeurs uniques à travers plusieurs champs Salesforce (31 Jan 2019)
9 fév: Démonstration de Python pour admins Salesforce (FR) (24 Jan 2019)
Feb. 9: FRENCH-language demo of Python for Saleforce admins! (24 Jan 2019)
Proper-Casing CSV/XLSX Data With Python (10 Jan 2019)
Filter a large CSV file with Python (08 Jan 2019)
Filtrer un gros fichier CSV avec Python (08 Jan 2019)

pardot

Logging into Salesforce's Pardot API (w/ Python) (04 Apr 2019)
Cleaning bad Pardot data with Python (15 Feb 2019)

professional development

Cover letter workshop - WITness Success / Minnebar (23 Jul 2022)
Cover Letter Examples (24 Feb 2022)
Cover Letter Flowchart (23 Feb 2022)

python

Find a library job with Python (20 Apr 2022)
Localhost HTML with Python on Windows (09 Nov 2021)
WCOnline API explainer (20 Oct 2021)
A dumb Python mistake (25 Aug 2021)
Off-by-one errors in Python API pagination (16 Mar 2021)
Setting up Windows Store Python with Pandas in VSCode (01 Oct 2020)
Rate-limiting API requests in Python with a decorator (28 Jul 2020)
Python NumPy code to compute when a mortgage will be free of PMI (Private Mortgage Insurance) (12 Feb 2020)
Disabling Lightning Experience w/ Python and Selenium in Salesforce (12 Sep 2019)
No-Permissions Salesforce Profile w/ Python and Selenium (23 Aug 2019)
Python Pandas For Excel on vBrownBag - show notes (21 Aug 2019)
XML for Salesforce Administrators: DemandTools Configuration (08 May 2019)
Intro to XML and JSON #7: Recap & Real World Use (26 Apr 2019)
Logging into Salesforce's Pardot API (w/ Python) (04 Apr 2019)
Intro to XML and JSON (16 Mar 2019)
Python pour Salesforce: compte -> campagne (07 Mar 2019)
Setting up Python on Windows with Anaconda (05 Mar 2019)
Setting up Python on Windows with Miniconda by Anaconda (04 Mar 2019)
Logging into Salesforce's Marketing Cloud API (w/ Python or Postman) (26 Feb 2019)
Git and SourceTree setup with AWS federation on Windows (20 Feb 2019)
Cleaning bad Pardot data with Python (15 Feb 2019)
Modification des données CSV / XLSX en Python pour admins Salesforce : vidéo et notes (09 Feb 2019)
Python for Salesforce: List unique values found across similar Salesforce fields (31 Jan 2019)
Python pour Salesforce: Énumérer les valeurs uniques à travers plusieurs champs Salesforce (31 Jan 2019)
9 fév: Démonstration de Python pour admins Salesforce (FR) (24 Jan 2019)
Feb. 9: FRENCH-language demo of Python for Saleforce admins! (24 Jan 2019)
Proper-Casing CSV/XLSX Data With Python (10 Jan 2019)
Filter a large CSV file with Python (08 Jan 2019)
Filtrer un gros fichier CSV avec Python (08 Jan 2019)
Dedupe Salesforce NPSP Emails with Python (23 Nov 2018)
Python for Salesforce Real-Life Challenge: NPSP Email Deduping (12 Nov 2018)

questions

Naomi Kritzer will be blogging some Minnesota 2021 candidates again (08 Sep 2021)
Dedupe Salesforce NPSP Emails with Python (23 Nov 2018)
Python for Salesforce Real-Life Challenge: NPSP Email Deduping (12 Nov 2018)

salesforce

Transforming CommonApp into Salesforce EASY question responses (11 Aug 2022)
Cover letter workshop - WITness Success / Minnebar (23 Jul 2022)
Welcome to Minneapolis, Salesforce! (12 Jul 2022)
Skyvia test - Salesforce to database (28 Jun 2022)
Loop through Trigger.new all you want (05 Mar 2022)
Salesforce Apex lets you use external IDs (04 Jan 2022)
How I set up VSCode for a new Salesforce project (21 Dec 2021)
Document Salesforce TDTM to avoid dev-admin handoff issues (30 Sep 2021)
Random handy CumulusCI notes (13 Jul 2021)
Open a Salesforce scratch org in a different browser with CumulusCI (10 Jul 2021)
A Lyris to Marketing Cloud imaginary architecture (15 Mar 2021)
Data Development and Integrations (official Salesforce Developers podcast appearance) (08 Mar 2021)
Insert, update, and delete from a database to Salesforce (05 Feb 2021)
APIs are for admins: texting your colleagues with Salesforce Flow (Cactusforce 2021) (15 Jan 2021)
Setting up Windows Store Python with Pandas in VSCode (01 Oct 2020)
Study plan for GraphQL in Salesforce Marketing Cloud (15 Sep 2020)
Boolean 'OR' in DemandTools MassImpact formulas (07 May 2020)
Le 'ou' booléen aux formules MassImpact de DemandTools (07 May 2020)
Salesforce Classic slow in Chrome? Use Firefox until Spring '20 (12 Feb 2020)
Tutorial: Flow External Services for Salesforce Admins (30 Jan 2020)
Salesforce Spring '20 Community Guest User Apocalypse (08 Jan 2020)
Flow Invocable Apex with Any Salesforce Object Type (02 Jan 2020)
Migrating my Salesforce org backups from Eclipse to VSCode without messing up Git (07 Nov 2019)
Workaround: Salesforce Flow Picklist-Related Invalid Type Error (06 Nov 2019)
A Jitterbit Case Study: Higher Education Adventures in Salesforce (04 Nov 2019)
Solved: 2 Salesforce ETL Errors (01 Nov 2019)
Clearing A Jitterbit FillDataElements Error (31 Oct 2019)
S'occuper d'une erreur FillDataElements en Jitterbit (31 Oct 2019)
Better Salesforce Insert/Update Operations with Jitterbit Caching (28 Oct 2019)
Disabling Lightning Experience w/ Python and Selenium in Salesforce (12 Sep 2019)
Recalculating Salesforce Formula Fields in Apex (10 Sep 2019)
Recalcul des champs de formule Salesforce en Apex (10 Sep 2019)
No-Permissions Salesforce Profile w/ Python and Selenium (23 Aug 2019)
Forcelandia 2019 XML & JSON Conference Talk Resources (31 Jul 2019)
Salesforce Apex Performance: new ID map vs. for loop (08 Jul 2019)
Tutoriel : types de données définis par Apex pour admins Salesforce (12 Jun 2019)
Tutorial: Flow Apex-Defined Data Types for Salesforce Admins (29 May 2019)
XML for Salesforce Administrators: DemandTools Configuration (08 May 2019)
Intro to XML and JSON #7: Recap & Real World Use (26 Apr 2019)
Setting up VSCode to edit Salesforce metadata (10 Apr 2019)
Logging into Salesforce's Pardot API (w/ Python) (04 Apr 2019)
Intro to XML and JSON (16 Mar 2019)
Salesforce REST APIs: A High-Level Primer (14 Mar 2019)
Python pour Salesforce: compte -> campagne (07 Mar 2019)
Setting up Python on Windows with Anaconda (05 Mar 2019)
Setting up Python on Windows with Miniconda by Anaconda (04 Mar 2019)
Logging into Salesforce's Marketing Cloud API (w/ Python or Postman) (26 Feb 2019)
Cleaning bad Pardot data with Python (15 Feb 2019)
Modification des données CSV / XLSX en Python pour admins Salesforce : vidéo et notes (09 Feb 2019)
Python for Salesforce: List unique values found across similar Salesforce fields (31 Jan 2019)
Python pour Salesforce: Énumérer les valeurs uniques à travers plusieurs champs Salesforce (31 Jan 2019)
9 fév: Démonstration de Python pour admins Salesforce (FR) (24 Jan 2019)
Feb. 9: FRENCH-language demo of Python for Saleforce admins! (24 Jan 2019)
Proper-Casing CSV/XLSX Data With Python (10 Jan 2019)
Filter a large CSV file with Python (08 Jan 2019)
Filtrer un gros fichier CSV avec Python (08 Jan 2019)
Dedupe Salesforce NPSP Emails with Python (23 Nov 2018)
Python for Salesforce Real-Life Challenge: NPSP Email Deduping (12 Nov 2018)
Salesforce Custom Metadata vs. Custom Objects (18 Oct 2018)
Salesforce: métadonnées personnalisées v. objets personnalisés (18 Oct 2018)

salesforce saturday

Feb. 9: FRENCH-language demo of Python for Saleforce admins! (24 Jan 2019)

samedi salesforce

Modification des données CSV / XLSX en Python pour admins Salesforce : vidéo et notes (09 Feb 2019)
9 fév: Démonstration de Python pour admins Salesforce (FR) (24 Jan 2019)

security

SSH or SFTP into a Linux server from a Windows machine with key-based authentication (17 May 2022)
Salesforce Spring '20 Community Guest User Apocalypse (08 Jan 2020)
Salesforce REST APIs: A High-Level Primer (14 Mar 2019)

selenium

Check a URL with Selenium IDE (06 Apr 2022)
Disabling Lightning Experience w/ Python and Selenium in Salesforce (12 Sep 2019)
No-Permissions Salesforce Profile w/ Python and Selenium (23 Aug 2019)

spreadsheet

Python Pandas For Excel on vBrownBag - show notes (21 Aug 2019)
Feb. 9: FRENCH-language demo of Python for Saleforce admins! (24 Jan 2019)
Proper-Casing CSV/XLSX Data With Python (10 Jan 2019)
Filter a large CSV file with Python (08 Jan 2019)

sql

UNPIVOT to key-value pair in Oracle SQL (11 Aug 2022)
Connect to a database from Windows (25 Jan 2022)
Read an NDJSON file with anonymous PL/SQL (21 Jan 2022)
Big Data: What to learn (02 Apr 2021)
Anonymous PLSQL subquery from a file (23 Mar 2021)
Insert, update, and delete from a database to Salesforce (05 Feb 2021)
Anonymous PL/SQL to write a CSV from SQL (05 Oct 2020)
ORA-29283 hello world (05 Oct 2020)
ORA-29283 salut le monde (05 Oct 2020)
Reading a datetime with miliseconds into an Oracle DATE (26 Aug 2020)
PL/SQL Nested Queries (14 Jul 2020)
Recompile dependent PL/SQL code after changes (27 Apr 2020)
Every SQL Join You'll Ever Need (08 Nov 2018)
Why & How Should I Learn PL/SQL? (…T-SQL…PL/pgSQL…) (01 Nov 2018)
Pourquoi - et comment - apprendre PL/SQL (…T-SQL…PL/pgSQL…) (01 Nov 2018)

tips

Loop through Trigger.new all you want (05 Mar 2022)
Cover Letter Flowchart (23 Feb 2022)
Next.js for novices and dabblers (22 Aug 2021)
Big Data: What to learn (02 Apr 2021)
Checking a password against Troy Hunt's list (28 Mar 2021)
Off-by-one errors in Python API pagination (16 Mar 2021)
Data Development and Integrations (official Salesforce Developers podcast appearance) (08 Mar 2021)
11ty Markdown -- group pets by color (08 Feb 2021)
Insert, update, and delete from a database to Salesforce (05 Feb 2021)
Clean up old node_modules in Windows 10 (05 Jan 2021)
How to use Jekyll SSG with Headless CMS (02 Jan 2021)
How to break (and rebuild) the Jamstack (26 Dec 2020)
Hello World on Netlify Functions, Cloudflare Workers, & Vercel Functions (09 Dec 2020)
Add users to Netlify Identity with Postman (07 Dec 2020)
Drupal vs. 11ty with kittens & puppies (05 Nov 2020)
Movable page builder components in Sanity CMS (27 Oct 2020)
Ellucian Banner fan wiki, OMG (14 Oct 2020)
Re-indenting with Notepad++ regex replace (08 Oct 2020)
Study plan for GraphQL in Salesforce Marketing Cloud (15 Sep 2020)
Sep. 9: Content creation panelist on Whiskey Wednesday podcast (08 Sep 2020)
Rate-limiting API requests in Python with a decorator (28 Jul 2020)
Gatsby Cloud live previews for Sanity-based sites (21 Jul 2020)
Educators and students - get Figma graphic design software free (17 Jul 2020)
Gatsby Minimum Viable Sanity Template (08 Jul 2020)
Sanity CMS Minimum Viable Build (07 Jul 2020)
How I brought my Google Page Speed from 80 to 91 in 5 minutes (23 Jun 2020)
Gatsby React WYSIWYG CMS-Friendly Markdown (22 Jun 2020)
Gatsby React Minimum Viable Markdown Template / Component (18 Jun 2020)
Gatsby Minimum Viable Build (09 Jun 2020)
Gatsby for novices and dabblers (09 Jun 2020)
Recompile dependent PL/SQL code after changes (27 Apr 2020)
Netlify CMS Jekyll Minimum Viable Build (21 Feb 2020)
Salesforce Classic slow in Chrome? Use Firefox until Spring '20 (12 Feb 2020)
Workaround: Salesforce Flow Picklist-Related Invalid Type Error (06 Nov 2019)
Solved: 2 Salesforce ETL Errors (01 Nov 2019)
Clearing A Jitterbit FillDataElements Error (31 Oct 2019)
Better Salesforce Insert/Update Operations with Jitterbit Caching (28 Oct 2019)
Recalculating Salesforce Formula Fields in Apex (10 Sep 2019)
Salesforce Apex Performance: new ID map vs. for loop (08 Jul 2019)
Studying programming by writing glossaries (17 Feb 2019)

triggers

Salesforce Apex Performance: new ID map vs. for loop (08 Jul 2019)
Why & How Should I Learn PL/SQL? (…T-SQL…PL/pgSQL…) (01 Nov 2018)
Pourquoi - et comment - apprendre PL/SQL (…T-SQL…PL/pgSQL…) (01 Nov 2018)

tutorials

SSH or SFTP into a Linux server from a Windows machine with key-based authentication (17 May 2022)
Check a URL with Selenium IDE (06 Apr 2022)
Insert, update, and delete from a database to Salesforce (05 Feb 2021)
Passwordless Auth0 and Netlify functions: backend (07 Dec 2020)
Setting up Windows Store Python with Pandas in VSCode (01 Oct 2020)
Configuring public-private key pairs so 2 Linux machines can talk (16 Sep 2020)
Intro to XML, JSON, & YAML: the book (04 Sep 2020)
What is a static site generator? (18 Aug 2020)
What is static web hosting? (18 Aug 2020)
Heroku live previews for Gatsby + Sanity sites (17 Aug 2020)
Boolean 'OR' in DemandTools MassImpact formulas (07 May 2020)
Jitterbit Hosted API Tutorial: 302 Redirect with Cloud Studio (02 Apr 2020)
Jitterbit Hosted APIs: Hello World tutorials (02 Apr 2020)
Tutorial: Flow External Services for Salesforce Admins (30 Jan 2020)
Better Salesforce Insert/Update Operations with Jitterbit Caching (28 Oct 2019)
Disabling Lightning Experience w/ Python and Selenium in Salesforce (12 Sep 2019)
Recalculating Salesforce Formula Fields in Apex (10 Sep 2019)
No-Permissions Salesforce Profile w/ Python and Selenium (23 Aug 2019)
Intro to HTTP (03 Jun 2019)
Tutorial: Flow Apex-Defined Data Types for Salesforce Admins (29 May 2019)
XML for Salesforce Administrators: DemandTools Configuration (08 May 2019)
Intro to XML and JSON #7: Recap & Real World Use (26 Apr 2019)
Intro to XML and JSON #6: JSON (26 Apr 2019)
Setting up VSCode to edit Salesforce metadata (10 Apr 2019)
Logging into Salesforce's Pardot API (w/ Python) (04 Apr 2019)
Intro to XML and JSON #5: XML/CSV Conversions (03 Apr 2019)
Intro to XML and JSON #4: XML Values (03 Apr 2019)
Intro to XML and JSON #3: XML Items & Keys (03 Apr 2019)
Intro to XML and JSON #2: Data's Shape (25 Mar 2019)
Intro to XML and JSON (16 Mar 2019)
Salesforce REST APIs: A High-Level Primer (14 Mar 2019)
Setting up Python on Windows with Anaconda (05 Mar 2019)
Setting up Python on Windows with Miniconda by Anaconda (04 Mar 2019)
Logging into Salesforce's Marketing Cloud API (w/ Python or Postman) (26 Feb 2019)
Cleaning bad Pardot data with Python (15 Feb 2019)
Git brain dump (12 Feb 2019)
Telling Sourcetree about one of my GitHub repositories (12 Feb 2019)
Python for Salesforce: List unique values found across similar Salesforce fields (31 Jan 2019)
Feb. 9: FRENCH-language demo of Python for Saleforce admins! (24 Jan 2019)
Proper-Casing CSV/XLSX Data With Python (10 Jan 2019)
Filter a large CSV file with Python (08 Jan 2019)
Dedupe Salesforce NPSP Emails with Python (23 Nov 2018)
Salesforce Custom Metadata vs. Custom Objects (18 Oct 2018)

tutoriels

Qu'est-ce qu'un générateur de site statique ? (18 Aug 2020)
Qu'est-ce que l'hébergement web statique ? (18 Aug 2020)
Le 'ou' booléen aux formules MassImpact de DemandTools (07 May 2020)
Recalcul des champs de formule Salesforce en Apex (10 Sep 2019)
Python pour Salesforce: compte -> campagne (07 Mar 2019)
Modification des données CSV / XLSX en Python pour admins Salesforce : vidéo et notes (09 Feb 2019)
Python pour Salesforce: Énumérer les valeurs uniques à travers plusieurs champs Salesforce (31 Jan 2019)
9 fév: Démonstration de Python pour admins Salesforce (FR) (24 Jan 2019)
Filtrer un gros fichier CSV avec Python (08 Jan 2019)
Salesforce: métadonnées personnalisées v. objets personnalisés (18 Oct 2018)

videography

What's a docking station? (06 Mar 2021)
Using OBS as a virtual webcam for Zoom conference calls (06 Mar 2021)
Using your phone or iPad as a webcam (06 Mar 2021)
PiP webcam + screen sharing (06 Mar 2021)
Record 2 videos using the same microphone (06 Mar 2021)
Using a Behringer UCA202 with Windows, Android, or iOS (06 Mar 2021)
Listening to computer sound through an Audient iD14 (06 Mar 2021)
Recording an Audient iD14's sound in Windows (06 Mar 2021)
Intro to streaming and recording concepts (06 Mar 2021)
My video editing software (01 Mar 2021)
Wanted: mirrorless camera & lens for livestreaming (24 Nov 2020)
Writing & graphics for scheduled Facebook Live videos (21 Apr 2020)
Livestreaming Music Diary - Facebook Live (20 Apr 2020)

vscode

How I set up VSCode for a new Salesforce project (21 Dec 2021)
Random handy CumulusCI notes (13 Jul 2021)
Setting up Windows Store Python with Pandas in VSCode (01 Oct 2020)
Migrating my Salesforce org backups from Eclipse to VSCode without messing up Git (07 Nov 2019)
Setting up VSCode to edit Salesforce metadata (10 Apr 2019)

web development

Check a URL with Selenium IDE (06 Apr 2022)
SvelteKit Minimum Viable Build (10 Jan 2022)
Localhost HTML with Python on Windows (09 Nov 2021)
How I added Algolia search: front-end (04 Oct 2021)
Inspecting an existing 11ty project (04 Oct 2021)
Customizing Sanity Studio beyond the schema (27 Sep 2021)
Jekyll doesn't do components? Liar! (09 Sep 2021)
Learn static site generation with Stackbit (28 Aug 2021)
Next.js Minimum Viable Build (23 Aug 2021)
Next.js for novices and dabblers (22 Aug 2021)
Adding Tailwind to a Jekyll site on Windows (06 Jul 2021)
Jamstack live preview tooling (15 Jun 2021)
Growing link underline, in Tailwind CSS (15 Jun 2021)
SEO savings, one bubble tea at a time (10 Jun 2021)
Tailwind JIT starter for Gatsby (07 Apr 2021)
Tailwind JIT starter for 11ty (play fast!) (19 Mar 2021)
Can 11ty host my podcast for free? (10 Mar 2021)
Stackbit can teach you web development (09 Mar 2021)
11ty Markdown -- group pets by color (08 Feb 2021)
Responsive, accessible navigation 5: HTML structure (08 Feb 2021)
Responsive, accessible navigation 4: Preventative troubleshooting (08 Feb 2021)
Responsive, accessible navigation 3: Constraining width (08 Feb 2021)
Responsive, accessible navigation 2: 11ty (08 Feb 2021)
Responsive, accessible navigation 1: Intro (08 Feb 2021)
5 things you need to know about Jekyll vs. 11ty Liquid includes (29 Jan 2021)
The first JavaScript I ever wrote (08 Jan 2021)
How to use Jekyll SSG with Headless CMS (02 Jan 2021)
How to break (and rebuild) the Jamstack (26 Dec 2020)
Hello World on Netlify Functions, Cloudflare Workers, & Vercel Functions (09 Dec 2020)
Passwordless Auth0 and Netlify functions: backend (07 Dec 2020)
Add users to Netlify Identity with Postman (07 Dec 2020)
A starter for Netlify Functions with 11ty (07 Dec 2020)
Drupal vs. 11ty with kittens & puppies (05 Nov 2020)
Movable page builder components in Sanity CMS (27 Oct 2020)
Algolia attributes are flexible (15 Oct 2020)
Sanity datatable serializer for 11ty sites (10 Sep 2020)
Choosing a headless CMS without losing your head (24 Aug 2020)
Why do bloggers love Markdown? Why use MDX? And other notes from MDXConf 2020 (24 Aug 2020)
What is a static site generator? (18 Aug 2020)
What is static web hosting? (18 Aug 2020)
Heroku live previews for Gatsby + Sanity sites (17 Aug 2020)
HowToGraphQL.com Notes (09 Aug 2020)
Gatsby Cloud live previews for Sanity-based sites (21 Jul 2020)
Gatsby Minimum Viable Sanity Template (08 Jul 2020)
Sanity CMS Minimum Viable Build (07 Jul 2020)
Why WYSIWYG static site CMS's love Gatsby (24 Jun 2020)
How I brought my Google Page Speed from 80 to 91 in 5 minutes (23 Jun 2020)
Gatsby React WYSIWYG CMS-Friendly Markdown (22 Jun 2020)
Gatsby React Minimum Viable Markdown Template / Component (18 Jun 2020)
Gatsby Minimum Viable Build (09 Jun 2020)
Gatsby for novices and dabblers (09 Jun 2020)
Netlify CMS Jekyll Minimum Viable Build (21 Feb 2020)

windows

SSH or SFTP into a Linux server from a Windows machine with key-based authentication (17 May 2022)
Setting up Windows Store Python with Pandas in VSCode (01 Oct 2020)
Setting up Python on Windows with Anaconda (05 Mar 2019)
Setting up Python on Windows with Miniconda by Anaconda (04 Mar 2019)
Git and SourceTree setup with AWS federation on Windows (20 Feb 2019)

xml

Intro to XML, JSON, & YAML: the book (04 Sep 2020)
Forcelandia 2019 XML & JSON Conference Talk Resources (31 Jul 2019)
XML for Salesforce Administrators: DemandTools Configuration (08 May 2019)
Intro to XML and JSON #7: Recap & Real World Use (26 Apr 2019)
Intro to XML and JSON #6: JSON (26 Apr 2019)
Setting up VSCode to edit Salesforce metadata (10 Apr 2019)
Intro to XML and JSON #5: XML/CSV Conversions (03 Apr 2019)
Intro to XML and JSON #4: XML Values (03 Apr 2019)
Intro to XML and JSON #3: XML Items & Keys (03 Apr 2019)
Intro to XML and JSON #2: Data's Shape (25 Mar 2019)
Intro to XML and JSON (16 Mar 2019)

yaml

Intro to XML, JSON, & YAML: the book (04 Sep 2020)

Tweet Share on LinkedIn