Managing Events in CSV Files

Manage event data for My Calendar in CSV files.

Importing Data from a CSV File

Import the event data from CSV files.

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

  2. Click User name in the header. Screenshot: User name in the header is highlighted on the top page of Garoon

  3. Click Personal Settings. Screenshot: The Personal Settings action link is highlighted in the dropdown list of the user name

  4. Click "Common settings".

  5. Click Calendar.

  6. Click My calendar settings.

  7. On the "My calendar settings" screen, click Import events data.

    Image of the action link for importing events

  8. On the screen to "import events step 1/2", select the CSV file that you created in step 1.

  9. Set the data to import, and 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:
      • Unicode (UTF-8)
      • Japanese (Shift-JIS)
      • ASCII
      • English (Latin1)
      • Simplified Chinese (GBK/GB2312)
      • Thai (TIS-620)
    • Skip the first row:
      If the header row contains information other than data such as an item name and a comment, select "Yes".
    Screenshot: "Import events data" screen

  10. On the screen to "import events step 2/2", check the contents of the CSV file, and click Import.

Exporting Data to a CSV File

Export the e-mail data to a CSV file.

Steps:
  1. Click User name in the header. Screenshot: User name in the header is highlighted on the top page of Garoon

  2. Click Personal Settings. Screenshot: The Personal Settings action link is highlighted in the dropdown list of the user name

  3. Click "Common settings".

  4. Click Calendar.

  5. Click My calendar settings.

  6. On the "My calendar settings" screen, click Export events data.

    Image of the action link for exporting events

  7. On the screen to export events, set the required items for the exported data.

    The setting fields are as follows:

    • Period to export:
      Specify all periods or a period to export.
    • Character encoding:
      Encodes data from a CSV file with the selected character code.
      The following character codes can be selected.
      • Unicode (UTF-8)
      • Japanese (Shift-JIS)
      • ASCII
      • English (Latin1)
      • Simplified Chinese (GBK/GB2312)
      • Thai (TIS-620)  
    • Include header row:
      To export an item name to the header row of a CSV file, select "Yes".
    Screenshot: "Export events data" screen

  8. Confirm your settings and click "Export".

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