Authentication

How do I login?
I forgot my password!
Why can't I delete/alter an aircraft or instructor schedule?
How do I update my user information (name, address, phone number, etc.)?
How do I change my password?
How do I prevent the display of my phone numbers?
Schedule/Altering Aircraft or Instructor Schedules How do I schedule an aircraft or instructor?
How do I delete a schedule?
How do I make a recurring schedule?
How do I delete one instance of a recurring schedule?
My aircraft or instructor schedule failed to be created because of "too many entries"!
What happens if multiple people schedule the same aircraft or instructor?
How do I request to be on standby for an aircraft or instructor?
Checkout/Checkin an Aircraft Check out an aircraft?
Check in an aircraft?
Administration Add a new user to the database?
Modify an existing user's information?
Add a new aircraft to the database?
Modify an existing aircraft information?
Check a user's currency?
Check a user's bill?
About The AircraftScheduling Booking System How does the system work and who wrote it?

How do I sign in?

To sign in, select the Sign In link from the blue bar at the top of the screen. Enter the username and password that was assigned when you joined.

Some functions are restricted to certain users, and other users will get the message You do not have access rights to modify this item. See your system administrator if you are not able to create and modify your aircraft or instructor schedules.

Top

I forgot my password!

To have your password sent to your Email address, use this form. Your password will be sent to the Email address you have on file.

Top

Why can't I delete/alter an aircraft or instructor schedule?

In order to delete or alter an aircraft or instructor schedule, you must be logged in as the same person that scheduled . Contact one of the office staff or the person who initially scheduled the aircraft or instructor to have it deleted or changed.

Top

How do I update my user information (name, address, phone number, etc.)?

You may update your user information (name, address, etc.) after you have signed in, by selecting Change User Info in the top bar.

Top

How do I change my password?

You may change your password after you have signed in, by selecting Change Password in the top bar.

Top

How do I prevent the display of my phone numbers?

You may prevent your phone numbers from being displayed by selecting Change User Info in the top bar after you have signed in. Clearing the selection for the Display Phone Numbers checkbox.

Note that any existing scheduled entries will continue to display your phone number. All schedules created in the future will show "UNLISTED" instead of the phone number. If you wish, you may go back and edit your existing schedule entries to clear the phone number there.

Top

How do I schedule an aircraft or instructor?

Clicking on the desired time brings you into the booking screen. The screen will be slightly different depending on how you logged on.

As a normal user, your name and phone number will be filled in. The name cannot be changed, but a different phone number may be entered. If you are logged in as one of the office staff (super user), you can make reservations for other users so the name field is now a drop down list of all users. As you select a user, their default phone number is placed in the phone number field. The phone number may be changed as desired.

Enter any notes about the schedule in the description field. This field may be left blank if desired.

If you are scheduling an aircraft and wish to schedule an instructor for the same time, select the instructor from the drop down list. Set to none (the default) if you want to schedule just the aircraft.

Select the date for the schedule. The default date is the date selected on the main screen. The date may be changed to any date desired.

Enter the starting time. The default time is the time selected on the main screen. The time may be changed to any time desired.

Enter the duration of the booking or select All day as desired. The time may be entered in the selected units (minutes, hours, days or weeks). The default time is 2 hours.

See How do I make a recurring schedule? on the use of the repeat information items.

When all entries are complete, press the Save button to complete the scheduling.

Top

How do I delete a schedule?

Select the day/aircraft/instructor/time that you want to delete and select Delete Entry.

Top

How do I make a recurring schedule?

Clicking on the desired time brings you into the booking screen. Select the appropriate Repeat Type. The aircraft or instructor will be scheduled at the same time, until the Repeat End Date, on the days determined by the Repeat Type.

A Daily repeat schedules every day. A Weekly repeat schedules those days of the week that you check under Repeat Day. For example, use Weekly repeat to schedule the aircraft or instructor every Monday, Tuesday, and Thursday; check those days under Repeat Day. If you check no days under Repeat Day, the schedule will repeat on the same day of each week as the first scheduled day. A Monthly repeat schedules the same day of each month, for example the 15th of the month. A Yearly repeat schedules the same month and day of the month, for example every March 15th. Finally, a Monthly, corresponding day repeat schedules one day each month, the same weekday and ordinal position within the month. Use this repeat type to schedule the first Monday, second Tuesday, or fourth Friday of each month, for example. Do not use this repeat type after the 28th day of the month.

Top

How do I delete one instance of a recurring schedule?

Select the day/aircraft/instructor/time that you want to delete and select Delete Entry.

Top

My schedule failed to be created because of "too many entries"!

Any schedule cannot create more than 365 entries. There needs to be some limit on the number of schedule created. This number can be increased if necessary.

Top

What happens if multiple people schedule the same aircraft or instructor?

The short answer is: The first person to click on the Submit button wins.
Behind the scenes, the system is using a proper multi-user, multi-threaded relational database than can handle many thousands of simultaneous users.

Top

How do I request to be on standby for an aircraft or instructor?

If the aircraft or instructor that you wish to schedule is already booked for a time period, you may request the same time on a standby basis. To be added to the standby request list for a particular time, select the time period that has an existing schedule to bring up the details for that booking. Select the Add Standby Request and fill in the requested information. If the original schedule is canceled, you will be notified by email (assuming you have a valid email on file) that the time period has been given up and you are now scheduled.

