A downloadable PDF version is available at the bottom of the page together with the Excel import template.

Rules. (Required fields are marked with a Red background colour)


Rules. (Required fields are marked with a Red background colour)


Field NameDescriptionRulesException HandlingValues to be placedDefault ValuesField Type
ActiveThis contains confirmation if the user account should be activated immediately after creationThis needs to be a True/False valueN/ATrue/FalseFalseBoolean
FullNameThis field contains the full name of the user.Alphanumeric valueN/AN/AN/AVariable Character (100)
UserNameThis field contains the username, which the user will use to log into PIPware.Usernames must be unique.  This field is used to determine whether to update an existing user or create a new user.If the username already exists, the existing user/person will be updated rather than creating a new user. if left blank the record will not be importedN/AN/AVariable Character (100)
PasswordThis field contains the password for the user. If no password is specified, a "Create Password" email will be sent out to the user to allow them to choose an initial password.N/AN/AN/AVariable Character (100)
EmailAddressThis field contains the email address of the user. Must be a valid email address.N/AN/AN/AVariable Character (250)
PhoneNumberThis field contains the phone number of the user.Alphanumeric valueN/AN/AN/AVariable Character (30)
MobileNumberThis field contains the mobile number of the user.Alphanumeric valueN/AN/AN/AVariable Character (30)
LanguageThis field contains the primary Language for the user.This value must be valid in the system. The language selected must match up with the name of a Language saved on the system.If there is a spelling mistake or the language selected on the import does not meet the Languages saved on the system, the record will still be allowed to be imported onto the system. However, the Language field will be empty.N/AN/ALookup (Language)
Structure Level 1
This value must be valid in the system. The Structure Level 1 (Department) selected must match up with the name of a Structure Level 1 (Department) saved on the system.If there is a spelling mistake or the Structure Level 1 (Department) selected on the import does not meet the Structure Level 1 (Department) saved on the system, the record will still be allowed to be imported onto the system. However, the Structure Level 1 (Department) field will be empty. N/AN/ALookup (Department)
Structure Level 2This field contains the Structure Level 2 (Sub Department)  to which the user belongs.This value must be valid in the system. The Structure Level 2 (Sub Department) selected must match up with the name of a Sub Department saved on the system.If there is a spelling mistake or the Structure Level 2 (Sub Department)  selected on the import does not meet the Structure Level 2 (Sub Department) saved on the system, the record will still be allowed to be imported onto the system. However, the Structure Level 2 (Sub Department) field will be empty. N/AN/ALookup (Sub Department)
Structure Level 3This field contains the Structure Level 3 (Team) that the user belongs to.This value must be valid in the system. The Structure Level 3 (Team)  selected must match up with the name of a Team saved on the system.If there is a spelling mistake or the Structure Level 3 (Team) selected on the import does not meet the Structure Level 3 (Team) saved on the system, the record will still be allowed to be imported onto the system. However, the Structure Level 3 (Team) field will be empty. N/AN/ALookup (Team)
PersonPositionThis field contains the Person Position assigned to the user.This value must be valid in the system. The Person Position selected must match up with the name of a Person Position saved on the system.If there is a spelling mistake or the Person Position selected on the import does not meet the Person Positions saved on the system, the record will NOT be imported onto the system.N/AN/ALookup (Person Position)
RoleThis field contains the Role assigned to the user.This value must be valid in the system. The Role selected must match up with the name of a Role saved on the system.If there is a spelling mistake or the Role selected on the import does not meet the Roles saved on the system, the record will NOT be imported onto the system.N/AN/ALookup (Role)
Help ToursThis field determines if the Help Tours should be activated for the userThis needs to be a True/False value
N/A
True/False
FalseBoolean
SupportWidgetThis field determines if the Support Widget should be activated for the userThis needs to be a True/False value

N/A

True/False
FalseBoolean
SupplierThis field contains the name of the Supplier the User belongs to.
This value must be valid in the system. The Supplier selected must match up with the name of a Supplier saved on the system.
If there is a spelling mistake or the Supplier selected on the import does not meet the Suppliers saved on the system, the record will still be allowed to be imported onto the system. However, the Supplier field will be empty.
N/AN/ALookup (Suppliers)