After being impressed working with DotNetNuke at Hempfield on their new website before I left. I have decided that bringing it to Memorial Hospital would be a project that would get the thumbs up.
I was given a project to somehow collect all the contact information (e-mails, home/cell phones) of our hospital physicians, administrators and staff to cross check with our payroll database. The idea is for us to get the correct information to create an “alert now” type of directive that will allow us to get information or a message to the staff in need of an emergency.
Originally I was asked to learn Visual Basic and write a windows application that would basically be a “contact form”. After spending about 4 days learning about SQL databases and learning a bit of Visual Basic I started building. The database part was easy enough in SQL but the windows application was a bit tricky for me since I was trying to get the “submit” button to actually insert the data that was filled in each text field into the SQL database. I was so close and I know its a few minor modifications away from actually working however, I was on a tight timeline.
I finally spent an evening thinking about other ways this could be done and it finally hit me…. I knew that DotNetNuke already had a “registration form” that would you could fill out and submit data into a SQL database so I did some researching and I found a custom module that allowed me to make a custom for of my choosing and link it to a table in the database.
So with that I got permission to try DotNetNuke before we contracted this project out to someone outside of the hospital. It took a few tries to get it installed due to some hardware and software issues but then finally, third times a charm and I got it installed on the third server I tried. (with Mike Grahams help of course).
Once it was installed and the portal was running it was about another hour until I got the form module installed and had the custom form built. It wasn’t perfect yet it was usable and I got the “looks good” from the boss.
This weekend I found a DNN skin that would fit well to the hospital (color,theme,layout) with some slight adjusting the skin fits well to the website that the hospital already has.
Hopefully I can get the hospital to use DNN for more than just gathering staff contact information. Maybe i’ll wait to see how well this will work and how well this is gonna be received before I mention that we can use this to replace the intranet we already have.