converting_to_json.py

import re
import json

def parse_and_generate_json():
    """
    Parses 'email_summary_report.txt' and generates 'report.json'.
    This script should be run from the same directory where your report text file is located.
    """
    try:
        report_data = []
        current_entry = None
        # Ensure the file is read with utf-8 encoding to handle various characters
        with open('email_summary_report.txt', 'r', encoding='utf-8') as f:
            for line in f:
                line = line.strip()
                # Skip empty lines or the main header
                if not line or "Processed Emails Report" in line:
                    continue

                # A new entry starts with '---'
                if line.startswith('---'):
                    # If there's a previously processed entry, save it to our list
                    if current_entry:
                        report_data.append(current_entry)
                    # Start a new entry
                    current_entry = {'title': line.strip(' -'), 'details': []}
                # Check if 'from' field has not been assigned yet and the line contains 'From:'
                elif 'from' not in current_entry and line.startswith('From:'):
                    from_match = re.search(r"From: (.*?) \|", line)
                    date_match = re.search(r"Date: (.*)", line)
                    if from_match:
                        current_entry['from'] = from_match.group(1).strip()
                    if date_match:
                        current_entry['date'] = date_match.group(1).strip()
                # Check if 'summary' has not been assigned and the line starts with 'Summary:'
                elif 'summary' not in current_entry and line.startswith('Summary:'):
                    current_entry['summary'] = line.replace('Summary:', '').strip()
                # Lines starting with '- ' are considered details or action items
                elif line.startswith('- '):
                    current_entry['details'].append(line.lstrip('- ').strip())
        
        # Append the very last entry in the file
        if current_entry:
            report_data.append(current_entry)

        # Write the structured data to a JSON file
        with open('report.json', 'w', encoding='utf-8') as json_file:
            json.dump(report_data, json_file, indent=4)
            
        print("Successfully generated report.json. You can now view it on the dashboard.")

    except FileNotFoundError:
        print("Error: email_summary_report.txt not found. Make sure it's in the same directory.")
    except Exception as e:
        print(f"An error occurred: {e}")

if __name__ == "__main__":
    parse_and_generate_json()