SOFTWARE REVIEW:

Web-Based Client Survey and Data Analysis: A Review of Message Parse

by Haiwang Yuan, haiwang.yuan@wku.edu 

We want to conduct a web-based survey, but....
It is easy to create a survey web form and get dozens, if not hundreds, of responses from patrons. To process the results piling up in one’s e-mail inbox for analysis, however, is a daunting task. Do not get me wrong.  I am fully aware that one can always find among one’s librarian colleagues experts on attitude measurements who understand means and standard deviations.  The question is this: how in the world can one convert the raw data from the web form sent back via e-mail to a file usable by analysis software such as SPSS without keying in the data, character by character?

One thinks one is out of luck unless one is budgeted for an expensive online survey service or a programmer who charges by the line. Incidentally, a small computer program may require thousands of lines of code. Wrong. One does not have to pray for a miraculous someone or something that can do the dirty job of data entry quickly, neatly, and cheaply. With Message Parse, there is no need to look elsewhere.

What is Message Parse?
Message Parse is a web utility program created by Cypress Technologies for extracting common data from the results of web forms sent through e-mail and for converting the extracted data to formats usable by applications such as MS Excel and SPSS for data analysis.  One only needs to install the software, set up the templates (otherwise called user defined output files) to fit one’s needs. Everything else is done automatically. Message Parse is capable of filtering selected messages and searching for specific keywords and phrases. Its user-friendly interface “makes it easy to create templates that define how to get and store the information you want” (Cypress Technologies). Learning how to create the templates is a matter of reading the Help file while experimenting with the program for a few hours. Don’t have the time to learn before you need to do the analysis? No problem! At the time of purchase, Cypress Technologies, producer of Message Parse, offers to help its customers set up their first template free! Figure 1 is a flow chart that describes the process of how Message Parse converts web form data to an exportable text file using the templates.

Can we do the analysis ourselves? 
Before proceeding to analyze one’s data, one needs to decide how sophisticated one wants the report to be. To get numbers, percentages, means and standard deviations, it is not necessary to spend big bucks for a top-flight analysis software package. Most libraries have a copy of either MS Excel or Lotus 1-2-3. Believe it or not, that is all one needs. Figure 2 illustrates how the text file Message Parse produces can be imported into MS Excel for analysis.

How did Western Kentucky University Libraries conduct web-based surveys?
After a committee created the web-based survey form (located at <www.wku.edu/Library/LibSurvey/libsurvey.htm>), 
we downloaded the trial version of Message Parse and put it to the real-life test through two pilot surveys. Each ran for a week, from November 29, through December 12, 1998. We dubbed the first of the surveys “Passive,” as we did nothing more than add an icon to the WKU Libraries homepage <http://www.wku.edu/Library> linking to the survey form. The second one was “Active” because we required our patrons to decide if they would like to do the survey before they could access the library’s homepage. The effect of these two approaches dramatically affected the number of patrons who took the surveys. Our first regular web-based Library Satisfaction Survey was conducted “actively” and successfully during National Library Week, April 12-18, 1999.  The impact of the pilot and regular surveys is, of course, beyond the scope of our discussion about Message Parse.  The point is that if Message Parse worked for us, it will work for you.  Test the trial version in a real-life situation before your purchase.
 

How can we get Message Parse?
Cypress Technologies can be accessed at <http://www.cypressnet.com>. The Message Parse utility can be found at <http://www.cypressnet.com/Products/msgparse/msgparse.htm>.  A trial version of Message Parse for Win95/NT4.0 can be downloaded at  <http://www.cypressnet.com/Download/Download.htm> and will expire in 30 days. At the time of purchase, one will get the latest version. Pricing is scaled downwards from $79.95 depending on the number of users.

Haiwang Yuan, a member of the LIRT Computer Applications Committee, is Assistant Professor, Web Site & Virtual Library Coordinator at the Western Kentucky University Libraries & Museum.


LIRT News, June 1999. Volume 21, number 4.
To report problems, please contact the LIRT News Production editor at edwards@ufl.edu

    WELCOME  BACK ISSUES