The issues are created by CSV import.
An automation rule should trigger to sum up all the original estimate and remaining estimate of the child issues to the parent
Now the original estimate and remaining estimate of subtask should be updated to Story which inturn update Epic.
When work effort is logged to the subtask, an automation rule should trigger to calculated the remaining estimate update the subtask , story and Epic.
How to create the automation rule?
Even if we built this automation, it won't trigger as automation rules don't trigger on CSV import.
If you want this on the issue, make sure there is a field for this in Jira and set that field as a column in your CSV, with the calculated value.
Than you have in on the issue.
If we should create an automation rule to do this, then this would only trigger when you update an issue in Jira or change a field value in Jira.
In Automation Trigger there is a option "Issue Created" . I hope this will trigger the Automation rule.
There is a field called Original Estimate and Time Remaining. I have given it in the CSV screenshot
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Not on creating issues via CSV import, only if you create issues via the GUI or API
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, and...to the suggestions from @Marc - Devoteam
There are many posts in the community for a similar scenario. I recommend searching the posts to find example rules as a starting point, try to build your rule, and then ask for help if it does not work as expected.
Successfully using automation rules requires learning and experimentation. When one just uses rules created by others without understanding them, they will be unable to maintain them.
Kind regards,
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the input @Bill Sheboy I have gone through many article here regarding this and I have created rule to update the sum. I didn't get a clear answer whether it possible through automation.
One level updation is happening. From subtask to story but not story to Epic. More over with the given CSV screenshot, the time remaining is not updating and remains 0.
When I create manually , whatever estimate I gave in Original estimate will get updated in the time remaining field. But while importing the issues its not updating the time remaining field. Its shows 0. I think its because of the below warning
Please do suggest a way around to accomplish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As I explained.
Import via CSV doesn't trigger automation rules. It creates issues with the information provided in the CSV.
That's all what will happen.
If you then create an automation rule to execute a math function, this will only trigger when you make a change on an issue in Jira
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Import with a CSV file does fire the event and can trigger a rule with Issue Created.
I hypothesize the challenge for your scenario is some data is updated after the issue is created (which is the same thing as when this happens in the UX). You will need to experiment to confirm if the issue history shows multiple events when importing those fields.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.