Difference between revisions of "CSV Transfer"

From nuBuilderForte
Jump to: navigation, search
(The CSV Transfer Form Functionality)
Line 30: Line 30:
 
Importing Users can be done by...
 
Importing Users can be done by...
  
#Creating a CSV file with the following format
+
*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.
+
*Place this file in the ''temp'' directory where nuBuilder is installed.
#Import from CSV File. Choose ''zzzzsys_user'' from the nuScroll list.
+
*Import from CSV File. Choose ''zzzzsys_user'' from the nuScroll list.
#Delimiter. Choose Comma.
+
*Delimiter. Choose Comma.
#Import to (Table). The name of the file above.
+
*Import to (Table). The name of the file above.
#Click the Transfer Action Button.
+
*Click the Transfer Action Button.

Revision as of 09:18, 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

  • 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.