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)


Field NameDescriptionRulesException HandlingValues to be placedDefault ValuesField Type
NameThis 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 for the user. Must be a valid email address.N/AN/AN/AVariable Character (250)
PhoneNumberThis field contains the phone number for the user.Alphanumeric valueN/AN/AN/AVariable Character (30)
MobileNumberThis field contains the mobile number for the user.Alphanumeric valueN/AN/AN/AVariable Character (30)
LanguageThis field contains the primary Language for the user.This value must be valid from 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)
DepartmentThis field contains the Department that the user belongs to.This value must be valid from the system. The Department selected must match up with the name of a Department saved on the system.If there is a spelling mistake, or the Department selected on the import does not meet the Departments saved on the system, the record will still be allowed to be imported onto the system. However the Department field will be empty. N/AN/ALookup (Department)
Sub DepartmentThis field contains the Sub Department that the user belongs to.This value must be valid from the system. The 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 Sub Department selected on the import does not meet the Sub Departments saved on the system, the record will still be allowed to be imported onto the system. However the Sub Department field will be empty. N/AN/ALookup (Sub Department)
TeamThis field contains the Team that the user belongs to.This value must be valid from the system. The Team selected must match up with the name of a Team saved on the system.If there is a spelling mistake, or the Team selected on the import does not meet the Teams saved on the system, the record will still be allowed to be imported onto the system. However the Team field will be empty. N/AN/ALookup (Team)
PersonPositionThis field contains the Person Position assigned to the user.This value must be valid from 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 to be imported onto the system.N/AN/ALookup (Person Position)
RoleThis field contains the Role assigned to the user.This value must be valid from 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 to be imported onto the system.N/AN/ALookup (Role)


Sample.

 

NameUserNamePasswordEmailAddressPhoneNumberMobileNumberLanguageDepartmentSub DepartmentTeamPersonPositionRole
Zuri MatheZuriPip@123Kmathe@digiquill.co.za+27 11 586 5822+27 01 225 3659EnglishBusiness Performance

SP AdministratorAdministrator