Blog

Blog

18
Feb
2010

Customer Relationship Management – CRM

Open Source Customer Relationship Management (CRM) Software

There are many commercial CRM packages out there. Our favorites are Sugar CRM and Tiger CRM, both very comprehensive and feature rich. The best part is the basic editions are totally free!

Over the years we’ve done a few Sugar CRM installations and things can get a bit hairy when it comes to getting all the SW requirements in place. However the installer in the latest version is amazing. All opensource software programmers should take a hint from Sugar. My favorite part is how it automatically creates the database and tables in MySQL.

For those interested in quickly installing one of the above CRM’s I would recommend a using an bundled Apache, PHP & MySQL installation such as Apache2triad. With Triad you only have to worry about one installation file.

I would love to hear about other opensource CRM’s out there.

18
Feb
2010

Deleting QMAIL Email by Date

One of our customers had checked the “leave message on server” box, by accident in Outlook and over 8 months accumulated over 20,000 messages (mostly spam) on the server. The mailbox was close to 1.5GB in size.

Its a Qmail mail server.

First, find out exactly how many messages are in the box and sort by the largest message

ls -Slh | – less

The | less will allow you to go page by page. To exit type :q

Tags: , ,
Category: General
18
Feb
2010

Three Tips to Get Your Site on Google

One of the first question we get from new clients is “How quickly can I get my site on page 1 of Google?” Some clients think this can happen overnight but new websites setup on a new domain name have to build credibility (page rank) with sites like Google. Search engines want to make sure that your site is not the latest Big Foot scam site. While search engines take time to index sites there are some tips you can implement to speed up the process.

Tip # 1 – Target Relevant Keywords

Keywords are the descriptors of your content. Be selective in the keywords you choose and try to use them throughout your website, links, meta tags etc. Just don’t overdo it :) Here’s a good article on selecting keywords.

Tags: , ,
Category: General,SEO
18
Feb
2010

Optimizing Skype to Work in a LAN with Routers and Firewalls

Network administrators can positively impact the quality of Skype communications
conducted by their network’s users by tuning the network’s handling of transmission
control protocl (TCP) and user datagram protocol (UDP) packets for best Skype performance.
By this we mean that network administrators can exercise a great deal of
control over their users’ networking experience by adjusting control parameters on
networking appliances such as routers, fi rewalls and network address translation devices.
In the broadest possible terms, Skype considers an ideal network confi guration

8
to be one that’s set up according to the rules shown in Table 1-1, below.

Category: Web Design
18
Feb
2010

Optimizing Skype to Work in a LAN with Routers and Firewalls

Skype Network Settings
Network administrators can improve the quality of Skype calls by tuning the network’s handling of (TCP) and (UDP) packets for best Skype performance.

Configure settings on Firewall, Router or NAT device.

1. Outgoing TCP connections should be allowed to remote ports 1024 and higher.

2. Outgoing TCP connections should be allowed to remote ports 80 and 443.

3. Outgoing UDP packets should be allowed to remote ports 1024 and higher. For UDP to be useful
to Skype, the NAT must allow for replies to be returned to sent UDP datagrams. (The state of UDP
“connections” must be kept for at least 30 seconds, and Skype recommends that these translations
be maintained for as long as an hour, if possible.)

Category: General