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.

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.

Boo!

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

Better Salesforce Insert/Update Operations with Jitterbit Caching

28 Oct 2019 🔖 salesforce jitterbit integration tutorials tips 💬 EN

Combined with “external ID” fields, Salesforce’s “upsert” data-loading option is a godsend for dumping data from legacy systems into Salesforce.

But what do you do if you only want to insert new records or only want to update existing records, using the external ID as an inter-system matching key, considering Salesforce’s “insert” and “update” operations don’t support matching on external IDs?

Continue Reading

Disabling Lightning Experience w/ Python and Selenium in Salesforce

12 Sep 2019 🔖 salesforce tutorials python selenium 💬 EN

You saw me be too lazy to click buttons in No-Permissions Salesforce Profile w/ Python and Selenium: watch me do it again turning Lightning Experience off in all my Custom Profiles.

(And watch me get shunned from the Salesforce community for making it easier to neuter the Winter ‘20 release feature that flips Lightning Experience on?)

Continue Reading

Recalculating Salesforce Formula Fields in Apex

10 Sep 2019 🔖 salesforce apex tips tutorials 💬 EN ( FR )

Salesforce Winter ‘20 has a new Formula class in Apex – check out what it can do.

Continue Reading

Recalcul des champs de formule Salesforce en Apex

10 Sep 2019 🔖 salesforce apex astuces tutoriels 💬 FR ( EN )

L’édition hiver ‘20 de Salesforce inclue une nouvelle classe Apex Formule – regardez ici un exemple de ses capacités.

Lire plus

No-Permissions Salesforce Profile w/ Python and Selenium

23 Aug 2019 🔖 salesforce tutorials python selenium 💬 EN

I needed a fresh “no permissions” Salesforce profile in a mature org.

I couldn’t get the Metadata API working fast enough to my liking, so I gave up and built a “robot version” of myself with Python and Selenium, hijacked my own browser, and watched fake-me click thousands of buttons at computer speed.

(Does that make my computer itself the #AwesomeAdmin?)

Here’s how I did it.

Continue Reading