The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

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

Import csv with scripted field

Itamar Ben Sinai
Contributor
January 10, 2016

I need to make calculation based on existing dates from cf , compare with the dates from the csv imported dates and insert a busy/available text on the scripted field

Howccancthat be achieved? 

1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes
Vasiliy Zverev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
January 11, 2016

Lets specify a trouble at first.

  1. You have some dates into custom field. 
  2. You also have other dates form csv. Are these dates already imported into JIRA into sertain customfield or these dates are stored into csv.
  3. If you need to compare two dates into different customfileds try adapt folloeing script

    long DateDiff = 0;
    if( (getCustomFieldValue(10105) != null) & (getCustomFieldValue(12700) != null))   
    	DateDiff = (getCustomFieldValue(10105).getTime() -  getCustomFieldValue(12700).getTime())/(24*60*60*1000);
    return (String) DateDiff