CSV Transfer: Difference between revisions
No edit summary |
|||
(18 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
Back to [[Documentation]] | |||
The CSV Transfer Form | == The CSV Transfer Form Functionality == | ||
Importing CSV files to a new database table. | * Exporting a database table to a CSV file. | ||
* Importing CSV files to a new database table. | |||
* [https://forums.nubuilder.cloud/viewtopic.php?f=19&t=10821 Forum Post] - '''user''' access to CSV Transfer, generally limited to '''globeadmin'''. | |||
Exporting | === 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 === | |||
<div style='background-color:#D8E4FF;padding:10px'> | |||
To appear in the nuScroll List the CSV File must be placed in the '''temp''' subdirectory inside nuBuilder Forte's directory - on the server.<br> | |||
Currently, a file can only be imported into a new database table. | |||
</div> | |||
#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 | |||
3 | <code> | ||
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 | |||
</code> | |||
4. Click the Transfer Action Button. | |||
<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> | |||
*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. |
Latest revision as of 09:58, 29 January 2022
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.