W3Expert.com

Installing MySQL WorkBench on Ubuntu

2011-12-04T03:06:00.001-08:00

Download MySQL WorkBench from here
http://dev.mysql.com/downloads/workbench

In the list at the bottom of the page, select Ubuntu Linux

Next install using following command

sudo gdebi mysql-workbench-gpl-5.2.36-1ubu1004-amd64.deb

Also if the you get error as "gdebi" not installed or found, need to install this using following command first,

sudo apt-get install gdebi

"gdebi" searchs for all dependent files and installs them first (if not installed) before installing the requested file.

The Beauty of India: 50 Amazing Photos

2011-09-30T07:43:00.001-07:00

Good Photos

http://www.smashingmagazine.com/2010/03/20/the-beauty-of-india-50-amazing-photos/

More ImageMagick Commands

2011-06-13T19:08:00.001-07:00

Crop the images into multiple parts
convert -crop 10x2000 photo1.png photo11.png

Reduce the density of the image (reduces the file size of the photo for faster viewing)
convert -quality 70 photo1.png photo11.png

Flip the image 180 degrees (upside down)
convert -flip photo1.png photo2.png

Batch Covert Images from one format to another
mogrify -resize 200x150 -format jpg *.png
This will covert all PNG images to JPG

Enable UserDir in Apache in UBuntu

2011-05-29T22:00:00.001-07:00

1. Change to the User Home Directory, and create folder "public_html"

2. Next Execute following commands,

cd /etc/apache2/mods-enabled
sudo ln -s ../mods-available/userdir.conf userdir.conf
sudo ln -s ../mods-available/userdir.load userdir.load

3. Restart Apache Server using this,
sudo /etc/init.d/apache2 restart

Create Image with Custom Text using Background Image

2011-01-02T10:40:00.000-08:00

Can be done easily using ImageMagick using following command,

convert -background none -size 320x60 -fill white -gravity Center \
-pointsize 36 -font /home/user1/myfonts/UrsaSerifEngraved.TTF label:'My Image Text'  png:- |\
composite -tile /home/user1/bkg_imgs/bkg_img.gif  -   -compose Dst_Over   final_image_name.gif

MediaWiki Options

2010-10-08T14:41:00.000-07:00

Following are some of the MediaWiki options, that might be useful when using Wiki on Local Machines,

Add/Modify following entries to LocalSettings.php file for enable each of the following options,

Enable Sub Pages Navigation, using [/SubPage]
Add following: $wgNamespacesWithSubpages = array_fill(0, 200, true);

Disable anonymous editing
Add following: $wgGroupPermissions['*']['edit'] = false;

Change default theme for all Non Logged in users,
Update following: $wgDefaultSkin = 'monobook';

Adding Custom Text on Photos

2010-09-26T10:09:00.001-07:00

Based on following post,

http://www.w3expert.com/2008/09/display-photo-taken-date-on-image-using.html

The Java program provided in above post is required only if you want to add the date on which the photo was taken to the image.

If you ONLY want to add any text on the image (using custom Font), and also reduce the size of the image by removing additional image (which Camera adds) and reducing the image size, you can execute following commands.

Step 1: Install ImageMagick

First download and install ImageMagick from following site,

http://www.imagemagick.org/script/binary-releases.php

Step 2: Add Text on Image

Custom Text can be added to the image by executing following command from command prompt,

C:\apps\ImageMagick\mogrify -font C:\myfonts\BaroqueScript.ttf -pointsize 50 -fill red -gravity south -annotate +15+45 "Summer Photos" *.jpg

Details:

pointsize =50 : This is the Text Size on the image

fill =red : This is Text Color

-gravity south -annotate +15+45 : Text Position, add to the bottom center of the image

"Summer Photos" : Replace this with Text to be added on the image

*.jpg : execute command on all jpg files in current folder,

Step 3: Re-Size Images

Images size can reduced by executing following command from command prompt,

C:\apps\ImageMagick\mogrify -strip -resize 50% *.jpg

Details,

strip : Remove all EXIF info (including Camera Details), added to the image (not visible on top of the image). This reduces image size considerably

