smallik123
smallik123
Sanjeev Mallik
67 posts
I am still searching myself
Don't wanna be here? Send us removal request.
smallik123 · 10 months ago
Text
How to integrate Microsoft team from PHP application
cdata To integrate Microsoft Teams with a PHP application, you’ll need to use the Microsoft Graph API, which provides a unified programmability model for Microsoft services, including Teams. The Graph API allows you to access Teams data, such as channels, messages, and members, and perform actions, such as sending messages and creating meetings. Here are the general steps to integrate Microsoft…
0 notes
smallik123 · 2 years ago
Text
How to Create Custom API V8 in Suite CRM 8
Creating a custom API in SuiteCRM 8 involves a few steps. Here’s a high-level overview of the process: Define the API endpoint: Decide on the functionality you want to expose through your custom API. Determine the URL endpoint for your API, such as custom/application/Ext/Api/V8/. Create a new Custom API controller: In the SuiteCRM 8 source code, navigate to the…
View On WordPress
0 notes
smallik123 · 5 years ago
Text
Python Script for Data Migration
Python Script for Data Migration
Migrate data from CSV to Postgres and Postgres to MySQL step by step:-
import pymysql, psycopg2, csv
# Postgres Connection properties postgres_connection = psycopg2.connect(user = “postgres”, password = “*****”, host = “127.0.0.1”, port = “5432”, database = “python_db”) postgres_cursor = postgres_connection.cursor() print (“Opened Postgres database successfully”) # MySQL Connection properties my…
View On WordPress
0 notes
smallik123 · 5 years ago
Text
Salesforce Validation Rules
Validation rules verify that the data a user enters in a record meets the standards you specify before the user can save the record. A validation rule can contain a formula or expression that evaluates the data in one or more fields and returns a value of “True” or “False”. Validation rules also include an error message to display to the user when the rule returns a value of “True” due to an…
View On WordPress
0 notes
smallik123 · 5 years ago
Text
Salesforce Developer Interview Questions & Answers
Salesforce Developer Interview Questions & Answers
  1. Can you name three types of object relationships available in Salesforce?
A lookup relationship can be used to link two objects together. It is the most basic type of relationship that creates a child-parent relationship between two objects.
A master-detail relationship can also be used to link two objects together. A master-detail relationship creates a tight relationship between the parent…
View On WordPress
0 notes
smallik123 · 6 years ago
Text
SFDC - Data Loader Command Line Introduction - Invoke Data Loader on window
SFDC – Data Loader Command Line Introduction – Invoke Data Loader on window
Step One: Create the Encryption Key File
Create an encryption key file by entering the following command. Replace [path to key file] with the key file path.
encrypt.bat —k [path to key file] – Note the key file path. In this example, the path is C:\Users\IEUser\.dataloader\dataLoader.key.
Step Two: Create the Encrypted Password
encrypt.bat –e <password> <key file path>
View On WordPress
0 notes
smallik123 · 6 years ago
Text
How to calculate date difference in JavaScript?
How to calculate date difference in JavaScript?
var DateDiff = { inDays: function(d1, d2) { var t2 = d2.getTime(); var t1 = d1.getTime(); return parseInt((t2-t1)/(24*3600*1000)); }, inWeeks: function(d1, d2) { var t2 = d2.getTime(); var t1 = d1.getTime(); return parseInt((t2-t1)/(24*3600*1000*7)); }, inMonths: function(d1, d2) { var d1Y = d1.getFullYear(); var d2Y = d2.getFullYear(); var d1M = d1.getMonth(); var d2M = d2.getMonth(); return…
View On WordPress
0 notes
smallik123 · 6 years ago
Photo
Tumblr media
at Bangalore, India https://www.instagram.com/p/BsP9mbLHQR6/?utm_source=ig_tumblr_share&igshid=mxb26mams5ql
0 notes
smallik123 · 6 years ago
Text
Difference Between - Keys in MySQL
Difference Between – Keys in MySQL
Primary key and Candidate key?
Primary key in MySQL is use to identify every row of a table in unique manner. For one table there is only one primary key. One of the candidate keys is the primary key and the candidate keys can be used to reference the foreign keys.
Primary key and Unique key?
While both are used to enforce uniqueness of the column defined but primary key would…
View On WordPress
0 notes
smallik123 · 6 years ago
Text
MySQL Joins in Simple Word
MySQL Joins in Simple Word
In MySQL the Joins are used to query data from two or more tables. The query is made using relationship between certain columns existing in the table. There are four types of Joins in MySQL.
Inner Join
Inner Join returns the rows if there is at least one match in both the tables.
Left Join
Left Join returns all the rows form the left table even if there is no match in the right…
View On WordPress
0 notes
smallik123 · 6 years ago
Text
Interfaces - object oriented programming
Interfaces – object oriented programming
Object interfaces allow you to create code which specifies which methods a class must implement, without having to define how these methods are implemented. Interfaces are defined in the same way as a class, but with the interface keyword replacing the class keyword and without any of the methods having their contents defined. All methods declared in an interface must be public; this is the…
View On WordPress
0 notes
smallik123 · 7 years ago
Photo
Tumblr media
at Bangalore, India https://www.instagram.com/p/BoFOCiAhCDo/?utm_source=ig_tumblr_share&igshid=oujamnllpxsv
0 notes
smallik123 · 7 years ago
Photo
Tumblr media
at Bangalore, India
0 notes
smallik123 · 7 years ago
Photo
Tumblr media
Time for relax after stressful day. (at BTM Layout)
0 notes
smallik123 · 7 years ago
Photo
Tumblr media
Gym with my best buddy (at Infosys Campus Bangalore India)
0 notes
smallik123 · 7 years ago
Text
SugarCRM – SugarQuery – Raw Methods
groupByRaw()
To add multiple fields to the GROUP BY statement on the SugarQuery Object, it may be easiest to use the groupByRaw() method.
$SugarQuery = new SugarQuery(); $SugarQuery->select(array('account_type', 'industry')); $SugarQuery->from(BeanFactory::newBean('Accounts')); $SugarQuery->groupByRaw("accounts.account_type,accounts.industry");
orderByRaw()
Using the oderBy() method only allows…
View On WordPress
0 notes
smallik123 · 7 years ago
Text
SugarCRM – SugarQuery - Advanced Techniques -
SugarCRM – SugarQuery – Advanced Techniques –
some of the advanced methods that SugarQuery has to offer, that are not as commonly used.
getOne()
//Get the Name of the account $accountName = $SugarQuery->getOne();
setCountQuery()
$SugarQuery->select(array('name'))->setCountQuery();
joinName()
$contacts = $SugarQuery->join('contacts')->joinName();
union()
//Create union $sqUnion = new SugarQuery(); $sqUnion->union($SugarQuery1);…
View On WordPress
0 notes