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…

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: Double Quoted CSV Data

Sometimes I get SAP data that is quoted with both single quotes and double quotes. The data looks something like this: “‘001′”,”’01′”,”‘100123′”,”‘#’”,”‘#’”,”‘#’”,”‘100123′” CSVFIX will strip out the extra single quotes with the following command: csvfix read_dsv -s “,” -csv Input_File1.csv > Output_File1.csv Seems unneeded but otherwise your output is double quoted. I blame SAP. The…

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…

Silly Admin Trick: Alternate Row Colors in Visualforce without CSS or Jquery for PDF Renderas

In Salesforce.com, when you set up a Visualforce page to ‘renderas’ to export to PDF, there are lots and lots of constraints. I’m going to do a larger post on some of the tips and tricks to get PDF’s in Visualforce looking nice without hardcoding every style. Today’s silly admin trick is how to get alternate…

Upgrading to Windows 10…or maybe not.

My game machine is or was a smoking i7 hog with all the bells and whistles of the day but even after some small memory and SSD upgrades is still 5+ years old. And I have a lot of stuff that barely worked on Win7…so I’m probably going to pass on upgrading it to Windows…

Disabled Bootstrap Dropdown Menu Still Clickable

It is a strange use case but for certain situations where you want to disable functionality due to the status of a record, bootstrap offers the handy dandy ‘disable’ class that works for drop downs, buttons, and links. Button’s works without fuss and when disabled are totally not clickable but to get a dropdown to mimic…