Co-op 2 Highlights 11

This week has been filled with web updates, including some live database updates for our sister organization’s website.  This included uploading Powerpoint presentations through Cloudberry and linking them on the web page for a weekly class and updating another web page with new data.  One of things that has been consistently reinforced for my over the past 6 months, but also over the past 8 years or so, is that web content absolutely needs to be current and that a person’s first impression of your organization (including their decision to do business with you or not) sometimes comes down to a single visit to your website.  With poor or outdated content, all the flash, shock, and awe of great web design is not going to mean squat.  I visited a website recently and the most current news information they had posted was from 2011.  That either means they haven’t done anything newsworthy in the last 3 years or no one has updated their website.

Another item I’ve been working on over the last week or so has been using jquery to formulate a datepicker option on my attendance recording project (my capstone).  The more I work with jquery, the more I like it.  I used this article to gather more information about how to get things set up and I was so pleased to see it actually work!  This article contains a lot of good information on how to configure your bundles, what bundles do, and even provided a few other links to additional information.  Very helpful and so exciting to see my project developing further and taking shape.

Along the jquery path, I also needed to find a way to generate charts or graphic representations of attendance data on my Reports page.  I found a great open source option call jqplot and a really informative step-by-step guide on how to implement it in my MVC project.  After downloading the source code, I saved it in my Scripts folder in a sub-folder called jqplot.  I also modified my Bundles.config file to handle this set of jquery options and then included this bundle in my _Layout.cshtml file.  I am still configuring things, so I have not been able to test this part yet.  This could revolutionize how our organization currently looks at attendance data, so I’m hopeful and cautiously optimistic.

I’ve also been researching using a combination of MVC and Web Forms on my project and found this article that talks about how the two can coexist in a single project.  It seems like this MVC vs. Web Forms is a popular topic, possibly even hotly debated around the C# .NET water cooler.  I’m pretty new to both, having started out with Web Forms last year and now am working on an MVC project, so I think I’m maybe more open-minded to using either or both just because I haven’t developed a favorite yet.  The way I see it, Web Forms is the older and maybe more widely used format.  MVC came along and provides some great scalability, allowing you to write a piece of code once, instead of repeating the same thing multiple times (like configuring your data source).  It feels like there is more MVC can do to bridge the gap though, and I’m curious to see future developments of it.

If I was going to explain it to someone, I would say that Web Forms is like a toolbox, full of great tools, but all of specific use and size.  MVC is similar to that same toolbox, but it contains blueprints to build the tools and adjust them for different uses and sizes.  I could be totally wrong, but that’s how I am interpreting what I’ve read to this point.

Co-op 2 Highlights 10

My focus over this past week has been making updates to our sister organization’s website, adding links to Google form surveys and uploading Powerpoint training presentations through Cloudberry to link to on the web page.  I created a simple table to hold weeks 1 – 6 with another column for the training and survey links.  It was interesting because the person requesting this update was so pleased that I put it in some sort of order, which was such an easy thing to do.  Another update last week concerned staff as there was a recent turnover.  This website has limited connectivity to our MySQL database, so our staff web page is static.  When someone leaves, it requires a manual update to the web page taking out the former staff person’s name and adding in the new temporary person’s name.  There is also a big event coming up in May, the Hunger Walk in Cincinnati, and our organization uses this event as a major fundraiser for food dollars for the year.  At the core of that is project management, communications, registrations, print pieces, social media marketing, coordinating with the Freestore Foodbank, working with the project team to bring completion to items under deadline, and updating the web page.  That has been a focus this week also.  Although the social media and web page updates are only part of this project, I do feel that project management overall is a valuable tool to have in one’s toolbox.  There is a need to be able to work under deadline, sketch out the overall goal, and fill in all of the details that need to happen in order to meet the goal.

I came across a new term this week, parallax web design, and wanted to investigate this a little further.  This web page from AWWWARDS gives a great overview of what parallax web design is and provides links to good examples.  Parallax design is based on the old-school video games (think old Super Mario Brothers) that scroll along with links or anchors to different sections of the large page, instead of chopping the website up into small individual pages.  I’d be curious to know the pros and cons of this design and how or why it seems to be trending now.  This article was from October 2013, so it’s not terribly old.  It would be curious to see how popular this trend becomes.

There is more work to do on VARI, my attendance reporting project, and I am meeting with my Capstone professor tonight to clarify a couple of items.  It has morphed a little from my original design and scope, but I think it will still be a very helpful tool, if my organization decides to use it.

 

Co-op 2 Highlights 9

Happy 25th Anniversary to the web this week!  I saw this article on Google and wanted to mention it here.  The web is something many of us take for granted nowadays, and Sir Tim Berners-Lee asks some really great questions about the future.  This website, http://www.webat25.org/, talks in-depth about the past, present, and most importantly, the future of the web.  The top 3 questions asked by Sir Tim Berners-Lee are:

  • How do we connect the nearly two-thirds of the planet who can’t yet access the Web?
  • Who has the right to collect and use our personal data, for what purpose and under what rules?
  • How do we create a high-performance open architecture that will run on any device, rather than fall back into proprietary alternatives?

Great questions, with no easy answers.

Earlier this week I’ve been working on VARI, my capstone project.  I have more research to do regarding the Data Access Layer (DAL) and the Business Logic Layer (BLL).  I’ve found some great information here to read through and hope that I can build my Data Access Layer correctly to be able to communicate with my database.  I’ve also worked on building my database and transferring the raw attendance data into it.  There is much more to do, and I hope to make some good progress on this on Sunday this week.

 

Co-op 2 Highlights 7

Week 7 has just finished up and I wanted to show a little of the progress on my current Capstone project – VARI.  VARI stands for Vineyard Attendance Reporting Index.  That name may change, but I wanted to be able to call it something while I am working on it.  Here is a screen shot of the current home page for the application:

Image

It’s been a week of ups and downs.  A major domain migration messed with my SQL Server settings (the name of my computer changed, so SQL couldn’t find the server anymore, even though it was still physically right there on the same computer – at least that’s how I understand it), and I have uninstalled and reinstalled SQL at least 6-7 times in the last few week, with no good results.  😦  From talking with our IT department, I have figured out that even though I uninstalled SQL, it still maintained some registry key history, so a new server name could not be identified (even with a new install, it was still looking for the old computer name, pre-domain-migration).  I finally have resolved to create my database in MS Access as close as I can to the original SQL database that I had created because I feel like I should be making some solid progress on this project (as it is already week 7!).  Down the road, if the project (VARI) proves to be valuable, then it can be migrated to a SQL database or even into the proprietary MySQL database, if desired.  I am patterning the tables as close as I can to the MySQL tables and even exporting a copy of the data from the tables I have copied, so hopefully that would happen easily.  However, it should also be fine as a stand-alone application.

I am also building VARI under the MVC model, so I am learning a ton as I go along, but this also is causing the project to move along at a much slower pace.

Our sister organization’s website is being remodeled and the wireframes are going to be reviewed at a meeting tonight.  Once the group reviews and determines to go ahead with a design choice, then I believe I will be more involved in this project in helping to transfer current web information over to the new format.  It will be interesting to hear everyone’s thoughts.  One thing I have learned in all my website work over the years is that people want really great websites, but don’t necessarily want to put the time into writing really great content (with the end user in mind, of course).  I have seen this with Facebook recently too.  There is a sub-group under our sister organization that has a FB page and wants to build followers.  After providing some tips and suggestions for doing this, I received a request about a month later from the director to see if I can ‘help.’