27.3.3. Exporting Timesheet

Timesheet data can be exported to MS Excel format for reporting. You can export individual timesheets or export bulk timesheets at once.

After logging in to OfficeClip, select Timesheets from the menu, and then click Import/Export.

If you select Individual timesheet report link, you can generate a timesheet report for a given user for a specific time period. You can select the details to be included in the report. Choose the date range and select the users using the checkbox, and click Continue. Click Select all to select all users at a time. Click Clear all to clear the selections. If there is no timesheet the following message is displayed: There is no timesheet in the system for the selected period.

To export timesheet details for multiple users to a comma separated (CSV) file, select the Bulk Timesheet Export link. There is a provision for exporting only approved timesheets, which you can select by checking the box. Choose the date range and select the users, then click Continue. In following screen you can rename the fields and move the fields as you wish them to appear in the report. Click on theorbutton to move the fields up or down the list, determining their order on the exported Excel sheet. In the top section, select the checkbox, if you want the column names to appear as first row in the comma separated file. Click Export to view or save as an Excel file.

See Also:

Creating a Timesheet

Inbox/Outbox Portlet

Reports

Shared Items

Importing TrackTime