Create a Calendar for FME Server Schedules

Liz Sanderson
Liz Sanderson
  • Updated

FME Version

  • FME 2020.0

Introduction

There are plans to implement a calendar view for FME Server schedules, but we are still working on improving this functionality before we release it. In the meantime, Philippe Blackburn Gravel from the City of Repentigny has developed a workspace that creates an Excel Spreadsheet where you can see all of the schedules on FME Server, as well as shows you open time in the schedule where you could potentially plan downtime for upgrades or add CPU intensive workspaces. This method will also continue to be useful once we release our schedule viewer, as you can share the Excel spreadsheet with whoever may need to find a time slot.
 

Overview

WorkspaceOverview.png

This workspace utilizes the FME Server REST API to retrieve the schedules and, based on how the schedule was set up, then either the time or the CRON expression is extracted. After some attribute manipulation, the data is output to Microsoft Excel. 


To run the attached workspace, you will need to create an API token in FME Server that has access to Schedules. 
CreateToken.png

Once the API token has been created, open the workspace in FME Workbench, then run the workspace with Prompt. In the prompt, enter your FME Server URL and the token. Then browse to a location to save the Excel spreadsheet. 
UserParameters.png

Run the workspace, then view the output in Microsoft Excel. 
 

Output

The Time worksheet lists the name of the schedule, the description (if there is one), how often the schedule reoccurs, the time it starts, and if it is enabled. 
ScheduleEnabled.png

The Week worksheet provides an overview of the week which shows where there would be gaps in the schedules. The FME Server instance shown in this demo isn’t very busy, but if we were planning downtime for an upgrade, then it looks like the most optimal time would either be a Wednesday or Thursday, as the schedules on those days are disabled, or over the weekend. 
CalendarView.png


Additional Resources

REST API Documentation
FME Server REST API Training Manual
Tutorial: Getting Started with Microsoft Excel
How to Connect to Any REST API (Without Writing Any Code)
 

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.