WebtechQuery

If you are looking for a tool which will help you recognize that all of your web page links are working fine or not, or if you want to know that how much links are there in a webpage, then check out LinkChecker plugin for Firefox. All you need is the Firefox browser, in which you can use this Link Checker addon.

LinkChecker

LinkChecker will help you in counting the number of total links in a webpage as well as the status of working and non-working links existing in a webpage. It will be helpful for Developers, QAs, SEOs etc. to check the links and counts of links in a webpage.

Download And Install LinkChecker

You can download the LinkChecker from the following url:
https://addons.mozilla.org/en-US/firefox/addon/532

Or directly goto the FireFox Addons website, and search for LinkChecker over there to get it.

How To Use LinkChecker

After successfully installing the LinkChecker, just goto the webpage you want to test the links on, and right click anywhere in the page, and select Check Page Links. It will show you the links counter in your Firefox status bar, and the working links will be colored in Green, while the broken links or non-working links will be colored in Red.

If you are a Firefox user, or even if you are not then you should start using it, and you are concerned about having different types of sorting on the reports generated and displayed on webpages or websites, then you are on the right place.

Now you dont need to copy the HTML tables from webpages into MS Excel, OpenOffice SpreadSheet etc., for Data Sorting or Data Filtering, as Firefox plugin TableTools will help you providing such features, and you can have same type of functionality in websites or webpages.

Firefox Plugin – TableTools

TableTools is the plugin where you can sort and filter the tables in any website. Two of its main features are:

1. Data Sorting
2. Data Filtering

Data Sorting

This feature will help you sorting your webpages table data in different columns, example, you can sort your columns in ascending and descending orders for:

• Alphabets
• Integers
• Date Time
• IP Address
• etc.

Data Filtering

This feature will help you filtering your webpages data in your desired columns. You can choose more than one columns for data filtering, just like you do the filtering in MS Excel, OpenOffice SpreadSheet etc.
For filtering the data, you have two options, Select Filters and Search Filters.

• Select Filters will show you the drop down menu in all the table columns, to select your filtration, just like Excel’s Data Filtering.
• Search Filters will give you a text box on top of each column, to write your own data there for filtering, without choosing any from the list.

Download TableTools

You can download Firefox TableTools extension directly from the following url:
http://mingyi.org/T2F3/tabletools0.28.xpi

Or visit the official website of TableTools for more details:
http://mingyi.org/T2F3/

How To Use TableTools

After installing the TableTools, just right click on your reports or tables, and you will see two new options there, Sort Table Columns as for Data Sorting and Other Table Operations for Data Filtering and copying purpose.

After searching for the Device Manager in Ubuntu, I got to know that there is no built in Device Manager installed in Ubuntu, where you can have a list of hardware devices installed in your system.

Install Device Manager For Ubuntu / Linux

You have to install GNOME Device Manager, to have a list of your installed hardware devices.

Install GNOME Device Manager

To install GNOME Device Manager, simply goto the terminal ( Applications -> Accessories -> Terminal ) and enter:

sudo apt-get install gnome-device-manager

or goto

System -> Administration -> Synaptic Package Manager

And find the package or software “gnome-device-manager“
and start using Device Manager, after successfully installing it from Synaptic Package Manager.

Thats it.

You can now use your Linux Device Manager, which could be easily found at:

Applications -> System Tools -> Device Manager

or writing the command gnome-device-manager in your Terminal.

Uninstall / Remove Applications Ubuntu

If you want to remove applications from Ubuntu, please follow the post below:
Uninstall / Remove Applications Ubuntu

If you are seeing the folowing type of error:

Could not reliably determine the server’s fully qualified domain name
or
Could not reliably determine the server’s fully qualified domain name, using 127.0.1.1 for ServerName

while restarting your Apache Server through the following command:

sudo /etc/init.d/apache2 restart

then I have a better solution for you, which might let you resolve this error.

How To Resolve

Goto your apache folder, which would be:

