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.

Salesforce Classic slow in Chrome? Use Firefox until Spring '20

12 Feb 2020 🔖 salesforce tips 💬 EN

Are your Salesforce “Classic” record pages loading slowly in Chrome, only to eventually load with broken content?

Continue Reading

Tutorial: Flow External Services for Salesforce Admins

30 Jan 2020 🔖 tutorials api salesforce flow integration architecture 💬 EN

Who remembers my #GIFSquad-friendly Salesforce Flow project from last summer, teaching Apex-Defined Data Types? I just learned that you can build the same project in Flow without writing any Apex code!

Continue Reading

Salesforce Spring '20 Community Guest User Apocalypse

08 Jan 2020 🔖 salesforce security architecture 💬 EN

All right … a nuisance, not an apocalypse. Heads up: There are some things changing with Guest User access Salesforce Communities in the Spring ‘20 release that can break your business’s customer experience if you’re not on top of them.

Continue Reading

Flow Invocable Apex with Any Salesforce Object Type

02 Jan 2020 🔖 salesforce flow architecture 💬 EN

In case you missed it (hat tip to the “Salesforce Discord Abridged Release Notes” on my part), when working with a developer to build out snippets of “Invocable Apex” (kind of like sub-flows, but written in code) to run from your Salesforce flows, as of Spring ‘20 you can make them work on any Salesforce object.

Continue Reading

Migrating my Salesforce org backups from Eclipse to VSCode without messing up Git

07 Nov 2019 🔖 salesforce vscode eclipse 💬 EN

Here’s how I migrated all my “Salesforce configuration metadata backups” from Eclipse to VSCode without my 5-year-old Git history really caring.

Continue Reading

Workaround: Salesforce Flow Picklist-Related Invalid Type Error

06 Nov 2019 🔖 salesforce tips flow apex 💬 EN

I received an INVALID_TYPE_ON_FIELD_IN_RECORD / value not of required type error that made no sense when editing a Salesforce flow. Turns out it’s a known error. Here’s how I got around it.

Continue Reading

A Jitterbit Case Study: Higher Education Adventures in Salesforce

04 Nov 2019 🔖 salesforce jitterbit integration 💬 EN

Boy have I been on a database integration adventure these last few weeks. In this series, I’ll review some of the more interesting hoops I jumped through with Jitterbit to load data in CSV files provided by an external admissions application partner (think common app … only this was a much smaller organization) into tables of a Salesforce org.

Continue Reading

Solved: 2 Salesforce ETL Errors

01 Nov 2019 🔖 salesforce integration tips jitterbit 💬 EN

I’m blogging about 2 Salesforce errors I ran into today so that your search results will, hopefully, be a little bit more helpful when you, too, see them.

bad value for restricted picklist field & id value of incorrect type

Continue Reading

Clearing A Jitterbit FillDataElements Error

31 Oct 2019 🔖 salesforce jitterbit integration tips 💬 EN ( FR )

Today is Halloween, so to scare me, Jitterbit threw a “FillDataElements” error when I tried to build a Salesforce Insert operation and it didn’t like something I’d tried to do with a date.


Luckily … I found a trick (rebuilding my Operation from scratch once I’d fixed the underlying problems) that brought me a treat (the error stopped appearing).

Continue Reading

S'occuper d'une erreur FillDataElements en Jitterbit

31 Oct 2019 🔖 salesforce jitterbit integration 💬 FR ( EN )

Aujourd’hui, c’est l’Halloween. Et Jitterbit m’a bien effrayé en lançant une erreur FillDataElements lorsque j’élaborais une opération d’insertion Salesforce.

Hou là là ! 👻

Heureusement, j’ai découvert une bêtise (réélaborer l’opération de zéro) qui m’a plu autant que des friandises.

Lire plus