Extract and Export Qualtrics Add Contacts and Transactions to XMD Task Field Mappings to CSV

// ============================================================================
// QUALTRICS XMD TRANSACTION MAPPING EXTRACTOR v3.0 (Resilient)
// Extracts field mappings from "Add contacts and transactions to XMD" task
// Uses stable data-testid attributes with fallbacks
// ============================================================================

// ============================================================================
// UTILITY: RESILIENT SELECTORS
// ============================================================================

const XMD_SELECTORS = {
    table: [
        'div[data-testid="data-mapper-table-test-id"]',
        'div[role="grid"][aria-label="data-mapper-table"]'
    ],
    rows: [
        'div[data-testid^="data-mapper-table-test-id-row-"]',
        'div[role="row"]:has(button[data-testid^="source-field-dropdown-"])'
    ],
    sourceFieldButton: [
        'button[data-testid^="source-field-dropdown-"]',
        'button[role="combobox"][aria-haspopup="menu"]'
    ],
    dataProjectFieldInput: [
        'input[data-testid="destination-field-combo-input"]',
        'div[data-testid^="destination-field-combo-"] input[type="text"]'
    ],
    fieldTypeButton: [
        'button[role="combobox"][aria-haspopup="listbox"]',
        'button:has(span:contains("Contact data"), span:contains("Transaction data"))'
    ],
    moreOptionsButton: [
        'button[data-testid^="data-mapper-row-ellipsis-"]',
        'button[aria-label="more"]'
    ]
};

function findElement(parent, selectorArray) {
    for (const selector of selectorArray) {
        try {
            const element = parent.querySelector(selector);
            if (element) return element;
        } catch (e) {
            continue;
        }
    }
    return null;
}

function findElements(parent, selectorArray) {
    for (const selector of selectorArray) {
        try {
            const elements = parent.querySelectorAll(selector);
            if (elements.length > 0) return elements;
        } catch (e) {
            continue;
        }
    }
    return [];
}

// ============================================================================
// EXTRACTION FUNCTION (Resilient)
// ============================================================================

function extractXMDTransactionMappings() {
    console.log('\n🔍 Extracting XMD Transaction Mappings...\n');
    
    const mappings = [];
    
    // Find the main table
    const table = findElement(document, XMD_SELECTORS.table);
    if (!table) {
        console.error('❌ XMD transaction table not found');
        return mappings;
    }
    
    // Find all data rows (skip header row)
    const rows = findElements(table, XMD_SELECTORS.rows);
    
    if (rows.length === 0) {
        console.warn('⚠️ No mapping rows found');
        return mappings;
    }
    
    rows.forEach((row, index) => {
        // Extract Source Field
        let sourceField = '';
        const sourceButton = findElement(row, XMD_SELECTORS.sourceFieldButton);
        if (sourceButton) {
            const span = sourceButton.querySelector('span._7CkrI, span');
            sourceField = span?.textContent?.trim() || '';
        }
        
        // Extract Data Project Field
        let dataProjectField = '';
        const dataProjectInput = findElement(row, XMD_SELECTORS.dataProjectFieldInput);
        if (dataProjectInput) {
            dataProjectField = dataProjectInput.value || '';
        }
        
        // Extract Field Type
        let fieldType = '';
        const fieldTypeButton = findElement(row, XMD_SELECTORS.fieldTypeButton);
        if (fieldTypeButton) {
            const span = fieldTypeButton.querySelector('span._NQTya, span');
            fieldType = span?.textContent?.trim() || '';
        }
        
        // Only add if at least source field exists
        if (sourceField) {
            mappings.push({
                index: mappings.length + 1,
                sourceField: sourceField,
                dataProjectField: dataProjectField,
                fieldType: fieldType
            });
        }
    });
    
    console.log(`✅ Found ${mappings.length} field mappings\n`);
    return mappings;
}

// ============================================================================
// EXPORT FUNCTIONS
// ============================================================================

