Additional export format of survey response data to match previous export format

[GoogleCodeExporter]

The format of the file of responses needs to be changed so that it can be
exported more readily into an SPSS file. Specificly, the variable names
should be in the first row and the responses should be in the lower rows,
as in the attached CSV file from one of the ColdFusion metaprograms. Please
use the variable names in the attached CSV file. The names for the Personal
Construct variables are in columns AT through EW in the attached CSV file.
The names for the Conventional Construct variables are in columns EX
through IC, but in the PHP format, the CCIS_ variable names should come
before the CCOS_ variable names rather than in the order in which they
appear in the attached file. 

Original issue reported on code.google.com by warner.j...@gmail.com on 8 Oct 2009 at 1:02

Attachments:

• [All electronic data downloaded using Jack's new prompt - problem w comma fixed by Jack.csv](https://storage.googleapis.com/google-code-attachments/drupal-incarnate/issue-14/comment-0/All electronic data downloaded using Jack's new prompt - problem w comma fixed by Jack.csv)

[GoogleCodeExporter]

Original comment by warner.j...@gmail.com on 8 Oct 2009 at 1:03

• Changed title: Additional export format of survey response data

[GoogleCodeExporter]

Use placeholders for surveys not yet coded, for example, BDI, STAI, etc.

Original comment by warner.j...@gmail.com on 8 Oct 2009 at 1:12

• Changed title: Additional export format of survey response data that includes all surveys in single download file
• Added labels: Type-Enhancement
• Removed labels: Type-Defect

[GoogleCodeExporter]

Original comment by warner.j...@gmail.com on 16 Oct 2009 at 2:33

[GoogleCodeExporter]

Beginning to get SQL together for results:

select id, `61424X51X147` AS ParticipantCode, submitdate as TakenOn, 
`61424X51X146`
Gender,
`61424X41X136RR1` as PCRS1,
`61424X41X136RR2` AS PCRS2,
`61424X30X106RR3` AS PCRS3,
`61424X30X106RR4` AS PCRS4
 from lime_survey_61424

Original comment by warner.j...@gmail.com on 16 Oct 2009 at 3:53

[GoogleCodeExporter]

Original comment by warner.j...@gmail.com on 16 Oct 2009 at 3:53

• Changed title: Additional export format of survey response data to match previous export format

[GoogleCodeExporter]

Original comment by warner.j...@gmail.com on 16 Oct 2009 at 3:59

• Changed state: Started

[GoogleCodeExporter]

Updated admin/admin.php, common.php, and images/exportcsvmodern.png

Original comment by warner.j...@gmail.com on 19 Oct 2009 at 4:34

[GoogleCodeExporter]

And admin/export_data_csv_61424.php

Original comment by warner.j...@gmail.com on 19 Oct 2009 at 4:35

[GoogleCodeExporter]

Hi Neill and Adam,

I've added the data export function for the Personal Constructs, in the order I
remember them:

Ratings for Real, Ideal, and Ought selves (36 ratings for each self), the first 
6
ratings rate the real characteristics, the next 6 rate the opposite of real
characteristics, the next 6 rate ideal characteristics, the next 6 rate the 
opposites
of ideal characteristics, and the same pattern follows for ought. 

You can access the files from the Personal Constructs data download screen.  
There is
a new icon that looks a bit different and is labeled CSV (see screenshot 
attached).

Adam - you can see the files I changed at:
http://code.google.com/p/drupal-incarnate/issues/detail?id=14

Thanks, and I'll work on Conventional Constructs tomorrow.

- Jack

Original comment by warner.j...@gmail.com on 19 Oct 2009 at 4:43