CSV Transfer

From nuBuilderForte
Jump to navigation Jump to search

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.