Skip to main content

Import members

Dieser Artikel beschreibt, wie Sie Mitglieder in Converia per CSV-Datei importieren und welche Voraussetzungen, Pflichtfelder und Importregeln dabei zu beachten sind.

Overview

Converia imports members into member lists. At least one member list must exist before you can import member data.

If you use different membership types or different verification criteria, create separate member lists for them.

The general guidelines for importing person records also apply to member imports. Member imports have additional rules for the membership number, the CSV file and what happens when you import the data again.


Prerequisites

  • Access to Configuration → Basic Settings → Member lists

  • At least one member list has already been created and saved.

  • You use the corresponding CSV import template for importing person records.

  • The import file is saved as a CSV in UTF-8 without a BOM or in ANSI.


Configuration / Procedure

  1. Open Configuration → Basic Settings → Member lists.

  2. Create and save a member list or select an existing list.

  3. Click Template for CSV-import to download the template for the member list.

  4. Open the template, for example using Excel’s data import feature, and enter the member data.

  5. Fill in all required fields.

  6. Enter each member’s status in the IS_ACTIVE column.

  7. Add values in OPENFEE and EXT_REFERENCE if needed.

  8. Save the file as a CSV in UTF-8 without a BOM or in ANSI. In Excel, use the CSV (Comma delimited) (*.csv) option.

  9. Upload the edited CSV file to the relevant member list.


Required fields in the import file

The following fields are required:

  • Family name

  • Email address

  • Membership number

  • Country

  • Status

    • 1 = active

    • 0 = inactive

To import all members in the list as active, enter 1 in the IS_ACTIVE column for every record.


Optional fields

  • OPENFEE
    You can leave this field blank. If a member has an outstanding amount, you can collect it as part of registration.

  • EXT_REFERENCE
    Use this field to store your own reference number for the member account, for example to match the record with one in your own database.


Notes

  • The membership number must be unique within each member list and assigned consistently.

  • Converia assumes that member lists come from externally maintained databases in which each person has a unique identification number.

  • If you assign membership numbers specifically for use in Converia, take particular care to keep each number matched to the correct person’s details when you update or reimport the data.

  • We recommend maintaining a separate external member database for each event and regularly updating Converia from that database.

  • You can download the CSV import template for a member list once you have created and saved the list.

Warning: Each new import completely overwrites the existing member records in Converia. Ideally, make changes only in the central member database.

Members who are in Converia but are missing from the current import file automatically receive the Deleted status.


FAQs

Does a member list need to exist before I import members?

Yes. Members are imported into member lists, so you must create and save at least one list before importing.

What encoding does the import file need?

Save the file as a CSV in UTF-8 without a BOM or in ANSI. In Excel, use the CSV (Comma delimited) (*.csv) option.

What happens when I import the data again?

Reimporting completely overwrites the existing member records in Converia. Changes made directly in Converia are lost on the next import unless those changes were also made in the external member database.

What happens to members who are no longer in the import file?

These members automatically receive the Deleted status in Converia.

Is OPENFEE required?

No. This field is optional. Use it if you want to collect an outstanding amount as part of registration.

What is EXT_REFERENCE used for?

Use EXT_REFERENCE to store your own reference number for the member account, for example to match the record with one in an external database.

Did this answer your question?