PCJ-The custom field 'XXXX ' requires option 'YYYY' for the import but it does not exist in the current JIRA instance

import java.util.regex.Matcher
import java.util.regex.Pattern
import org.apache.log4j.Logger
import org.apache.log4j.Level

// Enable logging for the script
def log = Logger.getLogger("com.adaptavist.CustomFieldOptionEntitiesFixer")
log.setLevel(Level.DEBUG)

// Edit these constants if needed
final int MAX_ITERATIONS = 1
// Path for the entities.xml that caused custom field options errors
final String ENTITIES_PATH = "/tmp/entities.xml"
// Path for the new entities.xml file with those errors fixed
final String RESULT_PATH = "/tmp/entitiesFixed.xml"
// Path used for multiple iterations of this script (if necessary)
final String AUX_PATH = "/tmp/entitiesFixedAux.xml"

def currentIteration = 0
def lastPassWasAux = false
def resultIsFixed = false
def finalResultPath = RESULT_PATH
Map<String, String> blockingFieldConfigIdsToCorrectIds = [:]
// Regex pattern to detect FieldConfigSchemeIssueType lines and capture its fieldconfigscheme and fieldconfiguration ids
def fieldConfigSchemeIssueTypePattern =
        Pattern.compile($/.*<FieldConfigSchemeIssueType.*fieldconfigscheme="(\d*)".*fieldconfiguration="(\d*)".*/>.*/$)

// Initializes blockingFieldConfigIdsToCorrectIds map
def initBlockingFieldConfigIdsToCorrectIds = {
    def entitiesStream = new FileInputStream(ENTITIES_PATH)
    BufferedReader original = new BufferedReader(new InputStreamReader(entitiesStream))
    // Read the original file and find the field config ids that block the import
    // This is equivalent to running the query:
    // select * from fieldconfigschemeissuetype where fieldconfigscheme!=fieldconfiguration
    log.info "Finding blocking field config ids..."
    original.lines().each {
        Matcher match = fieldConfigSchemeIssueTypePattern.matcher(it)
        if (match.matches()) {
            def fieldConfigSchemeId = match.group(2)
            def fieldConfigurationId = match.group(1)
            if (fieldConfigSchemeId != fieldConfigurationId) {
                log.debug "  * " + match.group()
                blockingFieldConfigIdsToCorrectIds.put(
                        fieldConfigSchemeId,
                        fieldConfigurationId)
            }
        }
    }
    log.info "blockingFieldConfigIdsToCorrectIds: $blockingFieldConfigIdsToCorrectIds"
    original.close()
}

def executeOneIteration = { String entryFilePath, String resultFilePath ->
    log.info("Starting iteration #$currentIteration with entry file $entryFilePath and result file $resultFilePath")

    // Objects to read the entities.xml file
    def entitiesStream = new FileInputStream(entryFilePath)
    // Object to write into the new entities.xml file
    BufferedWriter entitiesFixed = new BufferedWriter(new FileWriter(resultFilePath))

    // Regex Pattern to detect CustomFieldOption lines
    def customFieldOptionPattern =
            Pattern.compile($/.*<CustomFieldOption.*customfieldconfig="(${String.join("|", blockingFieldConfigIdsToCorrectIds.keySet() as Collection)})".*/>.*/$)
    def customFieldValuePattern =
            Pattern.compile($/.*<CustomFieldOption.*value="([^"]*)".*/>.*/$)
    def fixedCustomFieldOptionValues = []

    log.info "Replacing blocking ids with correct ones..."

    // Reset the entities.xml reader to the start of the file
    entitiesStream.getChannel().position(0)
    BufferedReader original = new BufferedReader(new InputStreamReader(entitiesStream))

    // Read the original file again and copy it into the result file
    // This time, when we find a CustomFieldOption that points to a wrong customfieldconfig, we fix it before copying it
    original.lines().eachWithIndex{String line, int index ->
        Matcher match = customFieldOptionPattern.matcher(line)
        if(match.matches()){
            // Found a custom field value entry with wrong custom field config ids
            // Fix it and write the fixed entry
            def blockingId = match.group(1)
            def correctId = blockingFieldConfigIdsToCorrectIds.get(blockingId)
            def fixedLine = line.replace("customfieldconfig=\"$blockingId\"", "customfieldconfig=\"$correctId\"")

            log.debug "  * Found incorrect CustomFieldOption in line ${index + 1}" // +1 since file lines start at 1
            log.debug "        Original line: $line"
            log.debug "        Replacing customfieldconfig id $blockingId with $correctId"

            def valueMatch = customFieldValuePattern.matcher(line)
            if(valueMatch.matches()){
                fixedCustomFieldOptionValues.add(valueMatch.group(1))
            }

            entitiesFixed.write(fixedLine)
        } else {
            // Write every other line as-is
            entitiesFixed.write(line)
        }
        // Keep line separators between lines
        entitiesFixed.write("\n")
    }

    // Check if no more Custom Field Values need fixing
    if(fixedCustomFieldOptionValues.isEmpty()){
        resultIsFixed = true
        log.info("No more Custom Field Values needed to be fixed!")
        finalResultPath = lastPassWasAux ? AUX_PATH : RESULT_PATH
        return resultIsFixed
    }

    // Show the Custom Field Values fixed identified by their values
    log.info("Custom Field Values fixed: $fixedCustomFieldOptionValues")

    // Close both file readers to prevent memory errors
    log.debug "Closing files..."
    original.close()
    entitiesFixed.close()

    currentIteration++
    return resultIsFixed
}

