Hassan Janjua

Finding a Truck Camper to be a happy camper

For the last two months, I am have been searching for a truck camper which will fulfill my requirements based on my lifestyle and camping needs. In this blog post, I am going to highlight some of the difficulties I have been through and maybe it will help somebody who has similar requirements or they are new to truck camping world or want to find one article which mentions it all.


I am looking for a truck camper which;

  • A low footprint (non-slide)
  • Dry bath
  • LP Generator
  • Backup camera
  • 2-way power to the air conditioner
  • 3-way power to the refrigerator
  • Keyless entry
  • Entertainment system

Believe it or not, I was not able to find a single manufacturer who has thought of the requirements mentioned above. A few days ago I was watching a YouTube, the video was about “how to choose your RV” and in the video, they mentioned that you will never RV which fulfills your requirements. You always have to compromise and I think the same applies to truck campers.

I am going to organize this blog post in 5 high-level buckets which are listed below;

  1. Truck Camper Manufactures and Dealers
    1. Will provide Website review
    2. Will provide overall information manufacturers provide on their website.
    3. Will provide best YouTube channel to find detail preview and review of their products.
  2. Truck Camper  Features and Limitations
  3. Finding the right truck for your camper
  4. Truck Camper Magazine Website Review & YouTube Channels which can help!
  5. After Market Mods and Gadgets

Truck Camper Manufactures and Dealers

In my search, I found out that actually finding a truck camper is very difficult. The difficulty starts with finding the manufactures and their dealers. I was able to find following manufactures and I am going to review them based on their website, products descriptions, and features.

Lance Camper (Made in the USA):
Website: lancecamper.com
Website Rating on the scale of 5: 4
Product Description and Features Rating on the scale of 5: 4

Lance is very popular in the truck camper world, you can easily call them leaders of this industry. Everybody knows about lance; everybody sells lance. Dealers are available in every area within the USA. Their website is very informative guide both in the truck selection and the truck camper. Depending on what you are looking for Lance has a wide range of products. But what they are lacking on their website measurements of the bath. I had to contact the manufacturer to understand what are the measurements of the dry bath and wet baths you have on your various products. Their website is up to date and modern. Lance dealership are available all over the USA. I will recommend using the following YouTube channels to find the review of their products Camping World.

Northwood (Made in Canada):
Website: northwoodmfg.com
(more to follow)

Big Foot RV (Made in Canada):
Website: bigfootrv.com
(more to follow)

NuCamp RV (Made in Canada):
Website: nucamprv.com
(more to follow)

Posted on by Hassan Janjua in Miscellaneous Leave a comment

Export vimeo album to HTML table

I have VIMEO PRO account and its very difficult sometimes to copy paste videos titles and URLs to my website. I was trying to figure out a way to extract the video information from vimeo and get the list of all my videos under my vimeo channel. If you would like to achieve same functionality you can follow the following steps:


  • Go to https://vimeo.com/organizer/collections
  • Under organizer > Create new album and organize all videos in the newly created album
  • Get Album ID and save it (if you don’t know how to get album ID you can following instruction here -https://forum.livebooks.com/livebooks/topics/what_is_my_vimeo_album_id)


  • Download PHP API Library: https://developer.vimeo.com/apis/advanced#libraries
  • From that zip, upload “vimeo.php” and “index.php” to a folder called “vimeo” on the root of your website
  • Create a folder within “vimeo” called “cache” with permissions 777.
  • URL will be: www.YOURWEBSITE.com/vimeo/


  • Login to your vimeo account, and register your website as a new “app” at http://www.vimeo.com/api/applications/new
  • Use the URL of your website as the “Application URL”. IMPORTANT: Enter the URL to the index.php you just uploaded as the “Application Callback URL”. (In my example, this would be http://www.YOURWEBSITE.com/vimeo/index.php)
  • If it’s your first time registering an app, you MAY have to wait for a human interaction to authorize the request.
  • Get your Consumer Key and Consumer Secret
  • Get YourOAuthAccessToken and YourOAuthAccessTokenSecret

Posted on by Hassan Janjua in PHP Leave a comment

Function to export query or table to MS Excel

Following function exports data from a table or query to MS Excel.

Posted on by Hassan Janjua in SQL Server, Visual Basic Leave a comment

Delete all data in the all worksheets except first row in each sheet


How to delete all data in the all worksheets except first row in each sheet?



Posted on by Hassan Janjua in Excel VBA Leave a comment

Insert values if not exist


How to INSERT values in MySQL table if they don’t exist?


Following procedure will insert values in MySQL table “PatientProcedureCompleted”; if they do it will update “chart” value.

Posted on by Hassan Janjua in MySQL Leave a comment

Autofit using Excel VBA


In excel we selected the entire worksheet and then do Format > Column -> Autofit selection and Format > Row -> Autofit

How we can do this in VBA?



Posted on by Hassan Janjua in Excel VBA Leave a comment

Delete the entire row if the certain text is present in column


How to delete the entire row if the certain text is present in column?


Following procedure will delete the entire row if the certain text is present in the column(s)

This example deletes the entire row if it finds “error” in column CD


Posted on by Hassan Janjua in Excel VBA Leave a comment

xPlore Tools

The following  in the link to some useful tools for xPlore 1.0 or 1.1:


Posted on by Hassan Janjua in Documentum, ECM Leave a comment

How to view template module positions in Joomla! 2.5?

In Joomla! 1.5.x we used to append ?tp=1 at the end of the URL (i.e. http://www.yourdomain.com/index.php?tp=1) to view the module positions of the current template. In Joomla! 2.5, its same but you need to enable “Preview Module Positions”.


Following steps will help you to enable “Preview Module Positions” option from “Template Manager Options” of Joomla! 2.5.



    • Login to Joomla! 2.5.x administrator section (i.e. http://www.yourdomain.com/administrator)
    • Click on “Extensions” > “Template Manager”
    • Under “Template Manager: Styles” click on “Options”
    • Under “Template Manager Options” > Enable “Preview Module Positions” and click on “Save and Close”
    • Under “Template Manager: Styles” click on the template icon to see the modules positions of the style you want to preview as shown in the screenshot below
    • Alternative way to view module positions is to append ?tp=1 to the end of your URL (i.e. http://www.yourdomain.com/index.php?tp=1)
When you are done previewing module positions, remember to set “Preview Module Positions” to disable. Its recommend to disable the ?tp=1 function for security reasons.
Posted on by Hassan Janjua in CMS, Joomla! Leave a comment
  • Hassan Janjua is a Sacramento, CA, USA based web designer specializing in Joomla! development. Hassan is involved in many aspects of the Joomla! and open source content management community. Hassan holds project manager postion with JoomClan.com where he is managing 3rd party Joomla! extensions like JoomRSS, JoomListings, JoomClip, and JoomDocs. Hassan has more than 8 years of experience in Mambo and Joomla!.

    Let me know what you think

    You can contact me via email button below or submit online

    Feedback Form