22.04 This Day

Building a social network: Elgg vs BuddyPress

2011-09-08T14:06:00.000-07:00

I've wanted to build a social network for many years, I've worked on some building from scratch but now I stand in the why reinvent the wheel camp. After searching the web for people picks I've picked a couple of favorites. Elgg and BuddyPress. During my search I've also tested Dolphin, drupal, and joomla but my primary criteria was it should be easy to setup out of the box and work ok on a shared host which removed Drupal and Joomla though both look promising if you want to spend a little more time on it, and have some decent hosting.

BuddyPress
BuddyPress is really a plugin to wordpress adding basic social network features to the blog cms foundation. I've worked a lot with wordpress recently so that probably swayed my decision to try BuddyPress.
Features:
Out of the box buddy press offers

Activity streams
Extended Profiles
Friend connections
private messaging

Being the BuddyPress is a wordpress extension you a lot of plugins available to refine your social network. With some added plugins you can implement

groups
forums
albums

ELGG
Elgg is an open source social network project and is specifically built to be a social network.

Features

Profiles
Activity Feed
Groups
Pages for users and groups
Blogs for users and groups
Group discussions, bookmarks and calendar
Messaging system

The main difference between the two is how you want to generate content. A BuddyPress system is great for having the administrator publishing a blog and maintaining website pages with user content primarily in the forums. On the other hand Elgg doesn't really have any tools for an overall blog and website but has lots of ways for content to be published by users and user groups in addition to group discussions (forums).

BuddyPress is easier to skin especially if you are familiar with wordpress themes, and may have a slightly larger support base because of it's close ties to wordpress. I'd say use BuddyPress for a site that publishes content and wants a community discussion. Use Elgg if you want to empower your community more.

Updating the date modified field on SugarCRM when saving a note using triggers

2011-07-13T11:58:00.000-07:00

About SugarCRM
SugarCRM is an opensource CRM solution made with php and mysql, it is also available in a paid support version. It is a solid CRM with tons of features and some add-ons available. It is highly customizable for many types of businesses to work with.

Why update date modified?
CRM's can be used in a number of different ways, in many respects how the system is set up and the processes the users establish dictate how useful the CRM will be. In this case the system was pre-existing and the sales force has been using it for quite some time, so I didn't really want to try and change their process.

In SugarCRM the accounts screen view generates a table with numerous columns, one of which is the date modified which can be used for sorting. The sales team liked to use this to see which of their clients they had last worked with; however saving a note does not change the date modified. Only updating the main record updates the the data modified in the database, so they would create a note then do a save on the record to force a change on the date modified field.

I researched a number of solutions, there was logic hooks, custom fields and a number of things people have done but I had a simple idea... database triggers.

Basically I used the following statements:

create trigger note_insert insert on notes for each row update accounts set accounts.date_modified = NEW.date_modified where accounts.id= NEW.parent_id

create trigger note_update after update on notes for each row update accounts set accounts.date_modified = NEW.date_modified where accounts.id= NEW.parent_id

Now when some one creates or updates a note the date modified is changed by mysql and I didn't even have to touch the SugarCRM code. I know from searching around that others have made more elaborate changes to SugarCRM for similar purposes but this worked for me so I share it with you.

First Experiences with Magento

2011-02-11T22:30:00.000-08:00

Recently I started a job and was tasked with setting up a Magento based website. For those that don't know Magento is an open source e-commerce php/mysql software platform.

Installation
Installation was super easy, a simple upload of files, create the database, set some permissions and run the install script. I did the install on a private server but I know Bluehost offers a one click install, and I'm sure many other hosts would as well.

You should set up the cron job or you may unexpectedly see your pricing rules disappear.

Cool Features
Magento allows you to run multiple stores (using multiple domains, subdomains or subfolders) with one installation. That is you have one admin panel and one set of inventory. Each store can have it's own template, or you can have the same template with different inventories (this is what I did for a Canada/US store and different labelling requirements on products).

Magento allows for an extra temporary theme to replace your current theme, and the ability to set a duration on the change. For example you could create a Christmas theme that over rides your current one. This can be done at a site, category or even product level.
Magento handles newsletter registration and sending, inventory, a variety of shipping option, many types of payment gateways are built in, as well as pricing rules at the catalogue and shopping cart levels.

Things I didn't like...

Magento has a module system which can add a lot of funtionality but there are some core features I think that are missing.

In the wysiwig editor inserting a link to a page in the site requires a cut and paste from a browser. I like the Concrete5 method of having a sitemap open and selecting a page. Seems like a feature most CMS' lack but should be available.
Lightbox style gallery. I manually added one to the site but it would be nice to have out of the box, the pop up box used for products is not particularly attractive.
A quality set of default emails. Some of the emails have a hard coded "Demo Store" in them, while others use the proper variables to create the store name. A really simple fix if you ask me.

