Export Table Data (CSV)

Export Data (CSV)

  1. Click 'Table management' in "Manage" screen, and then 'Table management' view is opened.
../../../_images/img_01.en221.png
  1. Select table to export data, and then right-click 'Export table data' menu.
../../../_images/img_02.en206.png

Tip

Only the table data from CELF database (default) in ‘Database to connect to’ can be exported.

  1. Configure export settings in the 'Export table data' dialog.
../../../_images/img_03.en170.png

[1] File name

Specify output location to export table data file (.csv).

[2] Char encoding of the file (Initial Setting: Shift-JIS)

Specify the character encoding of the file to be exported.

Attention

  • If a character that cannot be expressed in the specified character encoding is included in the table data, it is converted to ‘?’.
  • The data of tables starting with sys_ can be exported. However they cannot be imported.
  1. Click the 'Output' button.

Important

To export table data, users require the following permissions.

  • Application author
  • Database administrator

And also, Application author needs below permission to tables.

  • Administrator

Regarding permission to tables, refer Set Permission for table Setting.

../../../_images/celf_help_mascot46.png

Related keywords

output, format, comma, separate, separator, delimiter