add code block (commented out) to use in case "?column?" headers become an issue.
handle repeating "?column?" headers - somewhat naively, but consistent
correct the metadata matrix for "transposed" data downloadhttp://bugzilla.ecoinformatics.org/show_bug.cgi?id=4452
allow user to specify the data columns included for the transpose data set (score, response, response file).decided in today's CC
add "responsefile" column as data in the transposehttp://bugzilla.ecoinformatics.org/show_bug.cgi?id=4412
include download link instead of an ecogrid pointerhttp://bugzilla.ecoinformatics.org/show_bug.cgi?id=4412
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 resultsetstrip 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 qChoiceneed 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