bulk modify custom link

[JG]

I have a external defect system (not JIRA) which managed production issues. .e.g CustSys

internally, we have JIRA for dev team.

then with a custom field CustSysURL then we manually paste the URL to this custom field.

Currently, the external defect system is migrated to JIRA. e,g, NewCustJira

now we have both systems running on JIRA (different instances).

in dev team JIRA, how do I bulk update the CustSysURL in order to reference to the "NewCustJira"?

[Renata_Getint · Accepted solution]

Hi there!

You can streamline this bulk update process in Jira by following these steps:

1. Export Issues with CustSysURL

• Use Jira's issue search (via Filters > Advanced Issue Search) to filter issues where the CustSysURL field is populated.
• Export the filtered results (e.g., to a CSV file) by clicking the Export option.

2. Map the URLs to NewCustJira

• In the exported file, replace the old CustSysURL values with the corresponding URLs for the "NewCustJira" instance. You can use tools like Excel or scripts for this transformation.

3. Prepare the CSV for Reimport

• Ensure the CSV includes columns for the Issue Key and the updated CustSysURL.
• Format the file to comply with Jira's import requirements. Include only the fields you need to update.

4. Bulk Update via CSV Import

• Navigate to Jira Administration > System > External System Import > CSV.
• Upload your updated CSV and map the fields accordingly.
• Test the import with a few records first (e.g., by limiting the CSV to a small subset) to ensure accuracy.

5. Automate with an Integration Tool (Optional)

If manual updates aren't feasible or scalable, consider using integration tools like Getint or ScriptRunner to automate the updates:

• Getint: With Getint's integration services, you can synchronize and transform data between Jira instances. Our solution supports automated field updates, making it perfect for such bulk transformations.
• ScriptRunner: For a more hands-on approach, create a Groovy script to update the CustSysURL field programmatically.

[JG]

I have tried your method.

during csv import, i select 'summary' and 'CustSysURL' to map only.

then message is displayed:

1 projects and 1 issues imported successfully!

however, i refresh the particular ticket, the URL is still old one.

[JG]

I realize there is a 'Map field value' checkbox, what is this for? am I need to tick it?

[JG]

anyway, i make it works. the 'Map field value' checkbox must ticked. then the new value got inserted.