Contents - Index

Import respondents

With ANR:
Here only one column is necessary, a column with six (in the future 7) numbers. The program searches for the names and email address of the respondents.

Without ANR:
From a external file, respondents can be imported. There are four fields each separated by a ";". The third and fourth field is optional. 
The fields are:  e-mail; name; reference; id;
The maximum for the id field is 6 chars. It is inserted in the ANR field.

Examples of the format of an export are:
p.puck@uvt.nl; Pietje Puck; 900.23.4.5; A10023
j.vulin@uvt.nl; Jan Vulin; 800.44.66.2; B12345
klaas@hotmail.com; Klaas Vaak

Often lists are available in Excel. These files can be exported to a .csv file with separator ";".
To get this separater the next operating procedure must be followed: (from help Excel, options in Windows, not in Excel!):

Change the separator in a CSV text file
  • Click the windows Stat menu.
  • Click Control Panel.
  • Open the Regional and Language Options dialog box.
  • Click the Regional Options Tab.
  • Click Custimize.
  • Type a new separator in the List separator box.
  • Click OK twice.
    Note1:  After you change the list separator character for your machine, all applications will use the new character. You can change the character back to the original character by using the same procedure. 
    Note2: To generate lists from Exel with own numbers, use 1001 in cel B1, and in cel A1 use the formula:  =TEXT(B1; "000")&"@uvt.nl". Copy this to a range of numbers.