Phil's Salesforce Tip of the Week

Command Line Data Loader – Phil’s Salesforce Tip of the Week #450

Tip 1 – Command Line 

(2 words that can strike fear into ‘non-developers’) Thank you to our Lead Developer Simon for sharing a use of the Command Line that many probably do not know about…

“Did you know that DataLoader can be launched from the command line? Setup can be fiddly, but once working this can be a robust solution for getting data in and out of Salesforce. Run a command after exporting data from databases, run a scheduled job to ensure Salesforce data is ready for work, or leave a shortcut to a batch file on the desktop of a User who needs to import data occasionally. See this for more info”.

Here is some further information from the Data Loader guide

When running Data Loader in batch mode from the command line, several operations are supported. An operation represents the flow of data between Salesforce and an external data source, such as a CSV file or database. You can use the following operations. Enter values in the process.operation parameter in lowercase

Operation Description
extract Uses the Salesforce Object Query Language to export a set of records from Salesforce. The exported data is written to a data source. Soft-deleted records are not included.
extract all Uses SOQL to export a set of records from Salesforce, including existing and soft-deleted records. The exported data is written to a data source.
insert Loads data from a data source into Salesforce as new records.
update Loads data from a data source into Salesforce, and updates existing records with matching ID fields.
upsert Loads data from a data source into Salesforce. Existing records with a matching custom external ID field are updated. Records without matches are inserted as new records.
delete Loads data from a data source into Salesforce, and deletes existing records with matching ID fields. Deleted records are moved to the Recycle Bin.
hard delete Loads data from a data source into Salesforce, and deletes existing records with matching ID fields without first storing them in the Recycle Bin.

Tip 2 – Help when you can

I know there are a lot of important causes vying for our attention. We at Cloud Galacticos wanted to show our support for our friends and colleagues in India, but were unsure of how to do so. Just in case anyone is looking, we found the DEC a reliable and trustworthy place to donate.

Final Tip – Sign up

Remember if you have enjoyed this week’s tip then sign up for the weekly email, direct to your inbox here!

Phil's Salesforce Tip of the Week

Apex Recipes – Phil’s Salesforce Tip of the Week #449

Tip 1 – Apex Recipes 

I recently revisited this post from the Salesforce Developers Blog by Kevin Poorman, introducing Apex Recipes last year. “Apex Recipes is a library of concise, meaningful examples of code for common use cases following best practices. They reflect enterprise patterns that can be utilized for real world solutions.”

Follow the instructions in the post to install the app, or you can do a quick Trailhead badge which guides you through it.

Look at the Trailhead module here…”Quick Start: Explore the Apex Recipes Sample App

Tip 2 – Take a break

I like this article from BBC this week, mainly because it gives 3 practical ways to take a break from screen time. It is worth a 5 min read, but my favourite is to do some ‘walking meetings’. If you don’t need to present slides, or take detailed notes, put your headphones on and walk while you talk. Fresh air, extra steps, and less screen time!

Final Tip – Sign up

Remember if you have enjoyed this week’s tip then sign up for the weekly email, direct to your inbox here!