The administrator user interface can be a bit confusing with options spread out all over the place, and multiple levels of settings based on websites and stores. It is very easy to miss a setting that is hidden in another view. A trade off for the power of having multipe websites/stores, but could be presented better.

Customizing Magento Templates
The template system in Magento is not for beginners, there are numerous files spread across a number of directories. For example the you have the "skin" directory where you keep css, js and images, then you have the app directory which you dig down into until you find your templates layout and template directories where you have the xml files that control layout blocks and the individual .phtml (php) template files.

Admittedly once you get used to it it's not as bad as it sounds. The template systems is based on a base template with your custom files over-riding the base set, so if you don't have all the files built into your something will still likely work. I would say you need some php experience in addition to skills in html and css to do basic customization, and good php skills to do more than that.

I also discovered some of the templates other people built have hard coded elements like banner images, logos etc. This isn't a fault with Magento but with the template designer. Magento allows for static blocks which can be used as place holders for these items, not forcing people to rename images to match the existing file or having to delve into the template code.

Getting the store running.
This is a very tedious process. Product creation is pretty slow, I created each product one at a time, entering the basic data and using the editor to layout the product descriptions. Getting a properly resized image can take you a lot of time as well but these details are necessary to make the store look good. There is the ability to import data from a spreadsheet but you still need to upload images manually and select them for each product.

After creating products and categories, you also have to check out tax rules, shipping rules, create good transaction emails and set up the payment system to start. There's much more to it and I found a handy checklist online just prior to launching the website. You can find it at
http://retailevolved.com/blog/cat/magento/post/magento-launch-checklist/, click on the link in the page for a 9 page pdf - a great resource for creating a well functioning store.

Final Thoughts
Now that I've worked with it for almost a month I'd recommend it, especially if you are making a large e-commerce site with numerous products. If you don't need to sell alot of products or carry a very small catalog, you do lack many of powerful cms tools you find in Concrete5 or even wordpress, for a robust ecommerce solution.

Check out the magento site in action http://www.4everfit.com/

The Joy of Telus Shared Hosting

2010-11-10T08:38:00.000-08:00

Recently I've had the joy (sarcasm here) of working on a Telus shared hosting plan. It's not something I'd recommend for anyone who wants any sort of data driven website but I've found a workable if not ideal solution.

The first thing to note with Telus is how slow the servers are. I can't say whether it is the mysql server or the equipment, or the php (no phpinfo allowed), but I can say with concrete5 it was 30 -90 seconds, timeouts errors and more making the system unworkable.

Note: If you want to use concrete5 I like Bluehost with the auto-installer, and it works fine on Dreamhost as well.

After building the site in concrete5 only to be stifled by the server, I decided to try a wordpress installation. I did find a few websites that said wordpress was terrible on telus too but I had to try it for myself. To my surprise the wordpress site performs reasonably well. True some pages take up to 8 seconds to load but with supercache this may be reduced for site visitors.

I had to manually install wordpress, which includes using the Telus archaic control panel but it really isn't that hard. Note they recommend filezilla for ftp and it seemed to work way better than my Dreamweaver ftp.

The site I'm working on isn't live yet and I haven't tested under any sort of load but I can say at least there is a chance that wordpress will create a reasonably working CMS on Telus hosting.

Creating A Fancy Menu In Concrete5 with CSS

2010-01-12T09:43:00.000-08:00

I was working on a subcontract for the Canadian Clean Power Coalition website and received a set of design files which included a very colorful side menu. I had planned to make the site using Concrete5 since the client wanted a CMS and C5 is my favourite.

The menu looks like this

As you can see the menu consists of :
the top level links in grey
the current top level in green with a leaf
sub level links in black
and the active page in red.

Once I created the skeleton of pages in the website I can use the auto-nav feature to create the menu. In this case the menu display all relevant subpages.

The actual html generated by the autonav looks like this:

<ul class="nav">
<li>
<a href="/index.php/about-the-ccpc/">About the CCPC</a>
</li>
<li class="nav-path-selected">
<a class="nav-path-selected" href="/index.php/electricity-sector/">Electricity Sector</a>
<ul>
<li class="nav-selected nav-path-selected">
<a class="nav-selected nav-path-selected" href="/index.php/electricity-sector/electricity-terms/">Electricity Terms</a>
</li>
<li>
<a href="/index.php/electricity-sector/how-a-coal-fired-power-plant-works/">How a coal-fired power plant works</a>
</li>
</ul>
</li>
<li>
<a href="/index.php/clean-power-projects-and-technology/">Clean Power Projects and Technology</a>
</li>
<li>
<a href="/index.php/ccpc-members/">CCPC Members</a>
</li>
<li><a href="/index.php/newsroom/">Newsroom</a>
</ul>

