User import via CSV

Technical assistance
1

Infos:

  • Used Zammad version: 5.1.1
  • Used Zammad installation type: package
  • Operating system: Ubuntu
  • Browser + version: Chrome 101

Expected behavior:

  • Importing users via CSV via either copy/paste or via file updates existing users and creates new users as applicable (this worked in the previous build) based on their email field

Actual behavior:

  • Attempting to import a file, if over 200 lines, fails and times out. If under 200 lines or using the copy/paste method returns the following:

Line X: Unable to update record - Validation failed: Email address ‘***’ is already used for other user

Importing that single line via CSV does randomly work at updating the user record, i.e. it will work once but you change the information and it wont work another seven times with the above error, and then it will work again, with no further changes.

Steps to reproduce the behavior:

  • Create a CSV using the user example CSV, remove the id column (or leave it blank, as there is no way to know the exact id for all the users to update), remove any fields not needing updated, and attempt to import.
2

According to the error message, the CSV file contains 2 user with the same email account.
You will need to change the email account for one user?

The CSV import should work fine.
https://admin-docs.zammad.org/en/latest/manage/users/via-csv-import.html

3

You, my fine human, are a gentleperson and a scholar. Thank you. Now to fix it.

4

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.