|
<< Click to Display Table of Contents >> Navigation: Reference Manual > Windows and dialog boxes > User Controls > Export type user control |
This user control is used to control export reports created with Data export.
It has the following tab pages:
•This tab is used to:
•Choose whether the serial number is output and the header name to be used for it
•Select the types of entries that are to be exported
•Select the text for filters. Common schemes are:
o"True" and "False"
o"1" and "0"
o"True" and blank
o"1" and blank
This tab is used to select the types of responses for questions that are to be output.
This tab is used to select the types of responses for variables that are to be output.
This tab is used to control the way that responses (single-coded and multi-coded) to questions and variables are to be output:
•Output the response text instead of the response number
•Whether to output unallocated responses (those without any response text)
•Specify some text to be used in front of response numbers, for example you might want response 15 to be output as "Response 15"
•Specify what to output when the entry is empty (has no responses set)
•Specify that response numbers all have the same number of digits, for example 003 for response 3; the number of digits will be set:
oFrom the data location width
oTo the number of digits needed to hold the largest response number
oAs specified on this tab
This tab is used to control the way that multi-coded responses to questions and variables are to be output. These settings are in addition to those on the Response tab:
There are three different ways to export multi-coded entries:
If a single column is not used then the allocated columns will all have a header that starts with the entry name followed by an underscore (_) followed by a sequence number. So Q1 columns will be headed Q1_1, Q1_2, Q1_3, and so on. You can alter the character used between the name and the sequence number at the bottom of the window.
This is the default for portable data files.
You can choose what character(s) to use to separate the responses. The default is a semicolon (;) if response text is being exported, or a blank ( ) if response numbers are being exported.
You can also choose "Binary" output which puts out a 0 or 1 for each response. For example if you have five responses and the second and fourth are true the program will output 01010~. A character is added to the end to prevent a spreadsheet program interpreting 01010 as value 1010. You can set the character(s) to use at the end.
This will output a separate column for every valid response. See Project global settings where you can choose whether a column is allocated for unallocated responses (those with no text) and empty responses (those with no data).
The program will output the relevant response number in each column. You can choose instead to output a fixed text for each true response instead.
The program will normally place a zero (0) in responses not present but this can be replaced using the Responses tab above.
For questions this will normally allocate the number of columns set as the "Max values" in the Question details.
For other entries the data is scanned to find the maximum number of responses used for a data record and this determines the number of columns allocated.
The first column will contain the response number (or text) for the first response found in the record. The second column will contain the response number (or text) for the next response found in the record. When a record has no more responses the rest of the allocated columns are left blank.
This tab is used to control the way that values (integer and float) to questions and variables are to be output:
•Specify that values all have the same number of digits, for example 003 for response 3; for float values this is the digits before the decimal point, the number of digits will be set:
oTo the number of digits needed to hold the largest value
oAs specified on this tab
•Specify a text (often "U") for undefined values
For float values:
•Specify that values all have the same number of decimal places, for example 6.300 for 6.3. The number of digits will be set:
oTo the number of decimal places needed to hold the largest number of places in the data
oAs specified on this tab
This tab is used to control the way that textual answers to questions are to be output:
•Whether to limit the output to a set number of characters, the answers will be truncated if necessary
This tab is used to control the way that date and time answers to questions are to be output:
•Whether to output the value as stored in data, either YYYYMMDD or HHMMSS
•Whether to use the long format instead of the short format as set in the Windows Control Panel