I like to wrap the nav in it's own div with an id, in this case I wrapped the navigation in a <div id="navBar">. Based on this it is an exercise in CSS using child and descendant selectors.

1. The base menu styles

#navBar{width: 180px; margin: 25px 0px 0px 5px; float:left ;font: normal 12px Arial, Helvetica, sans-serif; text-transform: uppercase;}

#navBar a{display: block; text-decoration: none; margin: 10px 0px 10px 20px; color: #999} // grey color
#navBar ul{margin: 0px; padding: 0px};
#navBar ul.nav li{list-style: none; margin-left: 0px;} // remove the list circles

2. The green on state, uses the .nav-path-selected class generated by autonav

#navBar ul.nav > li.nav-path-selected{background: url(images/nav_leaf.gif) 4px 4px no-repeat;} //place the leaf on the list item, note the descendant since the .nav-path-selected is used on both menu levels.
#navBar ul.nav li.nav-path-selected a{color:#090; font-weight:600;} // change text to bold green

3. The submenu only exists when the parent item is selected so i can still use .nav-path-selected class

#navBar ul.nav li.nav-path-selected ul{margin-left:20px;} // indent the sub menu

#navBar ul.nav li.nav-path-selected ul a{color:#000;} // base color of links is black
#navBar ul.nav li.nav-path-selected ul a.nav-selected{color:#C00;} // active link is red

The result is a 2 tier menu with 4 colors and a graphic leaf, sure it looks a little like Christmas but that's what they wanted.

Google webmaster tools great for web marketers

2009-12-17T13:52:00.000-08:00

Over the years I have built numerous websites, studied the art of SEO and recently have been testing theories on SEO and web marketing, in particular using Google Adsense.

It goes without saying that Adsense is a powerful force in the online advertising market, and that ads directly related to content only makes sense since it is more likely your target market on the site. Over the past 6 months I have been creating more and more content on different styles of sites, and can say the fastest way I have found to get a site crawled is using Google Webmaster Tools - specifically the sitemaps.

If the first step is ensuring your site/content is included in Google, the next step would be seeing how your content is viewed, where it appears on Google and using what search terms. Well this is super easy since the webmaster tools reports your position based on selected terms. How easy is that.

Case in point, this blog was started on October 29th, I haven't written a lot of posts but it appears in the top ten results for:
primus softphone and dreamhost kill ftp - admittedly not real money makers but I wouldn't have known this without the webmaster tools.

Some of the other great features are:
1. shows errors when crawling - for example 404 pages
2. shows you inbound links Google knows about.
3. reporting of content issues such as duplicate content or title tags
4. tools to help move a website
5. tools to test your site performance.

All in all a great little package you get for free from Google.

PR 6 in less than a month

2009-12-07T09:57:00.000-08:00

Recently 22.04 media recreated the Eagelcrest Resorts website repurposing the site from an investment website to a resort real estate sales website. Less than one month later I noticed that 2 pages have achieved a PR 6 on the google toolbar. How did this happen? With google there is no real way on knowing why, I can only offer what I have done.

How It's Built
All of the websites I build offer solid on page SEO, that is a good keyword title, matching h1 and content on topic. I use alt tags with keywords, and on this particular site I wrote all the content so it may have more keywords than a non-seo site like the previous version. The site is build on a concrete5 CMS, and also uses google analytics and a google sitemap account.

This site has a few differences from other sites I've made:
1. Numerous images, meaning more alt tags.
2. Integrated Youtube videos. The location page features 3 seperate videos about La Paz which may have been linked to, and the home page has another video. The youtube account does have the eaglecrest link in the profile.
3. Several PDF documents for download.

Off-site Work
I also had launched the REI Gallery which google webmaster tools reports 4 links from REI gallery to eaglecrest resorts. Note REI gallery has no page rank and is a brand new site.

There seems to be a few other links to the site, from old directory sites I submitted to and in a news group.

Did the PR6 help?
The website does list well for a number of good keywords, and traffic is actually arriving for things other than "eaglecrest" so in that sense it is a success. On the other hand in a straigt up search for a keyword in the title it doesn't beat lower PR sites so the PR6 may be less important than having good keyword content.

Make money at home scam?- google ad trick

2009-12-05T15:14:00.000-08:00