function downloadXMDTransactionCSV() {
    const mappings = extractXMDTransactionMappings();
    
    if (mappings.length === 0) {
        console.error('❌ No mappings found to export');
        return;
    }
    
    // Create CSV header
    const headers = ['Index', 'Source Field', 'Data Project Field', 'Field Type'];
    const csvRows = [headers];
    
    // Add data rows
    mappings.forEach(mapping => {
        csvRows.push([
            mapping.index,
            mapping.sourceField,
            mapping.dataProjectField,
            mapping.fieldType
        ]);
    });
    
    // Convert to CSV string
    const csvContent = csvRows.map(row => 
        row.map(cell => `"${cell}"`).join(',')
    ).join('\n');
    
    // Download
    const blob = new Blob([csvContent], { type: 'text/csv;charset=utf-8;' });
    const link = document.createElement('a');
    const url = URL.createObjectURL(blob);
    const timestamp = new Date().toISOString().slice(0, 19).replace(/:/g, '-');
    
    link.setAttribute('href', url);
    link.setAttribute('download', `xmd_transaction_mappings_${timestamp}.csv`);
    link.style.visibility = 'hidden';
    document.body.appendChild(link);
    link.click();
    document.body.removeChild(link);
    
    console.log(`✅ Downloaded CSV with ${mappings.length} field mappings`);
}

function copyXMDTransactionCSV() {
    const mappings = extractXMDTransactionMappings();
    
    if (mappings.length === 0) {
        console.error('❌ No mappings found to copy');
        return;
    }
    
    const headers = ['Index', 'Source Field', 'Data Project Field', 'Field Type'];
    const csvRows = [headers];
    
    mappings.forEach(mapping => {
        csvRows.push([
            mapping.index,
            mapping.sourceField,
            mapping.dataProjectField,
            mapping.fieldType
        ]);
    });
    
    const csvContent = csvRows.map(row => 
        row.map(cell => `"${cell}"`).join(',')
    ).join('\n');
    
    navigator.clipboard.writeText(csvContent).then(() => {
        console.log(`✅ Copied ${mappings.length} field mappings to clipboard`);
    });
}

function getXMDTransactionJSON() {
    const mappings = extractXMDTransactionMappings();
    console.log(JSON.stringify(mappings, null, 2));
    return mappings;
}

// ============================================================================
// VIEW FUNCTIONS
// ============================================================================

function listXMDTransactionRows() {
    const mappings = extractXMDTransactionMappings();
    
    console.log(`\n╔════════════════════════════════════════════════════════╗`);
    console.log(`║  Current XMD Transaction Mappings: ${mappings.length}`);
    console.log(`╚════════════════════════════════════════════════════════╝\n`);
    
    if (mappings.length === 0) {
        console.log('ℹ️ No mappings found\n');
        return [];
    }
    
    mappings.forEach(mapping => {
        console.log(`[${mapping.index - 1}] Source: ${mapping.sourceField} → Data Project: ${mapping.dataProjectField} (${mapping.fieldType})`);
    });
    
    console.log('');
    return mappings;
}

// ============================================================================
// USAGE GUIDE
// ============================================================================

console.log(`
╔════════════════════════════════════════════════════════════════╗
║  QUALTRICS XMD TRANSACTION MAPPING EXTRACTOR v3.0            ║
║  (Resilient Edition - Future-Proof with Fallback Selectors)  ║
╠════════════════════════════════════════════════════════════════╣
║                                                                ║
║  📥 EXTRACT FUNCTIONS:                                         ║
║    downloadXMDTransactionCSV()    - Download as CSV file      ║
║    copyXMDTransactionCSV()        - Copy to clipboard         ║
║    getXMDTransactionJSON()        - View as JSON              ║
║                                                                ║
║  📋 VIEW FUNCTIONS:                                            ║
║    listXMDTransactionRows()       - List all mappings         ║
║                                                                ║
║  ✨ Features:                                                  ║
║    - Uses stable data-testid attributes                       ║
║    - Fallback selectors for future-proofing                   ║
║    - Handles missing fields gracefully                        ║
║                                                                ║
╚════════════════════════════════════════════════════════════════╝
`);