Any number of standby requests may be made. The system will schedule the next person in order any time an existing booking is canceled.

Note that the system will not assign your standby request unless the entire time period is available. In other words, if you have requested a two hour block and only 1.5 hours is available, the system will not assign any of the available time to you.

Top

Check Out An Aircraft

To check out an aircraft requires the following steps:

  1. Select the Aircraft Checkout link in the menu bar at the top of the screen to take the user to the Aircraft Check Out Screen.

Note: If you already have an aircraft checked out, the Aircraft Checkout link will not be shown, the Aircraft Checkin link will be shown instead. Only one aircraft may be checked out by a user at a time.

  1. A drop down box at the top of the Aircraft Check Out screen may be used to select the desired aircraft to checkout. The system will look within two hours of the current time for a scheduled aircraft and select that aircraft as the default aircraft to checkout. If this is not the desired aircraft, select the correct one from the list.

  2. After filling in the Weight and Balance fields of the Aircraft Check Out Screen and assuming that the pilot's Flight Currency and Flight Status are valid and the Aircraft Status is valid, the program will allow the aircraft to be checked out.

Top

Check In An Aircraft

To check in an aircraft requires the following steps:

  1. Select the Aircraft Checkin link in the menu bar at the top of the screen to take the user to the Aircraft Check-in Screen.

  2. After filling in the Check-in Information fields of the Aircraft check-in Screen and entering any new aircraft squawks using the Squawk Data fields, the program will allow the aircraft to be checked in.

Top

Add A New User

To add a new user to the database requires the following steps:

  1. If you have the necessary privileges to enter a new user, there will be an Admin link in the menu bar at the top of the screen. The Admin link takes you to the Admin Screen.

  2. From the Admin Screen, select User Management to take you to the User Display Screen

  3. From the User Display Screen, select the Add User link to start the Add New User screen.

  4. After all entries are complete in the Add New User, select the Submit button and the new user is saved in the database.

Top

Modify An Existing User

To modify an existing user's information in the database requires the following steps:

  1. If you have the necessary privileges to modify a user, there will be an Admin link in the menu bar at the top of the screen. The Admin link takes you to the Admin Screen.

  2. From the Admin Screen, select User Management to take you to the User Display Screen

  3. From the User Display Screen, select the link from the username of the user to start the Modify User screen.

  4. After any entries are modified in the Modify User screen, select the Submit button and the updated user information is saved in the database.

Top

Add A New Aircraft

To add a new aircraft to the database requires the following steps:

  1. If you have the necessary privileges to add a new aircraft, there will be an Admin link in the menu bar at the top of the screen. The Admin link takes you to the Admin Screen.

  2. From the Admin Screen, select Aircraft Management to take you to the Aircraft Management Screen

  3. From the Aircraft Management Screen, select the Add Aircraft link to start the Add New Aircraft screen.

  4. After all entries are complete in the Add New Aircraft, select the Submit button and the new aircraft is saved in the database.

  5. It is recommended that a keycode (member status of Aircraft) that corresponds to the new aircraft be added to the user list using the Add New User screen. Any aircraft checked out using the tail number keycode will be recognized as a maintenance flight for all reports printed.

Top

Modify An Existing Aircraft

To modify an existing aircraft in the database requires the following steps:

  1. If you have the necessary privileges to modify an aircraft, there will be an Admin link in the menu bar at the top of the screen. The Admin link takes you to the Admin Screen.

  2. From the Admin Screen, select Aircraft Management to take you to the Aircraft Management Screen

  3. From the Aircraft Management Screen, select the tailnumber link to start the Modify Aircraft screen.

Note: The aircraft type may be changed from the Modify Aircraft Types screen.

  1. After any entries are modified in the Modify Aircraft, select the Submit button and the updated aircraft information is saved in the database.

Top

Check A User's Currency

To check a user's currency:

  1. Select the Check Currency link in the menu bar at the top of the screen to take the user to the Check Currency Screen.

Top

Check A User's Bill

To check a user's bill in the database can be accomplished in two ways. The first method is usually used by the manager or office staff to update a user's charges. This is accomplished by:

  1. If you have the necessary privileges to modify user charges, there will be an Admin link in the menu bar at the top of the screen. The Admin link takes you to the Admin Screen.

  2. From the Admin Screen, select Display User Charges to take you to the Display User Charges screen.

The second method is usually used by the general membership when a user is checking their own billing information. This is accomplished by:

  1. Select the Display Charges link in the menu bar at the top of the screen to take the user to the Display User Charges screen.

Top

How does the system work and who wrote it?

The OpenFBO Booking System written by Matt Barclay is based on the Meeting Room Booking System. AircraftScheduling was created from OpenFBO by Jim Covington.

The system is written mostly in PHP, which is an open source programming language that can be embedded in web pages similar in concept to Microsoft active server pages. PHP is especially good at accessing databases.

The database used for the system is either MySQL or PostgreSQL. MySQL is a very fast, multi-threaded, multi-user and robust SQL (Structured Query Language) database server that is also GPL. PostgreSQL is a full-featured multi-user open source Object Relational SQL database server.

The system will run on multiple platforms, including the PC architecture using the Linux operating system. Linux, is a free, open source, unix-like operating system.

Top

Back to the Help Table of Contents





Copyright 2003-2011, Jim Covington
Based on the OpenFBO Booking System written by Matt Barclay
and the Meeting Room Booking System