50% : Reduce the file size by 50%. Adjust this based on the image size generated by Camera. The higher the Mega Pixel of the camera or selected option before taking the photo, the higher the image size

*.jpg : execute command on all jpg files in current folder,

Other Options

The full list of options supported by mogrify command is available here,

http://www.imagemagick.org/www/mogrify.html

Here's how the final image looks like after adding the Text on the image,

Google Sites Calendar

2010-09-21T15:15:00.001-07:00

When using Google Sites templates, some of the Site templates include Calendars as part of the newly created site. Even though they looks like real calendars, and when you click on button, the calendar gets added to your profile, these are not updatable calendars and you will not be able to add any events to these calendars. These calendars are provided as placeholders only. Following steps are required to setup new calendar for these sites,

Create new Calendar

Login to calendar.google.com or your custom site (for google apps), and create new calendar.
Next select Settings option for the calendar from the drop down arrow next to the calendar name, in left navigation menu
You will get the screen shown below. Select the "Share this calendar" Tab, and assign the names of people you want to share this calendar with
Click Save and save the settings for the Calendar

Setup Calendar in Google Sites

Next from Google Sites page which is currently showing the default non editable calendar, perform following steps,

Click on Edit Page Button at the top of the page
On the edit page, select the Calendar Properties (in the small popup menu that comes when you select the calendar image). You will get following dialog box (shown below)
Click on link "Display another calendar" option
This will show dialog box with the list of your calendars. Select the calendar that was created in earlier step and click Select button.
Next select the small drop down button next to "Google calendar" and select the Remove Option
Click Save

Now the Google Sites page will display your calendar, and based on the security settings assigned to the calendar, your users can add new events to the calendar.

Interesting Post (UI created by Developers)

2010-09-03T22:43:00.000-07:00

This Is What Happens When You Let Developers Create UI

http://www.codinghorror.com/blog/2006/11/this-is-what-happens-when-you-let-developers-create-ui.html

Got Reference from here,

http://repeatgeek.com/technical/10-resources-for-design-challenged-programmers/

Google Sites options

2010-08-17T19:44:00.000-07:00

Remove Sub Links on the Page

When a new Sub Page is added to any of the pages, at the bottom of the parent page, links to all the sub-pages are displayed. These can be disabled by following these steps,

1. Navigate to the page with the sub-pages listed on the bottom.
2. Click "more actions" in the toolbar
3. In the drop down menu, select "page settings"
4. Next uncheck the option to "show links to sub-pages" and click Save button.

Disable Recent Activity

When visitors view the pages, at the bottom of the page, following links are shown, "Recent Site Activity" and "Revision History" which display history of who edited the page, and revision history of all the changes to the page.

These can be disabled by doing following steps,

1. Click "more actions" in the toolbar (on any page)
2. In the drop down menu, select "Manage Site"
3. On the left side navigation, under "Site settings" select General tab
4. On the right side at the bottom of the page, for "Access Settings", for
"Users who can access site activity" -> Select "Collaborators only"
"Users who can access revision history" -> Select "Collaborators only"

Excel Document List

2010-07-18T12:10:00.000-07:00

To define a list do the following,

In a separate Tab, create list of items. Let's say the name of the tab is "Data List" and elements are in Column A (from Rows 2 to 5)

Step 1:

1) From the menu, click on Insert -> Name -> Define
2) Give a unique name (for e.g. mylist1) and give reference as follows ='Data List'!$A$2:$A$5 and click on add. Here "Data List" refers to the name of the new tab and $A$2:$A$5 refers rows 2 through 5 in column A.
3) Click on Close button

Step 2 :

1) Select the cells which need to have drop down
2) From the menu, select Data -> Validation
3) In settings tab, for Allow, select "List" and for source give value as =mylist1 (change mylist1 to name given in above step)
4) Click on OK

For Example of this, please refer to following worksheet

http://docs.w3expert.com/view1/sample_list1.xls (Hosted on Google Sites. Download Attachment on Next Page)

Eclipse switch workspace from command line

2010-04-09T12:56:00.001-07:00

Eclipse workspace location can be given from command prompt using parameter "-data"

