Archive for the ‘Development’ Category

New Joomla site developed for backyardaquaponics.com

Thursday, October 15th, 2009

Cabot recently developed a Joomla based solution for backyardaquaponics.com. Backyard Aquaponics Pty Ltd, is a leading edge aquaponics company based in Western Australia. Originally started by Joel Malcolm as a means to provide information packages to people, who were interested in learning more about the subject, the company has now grown and changed quite a bit since those early days.  Aquaponics is the symbiotic cultivation of plants and aquatic animals in a recirculating environment.

The new site was developed in Joomla and has the following features:

  • Innovative new design
  • Search Engine Friendly URLs
  • E-commerce shopping cart
  • RSS integration with PhpBB Forum
Backyard Aquaponics Screenshot

Backyard Aquaponics Screenshot

  • Share/Save/Bookmark

Drupal Based Mortgage News Aggregation Site with Social Networking Features

Tuesday, October 13th, 2009

Cabot Solutions is pleased to announce the release of Mortgagespeak.com which is the latest product developed for a Marketing firm located in Chicago.   The primary stakeholder of the site Greg Janecka had conceived the idea of developing a news and networking site that catered to the needs of the Mortgage industry in the United States.

Cabot proposed to develop the site using Drupal which brought many features out of the box including Blogs, memberships, Polls, and a powerful admin area to manage content of the site.   Some of the innovative features we built are:

1. RSS aggregation into Drupal.
2. Facebook connect allowing facebook users to login and participate easily.
3. Display latest twitter post via twitter API.
4. Highly interactive home page news listing using JQuery.
5. RSS feeds for different news categories.
6. Newsletters.
7. Configurable Advertisement module to display sponsorships.

See the site here.

Mortgage Speak Screenshot

Mortgage Speak Screenshot

  • Share/Save/Bookmark

Getting started with JQuery

Thursday, July 9th, 2009

For working with jquery we need to download the jquery.js file.Also need to add the following javascript code in our file.

The first thing that most Javascript programmers end up doing is adding some code to their program, similar to this:

 window.onload = function(){ alert("welcome"); }

instead of above code, jQuery has a simple statement that checks the document and waits until it’s ready to be manipulated, known as the ready event:

$(document).ready(function(){
   // Your code here
});

Inside the ready event, add a click handler to the link:

$(document).ready(function(){
   $("a").click(function(event){
     alert("Welcome to cabot blog!");
   });
 });

Adding and Removing a CSS Class

To add and remove a class we can use jquery. For example, if we have a class like below

<style type="text/css">
   a.boldtext { font-weight: bold; }
</style>

If we want to add a class to the anchor tag below

<a href="http://jquery.com/">jQuery</a>

we can add it as :

$("a").addClass("boldtext");

Also to remove a class:

$("a").removeClass("boldtext");

we can add a css to a div or a tag using jquery as specified below

$("a").css({backgroundColor: 'yellow', fontWeight: 'bolder'});

Special Effects Using jquery

To add a special effect when we click on the anchor tag we can write code as

 
$("a").click(function(event){
   event.preventDefault();
   $(this).hide("slow");
 });

Now, if you click any link, it should make itself slowly disappear.

Jquery Events

We can create a new jquery event using the code specified below

var e = new jQuery.Event("click");

Describes the nature of the event. This returns a string.

$("a").click(function(event) {
  alert(event.type);
});

result:click

event.pageX/Y

The pageX/Y property pair returns the mouse coordinates relative to the document.The return value is string.

$("a").click(function(event) {
  alert("Current mouse position: " + event.pageX + ", " + event.pageY );
});

Result:”Current mouse position: 130, 640″

event.result

Will contain the last value returned by an event handler . The return value can be anything

$("p").click(function(event) {
 return "hey"
});
$("p").click(function(event) {
 alert( event.result );
});

Result:”hey”
There are several predefined methods in jquery.Some of them are:

event.preventDefault()

Prevents the browser from executing the default action. Use the method isDefaultPrevented to know whether this method was ever called (on that event object).
Stops the browser from changing the page to the href of any anchors.

$("a").click(function(event){
 event.preventDefault();
 // do something
});
event.isDefaultPrevented()

Returns whether event.preventDefault() was ever called on this event object. This returns true/false

$("a").click(function(event){
 alert( event.isDefaultPrevented() );
 event.preventDefault();
 alert( event.isDefaultPrevented() );
});

bind(type,[data],fn )

Binds a handler to one or more events (like click) for each matched element. Can also bind custom events.

Possible event values: blur, focus, load, resize, scroll, unload, beforeunload, click, dblclick, mousedown, mouseup, mousemove, mouseover, mouseout, mouseenter, mouseleave, change, select, submit, keydown, keypress, keyup, error

For example

