Sometimes you need to fill a database table with thousands of test data records. You may also need to generate test data in the form of csv file to feed to a program. How can you generate such a large set of data in short time?
One approach to generate Read more…
We were using insert_records() function to insert multiple records in a Moodle database table but it was not working.
We checked for errors by adding following lines in config.php file of moodle:
@error_reporting(E_ALL | E_STRICT);
$CFG->debug = (E_ALL | E_STRICT);
$CFG->debugdisplay = 1 Read more…
By default Apache web server does not come with all the securities enabled. We have to enable enhanced securities before making it live & accessible to the outside world.
Remove Server Version Banner :
Modify httpd.conf and add following directives and save it :
Disable directory browser Read more…
In one case we noticed that SQL Server (SQL Server 2014) service was scheduled to start Automatically on system boot but still it was not starting up. It did not even start when we manually tried to start the service. We got following errors:
Error1: A timeout was reached (30000 Read more…
Just write below line in your main java program and it will show you all System defined properties.
Some of the important properties that we can use generally:
1. user.dir will give project root directory location.
2. java.class.path will give the classpath Read more…
Created Date and Last Modified Date fields in Salesforce objects are audit fields and we can’t edit or change these field directly or through code. You have to contact salesforce support team for them to grant permissions to you to edit or change these fields if needed.
Just create Read more…
There is a functionality on Moodle course page that activities can be dragged up and down to change their order after turning on the edit button. If in the code you need to pull the activities in same order for a course then following code can help you :
$mods = $modinfo Read more…
Suppose you have a Visualforce page with a form and you have a link to open a popup. The page loaded in popup needs to set a value back into a textbox in the parent page. Here is how you can achieve this:
This is sample code of the parent Read more…
We can connect to a remote server via SFTP without password, using PEM file of server. The PEM file is public key certificate file of the server to which we have to connect. We’ll need to have following details in this case:
1. Open Read more…
If you want to programmatically read values of certain fields, those field must be visible in the layout. To change field visibility follow these steps:
1. Login and click on setup link.
2. Click Security Controls in Administrator menu.
3. Click on Field Accessibility.
4. Click on the object name Read more…
We had a table in our database having dot in the table name as below:
Table name – kpc.product_categories
On trying to delete kpc.product_categories using below command:
drop table kpc.product_categories
It used to give error that no such table exists.
Dot(.) is the reserved symbol in mysql so Read more…
When we add Salesforce project to Eclipse sometimes it asks for ‘Secure Storage Password’. You can try to enter your system password. If it doesn’t works you can change or recover ‘Secure Storage Password’. According to office eclipse documentation.
The secure storage saves data in an encrypted form. On Read more…
We needed to extend a default functionality of standard salesforce page and buttons on this page. That is we needed to display some custom buttons and fields on the standard page and perform our own logic for these. The Object for which we needed to modify functionality was Event. SInce Read more…
Following are the steps to delete the Postgres database backup:
1. Login into heroku.
2. Click on the database>PG Backups. Here you can see all the PG backups list.
3. . For deleting the database, first of all you have to install the toolbelt.
You can download Toolbelt from Read more…
If you are working with eclipse IDE, it provides many plugins and one of them is java decompiler. This plugin will decompile all your class files to give you Java source code.
JD-Eclipse is a plug-in for the Eclipse platform. It allows you to display all the Java Read more…
Routes in an application are configured in app/Config/routes.php. Defining your own routes allows you to define where your application will take the control to for a given URL.
Default routing is like this:
Prefix routing will Read more…
We have a page in which we have to display more than 50000 records. Visualforce page has View state Limit set to 135 KB hence after reaching this Limit salesforce throws Exception as “Maximum view state size limit (135KB) exceeded”.
Solution: To resolve this issue Read more…
Problem: After importing SSL certificate files to the server where the CSR was generated, Wamp was failing to start.
Solution: This problem occurs because passphrase does not match the given csr key. The solution is before sending the ssl CSR Read more…
This is a simple idea to reduce API calls consumption when you pull data from Zoho CRM into an integrated piece of code (like server side code in PHP or Java that connects to Zoho CRM to retrieve records). In one of the projects we were working on, we had Read more…
In one of the projects we had a batch file which runs another batch file within it in a loop. This was not working. It used to run once and then used to get stuck.
This is sample code of the outer batch file:
cd Read more…