Computers, Music, and Thoughts
Recently had a project to use Jitterbit to query and pull data out of Salesforce.com in to a CSV file to import in to another system. All great and fine except long text fields with carriage returns were wrecking the CSV. This simple fix was all that was needed: Replace(root$transaction.response$body$queryResponse$result$records.Account$BillingStreet$,’\n’,”); Got it right off the support…
I am a huge fan of creating global test classes within Salesforce that leverage one testSetup section to set up the data that then can be used many times to test the many different methods and classes. Gone are the days of having a million test classes to manage and update every time changes are made in…
Do the following to get a list of Objects by their API names: Pop in to Workbench Run the following query:SELECT SobjectType FROM ObjectPermissions Click Bulk CSV to download Click the query button to execute Open in Excel and Dedupe A quick and easy way to generating a list for creating backups using ‘Backup-force.com’: https://github.com/neowit/backup-force.com
There are a couple solutions both paid and free for backing up your Salesforce.com Metadata in addition to using an IDE like Eclipse. If you need something ‘free’ and on a schedule the best solution I have found has been: Alan Morey’s Force Meta Backup To use this tool though there’s a couple of prereq’s…
One gap with freezing users in Salesforce.com is the ability to go back and find those users. Google is your friend for finding the answer. There’s even an article from Salesforce: How can I tell what Users are Frozen via the API? The below is my take on it. Use workbench/bulk/csv to create an exportable list that…
Restart Chrome…it has an update that has been applied. Click Help -> About to validate but this issue drove me nuts and since I work on a Mac that only needs rebooting when the VPN crashes (1-4 weeks) I was periodically suffering through this one. It is amazing how long you can deal with a…
I recently had a use case where I was going to take a drop down value and use that to pull a value from a separate lookup object. I would have “Hourly” and my logic would return “Hourly__c” which I could then use dynamic SOQL and sObjects to do some magic. I did not want to use hardcoded values…
No school like the old school. A quick way to give quick visual feedback in the Classic Salesforce.com UI is to use the built-in icons in conjunction with a formula field. A source that I have used forever seems to work and then not work so I found another URL that seems to work: Does…
One tool I use to do bulk data loads in to Salesforce.com does not allow mapping one source to multiple destination fields. You can of course use workflows or code to backfill the data once it gets in but a cheaper/easier alternative if it is just one field is the following: // Works on Windows…
Custom Settings are one of the great ways a developer can give admins power to update logic, settings, and the behaviour of code and really make code more flexible. This is just a quick reference of all the cool ways you can pull those settings back out without having to use a SOQL statement. The…