Technical Solution

[LibreOffice Calc] How to create multiple pivot table in the same sheet

Technical Solution | 1 min read

Suppose you are working in spreadsheet and you want to display two different pivot table in the same spread sheet. Usually if you create pivot table without choosing the result sheet, it will create a new sheet. So let us check how we can display the result in our desired sheet so that we can show different pivot tables in the same sheet.

Technical Solution | 2 min read

Suppose you are working in OpenOffice Calc and you are writing some functions. And you want to apply this function to large number of column cells. You can do it by dragging the formula upto the last cell. But dragging is some times a very boring or tedious job. So let us check two simple ways to accomplish this task.

Technical Solution | 2 min read

In websites response time play a very important roles. Capturing this time is a difficult task. We can perform this by selenium Framework and by using the below script we can calculate the response time. The main aim of the script is to find time taken for JavaScript code execution, elements loading, page load etc. In this code we can calculate the time span between two events in different case.

Technical Solution | 2 min read

Suppose if a Drupal login page has a Captcha to find whether the user is human or a bot. Using Selenium IDE we can automate all type of web elements such as link, check box, radio button etc. In case of Captcha, human interaction is a must.

Technical Solution | 2 min read

Ignoring files:From time to time there are files you don't want git to track. There are a few methods of telling git what files to ignore. In which .gitignore file method is one of the popular method

Technical Solution | 2 min read

To connect into MySQL database with the help of PHP based web applications we are in need of mysql_connect or by PDO method. Here i have added a common function which will be useful for the php based websites to connect into the database.

Technical Solution | 3 min read

Recently I ran into the problem of mouseovers on touch devices. In short, they doesn't exist. I had just created a layout of four images which listed at the centre of the home page as like our zyxware website. And if you check the site on mouseover the image it will expand and while clicking the image it will go to the link added. But the problem is the mouse over wont work on the touch mobile devices.

Technical Solution | 3 min read

cPanel offers a very simple point and click way to create subdomains in your hosting account. Read-on to know how to create subdomain for a site using cpanel.

Technical Solution | 1 min read

Authorize.Net ARB is a standard recurring billing system module and gives you the freedom and flexibility to accept recurring payments without the need of a bulky shopping cart system. The users opting ARB payments mode will be charged the first amount of payment the next day after they subscribe on website, then the recurring billing will start after the first membership period. Paypal too is an online payment gateway but the process is too length for a transactions to complete, fee for multiple transactions, no recurring payment options, cannot make a change in the amount variations on subscriptions.

Technical Solution | 2 min read

I need to store some configuration information about my extension in database. Initially I thought of having a new table to store those. Then I found out that CiviCRM gives that feature. Here is its tip:

Technical Solution | 1 min read

In one of form that I created it need some client side dynamic behavior. I did that in a javascript and used JQuery. But it did not worked. I thought that JQuery did not work in CiviCRM.

Technical Solution | 1 min read

When I was calling CRM_Core_DAO::executeQuery() it gave error. I don't have any idea what went wrong. Not sure whether the SQL statement was correct or not. After searching for some time I found one function, composeQuery() in CRM_Core_DAO. It can be used to verify SQL query.

Technical Solution | 2 min read

Elance tracker helps individuals to track the time they have worked and this is automatically populates to work time sheet in elance. And this time sheet is automatically submitted to the client. So if you are working on elance projects some times it is necessary to track time through elance tracker. If incase you came up an error "Error: Dependency is not satisfiable: adobeair (>= 1:2.6.0.0) in Ubuntu 12.04" while installing Elance tracker, you may follow the below steps to resolve it.

Technical Solution | 2 min read

Most of us must be familiar with this message. After making the necessary changes to file and after going through the steps like git add, git commit, I tried git pull from server and got the following error message.

Technical Solution | 2 min read

The Apache Solr module integrates Drupal with the Apache Solr search platform. Solr search can be used as a replacement for core content search and boasts both extra features and better performance. The apachesolr module requires the external PHP library,"SolrPhpClient". If this is missing in your apachesolr module directory, it will show the following fatal error after installing or updating this module.

Technical Solution | 2 min read

The following is the shell script that will shutdown all computers in the network. This script will be really help full for system administrators who need not want to check all systems, whether all the systems in the office has been shutdown properly when the employees leave the office. The script will check all the active ips in the network and write the those ips to a file. It also login to each system and execute the shutdown command. The things that are to be done before running the script is to 'Make sure your public-key has been added in the authorized_keys file in .ssh folder of root'. This allows the script to login to each system by the method of public-key authentication rather than prompting for password. And also the 'StrictHostKeyChecking no' will avoid all prompts during ssh.

Application Development | 2 min read

We have already seen how to pass banner ad attributes to landing pages and also how to how to pass custom site variables to landing pages in our previous articles. Now, how can we get them included in the form submit of a landing page and get them emailed along with the lead. Here is how we can do it. Follow these steps in your landing page corresponding to your ad.

Technical Solution | 2 min read

Cron is a job scheduler, which helps to set the list of tasks, supposed to be executed periodically. However, if you are a Drupal developer and wondering how to add the drupal cron to the cron tab, here is the way.

Technical Solution | 1 min read

When we combine different CSV files using ‘cat’ command, the resulting CSV file contain repeating headers. This usually happens when we combine different CSV files having the same headers. Let us check a simple method to remove the repeating headers in Libre office - Calc document.

Technical Solution | 2 min read

In Ubuntu, new applications are usually available as deb packages. Although Ubuntu comes packaged with gui package management tools like synaptic, the command line provides a much faster way. Read on to know how to manage deb packages in Ubuntu from the command line using apt-cache.

Technical Solution

[LibreOffice Calc] How to create multiple pivot table in the same sheet

[OpenOffice Calc] How to to apply a formula in entire column without dragging in OpenOffice Calc

How to find response time of a website using selenium?

How to automate random captcha using Selenium IDE?

How to create git ignore file and what is the use of this gitignore file?

How to get connected with mysql database with the help of php?

How do you add an event Mouseover (hover) on touch devices using jQuery?

How to create subdomain for a site using cpanel?

Why is Authorize ARB payment gateway more preferred over paypal system

[CiviCRM] How to add and use your variable in Settings field in CiviCRM database?

[CiviCRM] How to use JQuery in CiviCRM?

[CiviCRM] How to debug SQL query in CiviCRM?

How to resolve the Error: Dependency is not satisfiable: adobeair (>= 1:2.6.0.0) in Ubuntu 12.04 while installing Elance tracker

How to fix the conflicts occured during automatic merge failure

[SOLVED] "Fatal error: require_once(): Failed opening required 'SolrPhpClient/Apache/Solr/Service.php'"

Shell script to shutdown all computers in a network

OpenX Tips- How to pass custom site variables to landing pages and get them included in the form submit - Part2?

[Drupal] How to add a cron job via cpanel?

How to remove repeating headers of a merged CSV file in Libre office calc?

[GNU/Linux] How to manage deb packages in Ubuntu from the command line using apt-cache