Metacat

do not duplicate the true/false indicators for the metadata vocab/value matrix

use recordNum instead of studentId for transposed data

use "recordNum" rather than "studentId"

omit studentId values from normal resultset
strip the html tags from the qti elements for both return formats

split vocab/value into two columns (can easily switch back to single column)

omit duplicate values in the for the standard metadata header section (columns for each question)

omit the metadata vocab/values from the normal header section since they will be used in the "matrix-style" header section

add vocab name/value matrix above data rows.
currently there is only a single column for the concatenated value of the vocab name + "/" + vocab value. it's so much easier!

reduce the extra whitespace on the transpose

only "correct" non-null values

include qPrompt and qChoice
need to quote the csv so that commas in the question text do not throw it off

Now the metadata attributes show as rows above the data.
very close!
todo: special handling for thesaurus (ie NBII/Bloom) metadata fields

pivot constrained to a List of specific attributes: studentId (record number), score, response.
This is the "lower half" of the return set (data).
now: on to the metadata header rows

Now doing the dataquery/download in the FIRST skin's jsp rather than embedded in the Metacat servlet.
TODO: implement the very-custom data return format agreed upon by the FIRST team