Skip to main content

Importing people

This article describes how to import multiple people into Converia using a CSV file and check the data before importing.

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

  1. Open Management → Person administration → Person import.

  2. Download the import template via CSV template file.

  3. Open the CSV file and remove the sample records.

  4. Enter the personal data in the designated columns.

  5. Leave columns without values empty, and do not delete or move any columns.

  6. 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

  7. Enter a username in Username if the person is to be imported with a Converia account.

  8. Leave Username empty if the person is to be imported without an account.

  9. Save the file as “CSV UTF-8 (Comma delimited) (*.csv)”.

  10. Select the prepared file in the CSV file field.

  11. If needed, enter keywords for the imported people in the Keywords field.

  12. Select Show preview.

  13. Check the displayed records for error messages and ensure that umlauts and special characters are displayed correctly.

  14. Correct the import file if errors are displayed, and upload the file again.

  15. Select Start import once the preview no longer displays any errors.

  16. 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

Did this answer your question?