Computers, Music, and Thoughts
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…
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!~
In my previous life/position, I was in charge of all things Technology including Desktop Support. One of the challenges of good desktop support other than of course the obvious: Great Customer Service! was of course keeping the machines patched, clean, and in good working order. In the last 10 years this was made a little easier by…
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:…
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…
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…
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…
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…
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…
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…