// First iteration, this will always happen
initBlockingFieldConfigIdsToCorrectIds()
resultIsFixed = executeOneIteration(ENTITIES_PATH, RESULT_PATH)

// Additional iterations
while(currentIteration < MAX_ITERATIONS && !resultIsFixed){
    if(lastPassWasAux){
        resultIsFixed = executeOneIteration(AUX_PATH, RESULT_PATH)
    } else {
        resultIsFixed = executeOneIteration(RESULT_PATH, AUX_PATH)
    }
    // invert lastPassWasAux value
    lastPassWasAux = !lastPassWasAux
}

// Show where the resulting file was saved
log.info "Final fixed file is '$finalResultPath'"
return "Final fixed file is '$finalResultPath' - Please check the logs tab for the full output"

import java.util.regex.Matcher
import java.util.regex.Pattern

// Edit these constants if needed
final int MAX_ITERATIONS = 1
// Path for the entities.xml that caused custom field options errors
final String ENTITIES_PATH = "/tmp/entities.xml"
// Path for the new entities.xml file with those errors fixed
final String RESULT_PATH = "/tmp/entitiesFixed.xml"
// Path used for multiple iterations of this script (if necessary)
final String AUX_PATH = "/tmp/entitiesFixedAux.xml"

def currentIteration = 0
def lastPassWasAux = false
def resultIsFixed = false
def finalResultPath = RESULT_PATH
Map<String, String> blockingFieldConfigIdsToCorrectIds = [:]
// Regex pattern to detect FieldConfigSchemeIssueType lines and capture its fieldconfigscheme and fieldconfiguration ids
def fieldConfigSchemeIssueTypePattern =
        Pattern.compile($/.*<FieldConfigSchemeIssueType.*fieldconfigscheme="(\d*)".*fieldconfiguration="(\d*)".*/>.*/$)

// Initializes blockingFieldConfigIdsToCorrectIds map
def initBlockingFieldConfigIdsToCorrectIds = {
    def entitiesStream = new FileInputStream(ENTITIES_PATH)
    BufferedReader original = new BufferedReader(new InputStreamReader(entitiesStream))
    // Read the original file and find the field config ids that block the import
    // This is equivalent to running the query:
    // select * from fieldconfigschemeissuetype where fieldconfigscheme!=fieldconfiguration
    println "Finding blocking field config ids..."
    original.lines().each {
        Matcher match = fieldConfigSchemeIssueTypePattern.matcher(it)
        if (match.matches()) {
            def fieldConfigSchemeId = match.group(2)
            def fieldConfigurationId = match.group(1)
            if (fieldConfigSchemeId != fieldConfigurationId) {
                println "  * " + match.group()
                blockingFieldConfigIdsToCorrectIds.put(
                        fieldConfigSchemeId,
                        fieldConfigurationId)
            }
        }
    }
    println "blockingFieldConfigIdsToCorrectIds: $blockingFieldConfigIdsToCorrectIds"
    original.close()
}

