autorun.py

#!/usr/bin/env python3
"""
Auto-convert all XML files in the current directory to CSV format
"""

from wxr_to_csv import WXRToCSVConverter
from pathlib import Path
import sys


def auto_convert_all_xml():
    """Automatically find and convert all XML files to CSV format."""
    
    # Initialize the converter
    converter = WXRToCSVConverter()
    
    # Find all XML files in current directory
    xml_files = list(Path('.').glob('*.xml'))
    
    if not xml_files:
        print("No XML files found in current directory.")
        print("To use this script:")
        print("1. Export your WordPress content (Tools → Export in WordPress admin)")
        print("2. Save the .xml file(s) in this directory")
        print("3. Run this script again")
        return
    
    print(f"Found {len(xml_files)} XML file(s):")
    for xml_file in xml_files:
        print(f"  - {xml_file}")
    print()
    
    converted_count = 0
    failed_count = 0
    
    for xml_file in xml_files:
        try:
            print(f"Converting {xml_file}...")
            
            # Create output CSV filename
            csv_file = xml_file.with_suffix('.csv')
            
            # Convert the file
            result = converter.convert_to_csv(str(xml_file), str(csv_file))
            
            if result:
                converted_count += 1
                print(f"✅ Successfully converted {xml_file} → {csv_file}")
            else:
                print(f"⚠️  No content found in {xml_file}")
                
        except Exception as e:
            failed_count += 1
            print(f"❌ Error converting {xml_file}: {e}")
        
        print()  # Add spacing between files
    
    # Summary
    print("=" * 50)
    print("CONVERSION SUMMARY")
    print("=" * 50)
    print(f"Total XML files found: {len(xml_files)}")
    print(f"Successfully converted: {converted_count}")
    print(f"Failed conversions: {failed_count}")
    
    if converted_count > 0:
        print(f"\n📁 CSV files created:")
        for xml_file in xml_files:
            csv_file = xml_file.with_suffix('.csv')
            if csv_file.exists():
                print(f"  - {csv_file}")
    
    if failed_count > 0:
        print(f"\n⚠️  {failed_count} file(s) failed to convert. Check the error messages above.")
        return 1
    else:
        print(f"\n🎉 All files converted successfully!")
        return 0


if __name__ == '__main__':
    exit(auto_convert_all_xml())