Other options from within Eclipse

Change workspace from within Eclipse -> File/Switch workspace

Ask workspace each time Eclipse starts : Window/Preferences/General/Startup and Shutdown and select Prompt for workspace on startup.

Interesting Patents

2010-03-08T19:27:00.000-08:00

Check these patents

http://www.google.com/patents?vid=USPAT7028023 -- Implementing Linked List (Basics of Computer Science)
http://www.google.com/patents?vid=USPAT6105067 -- Implementing Connection Pool (Basics of Server Side Implementation)

Curious, how do they approve these :)

What's so special about this statue?

2010-02-04T12:23:00.001-08:00

I am still wondering what's so special about this statue

http://www.nytimes.com/2010/02/04/arts/design/04giacometti.html

that it fetched $104.1 million.

I think i saw better statues in downtown's in major cities and also at museum entrances. Hopefully this was not another price speculation, same like Real Estate :)

Comics Post

2009-11-10T20:20:00.000-08:00

Interesting comics,

Good Video

2009-08-27T19:26:00.000-07:00

Check this one

http://www.youtube.com/watch?v=bYcF_xX2DE8

Min Requirements : Wooden Hard surface Floor :)

Another interesting product which will help Robot’s do the work is, Lego NXT. Check it out here,

http://mindstorms.lego.com/

Supports (code) instructions in both Java and C, (based on feedback from a friend of mine who recently bought one of these and is experimenting with Face Recognition).

Hibernate Named Queries Mapping to multiple classes

2009-06-19T14:06:00.000-07:00

Check following docs,

Native Queries

Annotations Reference

Getting function return values


@NamedNativeQuery(name = "average", query = "select avg(m.value) from Mark m", resultSetMapping = "columnmapping")
@SqlResultSetMapping(
 name = "columnmapping",
 columns = @ColumnResult(name = "aver")
)

List result = s.getNamedQuery("average").list();
assertEquals( 1, result.size() );

Hibernate additional support for Caching Named Queries


@NamedNativeQueries({
@NamedNativeQuery(
 name = "night&area", query = "select night.id as nid, night.night_duration, night.night_date, area.id as aid, "
 + "night.area_id, area.name from Night night, tbl_area area where night.area_id = area.id",
 resultSetMapping = "joinMapping")
 })


@org.hibernate.annotations.NamedNativeQueries({
@org.hibernate.annotations.NamedNativeQuery(
 name = "night&areaCached",
 query = "select night.id as nid, night.night_duration, night.night_date, area.id as aid, "
   + "night.area_id, area.name from Night night, tbl_area area where night.area_id = area.id",
 resultSetMapping = "joinMapping")
 })


@SqlResultSetMappings(
 @SqlResultSetMapping(name = "joinMapping", entities = {
 @EntityResult(entityClass = org.hibernate.test.annotations.query.Night.class, fields = {
 @FieldResult(name = "id", column = "nid"),
 @FieldResult(name = "duration", column = "night_duration"),
 @FieldResult(name = "date", column = "night_date"),
 @FieldResult(name = "area", column = "area_id")
   }),
 @EntityResult(entityClass = org.hibernate.test.annotations.query.Area.class, fields = {
 @FieldResult(name = "id", column = "aid"),
 @FieldResult(name = "name", column = "name")
   })
   }
 )
)

Display Photo Taken Date on Image using EXIF Data added by Camera

2008-09-06T22:46:00.000-07:00

Most of recent camera's have option to set Date Time in camera. When camera clicks photo, this date time is automatically added by camera when photo is taken as hidden EXIF info. The problem is when we copy these images from Camera to Computer, this image taken date does not appear on actual image, even though it's available as part of photo hidden EXIF data.

Quick intro to what is Exif data ?

Here's a picture that will explain it. After getting all the images from camera to Windows XP desktop, in the Explorer, you will see additional column called "Date Created". If not visible, then right click on fields list on top and select "Date Created".

This program will read "DateTime" attribute from Image EXIF Data and add this text onto image to all files specified in input folder in batch mode.

Additional info about EXIF format is available here http://en.wikipedia.org/wiki/Exchangeable_image_file_format