def executeOneIteration = { String entryFilePath, String resultFilePath ->
    println("Starting iteration #$currentIteration with entry file $entryFilePath and result file $resultFilePath")

    // Objects to read the entities.xml file
    def entitiesStream = new FileInputStream(entryFilePath)
    // Object to write into the new entities.xml file
    BufferedWriter entitiesFixed = new BufferedWriter(new FileWriter(resultFilePath))

    // Regex Pattern to detect CustomFieldOption lines
    def customFieldOptionPattern =
            Pattern.compile($/.*<CustomFieldOption.*customfieldconfig="(${String.join("|", blockingFieldConfigIdsToCorrectIds.keySet() as Collection)})".*/>.*/$)
    def customFieldValuePattern =
            Pattern.compile($/.*<CustomFieldOption.*value="([^"]*)".*/>.*/$)
    def fixedCustomFieldOptionValues = []

    println "Replacing blocking ids with correct ones..."

    // Reset the entities.xml reader to the start of the file
    entitiesStream.getChannel().position(0)
    BufferedReader original = new BufferedReader(new InputStreamReader(entitiesStream))

    // Read the original file again and copy it into the result file
    // This time, when we find a CustomFieldOption that points to a wrong customfieldconfig, we fix it before copying it
    original.lines().eachWithIndex{String line, int index ->
        Matcher match = customFieldOptionPattern.matcher(line)
        if(match.matches()){
            // Found a custom field value entry with wrong custom field config ids
            // Fix it and write the fixed entry
            def blockingId = match.group(1)
            def correctId = blockingFieldConfigIdsToCorrectIds.get(blockingId)
            def fixedLine = line.replace("customfieldconfig=\"$blockingId\"", "customfieldconfig=\"$correctId\"")

            println "  * Found incorrect CustomFieldOption in line ${index + 1}" // +1 since file lines start at 1
            println "        Original line: $line"
            println "        Replacing customfieldconfig id $blockingId with $correctId"

            def valueMatch = customFieldValuePattern.matcher(line)
            if(valueMatch.matches()){
                fixedCustomFieldOptionValues.add(valueMatch.group(1))
            }

            entitiesFixed.write(fixedLine)
        } else {
            // Write every other line as-is
            entitiesFixed.write(line)
        }
        // Keep line separators between lines
        entitiesFixed.write("\n")
    }

    // Check if no more Custom Field Values need fixing
    if(fixedCustomFieldOptionValues.isEmpty()){
        resultIsFixed = true
        println("No more Custom Field Values needed to be fixed!")
        finalResultPath = lastPassWasAux ? AUX_PATH : RESULT_PATH
        return resultIsFixed
    }

    // Show the Custom Field Values fixed identified by their values
    println("Custom Field Values fixed: $fixedCustomFieldOptionValues")

    // Close both file readers to prevent memory errors
    println "Closing files..."
    original.close()
    entitiesFixed.close()

    currentIteration++
    return resultIsFixed
}

// First iteration, this will always happen
initBlockingFieldConfigIdsToCorrectIds()
resultIsFixed = executeOneIteration(ENTITIES_PATH, RESULT_PATH)

// Additional iterations
while(currentIteration < MAX_ITERATIONS && !resultIsFixed){
    if(lastPassWasAux){
        resultIsFixed = executeOneIteration(AUX_PATH, RESULT_PATH)
    } else {
        resultIsFixed = executeOneIteration(RESULT_PATH, AUX_PATH)
    }
    // invert lastPassWasAux value
    lastPassWasAux = !lastPassWasAux
}

// Show where the resulting file was saved
println "Final fixed file is '$finalResultPath'"
return "Final fixed file is '$finalResultPath' - Please check the logs tab for the full output"