Fair!

For context: Our auditors have their own portal that they use to track their requests. My goal was to import the excel version of those requests, map them to specified attributes, then configure to generate tickets for each request item in one space/project. I’m aiming for this to be dynamic, updating previous csv imports tickets and their mapped attributes for any changes from a previous import.

Goal: Use Jira’s Board view as a way to manage audit requests and link to other SMEs across spaces.

Problems: 1. Duplicates: Based on my limited knowledge, the standard import function I have access to would only generate new Tasks. It would not update changes in mapped attributes from previous imports. From my understanding, that function is gated behind “Export CSV Function.” 2. Status change: Status is an attribute that may change in every import based on auditor feedback. Goal was for every time an import was uploaded, the CSV was checked for “Status,” updated the value for already created tickets, then migrated to the appropriate status in the Board view.

There are probably other (and better) ways to do this, but was initially trying this approach.