Extract & Export the Qualtrics Update XM Directory Contacts Task Mappings

/**
 * Qualtrics XM Directory Mapping Extractor (Contacts + Transactions)
 * Extracts Source Field to XM Directory Field mappings - v2.4 (Resilient Edition)
 * "Update XM Directory Contacts" workflow task.
 * Run this script on EACH screen (Part 1 and Part 2).
 * Developed by Pirai AI — piraiai.com
 * Last updated: April 2026
 *
 * v2.4 CHANGE: Qualtrics regenerates hashed CSS classnames (e.g. "_2Oqzg") on each
 * deployment. Row selection now uses stable attributes only (sourceFieldCell,
 * textInput, role="combobox") instead of hashed row classnames, which were
 * causing "0 rows found" errors after Qualtrics UI updates.
*/

(function() {
    console.log('=== Qualtrics XM Directory Mapping Extractor Started ===');

    function getRows(table) {
        if (!table) return [];
        // Resilient: any  that contains a sourceFieldCell — avoids relying
        // on hashed row classnames like "_2Oqzg" / "_l2NCb" which change between
        // Qualtrics deployments.
        const allRows = table.querySelectorAll('tbody tr');
        return Array.from(allRows).filter(row => row.querySelector('td.sourceFieldCell'));
    }

    function extractContactMappings() {
        const mappings = [];
        const contactsTable = document.querySelector('.contactsDataMapper table.dataMapperTable');
        if (!contactsTable) {
            console.log('No contacts mapping table found');
            return mappings;
        }
        const rows = getRows(contactsTable);
        console.log(`\nFound ${rows.length} contact mapping rows`);
        rows.forEach((row, index) => {
            try {
                let sourceField = '';
                let xmDirectoryField = '';
                const sourceInput = row.querySelector('td.sourceFieldCell input.textInput');
                if (sourceInput) {
                    sourceField = sourceInput.value.trim();
                }
                const destinationInput = row.querySelector('input[role="combobox"]');
                if (destinationInput) {
                    xmDirectoryField = destinationInput.value.trim();
                }
                if (sourceField || xmDirectoryField) {
                    mappings.push({
                        index: index + 1,
                        sourceField: sourceField,
                        xmDirectoryField: xmDirectoryField
                    });
                }
            } catch (error) {
                console.warn(`Error processing contact row ${index}:`, error);
            }
        });
        return mappings;
    }

    function extractTransactionMappings() {
        const mappings = [];
        const transactionTable = document.querySelector('.transactionDataMapper table.dataMapperTable');
        if (!transactionTable) {
            console.log('No transaction mapping table found');
            return mappings;
        }
        const rows = getRows(transactionTable);
        console.log(`\nFound ${rows.length} transaction mapping rows`);
        rows.forEach((row, index) => {
            try {
                let sourceField = '';
                let xmDirectoryField = '';
                let makePipedText = false;
                const sourceInput = row.querySelector('td.sourceFieldCell input.textInput');
                if (sourceInput) {
                    sourceField = sourceInput.value.trim();
                }
                const secondColumn = row.querySelector('td:nth-child(2)');
                if (secondColumn) {
                    const standaloneLabel = secondColumn.querySelector('label:not(:has(input))');
                    if (standaloneLabel) {
                        xmDirectoryField = standaloneLabel.textContent.trim();
                    } else {
                        const labelWithInput = secondColumn.querySelector('label input[type="text"]');
                        if (labelWithInput) {
                            xmDirectoryField = labelWithInput.value.trim();
                        } else {
                            const combobox = secondColumn.querySelector('input[role="combobox"]');
                            if (combobox) xmDirectoryField = combobox.value.trim();
                        }
                    }
                }
                const checkbox = row.querySelector('td:nth-child(3) input[type="checkbox"]');
                if (checkbox) {
                    makePipedText = checkbox.checked;
                }
                if (sourceField || xmDirectoryField) {
                    mappings.push({
                        index: index + 1,
                        sourceField: sourceField,
                        xmDirectoryField: xmDirectoryField,
                        makePipedText: makePipedText ? 'Yes' : 'No'
                    });
                }
            } catch (error) {
                console.warn(`Error processing transaction row ${index}:`, error);
            }
        });
        return mappings;
    }

    function displayAsTable(mappings, type) {
        console.log(`\n=== EXTRACTED ${type.toUpperCase()} MAPPINGS ===\n`);
        console.table(mappings);
        console.log(`\nTotal ${type} mappings: ${mappings.length}`);
    }

    function convertToCSV(mappings, includePipedText = false) {
        if (mappings.length === 0) return '';
        let headerRow = '"Index","Source Field","XM Directory Field"';
        if (includePipedText) {
            headerRow += ',"Make Piped Text"';
        }
        const dataRows = mappings.map(mapping => {
            let row = [
                `"${mapping.index}"`,
                `"${mapping.sourceField.replace(/"/g, '""')}"`,
                `"${mapping.xmDirectoryField.replace(/"/g, '""')}"`
            ];
            if (includePipedText) {
                row.push(`"${mapping.makePipedText}"`);
            }
            return row.join(',');
        }).join('\n');
        return headerRow + '\n' + dataRows;
    }

    function downloadCSV(csv, filename) {
        const blob = new Blob([csv], { type: 'text/csv;charset=utf-8;' });
        const link = document.createElement('a');
        const url = URL.createObjectURL(blob);
        link.setAttribute('href', url);
        link.setAttribute('download', filename);
        link.style.visibility = 'hidden';
        document.body.appendChild(link);
        link.click();
        document.body.removeChild(link);
        URL.revokeObjectURL(url);
        console.log(`✓ Downloaded: ${filename}`);
    }

    function copyToClipboard(text) {
        const textarea = document.createElement('textarea');
        textarea.value = text;
        textarea.style.position = 'fixed';
        textarea.style.opacity = '0';
        document.body.appendChild(textarea);
        textarea.select();
        try {
            document.execCommand('copy');
            console.log('✓ CSV data copied to clipboard!');
            return true;
        } catch (err) {
            console.error('Failed to copy to clipboard:', err);
            return false;
        } finally {
            document.body.removeChild(textarea);
        }
    }

    console.log('Starting extraction...\n');
    const contactMappings = extractContactMappings();
    const transactionMappings = extractTransactionMappings();
    if (contactMappings.length === 0 && transactionMappings.length === 0) {
        console.error('❌ No mappings found! Make sure you are on the XM Directory mapping dialog.');
        return;
    }
    if (contactMappings.length > 0) {
        displayAsTable(contactMappings, 'contact');
    }
    if (transactionMappings.length > 0) {
        displayAsTable(transactionMappings, 'transaction');
    }
    const contactCSV = convertToCSV(contactMappings, false);
    const transactionCSV = convertToCSV(transactionMappings, true);
    window.xmContactMappings = contactMappings;
    window.xmTransactionMappings = transactionMappings;
    window.xmContactCSV = contactCSV;
    window.xmTransactionCSV = transactionCSV;
    window.downloadContactMappingsCSV = function(filename) {
        downloadCSV(contactCSV, filename || 'xm_contact_mappings.csv');
    };
    window.copyContactMappingsCSV = function() {
        return copyToClipboard(contactCSV);
    };
    window.downloadTransactionMappingsCSV = function(filename) {
        downloadCSV(transactionCSV, filename || 'xm_transaction_mappings.csv');
    };
    window.copyTransactionMappingsCSV = function() {
        return copyToClipboard(transactionCSV);
    };
    window.downloadAllMappingsCSV = function() {
        if (contactMappings.length > 0) {
            downloadCSV(contactCSV, 'xm_contact_mappings.csv');
        }
        if (transactionMappings.length > 0) {
            downloadCSV(transactionCSV, 'xm_transaction_mappings.csv');
        }
    };
    window.getContactJSON = function() {
        return JSON.stringify(contactMappings, null, 2);
    };
    window.getTransactionJSON = function() {
        return JSON.stringify(transactionMappings, null, 2);
    };
    console.log('\n=== ACTIONS AVAILABLE ===');
    console.log('CONTACT MAPPINGS:');
    console.log('  1. Download CSV:  downloadContactMappingsCSV()');
    console.log('  2. Copy CSV:      copyContactMappingsCSV()');
    console.log('  3. View JSON:     getContactJSON()');
    console.log('\nTRANSACTION MAPPINGS:');
    console.log('  4. Download CSV:  downloadTransactionMappingsCSV()');
    console.log('  5. Copy CSV:      copyTransactionMappingsCSV()');
    console.log('  6. View JSON:     getTransactionJSON()');
    console.log('\nALL MAPPINGS:');
    console.log('  7. Download All:  downloadAllMappingsCSV()');
    console.log('  8. View data:     xmContactMappings / xmTransactionMappings');
    console.log('\n✓ Extraction complete! Use the commands above to export the data.');
})();