/etc/apache2/

And open or create the following file

httpd.conf

After creating / opening the file, simply add the following line in the file:

ServerName localhost

Now save the file and restart your Apache Server by the following command:

sudo /etc/init.d/apache2 restart

And your error could have been resolved.

Hope this simple solution works for you in getting rid of the error:

Could not reliably determine the server’s fully qualified domain name
or
Could not reliably determine the server’s fully qualified domain name, using 127.0.1.1 for ServerName

For some of the other PHP errors, you can follow the PHP Category:
http://www.webtechquery.com/index.php/category/php/

Also find out How To Install LAMP On Ubuntu:
http://www.webtechquery.com/index.php/2010/01/install-php-mysql-and-apache-lamp-on-ubuntu-linux/

If you are a Firefox fan, and want to install Firefox addon Firebug in Google Chrome, then it is a good news for you that Firebug extension is now also available for Google Chrome.

Download Firebug For Google Chrome

You can download and install Firebug for Google Chrome on the following websites:

https://chrome.google.com/extensions/detail/bnbbfjbeaefgipfjpdabmpadaacmafkj
or
https://chrome.google.com/extensions/detail/bmagokdooijbeehmkpknfglimnifench

Or directly goto the Google Chrome Extensions website, mentioned in the following link of Install Google Chrome Extensions / Addons, and search for Firebug over there to get it.

Install Google Chrome Extensions / Addons

If you dont know where to install extensions / addons for Google Chrome, then the following post may help you installing Google Chrome’s extensions or addons:
http://www.webtechquery.com/index.php/2010/03/google-chrome-and-its-extensions-addons-in-ubuntu-linux/

If you want your tables to be sortable by your clients on runtime, like ordering the columns of strings or integers to be in ascending or descending order, then this post can be helpful.

Sort Data In Reports

If you are working on some reports where you need the columns to be sorted on runtime, then this could be done easily using JavaScript in your page.

There are plenty of websites, which provide the JavaScript file .js for free, to make your table or reports sorted on runtime, by the user.

Get Rid Of Order By Queries

By using such sorting scripts, you can get rid of sorting the columns in alphabets, numbers, or both i.e. alphanumeric, in your queries, because users can sort them easily at their end, just by clicking on the columns they want the table or data to be sorted in.

Sorting Scripts

For more details on this, I recommend the the following websites to make your reports or data sorted on runtime by the clients, by just adding a single js file in your page:

Sort String and Integer Data:
http://www.kryogenix.org/code/browser/sorttable/

Sort String Data Only (Integer Sorting may not be correct) :
http://yoast.com/articles/sortable-table/

While finding MSN Messenger for Linux / Ubuntu, I found different software, where I found aMSN. But another alternative has been found, which is, in my view, much better than aMSN, as it feels you like you are using Windows MSN Messenger.

emesene

Emesene (Em Es Ene) is the one of the best alternative to MSN Messenger after aMSN. If you are addicted to MSN Messenger Windows, then you will find this alternative very good to use, which will make you feel like you are using MSN in Windows.

Download & Install emesene

If you are using Ubuntu, then you can simply goto

System -> Administration -> Synaptic Package Manager

And find the package or software as “emesene“
and start using emesene, after successfully installing it from Synaptic Package Manager.

Or you can install the other Linux versions (including Ubuntu) from the following website:
http://www.emesene.org/download.html

emesene is also available and could be downloaded and installed for Windows, MAC OS X.

For more details, check out the official website of emesene at:
http://www.emesene.org/

If you want to search people in your Pidgin, and the Pidgin Search is not working properly, like it stops searching after writing a single letter, then this must be the GTK problem.

Download The File:

Download the following zip file, where the file exists: libgdk-win32-2.0-0.dll

http://ftp.gnome.org/pub/gnome/binaries/win32/gtk+/2.12/gtk+-2.12.6.zip

Replace The File:

