Web Marketing Concept - The Trading Guru

Jeremy approached me for some ideas on how to spread his ideas across the internet and build a community on all his shares/investment/money talk.

Conceptualized ‘The Trading Guru’ and for the setup to run on both Blogspot(FREE) and Facebook(FREE). My services for overall IT setup, marketing concept, ongoing consultation… … also FREE.

Ongoing Projects

1. Project Management System - jobs and schedules
2. Property agent website - listing of property
3. Web design for business concierge service with CMS - build internet awareness
4. Procurement Portal for stationery company - facilitate business workflow
5. Website CMS for travel company - ease of updating website information
6. Full scale ERP project for manufacturing company - streamline business processes with business workflow system
7. Customer Relationship Management System - manage customers better

EDM Template and Copywriting for Newsletter - Tinkrbox

Done up a master template for the Tinkrbox monthly EDM as well as the copywriting for the March 2010 content.

Copywriting for Tech Blog on iPad

Got a request from a tech blog to help them on an iPad review.

My first write-up of a non-marketing nature; semi-tech review coupled with personal opinions. Too bad I can't release it here as I am not claiming credits for the writeup.

Internet Marketing - Tinkrbox

Current No of Users: 1500
Target by 10 April: 2000


I'll update with the numbers weekly.


What is Tinkrbox? www.tinkrbox.com

Excel - How to go next line in same cell?

In Microsoft Excel, most people have the problem of having many lines of input in one cell. Copy and paste works, but what if you are working on just an Excel spreadsheet.

Click ENTER and it will simply run to the column in the next row. This wouldn't work.

To go to the next line in the same cell, simply hold Alt and click ENTER. (Command+Alt+Return on a Macintosh)

Voila. Now you can do more with Excel that you previously thought not possible.

Making Apache,XAMPP and IIS work together

The Problem:

I have setup XAMPP at work. It comes with Apache 2, MySQL, phpMyAdmin and a whole bunch of stuff.

The Apache resides at

http://localhost (port:80)

I installed Microsoft Visual Studio Express Edition and also setup IIS via Windows Control Panel as I wanted to try MSSQL Server Express Edition .

Now after installing IIS, Apache Refused to start.

Only one usage of each socket address
is normally petmitted. :make_sock could not bound to address:0.0.0.0:80
no listening sockets available , shutting down
Unable to open logs

It was because there was a conflict in the port 80.

Now i went to the website properties in IIS and changed the port no to 9090 from 80.

Now restarted IIS and tried to start apache

Now similar error but diff port

Only one usage of each socket address
is normally petmitted. :make_sock could not bound to address:0.0.0.0:443
no listening sockets available , shutting down
Unable to open logs

The Solution:

Now i suspected the conflict was in the SSL port so tried digging through the XAMPP files.

found this file httpd-SSL.conf in \\apache\conf\extra\

Navigate to this line.

# When we also provide SSL we have to listen to the
# standard HTTP port (see above) and to the HTTPS port
#
# Note: Configurations that use IPv6 but not IPv4-mapped addresses need two
# Listen directives: "Listen [::]:443" and "Listen 0.0.0.0:443"
#

Listen 443

Change 443 to say some port like 4499

1 more change

# General setup for the virtual host
DocumentRoot "c:/web/xampp/htdocs"ServerName localhost:4499
ServerAdmin admin@localhost

Now IIS and Apache can run parallel. That means working with ASP and PHP at the same time.