Export ASCII Files

  Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic! Mail us feedback on this topic!  

 

This procedure allows you to export raw ComQuest results as ASCII comma-delimited or fixed-length flat files.  These files can then be imported into Microsoft Excel or Lotus 123, etc. to create your own custom reports, graphs and browse lists.

 

ExportASCII

Export ASCII Files screen

 

First, select the start and end date range for the data you wish to output.  Also, select whether you want the data to be formatted as Fixed length (each field is a uniform length, record to record) or Comma delimited (each field in each record is separated by a comma). You may also choose to Use Completes Only by checking this option.  Otherwise, all data from any respondents during the date range you specify will be output.

 

There are two files created, in the C:\ComQuest folder of the computer from which this procedure is run (or individual data directories, if you have multiple folders on your Fileserver); XXXSong.txt and XXX.txt (where XXX is the name of each Quota tier in your system). For example, if you have two tiers in ComQuest, WAAA and WBBB, you will see text files created named WAAASong.txt, WAAA.txt, WBBBSong.txt and WBBB.txt.

 

In addition, a PK-ZIP file of the two text files will be created; in this case WAAA.ZIP (containing WAAASong.txt and WAAA.txt), and WBBB.ZIP (containing WBBBSong.txt and WBBB.txt). This makes it easy to copy/move the two text files, without them getting separated from each other.

 

Here is what each file contains. The XXXSong.txt file contains a legend for each of the data elements contained in the XXX.txt file, as well as a list of the songs, in the order in which the scores are listed in the XXX.txt folder.  You must have (and use) this XXXSong.txt file to make sense of the raw data contained in the XXX.txt file.  Each week, the song order will most likely be different, and only the XXXSong.txt file, with the same date and timestamps as the XXX.txt file can be used!  (The order of the songs is actually somewhat arbitrary; ComQuest creates the order based on the scores of the first respondent from the first day you are outputting, so it will most probably not match your actual test list order).

 

HandOnly use the XXXSong.txt file with the linked XXX.txt file that has the same date and timestamps!

 

Here's a screen shot of the contents of the XXXSong.txt file:

 

ASCIIOut

Printed song text file

 

You should print the XXXSong.txt file.  It will help when you're creating your Excel template, if you have the field location for each data element handy.  Also, while this file is open, you can then cut and paste the list of song titles and artists to your Excel worksheet.

 

The actual raw data is written to the XXX.txt file.  Here's a screen shot of some sample raw data from that file:

 

ASCIIScores

Printed data text file

 

Notice the data in this file is in the exact same order as detailed in the XXXSong.txt file; first the respondent ID number, followed by the Demo Group, Gender, Ethnicity, etc. When you create these output files, you can choose whether to output them as comma-delimited or fixed-length; in the screen shot above, we have chosen fixed-length; thus each field is separated by an equal amount of space, and the columns for each data element are perfectly aligned.

 

Here are the fields, in sequential order, that are output in flat file format to the XXX.txt.

 

Respondent ID Number

Age Code (1-5)

Gender Code (1-2)

Ethnicity Code (1-6)

Cume Station 1 (0 or 1)

Cume Station 2 (0 or 1)

Cume Station 3 (0 or 1)

Cume Station 4 (0 or 1)

Cume Station 5 (0 or 1)

Cume Station 6 (0 or 1)

Fave Station 1 (0 or 1)

Fave Station 2 (0 or 1)

Fave Station 3 (0 or 1)

Fave Station 4 (0 or 1)

Fave Station 5 (0 or 1)

Fave Station 6 (0 or 1)

Date they took test (MM/DD/YY format)

Their Quota Tier (1-5 although this should always be 1 unless multiple stations/clients in same database)

999 (This is merely a buffer/placeholder to indicate the end of respondent data, and beginning of song score data…)

Song 1 score

Song 2 score

.

.

.

Song XX score (up to 40 song scores)

Interviewer Name

Respondent Phone Number

 

HandIf you are testing interactive questions on the Fileserver, those scores are prepended before the song scores.

 

For example, if you are asking respondents two interactive questions, after they are transferred to the Fileserver (the questions that come up right before the song clips), the answers to those two questions will immediately follow the 999 buffer listed above.  After the two question answers, Song 1 score, Song 2 score, etc. will then be output just as indicated above.  The question text, as well as the first 3 answers, will also be documented in the first two positions of the Song.txt file as well.