Display Outlook apointments

[jdesmoulins]

Hello, and thanks for this beautiful application.

Is it possible to add a plugin to display Outlook's calendar (upcoming appointments)?

Like in powershell: https://www.powershellgallery.com/packages/PSPrompt/0.4.3/Content/functions%5CGet-OutlookCalendar.ps1

Thanks in advance for your help,

Kind regards

[jdesmoulins]

Tried with this code, but I always have errors starting FlowLauncher:

main.py:

import sys
import json
import datetime
import win32com.client

def get_today_appointments():
    outlook = win32com.client.Dispatch("Outlook.Application")
    namespace = outlook.GetNamespace("MAPI")
    calendar = namespace.GetDefaultFolder(9)  # 9 = olFolderCalendar

    now = datetime.datetime.now()
    end = now.replace(hour=23, minute=59, second=59)

    restriction = "[Start] >= '{}' AND [Start] <= '{}'".format(
        now.strftime('%m/%d/%Y %H:%M %p'),
        end.strftime('%m/%d/%Y %H:%M %p')
    )

    items = calendar.Items
    items.IncludeRecurrences = True
    items.Sort("[Start]")

    restricted_items = items.Restrict(restriction)

    events = []
    for item in restricted_items:
        events.append({
            "Title": item.Subject,
            "Start": item.Start.Format('%H:%M'),
            "Location": item.Location or "Aucun lieu"
        })

    return events

def main(query):
    results = []
    try:
        events = get_today_appointments()
        if not events:
            results.append({
                "Title": "Aucun rendez-vous aujourd'hui",
                "IcoPath": "Images\\icon.png"
            })
        else:
            for evt in events:
                results.append({
                    "Title": f"{evt['Start']} - {evt['Title']}",
                    "SubTitle": evt['Location'],
                    "IcoPath": "Images\\icon.png"
                })
    except Exception as e:
        results.append({
            "Title": "Erreur lors de la récupération des rendez-vous",
            "SubTitle": str(e),
            "IcoPath": "Images\\icon.png"
        })

    print(json.dumps(results))

if __name__ == "__main__":
    main(" ".join(sys.argv[1:]))

And plugin.json:

{
  "ID": "outlook.today.agenda",
  "Name": "Outlook Today Agenda",
  "Author": "TonNom",
  "Version": "1.0",
  "Language": "python",
  "Website": "https://github.com/tonprofil",
  "ExecuteFileName": "main.py"
}

I have this error in FlowLauncher logs:

EXCEPTION OCCURS: System.ArgumentNullException: Value cannot be null. (Parameter 'path2')
   at void ArgumentNullException.Throw(string paramName)
   at string System.IO.Path.Combine(string path1, string path2)
   at void Flow.Launcher.Plugin.PluginMetadata.set_PluginDirectory(string value) in /_/Flow.Launcher.Plugin/PluginMetadata.cs:line 29
   at PluginMetadata Flow.Launcher.Core.Plugin.PluginConfig.GetPluginMetadata(string pluginDirectory) in C:/projects/flow-launcher/Flow.Launcher.Core/Plugin/PluginConfig.cs:line 113

without finding a solution...

I don't know if it can help someone to create this plugin.

Kind regards,
Jerome

[deefrawley]

There is quite a few things wrong there. I have only recently started using Flow on my work laptop so this feature would be useful. I have a Python script working well so just need to setup in Flow. I'll let you know when I get something working.

[jdesmoulins]

Many thanks :)

[deefrawley]

Just out of interest what version of Outlook are you running?

[jdesmoulins]

The Microsoft 365 version, not the Outlook new (version 2503)

[deefrawley]

Well that's going to be a problem. The 365 cloud version has a completely different mechanism for retrieving data and I'm well down the path of the Classic version (which I use). Even that isn't working currently given the bane of any developer - datetimes, timezones and locales. Might have to think about this one.

[jdesmoulins]

The following code works for me in powershell:

# Importer le module Outlook
Add-Type -AssemblyName "Microsoft.Office.Interop.Outlook"

# Créer une instance de l'application Outlook
$outlook = New-Object -ComObject Outlook.Application

# Obtenir le calendrier par défaut
$namespace = $outlook.GetNamespace("MAPI")
$calendar = $namespace.GetDefaultFolder([Microsoft.Office.Interop.Outlook.OlDefaultFolders]::olFolderCalendar)

# Définir la date d'aujourd'hui
$today = Get-Date
$start = $today.Date
$end = $start.AddDays(1)

# Filtrer les éléments du calendrier pour obtenir les réunions du jour
$filter = "[Start] >= '" + $start.ToString("g") + "' AND [Start] < '" + $end.ToString("g") + "'"
$items = $calendar.Items.Restrict($filter)

# Trier les éléments par date de début
$items.Sort("[Start]")

# Afficher les réunions du jour
foreach ($item in $items) {
    if ($item.Start -ge $start -and $item.Start -lt $end) {
        Write-Output "Sujet : $($item.Subject)"
        Write-Output "Début : $($item.Start)"
        Write-Output "Fin : $($item.End)"
        Write-Output "Organisateur : $($item.Organizer)"
        Write-Output "Participants : $($item.RequiredAttendees)"
        Write-Output "Lieu : $($item.Location)"
        Write-Output "----------------------------------------"
    }
}

It gaves the list of outlook meetings for the current day, using ComObject Outlook.Application. I don't know if it's possible with FlowLauncher.

[deefrawley]

If that works for you then you aren't using the 365 cloud version of Outlook, which is good as the plugin I am working in will work for you. Can you confirm if that script shows recurring events?

[jdesmoulins]

Hello, this script didn't show recurring tasks. Thanks for your remark.

I tried with this, and it works:

# Importer le module Outlook
Add-Type -AssemblyName "Microsoft.Office.Interop.Outlook"

# Créer une instance de l'application Outlook
$outlook = New-Object -ComObject Outlook.Application

# Obtenir le calendrier par défaut
$namespace = $outlook.GetNamespace("MAPI")
$calendar = $namespace.GetDefaultFolder([Microsoft.Office.Interop.Outlook.OlDefaultFolders]::olFolderCalendar)

# Définir la date d'aujourd'hui
$today = Get-Date
$start = $today.Date
$end = $start.AddDays(1)

# Filtrer les éléments du calendrier pour obtenir les réunions du jour
$filter = "[Start] >= '" + $start.ToString("g") + "' AND [Start] < '" + $end.ToString("g") + "'"
$items = $calendar.Items.Restrict($filter)

# Inclure les réunions récurrentes
$items.IncludeRecurrences = $true

# Trier les éléments par date de début
$items.Sort("[Start]")

# Afficher les réunions du jour, y compris les réunions récurrentes
foreach ($item in $items) {
    if ($item.Start -ge $start -and $item.Start -lt $end) {
        Write-Output "Sujet : $($item.Subject)"
        Write-Output "Début : $($item.Start)"
        Write-Output "Fin : $($item.End)"
        Write-Output "Organisateur : $($item.Organizer)"
        Write-Output "Participants : $($item.RequiredAttendees)"
        Write-Output "Lieu : $($item.Location)"
        Write-Output "----------------------------------------"
    }
}

Kind regards,
Jerome