CTS – Your Technology Partner

Export MVC WebGrid to Excel (CSV)

Written by Craig Butler on December 6, 2012

By: Scott Murphy Overview Have you ever needed to export a WebGrid to Excel? In this article I will explain the steps needed to export the contents of a MVC WebGrid to Excel (CSV). The only prerequisite is that your input be IEnumerable<T>. The first step is to create your Util or Helper methods that…

Continue Reading


Testing Techniques – Equivalence Partitioning and Boundary Values

Written by Craig Butler on December 6, 2012

By: Vicky Davis Conventional wisdom dictates that it is not possible to test all possible inputs when testing a software application. For instance, in the following pseudo code an infinite number of inputs can be used to test if “something” or “something else” happens. This Equivalence Partitioning technique helps reduce the number of total tests…

Continue Reading


Testing Metrics – Requirements Pass Rate

Written by Craig Butler on December 6, 2012

By: Vicky Davis The Requirements Pass Rate metric is one of several metrics that provide insight to the quality of a software solution. This metric indicates the status of test execution and the quality of the solution based on percentage of requirements passed. To obtain the values for the formula the tester must associate each…

Continue Reading


Don’t Take One From Max

Written by Craig Butler on December 6, 2012

By: William King In .NET, the Random object’s “Next(int min, int max)” method returns a random number between the two provided values. It is critical to note that the min parameter is inclusive but the max parameter is exclusive. This means that if you have an array of numbers like so: int[] numbers = new…

Continue Reading


History of QC Tickets Assigned to a Developer

Written by Craig Butler on December 6, 2012

By: Jonathan Powell I was recently asked by my Technical Lead to supply some information about each of the QC tickets I had worked on for a project. This included tickets currently in my queue, as well as tickets I had assigned back to QA Engineers for retesting. I needed a quick way to get…

Continue Reading


@font-face and Web Font Freedom

Written by Craig Butler on December 6, 2012

By: Jake Beaton If you’ve ever developed a website, you’re likely familiar with the concept of web safe fonts. Due to the way fonts are rendered in browsers, designers and developers have been limited to the fonts installed on user’s machines for most of the web’s history. This is what led to the notion of…

Continue Reading


PowerPivot for SharePoint 2010

Written by Craig Butler on December 6, 2012

By Tim Rooks PowerPivot is the self-checkout aisle of business intelligence. Install the free PowerPivot add-in for Excel 2010 and you can import, tabulate, summarize, and otherwise slice and dice data from multiple external sources, and you don’t need a separate BI engine like SQL Server Analysis Services. Develop data models, complex calculations, and create…

Continue Reading


Mobile Application Testing

Written by Craig Butler on December 6, 2012

By: Matthew Seese Twelve years ago, the world was catching it’s breath after the fears of a “Y2K freak-out” subsided. A lot of people were focused on the older machines that ran the world and what the implications would be if they suddenly stopped working. A few folks, myself included, were looking towards the future….

Continue Reading


Reading Informatica Developer Client File Sources

Written by Craig Butler on December 6, 2012

By: Kaiesha Ford In the Informatica Developer client, there are two ways to read a file in a data object: direct and indirect. 1) Direct is used for loading one single file. 2) Indirect is used for wanting to load multiple files. For example, in the screenshot below, I have 7 files that I want…

Continue Reading


Document Monitoring in SharePoint 2010

Written by Craig Butler on December 6, 2012

By: Simon Williams SharePoint document libraries can be used to contain related folders and documents. Recently, I was gathering information from an Access database stored in a SharePoint project documents library. The database was updated frequently and not on a fixed schedule; continually checking the Modified Date to ensure I was working with the latest…

Continue Reading