CSV Transfer: Difference between revisions
No edit summary |
|||
Line 43: | Line 43: | ||
5;NULL;NULL;user5;NULL;NULL;NULL;NULL;NULL;NULL;NULL;login5;password5;NULL;NULL | 5;NULL;NULL;user5;NULL;NULL;NULL;NULL;NULL;NULL;NULL;login5;password5;NULL;NULL | ||
</code> | </code> | ||
<div style='background-color:#D8E4FF;padding:10px'> | |||
*'''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. | |||
</div> | |||
Revision as of 01:03, 24 September 2021
Back to Documentation
The CSV Transfer Form Functionality
- Exporting a database table to a CSV file.
- Importing CSV files to a new database table.
- Forum Post - user access to CSV Transfer, generally limited to globeadmin.
Exporting a CSV File requisites
- Export to CSV File. Choose the CSV file from the nuScroll list.
- Delimiter. Choose the Delimiter to space each field value.
- Import to (CSV). Enter a filename for the new CSV file.
- Click the Transfer Action Button.
Importing a CSV File requisites
To appear in the nuScroll List the CSV File must be placed in the temp subdirectory inside nuBuilder Forte's directory - on the server.
Currently, a file can only be imported into a new database table.
- Import from CSV File. Choose the database table from the nuScroll list.
- Delimiter. Choose the Delimiter to space each field value.
- Import to (Table). Enter a filename for the new CSV file.
- Click the Transfer Action Button.
Importing Users
Importing Users can be done by...
- Creating a CSV file with the following format
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.
- 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 above.
- Click the Transfer Action Button.