Extract and Export Qualtrics Basic Transform Task Field Mappings to CSV

 
/**
 * Qualtrics Basic Transform Field Mapper Extractor v1.0
 * Extracts field mapping configuration from "Basic Transform" workflow task
 * Compatible with Qualtrics Workflow Editor
 * Developed by Pirai AI — piraiai.com
 * Last updated: March 09, 2026
*/

(function() {
    console.log('🚀 Qualtrics Basic Transform Extractor v1.0');
    console.log('📋 Extracting field mappings...');

    // Find all mapping rows
    const rows = document.querySelectorAll('tbody._2rtpf tr._Q2IPs');
    
    if (rows.length === 0) {
        console.error('❌ No mapping rows found. Make sure you are on the Basic Transform configuration screen.');
        return;
    }

    const mappings = [];
    
    rows.forEach((row, index) => {
        try {
            // Extract Required checkbox (3rd column)
            const requiredCheckbox = row.querySelector('td:nth-child(3) input[type="checkbox"]');
            const isRequired = requiredCheckbox ? requiredCheckbox.checked : false;
            
            // Extract Source Field (4th column - button with span._rR2lD)
            const sourceFieldButton = row.querySelector('td:nth-child(4) button[data-testid="source-field-selector"] span._rR2lD');
            const sourceField = sourceFieldButton ? sourceFieldButton.textContent.trim() : '';
            
            // Extract Destination Field Name (5th column - input)
            const destFieldInput = row.querySelector('td:nth-child(5) input[data-testid="destination-name-input"]');
            const destFieldName = destFieldInput ? destFieldInput.value.trim() : '';
            
            // Extract Field Type (6th column - button with span containing field type)
            const fieldTypeButton = row.querySelector('td:nth-child(6) button[data-testid="source-field-type-selector-button"] span._8kwlb');
            const fieldType = fieldTypeButton ? fieldTypeButton.textContent.trim() : '';
            
            mappings.push({
                index: index + 1,
                required: isRequired,
                sourceField: sourceField,
                destinationFieldName: destFieldName,
                fieldType: fieldType
            });
            
        } catch (error) {
            console.warn(`⚠️ Error extracting row ${index + 1}:`, error);
        }
    });

    // Store in global variable
    window.basicTransformMappings = mappings;
    
    console.log(`✅ Extracted ${mappings.length} field mappings`);
    console.log('📊 Data stored in: window.basicTransformMappings');
    
    return mappings;
})();

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

function downloadBasicTransformCSV() {
    if (!window.basicTransformMappings || window.basicTransformMappings.length === 0) {
        console.error('❌ No mappings found. Please run the extraction script first.');
        return;
    }
    
    // Create CSV content
    let csv = '"Index","Required","Source Field","Destination Field Name","Field Type"\n';
    
    window.basicTransformMappings.forEach(mapping => {
        const required = mapping.required ? 'Yes' : 'No';
        csv += `"${mapping.index}","${required}","${mapping.sourceField}","${mapping.destinationFieldName}","${mapping.fieldType}"\n`;
    });
    
    // Download CSV
    const blob = new Blob([csv], { type: 'text/csv;charset=utf-8;' });
    const link = document.createElement('a');
    link.href = URL.createObjectURL(blob);
    link.download = 'basic_transform_mappings.csv';
    link.click();
    
    console.log('✅ CSV downloaded: basic_transform_mappings.csv');
}

function copyBasicTransformCSV() {
    if (!window.basicTransformMappings || window.basicTransformMappings.length === 0) {
        console.error('❌ No mappings found. Please run the extraction script first.');
        return;
    }
    
    // Create CSV content
    let csv = '"Index","Required","Source Field","Destination Field Name","Field Type"\n';
    
    window.basicTransformMappings.forEach(mapping => {
        const required = mapping.required ? 'Yes' : 'No';
        csv += `"${mapping.index}","${required}","${mapping.sourceField}","${mapping.destinationFieldName}","${mapping.fieldType}"\n`;
    });
    
    // Copy to clipboard
    navigator.clipboard.writeText(csv).then(() => {
        console.log('✅ CSV copied to clipboard');
    }).catch(err => {
        console.error('❌ Failed to copy to clipboard:', err);
    });
}

function getBasicTransformJSON() {
    if (!window.basicTransformMappings || window.basicTransformMappings.length === 0) {
        console.error('❌ No mappings found. Please run the extraction script first.');
        return null;
    }
    
    console.log(JSON.stringify(window.basicTransformMappings, null, 2));
    return window.basicTransformMappings;
}

// ============================================================================
// USAGE INSTRUCTIONS
// ============================================================================
console.log(`
╔════════════════════════════════════════════════════════════════════╗
║  Qualtrics Basic Transform Extractor v1.0 - Ready!                ║
╠════════════════════════════════════════════════════════════════════╣
║                                                                    ║
║  📥 DOWNLOAD CSV:                                                  ║
║     downloadBasicTransformCSV()                                    ║
║                                                                    ║
║  📋 COPY TO CLIPBOARD:                                             ║
║     copyBasicTransformCSV()                                        ║
║                                                                    ║
║  🔍 VIEW JSON:                                                     ║
║     getBasicTransformJSON()                                        ║
║                                                                    ║
║  💾 ACCESS DATA:                                                   ║
║     window.basicTransformMappings                                  ║
║                                                                    ║
╚════════════════════════════════════════════════════════════════════╝
`);