You can simply overwrite the file libgdk-win32-2.0-0.dll, existing in the Program Files, which is usually found in the following location:
C:\Program Files\Common Files\GTK\2.0\bin\

Or if your Program Files is in different drive, then replace the C: with your drive letter, example D:

For replacing the file, you first have to close Pidgin. After replacing the file, open your Pidgin again, and enjoy searching in your Pidgin and save the time of finding people in your list, by simply typing their names in Pidgin to get them easily.

While going through a problem, I got a situation where I wanted to have a result set in a sorting order which is defined by me. Not ORDER BY ASC, not ORDER BY DESC, not ORDER BY RAND(), but ORDER BY FIELD i.e. the values which are defined by me, which could be random as well, but not ORDER BY RAND().

MySql Custom Order By Example

For example, if you have a result set of a table, containing the names of students, and you have set them as order by student names, and now you want the same ordering format of student names, in another table, which only only contains ids of the student. One easy way could be to make a join with the master table, containing the students names, and use simple Order By student name format, but there could be another way out, where you wont be needing to join the other table, just for the sake of ordering. You can use following type of query, where you already have the ordering student ids, i.e. you already know that which id will come first, and next, and so on.

ORDER BY FIELD

Following is the table tbl_test, where field id will be containing the student ids, through which we will be fetching 5 student ids, and we already know their sorting order, that which id will come first, and next and so on.

SELECT * FROM tbl_test
WHERE id IN (1,2,3,4,5)
ORDER BY FIELD(id, 1,3,5,4,2);

If you are looking for a Free alternative to Microsoft Office, then Open Office will be the best solution for you.

Why To Use OpenOffice ?

Besides other advantages of using OpenOffice, some good characteristics and features of using OpenOffice are:

• Its Free
• It supports different platforms like Windows, Linux (Ubuntu) etc.
• It feels you like you are in the Microsoft Office environment
• It supports the ISO/IEC standard OpenDocument Format (ODF)
• It supports most of the Microsoft Office files format like XLS, XLSX, DOC, DOCX, PPT, PPTX etc.

From some of the commonly used programs of Microsoft Office, OpenOffice has also introduced related software like OpenOffice Word Processor as a competitor of Microsoft Word, OpenOffice Spreadsheet as competitor of Microsoft Excel, OpenOffice Presentation as a competitor of Microsoft Powerpoint etc.

OpenOffice Word Processor

Similar to Microsoft Word, OpenOffice Word Processor aka OpenOffice Writer can be used to write documents, which can be read and saved in the file formats like DOC, DOCX, ODT etc.
Even the documents can easily be exported to PDF format, without need of any third party tools or plugins.

OpenOffice Spreadsheet

Similar to Microsoft Excel, OpenOffice Spreadsheet aka OpenOffice Calc can be used to maintain worksheets or spreadsheets, which can be read and saved in the file formats like XLS, XLSX, ODS etc.
From most of the basic features of Microsoft Excel, OpenOffice Spreadsheet can be used for preparing spreadsheets or worksheets, drawing charts, inserting objects etc.

OpenOffice Presentation

Similar to Microsoft Powerpoint, OpenOffice Presentation aka OpenOffice Impress can be used to create different types of presentations, using several templates, which can be read and saved in the file formats like PPT, PPTX, ODP etc.
Even the documents can easily be exported to PDF and SWF formats, without need of any third party tools or plugins.

Download OpenOffice

You can download OpenOffice from the following website:
http://download.openoffice.org/index.html

For more details on OpenOffice, check out the official website of OpenOffice:
http://www.openoffice.org/

Mozilla Thunderbird

OpenOffice has not released any software as competitor of Microsoft Outlook yet. But there are other free software, which can be used as an alternative to Microsoft Outlook. Mozilla Thunderbird is one of the best alternatives to Microsoft Outlook, for Windows, Linux etc. For more details about Mozilla Thunderbird, you can check out another of my post at:
http://www.webtechquery.com/index.php/2010/03/mozilla-thunderbird-free-alternative-to-outlook/