CSV Transfer

From nuBuilderForte
Revision as of 09:33, 24 September 2021 by Admin (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, 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


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