Clean Up a Column of Mixed Date Formats Tool

December 12th, 2010

A few times a year, a client of our will need our help in cleaning up a manually populated Excel file that has a couple of date columns. Invariably, there is a hodge-podge of date entries, such as 2010-10-05;  june 10, 2010; or 8/4/2008.  We’ve finally made a tool to fix up the bulk of this so that Excel will detect it properly as a date value.

Perceptus introduces the  Clean and convert a column of dates in Excel Numbers Wizard, on the Perceptus Web Tools mini-site.

We hope this tool saves some people besides ourselves some time.

 

Google Chrome Built-in PDF Viewer Incompatibility with IFRAME and a Workaround

December 11th, 2010

With the recent automatic upgrade of Google Chrome to version 8, Google made their built in PDF viewer the default viewer *.  I.e. there is now no need to separately download Adobe Reader or Adobe Flash Player to browse the web with Google Chrome.

Generally, I like this addition to Google Chrome; however, it caused some work for us.  Our web based bingo card generator, print-bingo.com, is highly dependent on PDF’s.  That’s the sole reason why our bingo cards are dead-easy to print out by the hundreds.  Unfortunately, Chrome’s built-in PDF renderer does not display PDFs that are in an IFRAME tag properly.

For the last few days, this is what users of print-bingo.com would see after generating 5 pages of bingo cards on print-bingo.com:

 

Broken PDF rendering in an IFRAME in Google Chrome 8 - screenshot from print-bingo.com

Broken PDF rendering in an IFRAME in Google Chrome 8 - screenshot from print-bingo.com

Chrome tries to scale the parent page to fit everything in… and it fails badly.

We were not able to get things working 100% the way we would like, but we have a workable situation now.

The basic steps that we had to take:

  • Change from IFRAME to OBJECT tag.  For whatever reason, this fixes the zooming issue.  And it was quite simple.  In our case, there wasn’t much difference between the two HTML tags.
  • Unfortunately, we can’t find a way to get Chrome to print the contents of the object tag without printing the rest of the page (though, perhaps using CSS  might work).
  • Instead, we added some bold warning text that gives Chrome users instructions to use the manual download links. We use a little function to identify Chrome users – the two key lines of code are: 
    $u_agent = $_SERVER[‘HTTP_USER_AGENT’]; 
    if(preg_match(‘/Chrome/i’,$u_agent)) { $ub = “Chrome”; }

So, we ended up with a workaround.  We sincerely hope that Google will add the missing interface elements that will make things just work, but until then, we are doing some other site improvements as we prepare to bump up the price of Premium Access to $12 in 2011.

* If you want to go back to using Adobe Reader in Google Chrome, you can turn off the  built-in viewer by going to the special address about:plugins and change Chrome PDF Viewer to Disable.  Of course, website owners should not depend on end-users to do this just to visit your site!

 

 

Canada.com Email is Shutting Down… it’s a good time to move to a vanity domain.

November 30th, 2010

I was mildly surprised when a relative mentioned to me that her free Canada.com email address was being shut down.  She’s had that email address for years – though, I know she hasn’t been using it for day-to-day email for most of that time.

For those individuals who are actively using their Canada.com email addresses still, here are a few suggestions from us at Perceptus:

  • Do NOT move to the email provided by your internet service provider.  Choose one of the major webmail providers such as Hotmail.com, Gmail.com or Yahoo.com – these services are all well run, and more importantly, they will probably be around for a long, long time.  Of these three, I recommend Google’s Gmail.com service.  I’ve written about this in a previous post: Picking an Email Address – Don’t use a Free Account from your ISP.
  • This is a great excuse to move to a vanity domain.  It’s cheap.  You can buy the rights to a .com domain for <$10 per year and have Google host the email for you.  If you have a few family members or friends, you can share a domain.  We use Google’s Apps for Domains  for all email to perceptus.ca – it’s excellent.
  • You do not have to lose your saved Canada.com email.  Read their own migration instructions here.  You can move your email to Google’s Gmail service easily.  These instructions can be adapted for all other major web email providers, and also, to download your email using POP3 to your own computer to software like Outlook or Thunderbird.
  • Remember to update all of your 3rd party logins.  eBay, PayPal.com, Amazon, everything.  You will not have an easy time getting access to your accounts once canada.com webmail goes offline.
  • Do this ASAP.  Canada.com really did a disservice to their users by providing such a small amount of notice.

I wonder if the email being shut down is related to the recent change in ownership of the site’s publisher, Postmedia Network Inc.  Seriously, couldn’t they find a way to make a buck on this by partnering with a 3rd party webmail provider and sharing ad revenue, rather than shutting it down?

Comments are encouraged.

Harry Potter Bingo Cards

November 19th, 2010

We finally decided to create a Harry Potter word list for our Harry Potter themed Bingo cards for print-bingo.com.  Check it out now!  You can play your customized bingo game while you wait in line to see the movie!

Entry level access to our web based bingo card generator is free!  An upgrade of $10 will get you a few extra features.

Turkey Bingo Time!

November 19th, 2010

Happy Thanksgiving to our American viewers. We hope that your turkey is especially tasty this year!

If you are looking for a way to spend some family time before or after the turkey has been served, we suggest Thanksgiving themed bingo cards. You’ll find that Thanksgiving word list, and many more,  at print-bingo.com.  Basic use our site is free – including customizing the cards!

Of course, for a small upgrade cost of $10, you get access to a few more features.  If you’ve used our site in the past, and are debating an upgrade – we strongly suggest that you do it soon.  We will be raising the price to $12 within a few months.