Tired of Outlook? Use this instead!

[majormer]

I was tired of using Teams or Outlook every time I wanted to see my upcoming meetings, so I used the custom sensors to list them. This was accomplished by scheduling a PowerShell script to pull the required data from my Outlook, and outputting it to a CSV file every 10 seconds or so. Then, I had to create a stupid amount of entries in the sensors_custom.py file (1879 lines total, now) to handle the array of events, and handle the countdown timers. There are still some artifacts on the real deal when items scroll up (I am using a mono-spaced font, and adding additional padding with justification, but it still isn't getting all the tops and bottoms of the letters...)

BTW, this is running on a 5-inch Turing. The 3.5-inch is too small for any reasonable amount of data.

The end result is this:

If there is enough interest, I might share the code. Just a bit self-conscious about how sloppy it looks...

An example:

#555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555

class EventDetails5DayOfWeek(CustomDataSource):
    def as_string(self) -> str:
        dayofweek = "NA"  # Default value or initialization
        csv_file_path = Path('W:/Personal/Repos/CalendarExtract/OutlookEvents.csv')
        day_abbreviations = {
            "Monday": "Mon",
            "Tuesday": "Tue",
            "Wednesday": "Wed",
            "Thursday": "Thu",
            "Friday": "Fri",
            "Saturday": "Sat",
            "Sunday": "Sun"
        }
        
        try:
            with csv_file_path.open(mode='r', newline='', encoding='utf-8') as csvfile:
                reader = csv.reader(csvfile)
                next(reader)  # Skip the header row
                for i, row in enumerate(reader):
                    if i == 4:  # Targeting the 5th row
                        # Use the day name from the CSV to get the abbreviation from the dictionary
                        day_name = row[0]  # Assuming the day of the week is in the first column
                        dayofweek = day_abbreviations.get(day_name, "NA")
                        break
        except FileNotFoundError:
            print(f"File not found: {csv_file_path}")
        except Exception as e:
            print(f"An error occurred: {e}")
        return dayofweek

    def as_numeric(self) -> float:
        pass

    def last_values(self) -> List[float]:
        pass

class EventDetails5BusyStatus(CustomDataSource):
    def as_string(self) -> str:
        busystatus = "NA"  # Default initialization
        csv_file_path = Path('W:/Personal/Repos/CalendarExtract/OutlookEvents.csv')
        try:
            with csv_file_path.open(mode='r', newline='', encoding='utf-8') as csvfile:
                reader = csv.reader(csvfile)
                next(reader)  # Skip the header row
                for i, row in enumerate(reader):
                    if i == 4:  # Targeting the 5th row
                        busystatus = row[1]
                        break
        except FileNotFoundError:
            print(f"File not found: {csv_file_path}")
        except Exception as e:
            print(f"An error occurred: {e}")

        # Substitute "OutOfOffice" with "OOO", and "Tentative" with "Tent"
        busystatus = busystatus.replace("OutOfOffice", "OOO").replace("Tentative", "Tent")

        return busystatus.ljust(4)

    def as_numeric(self) -> float:
        pass

    def last_values(self) -> List[float]:
        pass

class EventDetails5AttendeeCount(CustomDataSource):
    def as_string(self) -> str:
        attendeecount = "NA"  # Default initialization
        csv_file_path = Path('W:/Personal/Repos/CalendarExtract/OutlookEvents.csv')
        try:
            with csv_file_path.open(mode='r', newline='', encoding='utf-8') as csvfile:
                reader = csv.reader(csvfile)
                next(reader)  # Skip the header row
                for i, row in enumerate(reader):
                    if i == 4:  # Targeting the 5th row
                        attendeecount = row[2]
                        break
        except FileNotFoundError:
            print(f"File not found: {csv_file_path}")
        except Exception as e:
            print(f"An error occurred: {e}")
        return attendeecount.ljust(3)

    def as_numeric(self) -> float:
        pass

    def last_values(self) -> List[float]:
        pass

class EventDetails5StartTime(CustomDataSource):
    def as_string(self) -> str:
        starttime = "NA"  # Default initialization
        csv_file_path = Path('W:/Personal/Repos/CalendarExtract/OutlookEvents.csv')
        try:
            with csv_file_path.open(mode='r', newline='', encoding='utf-8') as csvfile:
                reader = csv.reader(csvfile)
                next(reader)  # Skip the header row
                for i, row in enumerate(reader):
                    if i == 4:  # Targeting the 5th row
                        starttime = datetime.strptime(row[3], '%m/%d/%Y %H:%M').strftime('%I:%M %p')
                        break
        except FileNotFoundError:
            print(f"File not found: {csv_file_path}")
        except Exception as e:
            print(f"An error occurred: {e}")
        return starttime.rjust(8)
    def as_numeric(self) -> float:
        pass

    def last_values(self) -> List[float]:
        pass

class EventDetails5StartDate(CustomDataSource):
    def as_string(self) -> str:
        startdate = "NA"  # Default initialization
        csv_file_path = Path('W:/Personal/Repos/CalendarExtract/OutlookEvents.csv')
        try:
            with csv_file_path.open(mode='r', newline='', encoding='utf-8') as csvfile:
                reader = csv.reader(csvfile)
                next(reader)  # Skip the header row
                for i, row in enumerate(reader):
                    if i == 4:  # Targeting the 5th row
                        startdate = datetime.strptime(row[3], '%m/%d/%Y %H:%M').strftime('%m/%d')
                        break
        except FileNotFoundError:
            print(f"File not found: {csv_file_path}")
        except Exception as e:
            print(f"An error occurred: {e}")
        return startdate
    def as_numeric(self) -> float:
        pass

    def last_values(self) -> List[float]:
        pass

class EventDetails5EndTime(CustomDataSource):
    def as_string(self) -> str:
        endtime = "NA"  # Default initialization
        csv_file_path = Path('W:/Personal/Repos/CalendarExtract/OutlookEvents.csv')
        try:
            with csv_file_path.open(mode='r', newline='', encoding='utf-8') as csvfile:
                reader = csv.reader(csvfile)
                next(reader)  # Skip the header row
                for i, row in enumerate(reader):
                    if i == 4:  # Targeting the 5th row
                        endtime = datetime.strptime(row[4], '%m/%d/%Y %H:%M').strftime('%I:%M %p')
                        break
        except FileNotFoundError:
            print(f"File not found: {csv_file_path}")
        except Exception as e:
            print(f"An error occurred: {e}")
        return endtime.ljust(8)
    def as_numeric(self) -> float:
        pass

    def last_values(self) -> List[float]:
        pass

class EventDetails5AllDayEvent(CustomDataSource):
    def as_string(self) -> str:
        alldayevent = "NA"  # Default initialization
        csv_file_path = Path('W:/Personal/Repos/CalendarExtract/OutlookEvents.csv')
        try:
            with csv_file_path.open(mode='r', newline='', encoding='utf-8') as csvfile:
                reader = csv.reader(csvfile)
                next(reader)  # Skip the header row
                for i, row in enumerate(reader):
                    if i == 4:  # Targeting the 5th row
                        alldayevent = row[5]
                        break
        except FileNotFoundError:
            print(f"File not found: {csv_file_path}")
        except Exception as e:
            print(f"An error occurred: {e}")
        return alldayevent.ljust(5)
    def as_numeric(self) -> float:
        pass

    def last_values(self) -> List[float]:
        pass
class EventDetails5MultiDayEvent(CustomDataSource):
    def as_string(self) -> str:
        multidayevent = "NA"  # Default initialization
        csv_file_path = Path('W:/Personal/Repos/CalendarExtract/OutlookEvents.csv')
        try:
            with csv_file_path.open(mode='r', newline='', encoding='utf-8') as csvfile:
                reader = csv.reader(csvfile)
                next(reader)  # Skip the header row
                for i, row in enumerate(reader):
                    if i == 4:  # Targeting the 5th row
                        multidayevent = row[6]
                        break
        except FileNotFoundError:
            print(f"File not found: {csv_file_path}")
        except Exception as e:
            print(f"An error occurred: {e}")
        return multidayevent.ljust(5)
    def as_numeric(self) -> float:
        pass

    def last_values(self) -> List[float]:
        pass
class EventDetails5Subject(CustomDataSource):
    def as_string(self) -> str:
        subject = "NA"  # Default initialization
        csv_file_path = Path('W:/Personal/Repos/CalendarExtract/OutlookEvents.csv')
        try:
            with csv_file_path.open(mode='r', newline='', encoding='utf-8') as csvfile:
                reader = csv.reader(csvfile)
                next(reader)  # Skip the header row
                for i, row in enumerate(reader):
                    if i == 4:  # Targeting the 5th row
                        subject = row[7]
                        break
        except FileNotFoundError:
            print(f"File not found: {csv_file_path}")
        except Exception as e:
            print(f"An error occurred: {e}")
        return subject.ljust(61)
    def as_numeric(self) -> float:
        pass

    def last_values(self) -> List[float]:
        pass
class EventDetails5Location(CustomDataSource):
    def as_string(self) -> str:
        location = ""  # Default initialization to an empty string for clarity
        csv_file_path = Path('W:/Personal/Repos/CalendarExtract/OutlookEvents.csv')
        try:
            with csv_file_path.open(mode='r', newline='', encoding='utf-8') as csvfile:
                reader = csv.reader(csvfile)
                next(reader)  # Skip the header row
                for i, row in enumerate(reader):
                    if i == 4:  # Targeting the 1st row
                        location = row[8].ljust(33)  # Assume this is the column for location
                        break
        except FileNotFoundError:
            print(f"File not found: {csv_file_path}")
        except Exception as e:
            print(f"An error occurred: {e}")

        # If location is empty, return "NA"
        return location if location.strip() else ("NA").ljust(50)

    def as_numeric(self) -> float:
        pass

    def last_values(self) -> List[float]:
        pass

class EventDetails5IsConferenceCall(CustomDataSource):
    def as_string(self) -> str:
        isconferencecall = "NA"  # Default initialization
        csv_file_path = Path('W:/Personal/Repos/CalendarExtract/OutlookEvents.csv')
        try:
            with csv_file_path.open(mode='r', newline='', encoding='utf-8') as csvfile:
                reader = csv.reader(csvfile)
                next(reader)  # Skip the header row
                for i, row in enumerate(reader):
                    if i == 4:  # Targeting the 5th row
                        isconferencecall = row[9]
                        break
        except FileNotFoundError:
            print(f"File not found: {csv_file_path}")
        except Exception as e:
            print(f"An error occurred: {e}")
        return isconferencecall
    def as_numeric(self) -> float:
        pass

    def last_values(self) -> List[float]:
        pass
class EventDetails5TimeToEventStartOrStatus(CustomDataSource):
    def as_string(self) -> str:
        time_to_event_start_or_status = "NA"  # Default initialization
        csv_file_path = Path('W:/Personal/Repos/CalendarExtract/OutlookEvents.csv')
        
        try:
            with csv_file_path.open(mode='r', newline='', encoding='utf-8') as csvfile:
                reader = csv.reader(csvfile)
                next(reader)  # Skip the header row
                for i, row in enumerate(reader):
                    if i == 4:  # Targeting the 5th row
                        start_time_str = row[3]
                        end_time_str = row[4]
                        # Assuming the datetime format in the CSV is 'MM/DD/YYYY HH:mm'
                        
                        chicago_tz = pytz.timezone('America/Chicago')
                        # Parse the times as Chicago time without converting from UTC
                        start_time = chicago_tz.localize(datetime.strptime(start_time_str, '%m/%d/%Y %H:%M'))
                        end_time = chicago_tz.localize(datetime.strptime(end_time_str, '%m/%d/%Y %H:%M'))
                        
                        now = datetime.now(chicago_tz)
                        
                        if start_time > now:
                            # Calculate remaining time until the event starts
                            delta = start_time - now
                            days, remainder = divmod(delta.total_seconds(), 86400)
                            hours, remainder = divmod(remainder, 3600)
                            minutes, seconds = divmod(remainder, 60)
                            time_to_event_start_or_status = f"Starts in {int(days)}d {int(hours)}h {int(minutes)}m {int(seconds)}s"
                        elif start_time <= now <= end_time:
                            time_to_event_start_or_status = "In Progress"
                        else:
                            time_to_event_start_or_status = "Event has ended"
                        break
        except FileNotFoundError:
            print(f"File not found: {csv_file_path}")
        except Exception as e:
            print(f"An error occurred: {e}")
        return time_to_event_start_or_status.ljust(23)

    def as_numeric(self) -> float:
        pass

    def last_values(self) -> List[float]:
        pass

[majormer]

Here is how I did the extract from Outlook. I run this on a scheduled task:

try {
    $outlook = New-Object -ComObject Outlook.Application
    $namespace = $outlook.GetNameSpace("MAPI")
}
catch {
    Write-Output "Outlook is not open or an error occurred. Exiting without updating the CSV."
    exit
}

$folder = $namespace.GetDefaultFolder(9) # Calendar
$items = $folder.Items
$items.IncludeRecurrences = $true

$start = (Get-Date).Date
$end = $start.AddDays(30)

$items.Sort("[Start]")
$filteredItems = $items.Restrict("[Start] >= `"$($start.ToString('g'))`" AND [End] <= `"$($end.ToString('g'))`"")

# Initialize an empty array to hold details of non-expired events
$eventsDetails = @()

if ($null -ne $filteredItems) {
    foreach ($item in $filteredItems) {
        # Check if the event end date/time is more than an hour in the past; if so, skip to the next iteration
        if ($item.End -lt ([DateTime]::Now).AddHours(-1)) {
            continue
        }


        # Determine if the event is marked as an all-day event
        $allDay = $item.AllDayEvent
        # Initialize a flag for multi-day events
        $multiDay = $false
        # Check if the event spans multiple days
        if ($item.Start.Date -ne $item.End.Date) {
            $multiDay = $true
        }
        # Determine the busy status of the event and convert it to a readable format
        $busyStatus = switch ($item.BusyStatus) {
            0 { "Free" }
            1 { "Tentative" }
            2 { "Busy" }
            3 { "OutOfOffice" }
            default { "Unknown" }
        }
        # Count the number of attendees/recipients for the event
        $attendeeCount = $item.Recipients.Count
        # Set the date format for start and end times
        $dateFormat = "MM/dd/yyyy HH:mm"
        # Format the start and end times according to the specified date format
        $startFormatted = $item.Start.ToString($dateFormat)
        $endFormatted = $item.End.ToString($dateFormat)
        # Retrieve the day of the week for the event start time
        $dayOfWeek = $item.Start.DayOfWeek
        
        # Determine if the meeting is a conference call based on its location
        $isConferenceCall = $false
        if ($item.Location -like "*Skype*" -or $item.Location -like "*Teams*" -or $item.Location -eq "Online") {
            $isConferenceCall = $true
        }
        
        # Create an ordered dictionary to store event details, ensuring property order
        $eventDetail = [ordered]@{
            DayOfWeek        = $dayOfWeek
            BusyStatus       = $busyStatus
            AttendeeCount    = $attendeeCount
            Start            = $startFormatted
            End              = $endFormatted
            AllDayEvent      = $allDay
            MultiDayEvent    = $multiDay
            Subject          = $item.Subject
            Location         = $item.Location # Store the location of the event
            IsConferenceCall = $isConferenceCall # Indicate whether it's a conference call
        }
        # Convert the ordered dictionary to a PSObject and add it to the events details array
        $eventsDetails += New-Object PSObject -Property $eventDetail
    }
    
    # Specify the path for the output CSV file
    $csvPath = "./OutlookEvents.csv"
    # Export the array of PSObjects to a CSV file, maintaining the specified order of properties
    $eventsDetails | Export-Csv -Path $csvPath -NoTypeInformation -Force
}

else {
    # Output a message if no items were retrieved from Outlook, indicating failure
    Write-Output "Failed to retrieve items from Outlook. Exiting without updating the CSV."
}