Filed away in the “Why is this so hard?”, extracting a list of users related to a Public Group, Queue, or Permission Set in Salesforce.com is harder than it should be. Not in reporting and a pain with Dataloader and XLS. There are lots of workarounds and methods for doing this but it should be easy!…
Category: Stupid
Fixing Salesforce.com Developer Console Jerking Back Up or Snapping Back
A strange issue I have had with Salesforce.com Developer Console on Chrome for a couple of (don’t laugh) a couple of months is that as I scroll down the page will jerk back up to the previous page. In scanning altslash.org I saw this headline: Chrome Now Uses Scroll Anchoring To Prevent Those Annoying Page Jumps…
Data Loader Error Message Fix: Failed to parse detail
If you have gotten the following message: Failed to parse detail: START_TAG seen …</sf:exceptionMessage><sf:upgradeURL>… @1:752 due to: com.sforce.ws.ConnectionException: unable to find end tag at: START_TAG seen …</sf:exceptionMessage><sf:upgradeURL> … @1:752 Or something like that while trying to load in to Salesforce.com Data Loader, try upgrading your version. I had 35.00 and 37.00 both fail where a…
Silly Admin Trick: Avoid Tables going across Page Break
When doing PDF’s in Salesforce.com one thing that can be tricky is dynamic content caught between the page break. Signature block being a good example of something that you want kept together on the page. Using the CSS ‘page-break-inside’ can work 100% the first time or if you have a busy page with lots of…
Silly Admin Trick: Date Formats without adding Zula Time
Microsoft Excel…it loves to format dates in a crazy way. By default it will do day dash 3 digit month name and 2 digit year like this: 13-Sep-2016. Not helpful. In the U.S. your first instinct would be to change it to 2-digit day dash 2-digit month dash 2 or 4-digit year: 10/13/2016. Salesforce.com does…
Silly Admin Trick: Quickly Add Custom Fields to Change Set
Adding Custom Fields to a Change Set can tedious. A quick way to add a bunch of fields to a Salesforce.com outbound change set is to create a report with those fields and save it, add the report to the change set, and then click the “View/Add Dependencies” and viola!~
ERROR: std::bad_alloc
If you are using CSVFIX and running UNIQUE against a large data set you have to remember that CSVFIX loads the entire file in to memory to do the processing. So if you get this…check and watch your environments memory. Mine only had 3gig…it could use a little more for parsing 3+ million rows. ERROR:…
Quick Tip: CSVFIX Skip First Line
Update Oct 2017 – For most csvfix commands the ‘-ifn’ command will also skip the first line. I say most as I know that it does not work for “read_dsv” which is ok as long as you are not combining files in addition of converting to CSV. The below solution is also good if you’re getting output…
Quick Tip: View Headers in Office 2016 (that works on a Mac)
To view header info in Office 2016 from the email list, right click and click ‘View Source’ and this will allow you to see all the email info. To view header info from the Web Client click in to the email and the drop down beside the ‘Reply All’ button in the top right there’s…
Silly Admin Trick: Page Block Text Wrapping
PageBlock, PageBlockSection, and PageBlockTable are all the devil I know this. But I support a lot of legacy Visualforce pages and before we make the jump to the Lightning UI I am updating a lot of these pages and find that the text wraps in the ‘PageBlock’ Title attribute for no reason at all. So this…