I recently discovered that a family friend was trying the make money at the home on the "work at home" internet plan. As a person who works on the internet I thought I'd help her out by making her website better for search engines.

It turns out that she took a paid for "course" on how to make money and some of the techniques really got me wondering.

First of all she started a website filled with work at home ads, in some cases 3 versions of the same ad on one page. The ads were mainly for affiliate programs which offer a commission for people who sign-up. This was supposed to be the primary income generator. There was also some links to the parent company web page (not-reciprocal) and some Google ads.

The parent company website also some work at home affiliate ads, but a lot of Google ads and numerous content pages also with several Google ad blocks, a better design from the seo perspective.

The strategy taught was to purchase Google or yahoo ads, in fact to purchase the most popular job related terms and pay whatever it takes to be number one. This strategy seems to be completely off the mark, the professional Adsense strategy is to pay as little as possible for "work at home" related keywords to use up your ad budget. Then it occurred to me perhaps the real motive is different...

If my website has a greater page rank and higher result position in searches I am more likely to get visitors. If I use Google ads, having the PPC rate pushed up means more money for me. If I sell a course which promotes pushing up the PPC rate for the same "work at home" industry I am advertising, not only do I get the course fee, but all my ad revenue will increase.

Now this is just my speculation, but the program does create this effect intended or not. Personally if the program advice contradicts popular wisdom, I would question it's motives.

Social Network as a CRM

2009-11-12T16:26:00.000-08:00

I've spent a lot of my time at work over the last 4-5 years working on lead generation and lead management or customer relationship management systems. As social networks became more and more prevalent and more integrated in peoples web habits it occurred to me that many features of a social network could easily be adapted to function as lead management.

