Add or Update Users

Objective:

  • Add new users.

  • Update existing users when user_external_id already exists.

Filename:

  • Pattern: AddUser_xxxxx

  • Example: AddUser_20240123-093412.csv

Field notes:

  • A user can have multiple card codes.

  • If generic garments are used, an item pool ID must be provided.

  • Language supports multiple tag styles.

  • Typical language tags: SWE, ENG, GER, DUT, FIN, NOR, FRA, ITA.

  • Also supported: short tags like sv, en, de, fi, fr, nl, nb, it.

  • Also supported: locale tags like SvSe, EnGb, DeDe, FiFi, FrFr, NlBe, NbNo, ItIt.

Columns:

Header

Alternative header

Requirement

Description

id

user_external_id

Mandatory

Unique user identifier

name

full_name

Mandatory

User name

uniforms

credit_limit_template_external_ids

Optional

One or more credit limit template IDs

customer

customer_external_id

Optional

Customer reference

limit

user_limit

Optional

User total credit limit

card

card_identifiers

Optional

User card or cards

department

department_external_id

Optional

User department

last_date

end_date

Optional

Access revoke date in ISO 8601 (YYYY-MM-DD)

language

language

Optional

Language preference

stocks

item_pool_external_ids

Optional

Generic stock or pool IDs

costcenter

cost_center_external_id

Optional

User cost center

email

email

Optional

User email address

pin_code

pin_code

Optional

PIN code

user_type

user_type

Optional

User type or category

Notes: * user_external_id is the stable identity and should not change between files. * credit_limit_template_external_ids, item_pool_external_ids, and card_identifiers may contain multiple values. * Multi-value fields must be quoted when they contain ;. * end_date can be given as date (YYYY-MM-DD). * customer_external_id is required in supplier mode. * Minimum practical data to use the system directly from import is: user_external_id, full_name, credit_limit_template_external_ids, card_identifiers, and item_pool_external_ids. * If needed, credit_limit_template_external_ids, card_identifiers, and item_pool_external_ids can be added later manually in Q-Web.

Examples:

As supplier:

user_external_id;full_name;user_limit;card_identifiers;credit_limit_template_external_ids;department_external_id;language;item_pool_external_ids;end_date;email;pin_code;user_type;customer_external_id
EP001101;Linda Johnson;5;1200;"14;8;3";Admin Office;ENG;1112;2026-12-31;linda.johnson@example.com;1234;Employee;1118-3
EP001102;Oliver Brown;15;1300;"10;1;7";Warehouse;GER;1112;2026-11-30;oliver.brown@example.com;4321;Employee;1118-3
EP001104;Emma Muller;8;1400;"18;4;9";Logistics;DUT;1112;2026-10-31;emma.muller@example.com;6789;Employee;1118-3

Multiple cards on same user:

user_external_id;full_name;user_limit;card_identifiers;credit_limit_template_external_ids;department_external_id;language;item_pool_external_ids;customer_external_id
EP001100;Charles Smith;10;"1100;1000";"12;2;6";Handwerker Schindler;SWE;1112;1118-2
EP001105;Hanna Virtanen;12;"1500;1600";"11;5;2";Customer Support;FIN;1112;1118-6
EP001106;Noah Hansen;20;"1700;1800";"20;3;8";Sales;NOR;1112;1118-7

As customer:

user_external_id;full_name;user_limit
EP009001;Test User One;5
EP009002;Test User Two;8