...
On this page: |
|---|
| Anchor | ||||
|---|---|---|---|---|
|
Importing time via the Timetracker UI (Times Explorer page)
Importing worklogs via the Timetracker UI can be done from the Times Explorer page. In order to import worklogs that you have tracked outside of 7pace Timetracker, you simply copy data from the source application (like Excel) and paste it into the "Import Times" popup window of the Times Explorer page. You then associate each worklog detail to the specific field in the Timetracker database. Once verified, the imported worklogs are stored in our database.
Import can be performed via the UI, but it can also be performed by using the workLogs endpoint from our REST CRUD API and also our NPM package.
If the system finds any errors, the import process will stop and the errors will display for you to correct before attempting to import again.
...
Templates for Date/Time Formats
Date Format | Time Format |
MM/dd/yyyy | h:mm tt |
dd.MM.yyyy | HH:mm |
yyyy-MM-dd | HH:mm |
7. Copy-paste the Date Format and Time Format of your choice into the corresponding fields.
...
Once the time details are successfully imported, you can view these details on the "Times Explorer" page.
| Anchor | ||||
|---|---|---|---|---|
|
Import Time (Worklogs) via REST CRUD API (NPM Package)
We have created an NPM package that can be used to import worklogs which utilizes our CRUD API.
timetracker-npm-import is a Node.js CLI for importing worklogs(csv/excel) to 7pace Timetracker.
The NPM package is distributed ‘as is’ and will not be developed further, since it was created solely as a showcase of how to use our CRUD API.
| Anchor | ||||
|---|---|---|---|---|
|
Import Time (Worklogs) via REST CRUD API Manually
You can also manually enter worklogs for specific users by using the REST CRUD API.
The endpoint that you will need to use is the workLogs endpoint and you will have to specify the parameters in the JSON body part of your POST request, as in the example below. Please note that the length field is in seconds, so you will need to account for that:
POST
...
https://{your-organization}.timehub.7pace.com/api/rest/workLogs?api-version={version}
JSON
...
body
...
to
...
create
...
worklog:
{
...
"timeStamp":
...
"2023-10-16T12:30:00.921Z",
...
"length":
...
14400,
"billableLength":
...
0,
...
"workItemId":
...
7,
"comment":
...
"string",
"userId":
...
"3fa85f64-5717-4562-b3fc-2c963f66afa6",
"activityTypeId":
...
"3fa85f64-5717-4562-b3fc-2c963f66afa6"
}