Articles

How to convert to Uppercase, Lowercase and Titlecase using spreadsheet formulas - These formulas will work on OpenOffice/LibreOffice Calc and Google Sheet

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.

In order to add a new jQuery or multiple javaScript/CSS to the Drupal site, it is better to use hook_library rather than using drupal_add_css/drupal_add_js multiple times. It is helpful if we are using the javaScript/CSS in multiple pages.

Importing and exporting files are common features we come across in software development. In one of my projects, I had to import large sized files which needed to be exported as well. Since normal process of importing and exporting files may cause problems when there is a network connectivity issue, we opted for Drupal's Batch API process to do this functionalities. Following are the client requirements:

Fullcalendar is a jQuery plugin which gives a full-sized calendar with drag-and-drop and with many other features. Events can be dragged on to the calendar and can be resized. It uses AJAX to dynamically load the events on the fly. In this article I will explain how to enable the fullcalendar with different options and loading events dynamically from the database.

We had an issue pointed out by one of our Drupal client that traffic from specific page to be redirected to another URL. In Drupal redirecting trafic from specific page on specific domains can be handle either by including a Drupal hook_init function or setting the .htaccess. Function hook_init runs at beginning of page request but it loads all Drupal modules and database for every page which results in performance issues. On the other hand .htaccess files are read on every page request and the effect to the changes in the .htaccess files is quick.

Organic Group Module in Drupal allows to create and manage different groups. While creating a content, we can add that content to a group. The og_group() function allows to add a content to a group. -->