Managing Timesheets Using CSV Files

Export timesheets of selected users to a CSV file.
The following items are exported to the CSV file

  • Login name
  • User name
  • Punched date
  • Start time
  • IP address of start time
  • End time
  • IP address of end time
  • Out time
  • IP address of out time
  • Back time
  • IP address of back time
  • Remarks

Exporting Each User's Data to a CSV File

Export the data from the timesheet of the selected users 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 Timesheet.

  5. Click "Timesheet List".

  6. On the "Timesheet list" screen, select the organization and the month of the user you want to export. Screenshot: The timesheet list screen with an organization and the month to export being highlighted

  7. On the "Timesheet" screen, click Export to CSV file. Screenshot: The timesheet list screen with the "Export to CSV file" action link highlighted

  8. On the "Export timesheet" screen, set the required items for the exported data.

    The setting fields are as follows:

    • Period to export:
      Select the range of data you want to export.
    • Character encoding:
      Select the character code that you want to use for encoding.
      The following character codes 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".

  9. Confirm your settings and click Export.

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

Exporting Multiple User Data to a CSV File

Exports the data from the timesheet of the selected users to one 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 Timesheet.

  5. Click Export Timesheet.

  6. On the "Export timesheet" screen, select the organizations and users who you want to export, and then click Add. Export timesheet screen

  7. Click "Next". Image of the Next button

  8. On the "Export timesheet" screen, set the required items for the exported data.

    The setting fields are as follows:

    • Period to export:
      Select the range of data you want to export.
    • Character encoding:
      Select the character code that you want to use for encoding.
      The following character codes 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".

  9. Confirm your settings and click Export.

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