Tuesday, 31 March 2015

Data Import Simplified: Excel to SQL Using Stored Procedure

As a programmer, one of the most common problems I face during data migration is the diverse forms that data comes in, rendering import of that data into SQL Server quite a cumbersome task! In fact, last week itself I was working on data import from as much as five different sources, all in their own disparate formats! Importing data through code was killing my project!!! That’s when I came up with the idea of OPENROWSET method through stored procedure in SQL Server. Now I can import...
Read More »

Salesforce Magic Tricks: Opportunity

Hello fellow magicians! How does it feel to be able to do magic with Salesforce? It’s a surreal feeling, isn’t it? In the previous posts, we discussed some quick tips and tricks about Lead & Account object, as well as Case & Report. After a longer than anticipated hiatus, I am back, but this time with a great idea presented by Steve Molis for the Opportunity object! Opportunity: Unidirectional Sales Stage Cycle Salesforce allows users to move from an advanced stage of the Sales...
Read More »

Amazing Visualforce Pages with AngularJS

It started out as a normal day at work. Midway into it, my client sent this requirement of implementing a Visualforce page which required predictive search, sorting on the basis of columns, completely responsive UI and the icing on the cake: everything needed to be done in a jiffy!! The day was normal no more! My first instinct was to use the usual apex calls to the server, but that reduced the response time like anything. I was in a frenzy. I asked my peers, searched the solution through...
Read More »

Monday, 30 March 2015

Custom Permissions – boon for Product Development

Salesforce.com introduced Custom Permissions with the summer’14 release. Custom Permission enables the user to set permissions and access levels just the way he wants, quite helpful when you are developing products using Salesforce.  Developers around the world have taken a fancy to Custom Permission as it is a more generic, yet an appropriate approach to fulfil requirements. Let me illustrate how you can take advantage of custom permissions. Suppose you are developing a Loan-Based...
Read More »

Sunday, 29 March 2015

9 Things I Love About Magentrix

Recently, one of my clients wanted me to build a customer portal for him. Normally, I would not think twice before recommending Salesforce Communities but this case was a tad different. My client needed cost-effective licensing for his portal which would enable him to provide role-based access to his users. Additionally, he needed the portal to be completely branded as per his company guidelines. This would be time consuming to achieve through Salesforce, as Salesforce does not have in-built...
Read More »

Salesforce to Amazon Integration Using Signature Version 4: Part 1

If you are using Salesforce and are in need to store large sets of data, you may want to consider Amazon’s cost-effective storage as an alternative. Amazon provides access to its broad spectrum of AWS services by leveraging different versions of a signature such as version 1, version 2 and version 4. What’s in a Signature? Moving away from the bookish definitions, a signature is simply a computed alpha numeric value of a certain length that acts as a mechanism to verify the identity...
Read More »

Friday, 27 March 2015

A Beginner’s Guide to GoClipse Installation

GoClipse is an Eclipse plugin that adds Eclipse’s IDE functionality to Google’s Go programming language. The purpose of GoClipse is to create an environment in which development using Go is easy for a rookie user. Often, rookie Go developers like you and me, truly struggle to install GoClipse in any of the Eclipse versions, and it is this effort which inspired me to write this post. Here, I have listed down a step-by-step procedure to install GoClipse easily and run your first Go program...
Read More »

Tuesday, 24 March 2015

The Magical world of Model Binder

For those who are new to ASP.NET MVC framework but have substantial experience on ASP.NET Web form like yours truly, getting the value of HTML form at client side and binding it to the model at server side is nothing short of absolute magic! This is achieved through Model binder which gets the values from the HTML form and binds them to the model, or the class having getter/setter properties on the server side. In order to fully understand and appreciate the significance of model binding,...
Read More »

Thursday, 19 March 2015

How to Build a Hierarchical Map using Apex

I was recently working on an integration project where we needed to generate a simple piece of output! I needed a simple hierarchical map of Salesforce objects which can be retrieved from relational queries. Sounds simple enough, right? You couldn’t be farther from reality though. It ended up giving me sleepless nights! Ticking off the list… When I started designing, I realized that there are many things that had to be taken into consideration for the design to hold up in the long...
Read More »