|
<< Click to Display Table of Contents >> Navigation: Reference Manual > Files > Response texts file |
This describes the layout of external files used to update response texts.
These files are accessed by requesting [Project] [Get response texts from file] from the Main window menu.
These "Code frame" CSV files are used to update all the relevant response texts.
Only the response texts are changed; all other response settings remain as before, except that if the previous text was empty then a "Refuse input" setting is turned off when text is allocated.
Only existing responses can have their text replaced; responses will not be added or deleted.
The update can safely be run whenever needed; it will only change texts that are different to the existing responses texts.
IMPORTANT: empty texts in the Text column will be used; any existing response text will be removed.
The response texts file can be a CSV file or a Microsoft Excel file.
Each worksheet contains the following columns with these headers:
This column is optional and identifies the entry names to be updated.
There can be more than one entry column, so this type of column will be recognised as any column whose header begins with "Entry".
This column will usually contain the same text (entry name) in every row.
This column is compulsory and contains the response numbers whose text is to be replaced. Typically all the responses will be listed except any supplemental reject responses.
This column is compulsory and contains the response texts that will replace any existing texts.
A CSV file can contain only one worksheet.
If there is no Entry column then the file name is assumed to be entry name and only one entry will be updated. For example, Q6A.csv with no column header beginning "Entry" will be used to update entry Q6A.
Every worksheet in the file will be used.
If there is no Entry column in a worksheet then the worksheet name is assumed to be entry name and only one entry will be updated for that worksheet. For example, worksheet Q6A with no column header beginning "Entry" will be used to update entry Q6A.
A CSV file or worksheet called "Q15A" contains:
Value |
Text |
1 |
New first response |
2 |
New second response |
3 |
New third response |
This will replace the text of responses 1-3 in entry Q15A with the new response texts.
A CSV file or worksheet called "MyTexts" contains:
Entry |
Value |
Text |
Q15A |
1 |
New first response |
Q15A |
2 |
New second response |
Q15A |
3 |
New third response |
This would have the same effect as the example above.
A CSV or worksheet called "Products" contains:
Entry_1 |
Entry_2 |
Entry_3 |
Value |
Text |
Q10A |
VQ10A |
Q20 |
1 |
First product |
Q10A |
VQ10A |
Q20 |
2 |
Second product |
Q10A |
VQ10A |
Q20 |
3 |
|
Q10A |
|
Q20 |
4 |
Extra product |
Q25 |
|
|
1 |
Test 1 |
Q25 |
|
|
2 |
Test 2 |
Q25 |
|
|
3 |
Test 3 |
This will replace the text of responses 1-4 in Q10A, VQ10A and Q20 with the new response texts.
If response 3 in these entries has a response text it will be removed and becomes an "unallocated" response.
Response 4 will not be changed in VQ10A.
This file will also replace the text of responses 1-3 in Q25 with the new response texts.