Forums

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

How to handle date data with different date format when batch import from csv file

Lin, Lijun July 11, 2023

Hi,

I got a CSV file with different format date data,like"yyyy-MM-dd" and "yyyy-MM-dd hh:mm:ss".Now,I created two extra fields to my issues,one "Date Picker",the other "Date Time Picker".I want to map "yyyy-MM-dd" date data into "Date Picker" field,"yyyy-MM-dd hh:mm:ss" go into "Date Time Picker" field.The problem is Jira can only specify one date format when I import issues from a CSV file.When a date with a date format not align to the specified format,a warning will be produced and that date data will be get lost.Is there a way for me to specify different conversion formats for different dates.

001.jpg

002.jpg

003.jpg

 

2 answers

0 votes
Jens Schumacher - Released_so
Community Champion
July 12, 2023

You could try to format all in the same way. You could run GPT over your file and asked it to re-write the date without the timestamp, or write a script with a regular expression to add the time format. 

0 votes
Mohanraj Thangamuthu
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 11, 2023

Hello, have you tried the format : yyyy-MM-dd already ?

Please refer to this doc once.

Lin, Lijun July 11, 2023

Yes,I have tried the format "yyyy-MM-dd",and for "yyyy-MM-dd hh:mm:ss" data, i just got "yyyy-MM-dd" part, the "hh:mm:ss" part lost.

001.jpg

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
atlassian, jira service management, jsm webinar, ai in jsm, opsgenie integration, incident management, virtual agent, atlassian intelligence, ai-powered service desk, it operations, atlassian learning, service management webinar, team '25 recap

What’s new in Jira Service Management 🤔

Discover how Atlassian is revolutionizing service management with cutting-edge solutions for AI-powered support, HR Service Management, or DevOps connectivity.

Register here ⬇️
AUG Leaders

Atlassian Community Events