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

Bienvenue! Welcome!

My goal is to help you work faster.

I must speak and teach until I hear 10 people say, "That thing you taught me? I used it! And it saved me time!"

(Ahem ... although maybe blogging slower than I'd hoped. Ugh, coders' repetitive stress injury.)

So check out the tutorials. Play with code. Tell me about your triumphs.

Studying programming by writing glossaries

17 Feb 2019 🔖 tips 💬 EN

While I can relate to the phrase, “I don’t know what any of those 30 words mean … it feels like too much to ask about all of them,” a study trick from grad school has greatly increased my ability to “fake it till I make it” in these situations!

Continue Reading

Cleaning bad Pardot data with Python

15 Feb 2019 🔖 python pardot salesforce tutorials api 💬 EN

This is an intermediate-level “Python for Salesforce” post – but still “admineloper”-level (e.g. you can code a basic trigger comfortably). Today we’ll go into a bit different usage for Python than we’ve been doing with CSV/XLSX-modifying!

Continue Reading

Git brain dump

12 Feb 2019 🔖 git tutorials 💬 EN

I barely know anything about Git, but I’m about to get trained in on more.
So I’m checkpointing what I think I do know at this point, in an “explain it like I’m five” fashion.

“OMG, you have it all wrong!” comments welcome.
(“OMG, that’s technically correct but painfully oversimplified” comments not necessary at this point.) 😃

Continue Reading

Telling Sourcetree about one of my GitHub repositories

12 Feb 2019 🔖 git tutorials 💬 EN

I edit this blog using Git. Learn how I set up graphical software called SourceTree to make it easier.
(This is also a gentle way to start getting used to concepts behind Git if you’re a Salesforce administrator who wants to learn SFDX.)

Continue Reading

Modification des données CSV / XLSX en Python pour admins Salesforce : vidéo et notes

09 Feb 2019 🔖 python pandas csv excel feuilles de calcul tutoriels salesforce samedi salesforce 💬 FR

Revoir la démonstration du 09 fév sur la simplicité et la puissance du Python pour modifier les feuilles de calcul – déstinée surtout aux administrateurs Salesforce.

Lire plus

Python for Salesforce: List unique values found across similar Salesforce fields

31 Jan 2019 🔖 python pandas csv excel tutorials salesforce 💬 EN ( FR )

Salesforce SOQL’s SELECT...COUNT...GROUP BY works great to find unique values present in a single field, but what if you have 50 nearly-identical fields and want to find unique values used in any of them? Python to the rescue – read on!

Continue Reading

Python pour Salesforce: Énumérer les valeurs uniques à travers plusieurs champs Salesforce

31 Jan 2019 🔖 python pandas csv excel tutoriels salesforce 💬 FR ( EN )

Le SOQL SELECT...COUNT...GROUP BY de Salesforce marche très bien pour énumérer les valeurs uniques d’un seul champs. Mais si on a 50 champs presque identiques, et si on veut trouver les valeurs uniques à travers l’ensemble de tous les champs ? Python à l’aide – lisez pour découvrir comment !

Lire plus

9 fév: Démonstration de Python pour admins Salesforce (FR)

24 Jan 2019 🔖 python pandas csv excel feuilles de calcul tutoriels salesforce samedi salesforce 💬 FR ( EN )

Pendant cette démonstration interactive (mini-atelier) #SalesforceSaturday, on verra la simplicité et la puissance que la langue de programmation Python vous offre pour modifier vos feuilles de calcul (telles que les fichiers CSV que l’on exporte de / importe avec #Data Loader) quand Excel vous présente des obstacles (lenteur, répétitivité, jointures VLOOKUP, etc.).

Lire plus

Feb. 9: FRENCH-language demo of Python for Saleforce admins!

24 Jan 2019 🔖 python pandas csv excel spreadsheet tutorials salesforce salesforce saturday 💬 EN ( FR )

In this Salesforce Saturday “hands-on demo,” I’ll show you simple, powerful Python code for modifying spreadsheets like you would export from / import into Salesforce.

Continue Reading

Proper-Casing CSV/XLSX Data With Python

10 Jan 2019 🔖 python pandas csv excel spreadsheet tutorials salesforce 💬 EN

Helen Anderson’s article “Excel Series: Formulas and Functions” went around Twitter today, and her first steps were so beautifully simple I thought, “Hey, let’s see what they look like in Python for a little compare-and-contrast.”

Continue Reading