Salesforce | Please use TLS 1.1 or higher when connecting to Salesforce using https

Author - Ashish

Salesforce login via PHP Salesforce Toolkit API may throw this exception:

Please use TLS 1.1 or higher when connecting to Salesforce using https

The reason is Salesforce has provided customers with the Critical Update feature Require TLS 1.1 or higher for HTTPS to maintain high Security. If you Read more…

Microsoft SQL Server | MySQL LIMIT equivalent in Microsoft SQL Server

Author - Kailash

Suppose you want to retrieve values from row from 5 to 10 from a table in SQL server. Since LIMIT keyword does not work in it so we can use any of these 2 alternative methods:

Solution 1 :

SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (ORDER BY name) as row FROM TableName Read more…

How to access Moodle files outside the Moodle?

Author - Shalini

We can access Moodle outside the Moodle (without login) by passing token in the URL.

For example :

http://localhost/Moodle_new/webservice/pluginfile.php/26/qtype_match/subquestion/17/5/6/PineApple.jpg?token=6yhg9331af9d9284abb36cyjh0c67114a

If token is not be passed into the URL, then it redirects to Moodle’s Read more…

Get Salesforce SObject name through Salesforce Record Id

Author - Webner
|
0 Comments
|

Description : We have Salesforce recordId but need to identify what is the type of Sobject corresponding to this record id.

Solution : We can get Sobject name from recordId with getSobjectType() function, sample code below:

Apex Code :

public void echoSObjectName(String RecID)
{
objName = RecID.getSobjectType();
System.debug(‘Object Name is ‘ + objName Read more…

CakePHP bake: SQLSTATE[42S02]: Base table or view not found

Author - Rita

While running cake bake command for cakephp 3.0 we got the following error:

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘tablename .columnname’ doesn’t exist

The culprit was a column with name test_id in one of the tables. As per bake command’s conventions about foreign Read more…

Salesforce | How to replace depreciated custom component ‘HTML Area’ for home page

Author - Webner
|
0 Comments
|

In the release of summer 14 Salesforce added the functionality of creating custom component for the home page.

In the past we were able to write HTML code in Salesforce using the HTML area under custom components on home page. For example if we needed to show RSS feed on Read more…

Selenium IDE | Test a form with multiple data sets

Author - Webner
|
0 Comments
|

If we have a Registration form and we want to test it with multiple datasets by using Selenium IDE then we have to follow these steps:

1. First, record the whole process of form filling with one set of data.

2. The data will be collected as shown Read more…

Salesforce | Convert DateTime to Epoch format

Author - Webner
|
0 Comments
|

In Salesforce apex code, we can use DateTime class methods to convert date and time to required format. And in one such case we needed to get Datetime in epoch format, also known as Unix TimeStamp for saving date and time.

To get the epoch from a datetime variable we Read more…

Heroku | Change PHP session timeout

Author - Webner

In Heroku, there is no way to change HTTP session timeout (or some other php.ini settings) from user interface. For this create a file with name .user.ini and specify the properties in it. This file is to be created in root folder of project.

In our case we Read more…

Moodle/Totara | Create custom fields for a course

Author - Neha Mishra
|
0 Comments
|

Create custom fields for a course in Moodle/Totara.

1. Go to Site administration. Select custom fields inside Courses as shown below:

2. Select option – which type of custom field do you want (say, menu of choices):

3. Fill the below form as per your requirement and save:

4. Now Read more…

Selenium | Mass CSV file generation by fetching data from database

Author - Webner

In a project we are working on there are large number of pdf files for which field mapping data is stored in the database. In this project pdf forms are auto filled with data from Salesforce. Which PDF form field is mapped to which corresponding Salesforce object or field is Read more…

Font family looks regular in Ubuntu and Windows but looks bold in Mac

Author - Kajal Marwaha

In one of our web development projects, we used font family named Calibri for breadcrumbs. This font worked fine on Ubuntu and Windows but on each browser of Mac fonts appeared bold.

We wrote the following code for making the text font normal and consistent for all operating systems:
.breadcrumb Read more…

CakePHP | Redirect from http to https URL

Author - Kailash

If you want to redirect from http to https in CakePHP, generally redirect method code is like this:
$this­->redirect(array(“controller” => “myController”,”action” =>t; “myAction”));
But if your site is running on http protocol it will redirect to the url with http protocol:

‘http://www Read more…

Insurance Agency Management System – Direct versus Agency Billing

Author - Webner
|
0 Comments
|

Basics first – Client is the insured person or who gets himself, his property or vehicle insured by the insurance company. Insurance company is also known as Insurance Carrier or insurer. And there is insurance agency that acts as interface between Client and Carrier to make it easy for Client to Read more…

Moodle and Java | Retrieving users’ data from Moodle using External Java Application

Author - Richa

Retrieving users’ data from Moodle using External Java Application

We can write a basic REST moodle client code using Java to fetch users’ records from moodle. Before writing the code, you need to perform below steps in Moodle which are required in order to fetch the data:

1. Create external Read more…

AWS EC2 | How to automate the Snapshot command

Author - Navneet Kashyap
|
0 Comments
|

You can create snapshots of the EBS volume which can help to restore to a prior state in future if required. Better is you can create a bash script and put the commands for taking snapshot in it and then put the script in task scheduler to run at specific Read more…

Linux | Installation of custom AWS metrics script & prerequisites for AMI

Author - Navneet Kashyap

1.  Login to Amazon Linux-AMI / Centos / RedHat:

Using ssh

2.  To Upgrade from a previous version of the scripts:
# sudo yum install perl-DateTime
3.  To install the scripts for the first time:
# sudo yum install perl-DateTime perl-Sys-Syslog perl-LWP-Protocol-https
4.  Download & Unzip Read more…

Selenium | How to count the number of products on a web page

Author - Namisha

In this post I will give an example of a Selenium script to count the number of products displayed on a web page. This is the screenshot of webpage:

As you can see products are displayed row wise with 4 products in 1 row. On scrolling down there are many Read more…

MySQL | A short note on database indexes

Author - Webner

Index is used for storing values for a specific column in a table. An index is created on a column of a table and used to speed up search queries.

For Example :

Suppose we have a database table called Users with three columns – User_Name, User_Age, and User_Address. Assume that this Read more…

Curl | How to test a Restful web service using curl

Author - Rita

Let’s consider, we have a demo Restful service (created in Java Spring here but you can create in any language) to login user which accepts username and password as input and returns Success/Failure in response.

Request Object : Demo Login Request class :

Response Object :

Here is how to call Read more…

‹ Prev page1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Next page ›