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.
Setting up Python on Windows with Miniconda by Anaconda
04 Mar 2019
After documenting this process step-by-step, I’ve concluded that the best way to install Python on your computer is to follow these shorter instructions and simply:
Download & install software called “Anaconda”. Look for software called “Spyder” in your Start menu, run it, and start coding.
You’ll be much happier than you would following these instructions, which take you through installing “Miniconda” (made by the makers of Anaconda) and adding functionality like “Spyder” and “Pandas” by hand.
But Miniconda takes less space, and may be easier to install without admin rights to your computer, so it’s worth documenting step-by-step.
Plus, even if you install “big Anaconda,” as I like to call it, the instructions on installing & updating “modules” in this documentation may come in handy if you need to install extra modules like “Simple Salesforce” or if you want to update your Python installation in a year.
Logging into Salesforce's Marketing Cloud API (w/ Python or Postman)
26 Feb 2019
Sometimes, just getting a login acknowledgement from an API is half the battle of using it.
Here, with screenshots, is how I finally logged into Salesforce Marketing Cloud’s API.
I used Python, but most of the steps have nothing to do with code.
Any language that can do HTTPS POST requests will do.
Git and SourceTree setup with AWS federation on Windows
20 Feb 2019
Do you have “single sign-on” for your Amazon Web Services accounts, but need to set up your computer to talk to their CodeCommit git repository hosting?
If you have Windows, Python, and Git installed on your computer, here’s how you can do so without messing up any other plain-old-username-and-password repositories you connect to!
Studying programming by writing glossaries
17 Feb 2019
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 ReadingCleaning bad Pardot data with Python
15 Feb 2019
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 ReadingGit brain dump
12 Feb 2019
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.) 😃
Telling Sourcetree about one of my GitHub repositories
12 Feb 2019
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.)
Modification des données CSV / XLSX en Python pour admins Salesforce : vidéo et notes
09 Feb 2019
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 plusPython for Salesforce: List unique values found across similar Salesforce fields
31 Jan 2019
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!
Python pour Salesforce: Énumérer les valeurs uniques à travers plusieurs champs Salesforce
31 Jan 2019
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 !
