Create public website using force.com platform

The amazing Salesforce platform allows us to create public website even with developer edition of the platform. The website address will be either SubDomainPrefix.force.com or www.YourCustomDomain.com. This is my public website created using Developer Edition. The major limitation I found for a force.com public website is the 500MB of daily bandwidth and ability of creating only one website.

Reference: An Intro to force.com + steps for creating your own website in a few minutes, Force.com sites overview – contains more details about possible custom domain options, Force.com Public Website implementation guide

Posted in Force.com, Salesforce | Leave a comment

APEX – @isTest annotation

APEX test classes are marked with @isTest annotation and it has an added benefit – the class will not be counted against 3MB organization code size limit.

Posted in APEX, Salesforce | Leave a comment

How to Think Like a Developer

Critical thinking is a core characteristic which most of the good developer has in common. And best part is that it is a skill which can be learned and mastered through continuous practice. In this article is Derk Chen (Product Manager at Udacity) writes about how it can be learned and mastered. Anyone with a strong determination and regular practice can think like a Developer.

Must watch this short You Tube video on Critical Thinking:

Posted in Best Practices and Guidelines, My Inspirations | Leave a comment

3 Questions to be asked while understanding Business Requirements from Client

Here is 3 very simple yet very effective questions which can be asked from Client while understanding Business Requirements for building IT solutions:

    What is your Vision & Goal?
    What are your pain points?
    Who all are the key players/ stakeholders?
Posted in Best Practices and Guidelines, Knowledge Sharing | Leave a comment

Developing Mobile Apps: Native, HTML5 or Hybrid: Understanding Development Options

A nice article answering your Questions here.

Posted in Knowledge Sharing | Leave a comment

Salesforce Dataloader

Salesforce dataloader is an easy to use graphical tool which installs on your local computer, connects to your Salesforce Instance and can populate your data (CSV, Excel, MS-Access) in Salesforce Instance and can also export your Salesforce data in these formats.

Features highlights:

  • An easy-to-use wizard interface
  • An alternate command line interface
  • A batch mode interface with database connectivity
  • Support for large files with up to millions of rows
  • Drag-and-drop field mapping
  • Support for all objects, including custom objects
  • Detailed success and error log files in CSV format
  • A built-in CSV file viewer
  • Supported on Windows 7 and Windows XP, though an unofficial OS X version is also available
  • Reference: Dataloader Technical Library

    Posted in Salesforce | Leave a comment

    SQL Server Source Control

    Database development traditionally hasn’t used source control at all, as a result there has been challenges in maintaining Change Control Versions. But now it is possible and very convenient as well. Read on this article and Download the free Ebook.

    Posted in Knowledge Sharing | Leave a comment

    Informatica – Salesforce Data export/import to SQL Server

    I have been looking for a way to synchronize Salesforce data to SQL Server and I find Informatica to be the thing I have been looking for. It installs on your Salesforce instance (native Salesforce App) and an connect to SQL Server to import/export data. It requires Secure Agent to be installed on your computer (available for Windows and Linux). The Secure Agent is easy to install. It allows you to integrate on premise applications, cloud applications and local files.

    I am not sure as of now, if SQL Server have any feature which could directly connect to Salesforce and could synchronize Salesforce data in SQL Server database. It would be a must ask question for me in coming SQL Server Event in Gurgaon.

    Posted in Knowledge Sharing, Salesforce | Leave a comment

    How to write SOQL queries in Salesforce

    There are many ways to write and execute SOQL (Salesforce Object Query Language) in Salesforce such as Workbench. Just login using your Salesforce Credentials (you have access to Workbench) and start writing and executing SOQL queries. You may either use the query wizard or can directly write query in SOQL query box and execute the same. Some of the sample SOQL queries are below.

    A simple SELECT statement:
    SELECT AccountNumber, AccountSource FROM Account

    This query is valid in most of the database query languages such as SQL but it is invalid for SOQL:
    SELECT * FROM Account (This is a invalid query in SOQL)

    WHERE clause with numeric check:
    SELECT ActualCost,AmountAllOpportunities,AmountWonOpportunities,BudgetedCost FROM Campaign where Actualcost=11400

    WHERE clause with string check:
    SELECT ActualCost, AmountAllOpportunities, AmountWonOpportunities, BudgetedCost, Description, Name FROM Campaign where Name = 'GC Product Webinar - Jan 7, 2002'

    LIKE queries:
    SELECT ActualCost, AmountAllOpportunities, AmountWonOpportunities, BudgetedCost, Description, Name FROM Campaign where Name like '%GC Product%'

    Using built-in functions:
    SELECT Min(BudgetedCost), Max(BudgetedCost) FROM Campaign

    Posted in Salesforce, SOQL | Leave a comment

    Smart devices as Web Server – Just an imagination

    Given the high end configurations of modern smartphones – is it not possible that Microsoft or Google think of creating a Internet Information Server or Personal Web Server type of utility such that these devices turns in to web servers. This way these devices are able to expose client-server apps from their devices just like a web server. And devices’ mobile number could work like their IP address so that the apps exposed by these devices could be available with a protocol and DNS address like: https://mobile.009199115588/home.

    I know this is a dream but I believe this is possible and may be something in future this will a big new technology revolution.

    Posted in Life, My Inspirations | Leave a comment