Phil's Salesforce Tip of the Week

Good Advice – Phil’s Salesforce Tip of the Week #485

Welcome to my Salesforce Tip of the Week #485

 

Tip 1 – Good Advice

Good Advice

Looking for some good advice?

Perfect for new year, here is a great article from the Guardian “100 ways to slightly improve your life without really trying”.

Better than making lame ‘join the gym’ resolutions!

 

Tip 2 – Using Data Loader?

Using Data Loader

Late last year it was announced that a major security flaw had been found in the Apache Log4j library which affected almost every computing organisation in the world – with Salesforce being no exception.

One of the benefits for Salesforce customers is that Salesforce can rapidly patch and rollout fixes across all its services meaning that for customers very little needs updating as we don’t have software from Salesforce running on our machines.

One small caveat to this however is the Data Loader application which does have this issue. Salesforce recently release a bulletin instructing customers and partners to download version 53.0.1 or later of the Data Loader (i.e. a version after December 20th 2021) to ensure that you stay safe.

So if you are a Data Loader user, best make sure you keep up to date! See here for the Help page..

 

Final Tip Of The Week – Sign Up

Remember if you have enjoyed this Tip of the Week then sign up for the weekly Friday email, direct to your inbox here. And feel free to get in touch if you have any ideas for future Salesforce tips!

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!