Import must be enabled in settings in order to import users.

Import file must be csv format, delimiter is semicolon ";" (without quotes).

First row is used for header, and cannot be changed and must use default naming (if custom headers are used, use "Import wizard" to import users with custom file).

Next rows represents individual users, who must have unique First name, Last name, Employee ID and identifications.

If user doesn't have information on some header, that header can be empty (for example middle name is skipped: first name;;Last name;...)

User photos is stored in assets folder as .jpeg format.

Export files from CredoID  4.1.0 versions and older are not directly compatible with current CredoID V4. You will need to edit the export file manually to match its structure to current format. Please contact support if you have such a case.

Import file fields requirements

If these fields configured incorrectly, import will fail or be incomplete:

  • Custom access levels - needs to be created in the CredoID before user import;
  • User Locations - custom location must be created before user import. Default location must be assigned to all the users;
  • Access levels locations - if not defined, will not be added to the users.

Import Wizard

Import wizard allows to import users from csv, txt files, which headers don't match CredoID headers.

Press "Import Wizard" button and select custom import file. After selecting the file, wait until file is loaded.

"Column Name" field represents header values read from the custom import file.

"Map to field" represents header values required for CredoID import.

Required fields are:

  • FirstName;
  • LastName;
  • Location1.Name;
  • EmployeeNumber;*

*EmplyeeNumber may be not required, if at Settings → User import, Primary key is set to "First and Last name".

After mapping fields, if all required fields are mapped, import should be available.

Press "Download CSV" to download generated import file, which matches CredoID requirements (optional).

Press "Import" to import users after mapping.

Import errors

Error messageError meaningHow to fix
Duplicate record 'x' line n (already seen on m line)This error means that import file contains at least 2 identical lines with primary key "First and Last name" or "Employee number" (depending on import settings).Give all the users unique primary keys: "First and Last name" or "Employee number" (depending on import settings). 
At least one location is required for user. Line n. Primary key: y
User doesn't have location assigned in the import file.Assign at least 1 location to the user. (Default: Main location).
Location 'x' not found in system on line n. Primary key: y
User have a location assigned in import file, that doesn't exists at CredoID.Remove location from this user at import file or create location with the same name at CredoID.
Access level 'x' not found in system on line n. Primary key: y
User have a access level assigned in import file, that doesn't exists at CredoID.Remove access level from this user at import file or create access level with the same name at CredoID.
Duplicate card found 'x' on line n. Primary key: y2 users in the import file have exactly same cards.Remove the card from one of the users.
Removed identification ('x') from user 'Firstname', 'Last name' id: y
Import file contained the card which was assigned to different user in CredoID.This is just a warning, which means that existing card was assigned to the new user after import.
Primary key 'x' is duplicated in systemMore than 1 user exists with primary key "First and Last name" or "Employee number" (depending on import settings) in CredoID.

Find the users with 'x' value in CredoID and give them unique value.

If at import settings, employee number is used and users were created before enabling this settings, all blank employee numbers are treated as duplicates. Assign Employee numbers to the users which doesn't have it at CredoID.

If at import settings, First name and Last name is used, users with exact same values exists in CredoID, change import settings primary key to the "Emplyeenumber" if user first name and last name cannot be updated.

  • No labels
Write a comment...