The first thing you need to do is classify people. Typically in a simple system you would have something like prospects(people how you know of but haven't contacted directly), contacted leads, qualified lead, not qualified leads, buyers. If I was to implement this in facebook I would have to use the list tool in friends (I think there used to be better ways but that was the old facebook). You could make a list for each category and assign people appropriately.

Once you have your lists sorted you can now use the system to deliver targeted messages to each lead category using the facebook inbox tools. As a person moves along the buying process you can move them into a new list and remove them from the old list.

The essentials are really classification and communication. Social networks typically contain these tools and that's how you can adapt them for CRM use. Of course some system may be more useful than others and I only use facebook as an example. Ultimately marrying social network features into a CRM would be extremely useful for many businesses.

Dreamhost vs Bluehost

2009-11-11T13:39:00.000-08:00

I've been a Dreamhost user for a number of years and I can honestly say I like their setup, but in recent months there has definately been a lot of downtime and server errors (I think due to overloading). This has lead me to trying Bluehost which a number of people recommended to me. Below I will do a little comparison.

Price
I got my Dreamhost account for a smokin deal. It was their one day president's day sale and I paid about $15 for a year of hosting with free domain. The current rate seems to be $8.95/month up from the rates charged over the last couple of years.

Bluehost has pricing at $4.95/month for a one year term ($3.95 on 2 years), if you get to Bluehost via a referral account the price will show as $6.95 to pay those referral fees I guess.

Control Panel
Dreamhost uses a custom control panel which although not the prettiest, it has excellent features. In particular the options for domain management include hooking into various google services and have automated processes for domain cloaking, mirroring and redirecting. They also create individual folders for each domain or subdomain which can really help when setting up some sites. Their DNS control is also good allowing you to change more than just MX records.

Bluehost uses a version of Cpanel, the biggest strength I see is the script installer (simple scripts) It's very easy to get a decent package installed with little effort. The list of scripts is considerably larger than Dreamhost's set, and includes Concrete5 which I do a lot of work with.

FTP
It may just be me but my FTP access to Dreamhost seems to always need me to kill ftp connections to get a large number of files up. Also you don't get anonymous FTP on Dreamhost for free, it's an additional $3.95/month for that feature. Each dreamhost ftp user uploads to a seperate directory on the server to give access to that directory their is only one user and password.

Load Time
As I noted in the opening paragraphs Dreamhost used to perform well for me. If you have a static html site it would still be very fast. The issue seems to be data driven sites with a lot of php processing. When it comes to the concrete5 sites I've built Bluehost is much consistently much faster in page loading time than Dreamhost.

Customer Service
I've only used Bluehost customer service once and it was only adequate. I have used Dreamhost on several occassions and usually have to reply to the ticket at least once for them to solve my problems, which is usually a problem with their system.

In the end, I did like Dreamhost but so far Bluehost appears to be better where it really counts. Having a fast reliable site is really what I want from my hosting company.

3 Days to Voice Mail Down

2009-11-09T14:57:00.000-08:00

Well it only took 3 days before our Primus system had problems. The voice mail is gone. It disappeared from our web control panel, is no longer accessible on the phone and doesn't pick up.

Perhaps this is retribution for the way I filled in the customer satisfaction surveys they sent me when I was still trying to get the service working in the first place.

Whatever the case, I now wait for their technical support to re-enable the voicemail function. I hope it all stabilizes soon, then I may write about some new topics.

Primus Talkbroadband softphone

2009-11-06T10:39:00.000-08:00

After several hours of calling customer service, technical support and customer service again, I finally have my primus VoIP service running.
To be fair all the trouble was caused by the initial sales person misspelling my name and email address.

Initial testing of the phone seems to have a very clear sound and some really great features at the $9.95/month plan, including the voicemail to email function and "find me follow me" function.

So even though the support/service was a bit of a gong-show the product seems to be alright for the price. I guess we will test reliability in the coming months.

Softphone VoIP

2009-10-29T15:39:00.000-07:00

Today I spent a great deal time trying to find a VoIP service that would allow me to have a second phone line without giving up my current Telus phone line.

Vonage
Apparently Vonage used to offer this service but not anymore, it seems they want more of the primary market and force you to move your main number to their service. Verdict - OUT

Ringcentral
The second option I found was ringcentral. The problem with them was they don't have a service for outbound calls in Canada, I don't really want to have to use my main phone to call out and hope they don't call me back on it. Verdict - OUT

Versature
Versature is a business solution. They offer up to 5 lines and lots of business features including the ability to select numbers or get toll free numbers. The package looked good but cost 35+ a month plus a setup fee. A little too rich for what I needed.

Primus
The solution I choose was a recommendation from a person who sets up PBX phone systems and that was Primus. First I ordered online and their system is poor to say the least. Basically the process ends and you don't know how much you are paying and have no account of the package ordered. It even has canned text that didn't apply to my order. So I tried going through the system again and found the service I really wanted (not the one I ordered) and set about making a number of calls to get the first order cancelled and the new "Talkbroadband softphone" service set up. They tell me I can have it in 24 hours which is significantly faster than anyone else and has the best pricing of $9.95/month unlimited local which I can upgrade to unlimited Canada/Usa for another $10.00.

I'll wait and see how the service turns out, but from my day of research, if you want a VoIP phone in Calgary, you want it cheap and fast with a seperate phone number. Go to Primus and order over the phone.

Social Networks in a Box

2009-10-27T12:19:00.000-07:00

I've been playing with a few social networking solutions as I work on the REI gallery and a yet to be determined second social network site. So far I have used ellg which is the basis for REI Gallery and seems to be very full featured, but was a bit ugly when it came to making templates.

The other solutions I've tried are Buddypress and Pligg. I haven't really delved into the internals of these systems but I do like some of the implementations from the Buddypress gallery. I also like the concept of CSS based themes since I am very into content seperate from structure. Many were the days studying CSS Zen Garden.

There are of course numerous other open source social networks but I think taking on 3 at a time will be my limit. Until then I will hack away at these three.

Connecting Dots

2009-10-26T08:54:00.000-07:00

I decided to update my company website and as part of the plan I wanted to link to major social networks... being facebook and twitter, plus add an rss feed which will be from this blog. The progression went like this.

Get a twitter account - this is fairly straight forward, I created an account a while ago and was able to change my username to match my company website. Getting followers will be next for twitter.
Setup the facebook page - it's not readily apparent how to do this, I used a sidebar link on the pages page which i got to from the control on the footer bar after login. Setup is pretty straight forward, though once it's up facebook is all about getting you to advertise your page in their network. Fair enough. I linked the facebook page to twitter using a built in tool so all my wall updates now post on my twitter (killing 2 birds with one stone as it were).
The blog - I looked at wordpress (free and self-hosted), typepad and blogger, of course as you can tell I chose blogger. They all have their strengths and weaknesses, but I decided a free blog that didn't take server resources away from my other sites would be best. Free wordpress has limits on commercial content which finds me here on blogger.
The website - I built the website with concrete5 which is definately overkill for what the site will actually need. I used it to test bluehost as a service provider, formerly I had it hosted on dreamhost. Bluehost uses a simple scripts program which installs concrete5 for you, which I thought would save me lots of time as I create more and more concrete5 sites. The problem is the installer creates a bad install and I had to do it manually anyways. I'm sure sometime in the future it will be fixed but for now manual is the way to go.

The ideal solution will be to use one service (probably the blog) to produce content for the other two. I have the facebook -twitter link so now I seek a link to blogger. I'll let you know what I find.