nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Import via csv a work log with both worked and billed time

Filipe Pereira

I can already import a csv file with the work log with worked time, as follows:

issue_key,pj_name,pj_key,Summary,Worklog
RM2FO-588,RM 2.0 FO,RM2FO,Desc1,Test;20110802;user;1800

But haven't found a way to import the billed time to the same work log.

Is it possible to import billed time in CSV?

image2015-8-22 1:3:19.png

Accepted answers

darrenpegg

If you want to import this into tempo with a check box that can be used for Billed time.. I think you are out of luck.

Upload Billed Time into another Custom Field and add this to TEMPO as exported field and create a Billed Time tag in TEMPO going forward.
Or
Add time spent and billed time together in seconds format and upload via CSV

All comments

darrenpegg

If you want to import this into tempo with a check box that can be used for Billed time.. I think you are out of luck.

Upload Billed Time into another Custom Field and add this to TEMPO as exported field and create a Billed Time tag in TEMPO going forward.
Or
Add time spent and billed time together in seconds format and upload via CSV

Filipe Pereira

When I Log work manually the billed field is available, what you're saying is that I can't import both the worked and billed by CSV. Ex: worked = 150 min; billed = 120 min

darrenpegg

Worked = Time Spent (Native to JIRA) Billed is configured by Tempo?

darrenpegg

I think only via JSON you will be able to import into Tempo as it will need to be direct. Worked relates to Time Spent a JIRA field. I'm pretty sure it's not possible via CSV

darrenpegg

For historical data just create a custom field.. for this Billed Time and use the Billed Time in Worklog which is tempo going forward. You can still associate the custom field with a TEMPO export

Filipe Pereira

Yes, and its used in the imesheets reports for tempo

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud