How to migrate historical JIRA tickets to Servicenow

[Community Alums]

How to migrate historical JIRA tickets to Servicenow, along with all of JIRA comments and attachments and all its data.

My plan is to create a snow catalog so that users will be able to create issues directly in Servicenow. And maybe i will be creating a custom table to store the variable datas from the RITMs there.

But my main concern is how to migrate the old JIRA tickets to servicenow ? 

Please help.

[James Schwab]

Hi SamiranD,

The most efficient way to do this type of one-off activity would be via an CSV Import and Transform Map.

You will need to do an exercise outside of ServiceNow where you export your JIRA tickets in a CSV or Excel format, and change the column headings to map them to what you would like them to be in ServiceNow on either your Request table or Requested Item table.

Once you have prepared your CSV file, please see the below resource on how to Import Data into your instance:

https://developer.servicenow.com/dev.do#!/learn/learning-plans/washingtondc/servicenow_application_d...

Good Luck!

[Community Alums]

By following this method, will it be possible to migrate the attachments and comments also from JIRA to SNOW.?

[James Schwab]

Hi SamiranD,

1. Uploading Attachments - This can be tricky to do on bulk depending on your volume. If you need to do it programmatically, try using a PowerShell implementation like this -https://www.servicenow.com/community/developer-articles/bulk-loading-attachments-to-servicenow-with-...
2. Comments - You could migrate this in a few ways, but I would recommend creating a field like "Historical Notes" and uploading the full history via a Transform Map. If you need to replicate your comment stream exactly, then you could try uploading to the sys_journal_field but it would not be recommended.