Booking Calendar

Booked Scheduler is the booking system at QDev and NBI cleanroom for reserving common resources such as cleanroom tools or design PCs. It is hosted remotely, with the backend fully managed by the developer. Cleanroom staff is responsible for maintaining it at QDev/NBI.

Status

There are two web monitors set up to track the status of the website:

• Freshping (1 week view)
• Uptime Robot (3 month view)

Cleanroom staff should get an email alerting them of downtime.

Please only follow up with the staff if the website has been down for more than 20 minutes. This is how long it takes to complete routine maintenance on the servers. We have no control or say on when these updates happen. They are carried out by the hosting provider, and not the developer of the booking system. Unfortunately, we can't receive a warning on when the maintenance is going to happen, nor there is a page to check the current webhost status.

Contact

Nick Korbel nick@twinkletoessoftware.com

Contract

USD 10 (ten) / month, billed annually

We can make no server-side changes ourselves. We have some custom modules that prevent us being updated to the new version of Booked Scheduler. Contact users is one of them. Quota has been rolled into the standard package. New features cost ~USD 100/hour of work. Nick makes an estimate but charges only for the hours he works. It is possible to ask to migrate to a new version (roughly 10 hours of work).

How to: change project alias list

• Booked Scheduler > Application Management > Custom Attributes

  link

• Edit (small green button)
• Copy Possible Values to your favorite text editor software (I use Sublime Text, you can use Notepad or Word or whatever you like)
• Replace every comma with a newline

  e.g. in Word:

  • Ctrl+V to paste
  • Ctrl+H to replace
  • Find what: , (a comma)
  • Replace with: More > Special > Manual line break (^l)
  • Replace all

• Edit the list conveniently
• Repeat the replace operation with the fields in reverse

  e.g. in Word:

  • Find what: More > Special > Manual line break (^l)
  • Replace with: , (a comma)

• Copy all the text and paste it back into Booked Scheduler
• Click Update
• Test if it appears in the dropdown menu while making a booking
• Done!

How to: generate a cleanroom tool usage report

Christine Nuding from NBI accounting requests this every quarter.

Only for HCØ, excludes MBE and QuanTech. MBE report is done by Claus using a separate MBE log. QuanTech report is done by Zhe, and should follow similar steps as outlined here.

Generate report

• Booked Scheduler > Reports > Create New Report

  link

• List / Resources / Between <dates>
• Export to CSV

Import to Excel

do not open directly in Excel

• Excel > Data > Get Data > From File > From Text/CSV

  this way column names and filters are automatically implemented

• hide unneeded columns

  e.g. Duration / Reference Number / First Name / Last Name / Organization / Groups / Created / Last Mofified / Status / Check In Time / Check Out Time / Original End / Column 1

Delete bookings that don't need aliases

• filter by Project Alias: (blanks)
• double check that none of the bookings refer to tools that need an alias
• select all visible bookings, right click > Delete > Table Rows

Delete bookings for QuanTech

• filter by Resource: Elionix F-125 / Jeol 7800F-prime
• select all visible bookings, right click > Delete > Table Rows

Clean up the remaining bookings

• sort User A to Z
• I typically look at user/project alias combinations
• if something is inconsistent, follow up with the users/supervisors. Change accordingly.
  • decide whether you want edit only exported data in the reports or change all the bookings in the booking system.
  • I previously only edited the exported data, so the reports sent to Christine Nuding should be the "ground truth" and not the booking system data.