CSV Transfer: Difference between revisions
No edit summary |
|||
Line 30: | Line 30: | ||
Importing Users can be done by... | Importing Users can be done by... | ||
*Creating a CSV file with the following format | |||
<code> | <code> | ||
Line 41: | Line 41: | ||
</code> | </code> | ||
*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. |
Revision as of 00:48, 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
- 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.