Selecting CSV as the output type will result in the creation of 3 text files, all in Comma Separated Values format.
When saving the output in the OUTPUT section, you are prompted to enter the name of the ResponseData CSV file.
The default name is StudyName_YYYYMMDD.csv
|
Header Record |
A comma separated record in the form:- Trial,Site,Label,PersonId,VisitCycle,FormCycle,RepeatNumber,Question1, Question2 …. Where QuestionN is of the form ShortCode or if LongCodes are being used VisitCode/FormCode/QuestionCode or VisitCode/FormCode/QuestionCode/Attribute if its an attibute (Comments, CTCGrade, LabResult, Status, TimeStamp, UserName, ValueCode) |
|
Data Record (1 per subject) |
A comma separated record of responses that corresponds to the header record. |
The name of the Questions file is derived from the ResponseData filename, adding the suffix of _DLU
The default name is StudyName_YYYYMMDD_DLU.csv
|
Header Record |
ShortCode,Visit/Form/Question,Description,Type Or if LongCodes are being used Visit/Form/Question,Description,Type Where Visit/Form/Question corresponds to a question’s VistCode/FormCode/QuestionCode or a question attribute’s VistCode/FormCode/QuestionCode/Attribute. Description corresponds to a questions description. Type corresponds to a questions type (Text, Category, IntegerData, Real, Date, Multimedia, LabTest) for questions and (Comments, CTCGrade, LabResult, Status, TimeStamp, UserName, ValueCode) for attributes. |
|
Data Record (1 per Question) |
A comma separated record of Questions their description and their type. |
The name of the CategoryCodes file is derived from the ResponseData filename, adding the suffix _CLU
The default name is StudyName_YYYYMMDD_CLU.csv
|
Header Record |
ShortCode,CatCode,CatValue Or if LongCodes are being used Visit/Form/Question,CatCode,CatValue Where Visit/Form/Question corresponds to a question’s VistCode/FormCode/QuestionCode. Where CatCode correspond to a Category Code (e.g. M, F, 1, 2). Where CatValue corresponds to a Category Value (e.g. Male, Female) |
|
Data Record (1 per category value) |
A comma separated record of questions, a category code and a category value. e.g. VizOne/FormOne/SexCodeCAT,m,Male VizOne/FormOne/SexCodeCAT,f,Female VizOne/FormOne/SexCodeCAT,u,Unknown |
Each field is delimited by commas (e.g. Field1,Field2,Field3,Field4)
Fields that contain a comma have double quotes put around them. For example,
Tom, Dick and Harry becomes "Tom, Dick and Harry"
Fields that contain double quotes have each double quote replaced by 2 double quotes and double quotes are put around the whole field. For example, Thomas "Hitman" Hearns becomes "Thomas ""Hitman"" Hearns"
"Tom" becomes """Tom"""
"Tom" is best becomes """Tom"" is best"
Fields containing both double quotes and commas have both rules applied, but only one set of double quotes are put around the field. For example,
"A", "B" and "C" becomes """A"", ""B"" and "C"""
me, "My Dog" and you becomes "me, ""My Dog"" and you"
Standard dates d/m/y, d/m/y/h/m, d/m/y/h/m/s, m/d/y, m/d/y/h/m, m/d/y/h/m/s, y/m/d, y/m/d/h/m, y/m/d/h/m/s, h/m, h/m/s will always appear in the dd/mm/yyyy format.
Non-standard dates y/m, y/m/h/m, y/m/h/m/s, m/y, m/y/h/m, m/y/h/m/s, y/d/m, y/d/m/h/m, y/d/m/h/m/s keep their original format.
If the CSV file you wish to open contains Unicode data, you must perform the following steps before attempting to open it:
Open the CSV file in Notepad.
Select File>Save As>Unicode big endian
Click Save.