Managing Permissions Using CSV Files

You can use CSV files to manage applications that you allow users to use in KUNAI.

Importing Data from a CSV File

Import permissions from a CSV file.
If an error occurs while importing a CSV file, the import process will be terminated. The data which has been imported will be eliminated.

Steps:

  1. Create a CSV file to import data.

    For information on items that can be managed using CSV files, refer to the CSV format in KUNAI.

  2. Click the Administration menu icon (gear icon) in the header.

  3. Click Garoon System Administration.

  4. Select "Application settings" tab.

  5. Click KUNAI.

  6. Click Import permission settings.

  7. On the screen to import permissions step 1/2, select the CSV file created in step 1.

  8. Set the required items for the data to import, and then click Next.

    The setting fields are as follows:

    • Character encoding:
      Encodes data from a CSV file with the selected character code.
      The following character encoding can be selected:
      • UTF-8 (Unicode)
      • Shift-JIS (Japanese)
      • ASCII
      • Latin1 (Western European)
      • GBK/GB2312 (Simplified Chinese)
      • TIS-620 (Thai)
    • Skip the first row:
      If the header row contains information other than data such as an item name and a comment, select "Yes".

  9. On the "Import permission settings - Step 2/2" screen, confirm the contents in the CSV file and click Import.

Exporting Data to a CSV File

Export permissions to a CSV file.

Steps:

  1. Click the Administration menu icon (gear icon) in the header.

  2. Click Garoon System Administration.

  3. Select "Application settings" tab.

  4. Click KUNAI.

  5. Click Export permission settings.

  6. Set the required items for the data to export.

    The setting fields are as follows:

    • Character encoding:
      Select the character code that you want to use for encoding.
      The following character encoding can be selected:
      • UTF-8 (Unicode)
        You can select with BOM as required.
      • Shift-JIS (Japanese)
      • ASCII
      • Latin1 (Western European)
      • GBK/GB2312 (Simplified Chinese)
      • TIS-620 (Thai)
    • Include header row:
      To export an item name to the header row of a CSV file, select "Yes".

  7. Confirm your settings and click Export.

  8. Save the file with a function provided by your Web browser.