Suppose you are working in OpenOffice Calc. Your requirement is to copy the Column B value into Column A, if Column A is blank. If the columns have lots of cells, filling it manually is extremely tedious. So, read on to know how to do it.
Technical Solution
I have a number of affiliate links in my page. The affiliate links are generated dynamically and so, I don't know the number of affiliate links generated in the current page. I had a requirement to open all affiliate links simultaneously upon clicking on a search all link in my page. Initially, I was not aware of the jQuery each function. So, I placed all the affiliate links in a particular div and used the size function to get the number of 'a' tags inside that div and used a 'for loop' to iterate through the 'a' tags and applied the behavior. However, after that I found there is an each function in jQuery, which can be used to itereate through all the elements with a particular identity.
Often, when you update styles or images on your website, the users of your web application might still get the old logo or style. This is because the browser caches the resources on your web application. Hence, when the user tries to access the application, it will be loaded from the local computer, not from the server. Here is a solution for this issue. Read on to know how to expire cached resources on your browser from your web application itself.
One of our partners came to us with a very innovative requirement for their OpenX banner ads that we placed on our site. Our partner wanted to pass the ad name and source(zone) as variables to landing pages. They basically wanted to pass the openx banner ad attributes to landing pages so that the landing pages could be modified accordingly. We thought it was a good idea and proceeded to modify it.
Quite often we feel the need for comparing wages in different countries when one is engaging with a global talent pool.
We face this need when we evaluate the costs of setting up a development centre in Australia or when we are discussing with a potential hire who is then based out of India. In such scenarios, purchasing power parity is a useful concept to make wage comparisons across different countries meaningful. It might be a slightly crude approach but it can be useful when you are looking for ball parks or quick evaluations.
If you are a GNU Linux user it is very likely that you would already know about the command top that allows you to see the memory and processor usage by each process in your system. However you would see multiple processes for applications like Chromium or Firefox for each of the tabs that are open in them. Similarly you could see apache run multiple processes if you have it configured to do so. What if you want to see the total memory usage for each application and not by each process. Here is a small bash script to help you do the same.
GIMP is a powerful tool for editing images but did you know that you could edit PDF files with GIMP? You can import a PDF document into GIMP as multiple layers. However the default export to PDF option would only allow you to export the document as a one page PDF as if it was an image. Here is a plugin that would allow you to export all the layers in your GIMP XCF file as a multi-page PDF document. You can use this not just for editing PDF documents but also for any xcf file where you want to export layers into a PDF document.
If you have been using Skype on Ubuntu and you have been unable to login to Skype recently then it is only that the old version of Skype for Linux is no longer supported on Skype servers. You can solve this problem by purging the existing skype installation on your system and then re-installing the latest version of Skype from skype.com
Do the following to fix this problem
The vlookup or Vertical Look Up Function in Openoffice calc can be used to search a range of cells.Suppose you have two spreadsheets and you want to append data from one sheet to another. We can use vlookup() in open office calc to accomplish this task. vlookup() searches for values in one column and given values in another column in true condition. Read on to know how to user VLookup.
The syntax for vlookup() is
VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
As the main intention of testing is to ensure the quality of the final product, understanding of various testing types is crucial for a tester. In this article we will see the main difference between two testing types- retesting and regression testing.
The apt-cacher-ng configuration requires certain changes to be made on the client side. Few changes has to be made on the client system so that during the download process the client system can check for the packages in the apt-cacher-ng server. And if the apt-cacher-ng server doesn't have the required package it will download it from the web. So the client configuration helps to make the download more faster and also helps to reduce the internet connection usage.
The few things that are to be noted before configuring apt-cacher-ng clients are
One of our Drupal clients had requested us to work on their Drupal website which was built around the ability to search the content on the site. Since the default Drupal search was a bit heavy they had opted to use ElasticSearch which was a dedicated lightweight tool for this purpose. Before developing we wanted to check ElasticSearch was running on their server. Read on to know how to check whether Elastic Search is running on your server
SSH Protocol's features can be changed using the sshd_config file.The sshd_config file is the main configuration file that allows the user to make the changes in the features of SSH protocol. This file resides in /etc/ssh folder. There are many features for this protocol and these can be made or changed according to the users needs. By making configuration changes, the protocol also provides more security to the user and server/system that we are using. Some of the main features of the SSH protocol are listed below.
Are you looking for a way to HTML validate your articles? Please try this. Normally, we can try any online HTML validator available over internet.
What we need is to just copy our page URL to the tool and validate it. But if you want to validate your content with your custom HTML formatting, before
publishing it in your site, you can try this method.
This article lists some of the basic MySQL commands how to create a new database, a new database user and granting privileges to a user.
How to create a new database from terminal.
The first step here is to log in as the MySQL root from terminal using the following command.
mysql -u root -p Now this will prompt for the MySQL root password.
Enter password : After entering the MySQL root password we will be able to log in to the MySQL prompt.
The next step is to create the new database.
Apt-cacher-ng can be defined as an apt proxy which caches the packages which you download locally on your computer. Consider you are using a network of computers and you have to install a package on each system then it will be great to configure an apt-cacher-ng on any system in your network so that it will cache the packages once they have been downloaded. Read on to know how to configure Apt-cacher-ng server in Ubuntu
Suppose you have details in LibreOffice calculator and you want to convert this in LibreOffice writer table format. Moving data from Calculator to Writer will come often when you prepare reports. It can be done in different ways. Read on to know how to transfer data in LibreOffice Calc to Libre Office Writer in table format.
Comma separated values, commonly referred to as CSV is one of the most popular methods for transferring data between systems. Creating code to export data to CSV is extremely useful in many applications. If you want to know how to create CSV files using PHP then read on.
OpenX is a free and open source ad server. It is a professional ad server which can be used for managing ads like Google DFP,
and has many features like geographical ad delivery limitation, features to limit ad based on the user agent, client IP address, client domain,
site variables, just to name a few. OpenX also provides a robust reporting interface. Read on to know how to install Openx in a GNU/Linux based server.