I have alot of data inside the customer field and want to change all from lower case to upper case using Bulk update. Please advise
Hello,
You can do it with the Power Scripts add-on.
Your script would look like this:
string [] keys = selectIssues("yourcustomfield is not Empty");
for(string k in keys) {
%k%.yourcustomfield =toUpper(
%k%.yourcustomfield)
}
Bulk update can only 'set' field values. You'll not find an Upper Case or Lower Case method. The only option would be to use a scripting addon or use the REST API to read out the values, manipulate them, and put them back.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
My vote also goes for a scripting add-on. You do not need to purchase one, but highly suggested.
Simple script would do.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Agreed -- This level of work would be difficult without either a plugin or a good knowledge of CURL to send API commands.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, that is what I thought. Alot of data is already loaded in the system via Bulk, then they realized now that some of the items are in lower case.
How about exporting the data > delete>modify >upload? I am new to Jira, so I am not sure if there is an export custom fields functions and mass delete.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can use the CSV Export to export to a spreadsheet. You can manipulate this in any program, and then Jira Administrators can use the CSV Import to overwrite existing issues.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I just had to do this and it works great:
Customize as needed.
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.