Download User Manual

User Manual
secuTrial® 4.7
FormBuilder

Excel file as *.csv

The variables are specified in the first line, and the values as of the second line

Only one patient may be defined per line

On individual import, the CSV parser only processes the values of the second line

Variable names contain no blanks, text delimiters, separating characters or assignment
characters.

If a text delimiter has been defined, values within the text delimiters are regarded as text
values. Blanks within text delimiters are not then interpreted as separating or end characters.

In addition, the character for separating and the character for including values are specified in the
parser. This is particularly necessary for interpreting text values. In the case of the listing parser, the
character for the allocation of variable and value is additionally specified instead of the separating
character. The equals character is used here as the default.

A name to identify the parser is specified for the user. If the user has access to several import
formats for one form, the user must select an explicit format and the parser on import.
Repetitions:

Imports in repetition groups is possible by columns or rows.

When importing by column, the dataset for the main form will be entered in one row. The contents
for the repetition groups will then be entered in repeating columns. To distinguish between the
columns, an extended identifier is defined for the import format. This extends the subform item
column headings which are defined as external variables together with the repetition number.

When importing by rows, the dataset is not created from a single row, but from the change in the
identified patient variables and, with visit entry in the file, from the visit column. A dataset for import ing can then consist of 1-n rows of the import file.
Fig. 59
As of 13/10/2014
If the import format is configured accordingly, these two import files would import the
same data
- 69 -
© iAS