Tag Archives: Database Maintenance

25Oct/12

Mercy Medical Center – Nampa, ID

Mercy Hospital in Nampa Idaho is a client of BBG Marketing.  Mercy wanted a calendar created for their website so they could input events and have them come up in order with certain details, like time, duration and location.  At the time there just weren’t any open source applications to install, so I wrote them custom application to suit their needs.  It was pretty cool.  They could add, edit and duplicate events with a few clicks and they would display through the day of the event, then disappear.  

Mercy Hospital - Nampa Idaho - Custom Calendar

For the events that recurred every week, the calendar would display the single event with multiple dates, but as the date passed, it would disappear leaving the rest of the dates for that month.  Seems simple, but it was quite the ordeal.

I always liked working for Mercy Nampa.  A couple years ago their parent corporation, or whatever you call the big group a hospital belongs to, changed hands and the new company had internal web guys.  They had me help with the transition and even had me take care of a few things before the final change, but I haven’t worked on their stuff in a while now.  I’ll have to check out the current site.  See if it’s as good as the work I did.  🙂

14Oct/12

Goin’ Postal – Roseburg Oregon

Goin’ Postal and Copy Copy Shop is a locally owned franchise that does everything shipping related, like packing your packages, sending it by the best carrier, holding your mail, renting post office boxes…  All that stuff.  Copy Copy Shop, obviously, is a copy shop.  Color copies, zillions of them?  No problem.

One pretty cool thing I did custom for them was adding a Google search bar that you can paste any tracking number from any carrier into and Google will sort out who the carrier is and show you where it’s at.  Oh, two cool things.  The icons on the bottom of the picture have a hover over action.  When your mouse goes over them, a tool-tip-like window pops up telling you about the service you’re hovering over.  Pretty slick.

I also gave them custom email addresses that customers can send documents to be printed.  Nothing amazing there, but some of those documents can be HUGE.  My server handles it no problem and I was able to give him a disk quota big enough to not run out of space after a few of those HUGE files.

If you need to ship your Christmas gifts, or anything really, I highly recommend Dave at Goin’ Postal.  He’s local and he’ll do a good job for you at a fair price.  Much better than the UPS Store.  None of the money you give them stays local.  That’s bad.

09Oct/12

Atrio Health Plans – Database Work

Atrio was a client of BBG Marketing, a local company I do a lot of maintenance and back end coding work for.  They came to me with Atrio because the database was having some issues and they needed to be able to get the drug information for their plans to display properly on their website.  Every month I would receive a couple monster text files that needed to be imported into their MySQL database.  Once the initial coding was done it was pretty easy.  Just a matter of backing up the database, blanking it out, then importing the new text files.

Atrio Healthplans - Custom Prior Authorization Drug Info database

Atrio had a change of leadership a couple years ago and started using a different company to do their website.  It’s ugly as hell now, and not cross browser compatible.  Good thing I’m not looking for a Medicare Supplement plan.  I can’t see their contact info in their header because I’m on a Mac.  Pretty sloppy.

Don’t let your website only be seen properly by people on one browser, or one kind of computer.  Cross browser compatibility is important these days.  More and more people are on Macs.  Even more are finally tired of Internet Explorer and all its problems and are using Chrome, or Firefox, or even Opera.  You need someone who tests cross platform and with multiple browsers to make sure your website is usable by all the people who want to give you money.