Choose your language

Choose your login

Support

Batch User Import/Update Example .tsv files

THE PAGE APPLIES TO:

This article details the two bulk-import methods for users, and shows example .tsv (tab separated values) files for the batch-user import/update tools.

Import method summary

Are you looking for the ‘password column’ in the import file where there doesn’t seem to be one? Or are you confused why you see a password column when you’re not expecting one? See below for the differences between ‘Standard’ and ‘Internal’ users - and the critical differences between the bulk import methods for both.

 Standard UsersInternal Users
DescriptionPasswords are managed by an external directoryPasswords are managed internally by PaperCut
Link to documentationBatch import and update user dataBatch Internal User Import and Update
Can you specify a user password in the import file?No (passwords cannot be managed internally by PaperCut)Yes (passwords are managed internally by PaperCut)
Import method usedInterface UI only - Users → Actions → Batch ImportCommand line import only - server-command batch-import-internal-users
Import file formatbatch-internal-user-example.zip
Fields available to import/updateUsername
Credit Balance
Restricted Status
Full Name
Email
Department
Office
Card/ID Number
Card/ID PIN
Notes
Secondary Card/ID Number
Other email addresses
Username alias
Home folder

(see here for more detail)
Username
Password
Credit Balance
Restricted Status
Full Name
Email
Department
Office
Primary Card/ID Number
Card/ID PIN
Notes
Secondary Card/ID Number
Home folder

(see here for more detail)

Standard Users (users which are managed by an external source like AD or LDAP)

The user import/update process is documented in the Batch import and update user data part of the manual:

  • Note that in this import method, you are not able to specify a password field, since the users passwords will be managed externally.
  • Note that you can only import Standard users through the Users → Actions → Batch Import method as detailed on the link above.

Download here: batch-user-example.zip

Internal Users (users managed entirely by PaperCut - including password)

The Internal user import/update process is documented in the Batch Internal User Import and Update part of the manual:

  • Note that this is the only import method where you can specify the password field, since this is for managing internal users
  • Note that you can only import Internal users through the ‘server-command batch-import-internal-users’ method as detailed on the link above.

Download here: batch-internal-user-example.zip

These example files are included in the PaperCut installation in the following directory:

  • [server install]/server/examples/import/users/batch-user-example.tsv
  • [server install]/server/examples/import/users/batch-internal-user-example.tsv

For a video run thru on creating/importing internal users please see below:


Categories: Reference Articles , User Management , Scripting and APIs


Keywords: tab delimited , example , file , template , tsv , csv

Comments

Last updated June 13, 2024