CSV Transfer: Difference between revisions
No edit summary |
|||
Line 5: | Line 5: | ||
* Exporting a database table to a CSV file. | * Exporting a database table to a CSV file. | ||
* Importing CSV files to a new database table. | * Importing CSV files to a new database table. | ||
* [https://forums.nubuilder. | * [https://forums.nubuilder.cloud/viewtopic.php?f=19&t=10821 Forum Post] - '''user''' access to CSV Transfer, generally limited to '''globeadmin'''. | ||
=== Exporting a CSV File requisites === | === Exporting a CSV File requisites === |
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.