Difference between revisions of "CSV Transfer"

From nuBuilderForte
Jump to: navigation, search
 
(10 intermediate revisions by 2 users not shown)
Line 1: Line 1:
The CSV Transfer Form Allows...
+
Back to [[Documentation]]
  
 +
== The CSV Transfer Form Functionality ==
  
Exporting a database table to a CSV file.
+
* Exporting a database table to a CSV file.
 +
* Importing CSV files to a new database table.
 +
* [https://forums.nubuilder.com/viewtopic.php?f=19&t=10821 Forum Post] - '''user''' access to CSV Transfer, generally limited to '''globeadmin'''.
  
Importing CSV files to a new database table.
+
=== 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.
  
'''Exporting a CSV File requires the following steps...'''
+
=== Importing a CSV File requisites ===
  
1. Export to CSV File. Choose the CSV file from the nuScroll list.
+
<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>
  
2. Delimiter. Choose the Delimiter to space each field value.
+
#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.
  
3. Import to (CSV). Enter a filename for the new CSV file.
+
=== Importing Users ===
  
4. Click the Transfer Action Button.
+
Importing Users can be done by...
 +
 
 +
 
 +
*Creating a CSV file with the following format
 +
 
 +
 
 +
 
 +
<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>
  
'''Importing a CSV File requires the following steps...'''
 
  
1. Import from CSV File. Choose the database table from the nuScroll list.
 
  
 
<div style='background-color:#D8E4FF;padding:10px'>
 
<div style='background-color:#D8E4FF;padding:10px'>
To appear in the nuScroll List the CSV File must be placed in the '''csvfiles''' subdirectory inside nuBuilder Forte's directory - on the server.
+
 
 +
*'''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>
 
</div>
  
2. Delimiter. Choose the Delimiter to space each field value.
 
  
3. Import to (Table). Enter a filename for the new CSV file.
 
  
4. Click the Transfer Action Button.
+
*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:33, 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

  1. Export to CSV File. Choose the CSV file from the nuScroll list.
  2. Delimiter. Choose the Delimiter to space each field value.
  3. Import to (CSV). Enter a filename for the new CSV file.
  4. 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.

  1. Import from CSV File. Choose the database table from the nuScroll list.
  2. Delimiter. Choose the Delimiter to space each field value.
  3. Import to (Table). Enter a filename for the new CSV file.
  4. 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.