ImageMagick (http://www.imagemagick.org/script/binary-releases.php) provides options to view to additional information added by camera.

Requirements to run this program:

1) ImageMagick needs to be installed on the machine where this program is running
Download page is here, http://www.imagemagick.org/script/binary-releases.php

Most recent windows version is available for download here
http://www.imagemagick.org/download/binaries/ImageMagick-6.4.3-6-Q16-windows-dll.exe

2) Update the variable IMAGE_MAGICK_INSTALL_LOCATION with location where ImageMagick is installed

3) For some camera's the format in which date is copied/stored could be different. Also not all camera's may support adding date information to photo's. On one of the original photo's which has been downloaded from camera execute following command,

IMAGE_MAGICK_INSTALL_LOCATION\identify -verbose "imagename.jpg"

Scroll down the list and check the "Properties:". One of the properties will be similar to "exif:DateTime: 2008:05:26 16:12:30"

If the Date format looks different, then update the variable CAMERA_IMAGE_DATE_FORMAT

FYI, if the image was not created by Camera and was created by program like Paint, then this
information is not available. This program is for executing on images which add additional exif information.

Also not all camera's may support adding date information to photo's. Executing "identify" command on photo will list all the additional information camera is adding to image.

Running this program:

This program takes 2 command line options

Run it as follows,
%JAVA_HOME%\bin\java com.w3expert.AddDateToImage "images_location" "additional_text_on_image"

For eg,
%JAVA_HOME%\bin\java com.w3expert.AddDateToImage "C:\sudhir\photos\set1" "Birthday Party "

For example, here's original image,

And the updated image will be like this (with updated text),

This program will add text on all images in specified folder as bulk operation. The date to add on image will be read from image exif data.

The code below only shows usage. Added support for Linux OS also. Please download complete Java Code Here (AddDateToImage.java) (Hosted on Google Sites. Download Attachment on Next Page)

Previous version of Windows Only Code is available here download complete Java Code Here (AddDateToImage.java) (Hosted on Google Sites. Download Attachment on Next Page)

package com.w3expert;

import java.io.*;
import java.text.*;
import java.util.Date;

/**
 *
 * @author Sudhir Ancha
 * @version 1.1 -- Updated to Support Linux OS also
 */
public class AddDateToImage {

    // ****************************************************************************
    // INITIALIZATION CONSTANTS
    // ****************************************************************************
    
    private static final String CUR_FILE_SEPERATOR = System.getProperty("file.separator");

    private static final boolean IS_LINUX_OS = true;

    private static final boolean DEBUG_ENABLED = true;

   // For Linux (Ubuntu)
    private static final String IMAGE_MAGICK_INSTALL_LOCATION = "/usr/bin/";

    // For Windows
    //private static final String IMAGE_MAGICK_INSTALL_LOCATION = "C:\\utils\\ImageMagick\\";

    // ****************************************************************************
    // OUTPUT IMAGE CONSTANTS (configure according to personal choice)
    // ****************************************************************************

    /** Adjust the fon't size as required based on image size. Currently using fontsize as 30 **/
    private static final String IMAGE_TEXT_FONT_SIZE = "30";

    /** Change this to required font name.  This can also map to custom font file name **/
    //private static final String IMAGE_TEXT_FONT_NAME = "Arial";
    //private static final String IMAGE_TEXT_FONT_NAME = "C:\\sudhir\\fonts\\BROADW.TTF";
    private static final String IMAGE_TEXT_FONT_NAME = "/home/user19/myfonts1/BaroqueScript.ttf";

    /** Text Location for annotate command. More description available here
     * http://www.imagemagick.org/www/command-line-options.html#annotate **/
    private static final String IMAGE_TEXT_LOCATION = "+15+45";

    /** Change this to required text color.
        http://www.imagemagick.org/www/command-line-options.html#fill **/
    private static final String IMAGE_TEXT_COLOR = "red";

     /** Please refer to topic 3 in requirements listed above. Update the date format as required **/
    private static final String INPUT_IMAGE_FROM_CAMERA_DATE_FORMAT = "yyyy:MM:dd HH:mm:ss";

