Importing Users

Importing Users into nuBuilder (the zzzzsys_user table) can be done using CSV Transfer.

By following these steps...

• Create a CSV file in the format explained below.
• Place this file in the temp directory where nuBuilder is installed.
• Import from CSV File. Choose zzzzsys_user from the nuScroll list.
• Delimiter. Choose Comma.
• Import to (Table). The name of the file below.
• Click the Transfer Action Button.

zzzzsys_user_id;sus_zzzzsys_access_id;sus_language;sus_name;sus_code;sus_position;sus_department;sus_team;sus_email;sus_additional1;sus_additional2;sus_login_name;sus_login_password;sus_expires_on;sus_json

1;NULL;NULL;user1;NULL;NULL;NULL;NULL;NULL;NULL;NULL;login1;password1;NULL;NULL

2;NULL;NULL;user2;NULL;NULL;NULL;NULL;NULL;NULL;NULL;login2;password2;NULL;NULL

3;NULL;NULL;user3;NULL;NULL;NULL;NULL;NULL;NULL;NULL;login3;password3;NULL;NULL

4;NULL;NULL;user4;NULL;NULL;NULL;NULL;NULL;NULL;NULL;login4;password4;NULL;NULL

5;NULL;NULL;user5;NULL;NULL;NULL;NULL;NULL;NULL;NULL;login5;password5;NULL;NULL

• zzzzsys_user_id: The first column has to contain consecutive numbers (e.g. 1,2,3,4,5,6 etc.) The importer will replace them with a unique nuBuilder id.
• sus_zzzzsys_access_id: Provide a valid Access Id (See Access Level Form -> ID or look it up in the table zzzzsys_access, column zzzzsys_access_id)
• sus_name: User name.
• sus_login_name: User login name
• sus_login_password: User password in plaintext. The importer will replace it with its MD5 value.