$("p").bind("click", function(e){
 var str = "( " + e.pageX + ", " + e.pageY + " )";
 $("span").text("Click happened! " + str);
});
$("p").bind("dblclick", function(){
 $("span").text("Double-click happened in " + this.tagName);
});
$("p").bind("mouseenter mouseleave", function(e){
 $(this).toggleClass("over");

});

here object 'p' is binded to different events like  click, dblclick, mouseenter mouseleave etc.

  • Share/Save/Bookmark

Authenticate your website using Facebook Connect API

Monday, June 15th, 2009

Facebook connect API allows users to dynamically connect their identity information from Facebook, such as basic profile, friends, photos information and more, to third party websites, as well as desktop and mobile applications.  The article here describes how to provide Facebook Connect authentication for your web application.

Steps to connect your site to Facebook :

1. If you don’t already have a Facebook API key for your site, create an application with the Facebook Developer application.

  • Go to http://www.facebook.com/developers/createapp.php to create a new application.
  • Enter a name for your application in the Application Name field.
  • Accept the Developer Terms of Service, then click Save Changes.
  • If you have a Facebook API key,follow from next step

  • On the Basic tab, keep all of the defaults.
  • Take note of the API Key, you’ll need this shortly.
  • Click the Connect tab. Set Connect URL to the top-level directory of the site which will be implementing Facebook Connect. You can include a logo that appears on the Facebook Connect dialog. Next to Facebook Connect Logo, click Change your Facebook Connect logo and browse to an image file. The logo can be up to 99 pixels wide by 22 pixels tall, and must be in JPG, GIF, or PNG format.
  • If your site is going to implement Facebook Connect across a number of subdomains of your site , you need to enter a Base Domain
  • Click Save Changes.

2. Create a cross-domain communication channel file called xd_receiver.htm and place it in a directory relative to the Connect URL that you entered in the previous step. Include following script into this file.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<body>
<script src="http://static.ak.connect.facebook.com/js/api_lib/v0.4/XdCommReceiver.js" type="text/javascript">
</script>
</body>
</html>

3. Next, in your Home Page ,ie page of facebook connect page,Place Html tag as following

<html xmlns="http://www.w3.org/1999/xhtml" xmlns:fb="http://www.facebook.com/2008/fbml">

4. include following javascript file with in your body tag NOTE IN HEAD TAG

<script src="http://static.ak.connect.facebook.com/js/api_lib/v0.4/FeatureLoader.js.php" type="text/javascript"></script>

5. Place facebook login Button in your page

<fb:login-button></fb:login-button>

6. Finally, Include following script after the login button

<script type="text/javascript"> FB.init("YOUR_API_KEY_HERE", "<path from web root>/xd_receiver.htm"); </script>

You should now be able to click on the facebook connect logo and use your facebook credentials to login to your web site.

  • Share/Save/Bookmark

Generating a Google Sitemap via PHP

Monday, June 15th, 2009

A sitemap is  an XML file,that lists the URLs of a site.  The sitemap file can be used to inform search engines like google on the pages available on a site and when those pages have been modified.  The search engines require a particular format for the sitemap xml file. Let me give a brief on sitemap creation for google.

Create an xml file(say sitemap.xml). Its better to create the xml file dynamically using the scripting language like php, jsp etc.

Format of sitemap xml  accepted by google:

<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.google.com/schemas/sitemap/0.84" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.google.com/schemas/sitemap/0.84 http://www.google.com/schemas/sitemap/0.84/sitemap.xsd">
<url>
<loc>http://domain.tld/</loc>
<lastmod>2008-01-01</lastmod>
<changefreq>daily</changefreq>
<priority>0.1</priority>
</url>
</urlset>

The points to be remembered when creating a sitemap are:

1. Sitemap should start with the tag <urlset> and end with </urlset>
2. Each set of xml entry shouild start with <url> and end with </url>
3. <loc></loc> contains the url
4. The <lastmod> tag expects a date in the  format YYYY-MM-DD,  or the date format can be in w3c format.
5. The <changefreq> tag expects one of the  values: always, hourly, daily, weekly, monthly etc.
6. The <priority> can be a value between 1.0 and 10

7. Replace special charecters from xml file.
Character                   Replacement
Ampersand     &         &amp;
Single Quote    ‘         &apos;
Double Quote  “         &quot;
Greater Than   >        &gt;
Less Than       <        &lt;

8. Encoding should be UTF-8 mode
9. The maximum permitted size of a sitemap file is 10 MB.

Sample PHP  code for sitemap generation:

