Extract and Export Qualtrics Load Responses Into Survey Task Field Mappings to CSV

// ============================================================================
// QUALTRICS LOAD RESPONSES INTO SURVEY - AUTOMATION TOOLKIT
// Version: 1.0
// Task: "Load responses into survey" workflow task
// Developed by Pirai AI — piraiai.com
// ============================================================================

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

const LRIS_SELECTORS = {
    // Main grid container
    grid: [
        'div[role="grid"][aria-label="data-mapper-table"]',
        'div[data-testid="data-mapper-table-test-id"]'
    ],
    // Data rows only (skip the header row which has role="rowgroup" with _hjyK0 _DoXPg)
    rows: [
        'div[role="rowgroup"]:not(._DoXPg) div[role="row"]',
        'div[role="row"][data-testid^="data-mapper-table-test-id-row"]'
    ],
    // Source field button inside a row
    sourceButton: [
        'button[data-testid^="source-field-dropdown-"]',
        'div[data-testid^="data-mapper-table-test-id-cell"][data-testid*="sourceFieldColumn"] button[role="combobox"]'
    ],
    // Destination field button inside a row
    destButton: [
        'button[data-testid^="destination-field-selector-"]',
        'div[data-testid^="data-mapper-table-test-id-cell"][data-testid*="destinationFieldColumn"] button[role="combobox"]'
    ],
    // The visible label text inside a combobox button
    buttonLabel: ['span._PZnC8', 'span[class*="PZnC8"]'],
    // Add field button
    addFieldButton: [
        'button[data-testid="add-field-btn"]',
        'button._O2hNj._ZUle5'
    ],
    // Clear all button
    clearAllButton: [
        'button[data-testid="clear-field-mappings-btn"]'
    ],
    // More/ellipsis button per row for delete
    moreButton: [
        'button[aria-label="more"]',
        'button[aria-haspopup="listbox"]'
    ]
};

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

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

function lrisGetButtonText(btn) {
    if (!btn) return '';
    for (const selector of LRIS_SELECTORS.buttonLabel) {
        const span = btn.querySelector(selector);
        if (span) return span.textContent.trim();
    }
    return btn.textContent.trim();
}

function lrisGetGrid() {
    for (const selector of LRIS_SELECTORS.grid) {
        try {
            const el = document.querySelector(selector);
            if (el) return el;
        } catch (e) { continue; }
    }
    return null;
}

function lrisGetRows() {
    const grid = lrisGetGrid();
    if (!grid) {
        console.warn('⚠️ Data mapper grid not found');
        return [];
    }

    // Always get ALL rows from the data rowgroup (second rowgroup) — this captures
    // every row including duplicate source field rows and the first unnamed row
    const rowgroups = grid.querySelectorAll('div[role="rowgroup"]');
    if (rowgroups.length >= 2) {
        const allRows = Array.from(rowgroups[1].querySelectorAll('div[role="row"]'));
        if (allRows.length > 0) return allRows;
    }

    // Fallback: rows with data-testid (may miss the first row and duplicates)
    return Array.from(grid.querySelectorAll('div[role="row"][data-testid^="data-mapper-table-test-id-row"]'));
}

// ============================================================================
// EXTRACTION FUNCTIONS
// ============================================================================

function extractLRISMappings() {
    const mappings = [];
    const rows = lrisGetRows();

    if (rows.length === 0) {
        console.warn('⚠️ No mapping rows found — make sure you are on the Load Responses Into Survey task');
        return mappings;
    }

    rows.forEach((row, index) => {
        try {
            const sourceBtn = lrisFind(row, LRIS_SELECTORS.sourceButton);
            const destBtn   = lrisFind(row, LRIS_SELECTORS.destButton);

            const sourceField = lrisGetButtonText(sourceBtn);
            const destField   = lrisGetButtonText(destBtn);

            // Skip placeholder/empty rows
            if (!sourceField || sourceField === 'Select source field...') return;

            mappings.push({
                index: mappings.length + 1,
                sourceField,
                destinationSurveyField: destField
            });
        } catch (error) {
            console.warn(`Error processing row ${index}:`, error);
        }
    });

    return mappings;
}

function downloadLRISCSV() {
    const mappings = extractLRISMappings();

    if (mappings.length === 0) {
        console.error('❌ No mappings found to export');
        return;
    }

    const headers = ['Index', 'Source Field', 'Destination Survey Field'];
    const csvRows = [headers.map(h => `"${h}"`).join(',')];

    mappings.forEach(m => {
        csvRows.push([
            `"${m.index}"`,
            `"${m.sourceField.replace(/"/g, '""')}"`,
            `"${m.destinationSurveyField.replace(/"/g, '""')}"`
        ].join(','));
    });

    const csvContent = csvRows.join('\n');
    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', `load_responses_mappings_${timestamp}.csv`);
    link.style.visibility = 'hidden';
    document.body.appendChild(link);
    link.click();
    document.body.removeChild(link);
    URL.revokeObjectURL(url);

    console.log(`✅ Downloaded CSV with ${mappings.length} field mappings`);
}

function copyLRISCSV() {
    const mappings = extractLRISMappings();

    if (mappings.length === 0) {
        console.error('❌ No mappings found to copy');
        return;
    }

    const headers = ['Index', 'Source Field', 'Destination Survey Field'];
    const csvRows = [headers.map(h => `"${h}"`).join(',')];

    mappings.forEach(m => {
        csvRows.push([
            `"${m.index}"`,
            `"${m.sourceField.replace(/"/g, '""')}"`,
            `"${m.destinationSurveyField.replace(/"/g, '""')}"`
        ].join(','));
    });

    navigator.clipboard.writeText(csvRows.join('\n')).then(() => {
        console.log(`✅ Copied ${mappings.length} field mappings to clipboard`);
    });
}

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

function listLRISRows() {
    const rows = lrisGetRows();

    console.log(`\n╔════════════════════════════════════════════════════════╗`);
    console.log(`║  Current Mapping Rows: ${String(rows.length).padEnd(31)}║`);
    console.log(`╚════════════════════════════════════════════════════════╝\n`);

    if (rows.length === 0) {
        console.log('ℹ️ No rows found\n');
        return [];
    }

    const rowData = [];
    rows.forEach((row, index) => {
        const sourceBtn = lrisFind(row, LRIS_SELECTORS.sourceButton);
        const destBtn   = lrisFind(row, LRIS_SELECTORS.destButton);
        const source    = lrisGetButtonText(sourceBtn) || '(empty)';
        const dest      = lrisGetButtonText(destBtn)   || '(empty)';
        console.log(`[${index}] Source: ${source} → Destination: ${dest}`);
        rowData.push({ index, source, dest });
    });

    console.log('');
    return rowData;
}

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

console.log(`
╔══════════════════════════════════════════════════════════════════╗
║  QUALTRICS LOAD RESPONSES INTO SURVEY TOOLKIT v1.0             ║
╠══════════════════════════════════════════════════════════════════╣
║                                                                  ║
║  📥 EXTRACT FUNCTIONS:                                           ║
║    downloadLRISCSV()   - Download mappings as CSV               ║
║    copyLRISCSV()       - Copy to clipboard                      ║
║    listLRISRows()      - View current rows in console           ║
║    getLRISJSON()       - View as JSON                           ║
║                                                                  ║
║  CSV columns: Index, Source Field, Destination Survey Field     ║
║                                                                  ║
╚══════════════════════════════════════════════════════════════════╝
`);