    private static final String FINAL_PHOTO_FOR_PRINT_DATE_FORMAT = "MM/dd/yyyy";

    /** Enable this if you have a high resolution camera and need to compress images
     * before uploading them to site like Picasa or Flickr **/
    private static final boolean COMPRESS_IMAGE = true;

    /** Adjust following command according to resolution required. by default i am using 50%
     *  Please refer here for additional options :  http://www.imagemagick.org/www/command-line-options.html#resize
     */
    private static final String OUTPUT_IMAGE_COMPRESS_VALUE = "50%";


    // ****************************************************************************
    // IMAGEMAGICK COMMANDS (usually don't have to change these)
    // ****************************************************************************

    /** Please refer to topic 3 in requirements listed above. Update the EXIF command if using different attribute **/
    private static final String GET_DATE_COMMAND = IMAGE_MAGICK_INSTALL_LOCATION + "identify -format \"%[EXIF:DateTime]\" ";


    private static final String ADD_TEXT_ON_IMAGE_COMMAND = IMAGE_MAGICK_INSTALL_LOCATION + "mogrify -font \""+
                                    IMAGE_TEXT_FONT_NAME+ "\" -pointsize " + IMAGE_TEXT_FONT_SIZE +
                                    " -fill "+IMAGE_TEXT_COLOR+" -gravity south -annotate " +
                                    IMAGE_TEXT_LOCATION + "  \"    ";

    /**
     * Also checkout the full list of options here http://www.imagemagick.org/www/mogrify.html **/
    private static final String COMPRESS_IMAGE_COMMAND = IMAGE_MAGICK_INSTALL_LOCATION + "mogrify -strip -resize "+OUTPUT_IMAGE_COMPRESS_VALUE+"  ";

}

Some more good Ajax Resources

2008-08-11T18:23:00.000-07:00

http://www.noupe.com/ajax/37-more-shocking-jquery-plugins.html (Good collection of JQuery Plugins)

http://www.codeitred.com/2008/08/09/multilevel-drop-menu-jquery (JQuery Drop Down Menu)

http://www.zkoss.org/demo/ (Open Source Ajax Framework)

http://www.bindows.net/demos/ (Commercial Ajax Framework)

http://vikjavev.no/highslide/ (Javascript image popup)

http://www.gmarwaha.com/blog/ (JQuery Menu)

http://jqueryfordesigners.com/ (JQuery Tutorials)

Some more good videos

2008-05-31T19:37:00.000-07:00

http://www.youtube.com/watch?v=P_ON2O3jnwY

Remove the word "Private" on Private Pages in WordPress

2008-04-03T18:15:00.000-07:00

Credits : http://www.sandboxdev.com/blog/wordpress/2008/178#

In the theme directory, create a new file called "functions.php". For some themes this file already exists.

For example in my install i am using "simple-green" theme. So my file will be here,

"\wp-content\themes\simple-green\functions.php"

In this file add following lines,


<?php
function remove_private_prefix($title) {
$title = str_replace(
'Private:',
'',
$title);
return $title;
}
add_filter('the_title','remove_private_prefix');
?>

10 Commandments for Java Developers

2008-04-02T20:33:00.000-07:00

Good article here for Java Developers

http://www.developer.com/java/data/article.php/10932_3612756_1

How to enable "Relation view" feature in PHPMyAdmin

2008-03-05T21:06:00.000-08:00

By default when PHPyadmin is installed, it does not enable to "Relation view" feature. To enable it, perform following steps,

1. Go to PHPMyAdmin from browser, for example,

http://localhost/phpmyadmin/

2. Click on SQL button on the left side frame, or visit this URL in another tab from the same browser instance,

http://localhost/phpmyadmin/querywindow.php

3. Open following file in Text Editor,

<WAMP_SERVER_INSTALL_LOC>\apps\<PHP_MYADMIN_LOCATION>\scripts\create_tables.sql

For example on my machine, it's here

d:\apps\wamp\apps\phpmyadmin2.10.1\scripts\create_tables.sql

