hotmail contacts

import pandas as pd
from reportlab.lib.pagesizes import letter
from reportlab.platypus import Table, TableStyle, SimpleDocTemplate, Paragraph
from reportlab.lib import colors
from reportlab.lib.units import inch
from reportlab.lib.styles import getSampleStyleSheet
import tkinter as tk
from tkinter import filedialog, messagebox


def import_contacts_csv(csv_path):
    df = pd.read_csv(csv_path)
    def safe_get(col):
        # Try to get the column, case-insensitive, fallback to empty
        for c in df.columns:
            if c.strip().lower() == col.strip().lower():
                return df[c].fillna('')
        return pd.Series([''] * len(df))

    first = safe_get('First Name')
    last = safe_get('Last Name')
    phone_home = safe_get('Home Phone')
    phone_business = safe_get('Business Phone')
    phone_mobile = safe_get('Mobile Phone') if 'Mobile Phone' in [c.strip() for c in df.columns] else pd.Series([''] * len(df))
    email = safe_get('E-mail Address')
    street = safe_get('Home Street')
    city = safe_get('Home City')
    state = safe_get('Home State')
    postal = safe_get('Home Postal Code')
    # Combine address fields, skipping empty parts and ensuring all are strings
    address = [', '.join(filter(None, [str(s).strip(), str(c).strip(), str(st).strip(), str(p).strip()])) for s, c, st, p in zip(street, city, state, postal)]
    # Combine all phone numbers into one string, labeled
    phones = []
    import re
    def phone_link(label, number):
        num = str(number).strip()
        if not num:
            return ''
        # Extract digits for tel: link
        digits = re.sub(r'[^0-9+]', '', num)
        if digits:
            return f'{label}: <link href="tel:{digits}">{num}</link>'
        else:
            return f'{label}: {num}'

    for h, b, m in zip(phone_home, phone_business, phone_mobile):
        phone_parts = []
        if str(m).strip():
            phone_parts.append(phone_link("Mobile", m))
        if str(h).strip():
            phone_parts.append(phone_link("Home", h))
        if str(b).strip():
            phone_parts.append(phone_link("Business", b))
        phones.append("<br/>".join(phone_parts))
    contacts = list(zip(first, last, phones, email, address))
    return contacts


def export_contacts_to_pdf(contacts, pdf_path):
    doc = SimpleDocTemplate(
        pdf_path,
        pagesize=letter,
        leftMargin=0.1*inch,
        rightMargin=0.1*inch,
        topMargin=0.3*inch,
        bottomMargin=0.3*inch
    )
    elements = []
    data = [["First Name", "Last Name", "Phone(s)", "Email", "Address"]]
    styles = getSampleStyleSheet()
    # Use a custom style for better word wrapping
    from reportlab.lib.styles import ParagraphStyle
    wrap_style = ParagraphStyle('wrap', parent=styles['Normal'], wordWrap='CJK', allowOrphans=1, allowWidows=1, splitLongWords=True, fontSize=8, leading=10)
    for c in contacts:
        # Phone(s) as Paragraph to support line breaks
        phone_para = Paragraph(str(c[2]), wrap_style)
        row = [
            Paragraph(str(c[0]), wrap_style),  # First Name
            Paragraph(str(c[1]), wrap_style),  # Last Name
            phone_para,  # Phone(s) with line breaks
            Paragraph(str(c[3]), wrap_style),  # Email
            Paragraph(str(c[4]), wrap_style)   # Address
        ]
        data.append(row)
    table_data = [data[0]]
    for row in data[1:]:
        table_data.append([row[0], row[1], row[2], row[3], row[4]])
    # Adjust column widths: more space for address, allow for wrapping
    table = Table(table_data, repeatRows=1, colWidths=[1.1*inch, 1.1*inch, 1.7*inch, 1.7*inch, 2.2*inch])
    # Enable word wrap and splitting for all columns
    table.setStyle(TableStyle([
        ('WORDWRAP', (0, 0), (-1, -1), 'CJK'),
        ('VALIGN', (0, 0), (-1, -1), 'TOP'),
        ('ALIGN', (0, 0), (-1, -1), 'LEFT'),
        ('SPLITLONGWORDS', (0, 0), (-1, -1), True),
    ]))
    style = TableStyle([
        ('BACKGROUND', (0,0), (-1,0), colors.lightblue),
        ('TEXTCOLOR', (0,0), (-1,0), colors.whitesmoke),
        ('ALIGN', (0,0), (-1,-1), 'LEFT'),
        ('FONTNAME', (0,0), (-1,0), 'Helvetica-Bold'),
        ('BOTTOMPADDING', (0,0), (-1,0), 12),
        ('GRID', (0,0), (-1,-1), 0.5, colors.grey),
        ('FONTNAME', (0,1), (-1,-1), 'Helvetica'),
    ])
    table.setStyle(style)
    elements.append(table)
    doc.build(elements)



def run_gui():

    import os

    def browse_csv():
        path = filedialog.askopenfilename(filetypes=[('CSV Files', '*.csv'), ('All Files', '*.*')])
        if path:
            csv_entry.delete(0, tk.END)
            csv_entry.insert(0, path)
            # Set PDF path to same folder and base name as CSV
            base = os.path.splitext(os.path.basename(path))[0]
            folder = os.path.dirname(path)
            pdf_path = os.path.join(folder, base + '.pdf')
            pdf_entry.delete(0, tk.END)
            pdf_entry.insert(0, pdf_path)

    def browse_pdf():
        # Default to the folder of the CSV if available
        initialdir = os.path.dirname(csv_entry.get()) if csv_entry.get() else ''
        path = filedialog.asksaveasfilename(defaultextension='.pdf', filetypes=[('PDF Files', '*.pdf'), ('All Files', '*.*')], initialdir=initialdir)
        if path:
            pdf_entry.delete(0, tk.END)
            pdf_entry.insert(0, path)

    def export():
        csv_path = csv_entry.get().strip('"').strip("'")
        pdf_path = pdf_entry.get().strip('"').strip("'")
        if not pdf_path.lower().endswith('.pdf'):
            pdf_path += '.pdf'
        try:
            contacts = import_contacts_csv(csv_path)
            # messagebox.showinfo("Debug", f"Output PDF path: {pdf_path}\nNumber of contacts loaded: {len(contacts)}")
            export_contacts_to_pdf(contacts, pdf_path)
            messagebox.showinfo("Success", f"Exported {len(contacts)} contacts to {pdf_path}")
        except Exception as e:
            messagebox.showerror("Error", f"Failed to export PDF: {e}")

    root = tk.Tk()
    root.title("Contacts to PDF Exporter")

    tk.Label(root, text="Google Contacts CSV:").grid(row=0, column=0, sticky='e')
    csv_entry = tk.Entry(root, width=40)
    csv_entry.grid(row=0, column=1)
    tk.Button(root, text="Browse", command=browse_csv).grid(row=0, column=2)

    tk.Label(root, text="Output PDF file:").grid(row=1, column=0, sticky='e')
    pdf_entry = tk.Entry(root, width=40)
    pdf_entry.grid(row=1, column=1)
    # tk.Button(root, text="Browse", command=browse_pdf).grid(row=1, column=2)

    tk.Button(root, text="Export to PDF", command=export).grid(row=2, column=0, columnspan=3, pady=10)

    root.mainloop()


if __name__ == "__main__":
    run_gui()