Overview
Person import allows you to create multiple person records in Converia at once. The data is imported using a predefined CSV file and checked in a preview before the actual import.
People can be imported with or without a Converia account. Certain mandatory information must be provided, and the structure of the import template must be preserved.
Prerequisites
You have access to Management → Person administration → Person import.
Use the CSV template provided there.
The languages required for the event are enabled.
Save the import file as a CSV file with UTF-8 encoding.
Configuration / Procedure
Open Management → Person administration → Person import.
Download the import template via CSV template file.
Open the CSV file and remove the sample records.
Enter the personal data in the designated columns.
Leave columns without values empty, and do not delete or move any columns.
Enter at least the following mandatory information:
Last Name: family name
Country: country as an ISO code
E-Mail: valid email address
Lang: the person’s language
Enter a username in Username if the person is to be imported with a Converia account.
Leave Username empty if the person is to be imported without an account.
Save the file as “CSV UTF-8 (Comma delimited) (*.csv)”.
Select the prepared file in the CSV file field.
If needed, enter keywords for the imported people in the Keywords field.
Select Show preview.
Check the displayed records for error messages and ensure that umlauts and special characters are displayed correctly.
Correct the import file if errors are displayed, and upload the file again.
Select Start import once the preview no longer displays any errors.
Then check the import log.
Result: The valid person records have been imported into Converia. People with a completed Username field have an account; people without a Username must subsequently activate their account via an activation link.
Notes
A valid ISO country code must be used for Country.
Only languages enabled for the event can be used for Lang.
Typical errors in the preview include invalid email addresses, invalid country codes, languages that are not enabled or a changed number of columns.
For data protection reasons, passwords should not be assigned through the import file.
If person records already exist, the import may create duplicates.
Warning: People imported without an account should subsequently activate their account via an activation link. Without this activation, an additional person record may be created when they register later.
External links
ISO 3166-1 code list – Overview of ISO country codes for the Country field.
