Import users via user standard importer
Questions:
- How to import user using standard importer?
- How to import user?
Description:
TYRIOS offers you the option of importing users into the user list or updating existing users via TYRIOS contact. At least the standard user importer is available. However, individual interfaces to merchandise management and ERP systems are also possible via the importer framework.
Solution:
The user default importer has the following fields:
| Field Name | Field Meaning |
|---|---|
| ID | User ID, if this is specified, it is used for updates of existing users |
| Title |
Title of the user (e.g. Dr., Prof.,...) |
| First Name | First name of the user |
| last Name | Last name of the user |
| Salutation | Salutation of the user (e.g. "Dear Mr Blum,") |
| E-mail address of the user | |
| Contact Phone | Contact telephone number |
| Contact Fax | Contact Fax |
| Birthday | Date of birth (in the format dd.mm.yyyy) |
| Password | The password of the user. |
| User Group | Comma-separated list of user groups |
| Tags | Comma-separated list of user tags |
| Gender |
Gender of the user |
| Company | Company name |
| Company 1 | Other company name |
| Company 2 |
Other company name |
| Company 3 | Other company name |
| Street | Street |
| House Number | House Number |
| Post Code | Postcode |
| City | City |
| Country | Country code (e.g. de) |
| BIC | BIC for SEPA information |
| IBAN | IBAN for SEPA information |
| SEPA Mandate | Sepa mandate for SEPA information |
| SEPA Signing Date | Date of the SEPA mandate |
| SEPA Account Activated | 0/1 |
| SEPA Account Owner |
SEPA account holder |
In the case of an update, only the fields that are filled in are taken into account. You can therefore also provide only a part of the fields during the import.
The address and SEPA data are appended to the user if these data do not already exist. An address or SEPA data object is automatically created.
To import, proceed as follows:
- Save the file in CSV format with UTF-8 encoding.
- Go to the User Area > User Administration > Manage Users
- Click on Import and select the standard importer.
- Upload the file. The import starts automatically and creates the users accordingly.