$xml = '';
$xml =  "<?xml version=\"1.0\" encoding=\"UTF-8\"?>"."\n";
$xml .= "<urlset xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:schemaLocation=\"http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd\" xmlns=\"http://www.sitemaps.org/schemas/sitemap/0.9\">"."\n";
for($i=0;$i<$subLimit;$i++){
$title = str_replace("&","&amp;",strip_tags($response['title']));
$loc = str_replace("&","&amp;",strip_tags($response['location']));
$com = str_replace("&","&amp;",strip_tags($response['company']));
//$loc1 = $row['job_jobs_location'];
$title = htmlentities($title, ENT_QUOTES, "UTF-8");
$com = htmlentities($com, ENT_QUOTES, "UTF-8");
$loc = htmlentities($loc, ENT_QUOTES, "UTF-8");
$date = $response['date'];
$date = strtotime($date);
$date = date(DATE_W3C, $date);   //Date in w3c format
$xml .= "<url>"."\n";
$xml .= "<loc>http://www.jobtreks.com/jobresult/$title/$com/$loc/$id</loc>"."\n";
$xml .= "<lastmod>$date</lastmod>"."\n";
$xml .= "<priority>0.50</priority>"."\n";
$xml .= "<changefreq>weekly</changefreq>"."\n";
$xml .= "</url>"."\n";}
$xml .= "</urlset>";
$fh = fopen('sitemap.xml', 'w'); //After exceuting this file, an xml file called sitemap.xml is created.
  • Share/Save/Bookmark

Programming With Twitter API

Friday, June 5th, 2009

Twitter is a popular social networking service where users can share their updates. User updates known as tweets which are text based posts up to 140 characters, displayed on the user’s profile page and delivered to other users who have subscribed to them called followers. Twitter has gained significant attention from web savvy social networkers, and lately also being used by businesses for marketing.

Twitter provides API that allows developers integrate twitter functions on their sites. Using the API, developers are now able to build desktop and web based messaging applications. These APIs have allowed for hundreds of exciting applications to be made available that allows friends to keep in constant contact.

The Twitter API currently consists of two discrete APIs, REST and Search APIs. We are not allowed to make unlimited calls in this API. The API is entirely HTTP-based. Methods to retrieve data from the Twitter API require a GET request. Methods that submit, change, or destroy data require a POST. A DELETE request is also accepted for methods that destroy data. API Methods that require a particular HTTP method will return an error if you do not make your request with the correct method. The API presently supports XML, JSON, and the RSS and Atom syndication formats, with some methods only accepting a subset of these formats.

Some of Search API Methods are shown below:
search: Returns tweets that match a specified query.
URL: http://search.twitter.com/search.format
Formats:json,atom  Example:http://search.twitter.com/search.atom?q=devo&rpp=15
Here rpp is the records per page
Trends: trends:Returns the top ten topics that are currently trending on  Twitter.
URL: http://search.twitter.com/trends.format
Format: json
We can fetch current topics,daily topics or weekly topics.
Example:http://search.twitter.com/trends/daily.json?date=2009-03-19

Some of REST API Methods shown below:

statuses/public_timeline : Returns the 20 most recent statuses from  non-protected users who have set a custom user icon
URL: http://twitter.com/statuses/public_timeline.format
Formats: xml, json, rss, atom.
Example: http://twitter.com/statuses/public_timeline.xml
 statuses/friends_timeline:Returns the 20 most recent statuses posted  by the authenticating user and that user's friends.
URL: http://twitter.com/statuses/friends_timeline.format
Formats: xml, json, rss, atom
Example:http://twitter.com/statuses/friends_timeline.xml
Status Methods:Returns a single status, specified by the id  parameter below.
URL:http://twitter.com/statuses/show/id.format
Formats: xml, json, rss, atom
Example: http://twitter.com/statuses/show/123.xml
  • Share/Save/Bookmark

java.lang.OutOfMemoryError when indexing large databases in Solr

Saturday, May 16th, 2009

When indexing large databases in Solr, if you encouter java.lang.OutOfMemoryError, this could be caused due to a bug in the mysql jdbc driver.  To resolve this, add include batchSize=”-1″ parameter in your dataSource entry of you data-import.xml file.  The entry should look something like :

<dataSource type="JdbcDataSource" name="ds-2"
          driver="com.mysql.jdbc.Driver"
          url="jdbc:mysql://localhost:8889/mysqldatabase" batchSize="-1"
          user="root" password="root"/>

Reference:

http://wiki.apache.org/solr/DataImportHandlerFaq#head-346bc6622c328a146d1691bc4ed6deb51086d9b3
  • Share/Save/Bookmark

Using Solr / Lucene for full text search with MySQL DB

Thursday, May 14th, 2009

Solr is a standalone webservice application that can be installed on any servlet container like tomcat, jetty etc.  It uses the popular Lucene java library to provide enterprise level search results from databases, filesystem, web services etc.    Solr runs as a web service, so in effect it provides a cross platform search engine.  The results can be accessed from php, java, RoR or .NET by invoking its web service.  The only requirement on your server is that it should allow you to run java application or have deploy solr as a webapp in an existing servlet container such as tomcat or jetty.

This article shows how to get Solr index and provide search results for a simple MySQL table.  The search results will be provided in XML, so you can get your web application to read the results, parse it and display it any form desired. (more…)

  • Share/Save/Bookmark