4. Take this SQL and paste it into SQL window opened in Step 2 and click on GO button. It will create a new database called "phpmyadmin" and also create all required tables there

Restart Apache WebServer (From Control Panel -> Administrative Tools -> Services -> WAMPApache).

That should enable "Relation View" feature when viewing table structure.

--------------------------------------------

5. The following steps are required only if any changes were made in "create_tables.sql" to rename database or table names.

Now open the config file for PHPMyAdmin which is here,

<WAMP_SERVER_INSTALL_LOC>\apps\<PHP_MYADMIN_LOCATION>\config.inc.php

For example on my machine, it's here

d:\apps\wamp\apps\phpmyadmin2.10.1\config.inc.php

(Fyi, it's also good idea to take backup of this file before editing)

6. In "config.inc.php" around line 81,make following changes,


$cfg['Servers'][$i]['pmadb']         = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation']      = 'pma_relation';
$cfg['Servers'][$i]['table_info']    = 'pma_table_info';
$cfg['Servers'][$i]['table_coords']  = 'pma_table_coords'; 
$cfg['Servers'][$i]['pdf_pages']     = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info']   = 'pma_column_info';
$cfg['Servers'][$i]['history']       = 'pma_history';

These are the default values. If not change was made in "create_tables.sql" then Step 5 is not required.

SubVersion quick setup on windows

2008-02-22T15:00:00.000-08:00

How to setup SVN on windows in quick steps

1. create a new folder "C:\svn_repo"

-- Replace this with location where you want to have your SVN repository
------------------

2. Download latest binary from here
http://subversion.tigris.org/servlets/ProjectDocumentList?folderID=91
and install it on local machine.

------------------

3. Update ENV variable to have "subversion_install_loc\bin" in you path (latest version of install seems to add this by default)

------------------

4. Go to command prompt and run following commands,

svnadmin create "C:\svn_repo"

------------------

5. Adding new users

a) open following file, "C:\svn_repo\conf\svnserve.conf" and enable following lines
anon-access = read
auth-access = write
password-db = passwd

b) open following file, "C:\svn_repo\conf\passwd" and add users as follows

[users]
user1=user1pwd
user2=user2pwd

------------------

Next from command prompt run following command,

svnserve --daemon --root "C:\svn_repo"

This will be running the SVN server at this point,

Open one more DOS prompt window and execute following command, [assuming you have somefiles in folder "C:\myproject" ]

svnadmin create "C:\myproject"

This will add "myproject" folder to SVN repository

------------------

Now to run the windows shell integration client, download and install following software,

http://tortoisesvn.net/downloads

I got this file, (TortoiseSVN-1.4.8.12137-win32-svn-1.4.6.msi)

Restart windows if required

Now go to another folder from Windows Explorer, say for example "c:\newproject_home"

Right click here, and select option "SVN Checkout" and checkout the folder "myproject" which was created in earlier step.

If everything checks out, then SVN is not correctly setup.

-----------

Using TortoiseSVN

If you want to add new folder to SVN repo from TortoiseSVN, in the right click popup menu, select the option "TortoiseSVN->Import"

And then delete this folder, and again use the option "SVN checkout" to checkout the imported folder.

You can browse the local repository using following option "svn://localhost/"

-------------------

Setting up SVN as Windows Service

Execute following command from DOS prompt,

sc create svn.local binpath= "\"C:\utils\Subversion\bin\svnserve.exe\" --service --root C:\svn_repo" displayname= "Subversion Repository" depend= Tcpip

replace "C:\utils\Subversion\bin\svnserve.exe" with "<<SVN_INSTALL_LOC>>\bin\svnserve.exe"

replace "C:\svn_repo" with folder where you created SVN_REPO in first step.

-------------------

Sniff browser history using JavaScript

2008-02-22T14:20:00.000-08:00

check this one

http://www.niallkennedy.com/blog/2008/02/browser-history-sniff.html

Using this one you can sniff the browser history using Javascript and show custom content based on sites user visited.

I think there is good part to this, and also bad part to this. The bad part is combine this JavaScript with Ajax code and send request to server without user knowledge (Just a thought) is not a good thing.