Check out my new project http://ow.ly/4rHEF
Starting a software business in Malaysia has been a good experience, says JeeShen Lee from BizVise
Interviewing serial entrepreneur JeeShen Lee in Malacca Malaysia (or Melaka) has shown me one thing: starting a tech company in a small industrial town requires lots of courage and determination. JeeShen has started a software solutions company called BizVise, and is looking to disrupt the hotel business in South-East Asia with a second company called mySoftinn.
JeeShen Lee met his partners and many of his clients through his involvement with…
got interviewed by Yvan, a two-time entrepreneur from Canada. He is currently traveling around the world meeting real entrepreneurs and blog about their stories. Make sure you check out his blog if you plan to be an entrepreneur, i'm sure you can learn from all the entrepreneurs he met and blog. ;) Here's the link of his blog - EntrepreneurshipForTheWorld - Beyong the Valey, http://entrepreneurshipfortheworld.com
JMC Excel Split – Split excel worksheets into separate workbooks.
This tool helps splitting multiple excel sheets and save each of them as an independent file. It was created following a feature request in another tool that I created – JMC Excel.
If you have many excel sheets created in multiple excel files and wanted to save each of them separately as workbook (or independent .xlsx file), JMC Excel Split will come in very handy.
Below is the download link to the trial version (which can split up to 5 files and 5 sheets each).
JMC Excel Split Download Link
Want to thank me? Buy me a coffee. Paypal Donation of any amount is welcome.
Remove limitation by Buying JMC Excel Split at USD 7 only. Contact jeeshenlee@gmail.com.
2010 in review by WordPress.com
Happy New Year! Check the review of my blog (www.jeeshenlee.wordpress.com) by WordPress below, I was rates “Wow!”
The stats helper monkeys at WordPress.com mulled over how this blog did in 2010, and here’s a high level summary of its overall blog health:
The Blog-Health-o-Meter™ reads Wow.
Crunchy numbers
The average container ship can carry about 4,500 containers. This blog was viewed about 14,000 times in 2010. If each view were a shipping container, your blog would have filled about 3 fully loaded ships.
In 2010, there were 16 new posts, not bad for the first year! There were 102 pictures uploaded, taking up a total of 3mb. That’s about 2 pictures per week.
The busiest day of the year was November 19th with 215 views. The most popular post that day was Eclipse: Failed to create Java Virtual Machine.
Where did they come from?
The top referring sites in 2010 were eclipse.org, stackoverflow.com, mrexcel.com, serverfault.com, and forums.asp.net.
Some visitors came searching, mostly for immigration malaysia blacklist, eclipse failed to create the java virtual machine, jmc excel, eclipse failed to create java virtual machine, and failed to create java virtual machine eclipse.
Attractions in 2010
These are the posts and pages that got the most views in 2010.
1
Eclipse: Failed to create Java Virtual Machine September 2010
20 comments and 1 Like on WordPress.com,
2
JMC Excel – Join, Merge, Combine multiple Excel sheets or Excel workbooks September 2010
23 comments and 1 Like on WordPress.com,
3
How to GZip on ASP.NET and GoDaddy August 2010
15 comments and 2 Likes on WordPress.com
4
How to add expires headers in ASP.NET July 2010
5 comments and 1 Like on WordPress.com,
5
myNotes February 2010
How to setup DotNetNuke on GoDaddy.
Below is the step by step guide to install DotNetNuke on GoDaddy.
1. Login to your GoDaddy account and browse to GoDaddy Hosting Connection® (the Application Management Page).
2. Search/Find DotNetNuke in the Content Management Category.
3. Click Install and follow the installation wizard. You will need to choose/fill up:
- Domain name.
- Database name and password.
- Installation directory. Note: I normally create a directory for each domains and install DNN to the domain’s directory.
- Super-user name and password.
- Admin user name and password.
4. Wait for the installation to take place. It normally takes about 30 minutes to install, you can check the status at your GoDaddy Hosting Connection.
5. Browse to your domain and follow through the installation wizard (Yes, you need to go through another installation to fully deploy your DotNetNuke. 
). In case you bumped into “Error 500” like me, don’t worry; please follow the instruction below. Otherwise, skip to Step 12.
6. If you bump into “Error 500” like me, we have to make some minor changes in the web.config file.
7. Use FTP tool (like FileZilla) to download your web.config file and turn on “CustomError” configuration in your web.config file. Read another post written by me on “How to turn on CustomError”.
8. Surf to your domain again; if you did Step 7 correctly, you should be able to view the details of the error (like the sample below).
9. Let’s try to debug these errors one at a time. The errors are normally generated by IIS because of “… duplicate collection entry of type ‘add’ with unique key attribute ‘name’…”.
10. So, add a ‘remove’ tag before the ‘add’ tag will normally helps. Take for example the error above (Config Error: Cannot add duplicate collection entry of type ‘add’ … set to ‘ScriptHandlerFactory’.) can be fix by:
<system.webServer> <handlers> <remove name="ScriptHandlerFactory" /> <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" /> </handlers> </system.webServer>
11. Re-upload the latest web.config to your domain’s directory and re-refresh (Ctrl+F5) your website. Repeat Steps 9 & 10 until you clear all the errors. Below is my web.cofig to remove all the errors.
<system.webServer> <asp scriptErrorSentToBrowser="true"/> <httpErrors errorMode="Detailed"/> <modules> <remove name="ScriptModule"/> <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" preCondition="managedHandler" /> <add name="Compression" type="DotNetNuke.HttpModules.Compression.CompressionModule, DotNetNuke.HttpModules" preCondition="managedHandler" /> <add name="RequestFilter" type="DotNetNuke.HttpModules.RequestFilter.RequestFilterModule, DotNetNuke.HttpModules" preCondition="managedHandler" /> <add name="UrlRewrite" type="DotNetNuke.HttpModules.UrlRewriteModule, DotNetNuke.HttpModules" preCondition="managedHandler" /> <add name="Exception" type="DotNetNuke.HttpModules.Exceptions.ExceptionModule, DotNetNuke.HttpModules" preCondition="managedHandler" /> <add name="UsersOnline" type="DotNetNuke.HttpModules.UsersOnline.UsersOnlineModule, DotNetNuke.HttpModules" preCondition="managedHandler" /> <add name="DNNMembership" type="DotNetNuke.HttpModules.Membership.MembershipModule, DotNetNuke.HttpModules" preCondition="managedHandler" /> <add name="Personalization" type="DotNetNuke.HttpModules.Personalization.PersonalizationModule, DotNetNuke.HttpModules" preCondition="managedHandler" /> <add name="Analytics" type="DotNetNuke.HttpModules.Analytics.AnalyticsModule, DotNetNuke.HttpModules" preCondition="managedHandler" /> <add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule, Telerik.Web.UI" preCondition="managedHandler" /> </modules> <handlers> <remove name="WebServiceHandlerFactory-Integrated" /> <remove name="ScriptHandlerFactory" /> <remove name="ScriptHandlerFactoryAppServices" /> <remove name="ScriptResource" /> <add name="LogoffHandler*" path="Logoff.aspx" verb="*" type="DotNetNuke.Services.Authentication.LogOffHandler, DotNetNuke" preCondition="integratedMode,runtimeVersionv2.0" /> <add name="RSSHandler" path="RSS.aspx" verb="*" type="DotNetNuke.Services.Syndication.RssHandler, DotNetNuke" preCondition="integratedMode,runtimeVersionv2.0" /> <add name="LinkClickHandler" path="LinkClick.aspx" verb="*" type="DotNetNuke.Services.FileSystem.FileServerHandler, DotNetNuke" preCondition="integratedMode,runtimeVersionv2.0" /> <add name="CaptchaHandler" path="*.captcha.aspx" verb="*" type="DotNetNuke.UI.WebControls.CaptchaHandler, DotNetNuke" preCondition="integratedMode,runtimeVersionv2.0" /> <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" /> <add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" /> <add name="ScriptResource" verb="GET,HEAD" path="ScriptResource.axd" preCondition="integratedMode" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" /> <add name="Telerik.Web.UI.WebResource" verb="*" path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource, Telerik.Web.UI" /> <add name="Telerik.Web.UI.ChartHttpHandler" path="ChartImage.axd" verb="*" type="Telerik.Web.UI.ChartHttpHandler, Telerik.Web.UI, Culture=neutral, PublicKeyToken=121fae78165ba3d4" /> <add name="UserProfilePageHandler" path="User.aspx" verb="*" type="DotNetNuke.Services.UserProfile.UserProfilePageHandler, DotNetNuke" preCondition="integratedMode,runtimeVersionv2.0" /> <add name="HtmTemplateFileHandler" verb="*" path="*.htmtemplate" type="DotNetNuke.HtmlEditor.TelerikEditorProvider.HtmTemplateFileHandler, DotNetNuke.HtmlEditor.TelerikEditorProvider" preCondition="integratedMode" /> </handlers> <validation validateIntegratedModeConfiguration="false" /> </system.webServer>
12. Follow through the installation wizard to fully deploy your DotNetNuke.
13. Below is the summary of what I did/choose in the installation wizard.
- Typical installation.
- SQL Server 2005/2008 Database.
- Copy the given Database Name, Database Server Path and set the Database password (Note: Please use the same password set in Step 3).
- Setup the Super User account.
- Setup the Admin/WebMaster account.
14. Ta-Daa~! Your DotNetNuke powered website is now online. Thanks! Good luck in WorldWideWeb!
I don’t get paid for writing blog posts. Your “Votes” and “Like” is my only motivation, so please “Like” it if you found this information useful. Cheers!!! Check out what other says about this post by clicking at the title of this post. Wondering what I’m up to recently? Check out mySoftinn.com
How to show the details of Error 500 on web server.
I run into Error 500 quite often while deploying web applications to web host server. While it’s good to provide a clean, nicely layout page to address the visitors upon error, but this page does not help developer in solving the problem.
To dive into the root of the problem and view the source of the error, we need turn on the “scriptErrorSentToBrowser". Paste the web.config code below to show the details of Error 500 and find out the root cause of your error. In case your web application is hosted in sub-domain or not in the root directory, paste also the web.config code above in the root directory.
1 <system.webServer> 2 <asp scriptErrorSentToBrowser="true"/> 3 <httpErrors errorMode="Detailed"/> 4 </system.webServer>
Happy debugging and Good Luck!
I don’t get paid for writing blog posts. Your “Votes” and “Like” is my only motivation, so please “Like” it if you found this information useful. Cheers!!! Check out what other says about this post by clicking at the title of this post. Wondering what I’m up to recently? Check out mySoftinn.com
10 Good/Bad/Weird things people thinks about me.
Find 10 good, bad, or weird things about me. To all my friends out there, I’m listening on what you have to say about me; so SHOUT it out LOUD~ here! This must be fun!
Have a known fact about me? Shout it in the comments area. No moderation.
I don’t get paid for writing blog posts. Your “Votes” and “Like” is my only motivation, so please “Like” it if you found this information useful. Cheers!!! Check out what other says about this post by clicking at the title of this post. Wondering what I’m up to recently? Check out mySoftinn.com
