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 System settings.

  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 organization of the user and the month are selected on the "Timesheets" screen

  7. On the "Timesheet" screen, click "Export to CSV file".

    Screenshot: An action link to export data to a CSV file is highlighted on the "Timesheet" screen

  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.
      • Unicode (UTF-8)
        You can select with BOM as required.
      • 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: The "Export timesheet data" screen

  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 System settings.

  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.
      • Unicode (UTF-8)
        You can select with BOM as required.
      • 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: The "Export timesheet data" screen

  9. Confirm your settings and click Export.

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