Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Importing CVS to spent programming time.

jvmvargas
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 13, 2019

I'm new in JIRA and I'll like to import CSV files to register the spent time for programming.

1 answer

0 votes
Petter Gonçalves
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
August 14, 2019

Hello @jvmvargas,

Welcome to Atlassian Community!

You can easily import work log entries to your existing issues using CSV by mapping the issue key in the file when importing it. Basically, these would be the steps:

- Export the issues you want to update with the work logs by configuring a JQL filter. Using this file to upload the entries will avoid you to miss any details or the issue key in the import:

Screen Shot 2019-08-14 at 18.37.57.png

- Edit this file with the work log entries, using the format below (In seconds)

Summary,Worklog
Only time spent (one hour),3600
With a date and an author,2012-02-10 12:30:10;wseliga;120
With an additional comment,Testing took me 3 days;2012-02-10 12:30:10;wseliga;259200

- Import the file back in your site, by navigating to JIRA Settings > System > External System Import > CSV

For more information about CSV import, you can check the documentation below:

Import Data from CSV

Let me know if you have any questions.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events