1.
Unzip
the program sources (.zip) with the help of an unzipper
(Winzip, etc.) into a dedicated directory.
2.
Create
a new virtual web directory on your web server. Choose the directory of step 1
as your base folder.
3.
Activate
these access rights for the directory: „Read“, „Execute Scripts“ and „Write“.
4.
Rename
Reservation.3.2.mdb as Reservation.mdb in folder “database”.
5.
Use
the windows explorer and add permission settings „Read“ for the accounts
IWAM_<Hostname> and IUSR_<Hostname> on all folders, subfolders and
files, including the base directory.
6.
Use
the windows explorer and change permission settings to „Full“ for the accounts
IWAM_<Hostname> and IUSR_<Hostname> on these folders and files:
Base directory, database directory, reports directory, Reservation.mdb file.
7.
The
DLL-files must be registered on the server by starting file register.bat in the
windows explorer folder. The pc-user must have the right to change the system
registry.
8.
Install
the Chilkat SMTP Service by double clicking ChilkatSMTPQ.msi.
The installation creates a folder C:\temp\ChilkatSmtpQ in directory with
subdirectories as this:
illustration 1.1:
smtpq service folder structure
9.
Start
the ChilkatSmtpQ Windows service under the system account thereafter. Start the
SMTP service if you use CDONTS:
illustration 1.2: the
chilkat stmp queue service
10.
If you
wish to make profit out of the standby-functionality of the program, then create
a Windows task based on the file reservation_check_queue_service/
reservation_check_queue.bat. You can define the task time interval freely.
illustraation 1.3: geplanter
task für reservation check queue batchdatei
11.
Read
file reservation_check_queue_service\reservation_check_queue.bat and modify the
file as required.
12.
Start
the program in your web browser. Type in on the address line:
http://<Your URL>/<Your
Directory>/default.asp
If the program doesn’t start
correctly, then restart the www-publishing service in the computer
administration.
13.
Log in
with login-id „Admin“ and password:
„Admin“.
Use version 3.2 directly and without migration,
and transfer your existing program data and changes, if you have made only a
few changes and if you currently administrate only a handful of reservations, users and events. Else
1.
Create
a backup of your existing program folder (especially of Reservation.mdb).
2.
Restart
the WWW publishing service (or the IIS Admin Service for NT).
3.
Unzip
the program sources (.zip) with the help of an unzipper
(Winzip, etc.) into the existing directory on the web server. All old files
shall be overwritten. Copy your old database Reservation.mdb to the database
folder.
4.
Apply
access permissions to the folders and files as described in chapter ‘Steps for
a First Time Installation’.
5.
Register
the new dll-files by double-clicking register.bat in the windows explorer
folder. You must have write permission to the system registry.
6.
Install
the Chilkat SMTP Service. Double-click ChilkatSMTPQ.msi. You can optionally use
MS CDONTS, too. See in the previous chapter, step 8 as well.
7.
If you
want to use the standby functionality of the program, than create a windows
task, which periodically scans a POP3 for reservation confirmation mails. The
task must be based on reservation_check_queue_service/
reservation_check_queue.bat. See in the previous chapter, step 10 and 11 as
well.
8.
Restart
the WWW service. Copy your old database reservation.mdb into the folder
‚database’. This folder already contains the new database Reservation.3.2.mdb.
9.
Start
the new asp-program by typing on the address line of the web browser:
http://<Your URL>/<Your
Directory>/default.asp
If the program doesn’t start
correctly, then restart the www-publishing service in the computer
administration.
You will get this message (with the corresponding version numbers):
illustration 1.4: database
migration notification
Click „OK“ and wait until the
upgrade has finished.
10.
Verify
that the file Reservation.Upgraded.mdb has been moved to Reservation.mdb. Do it
manually if not.
11.
Start
Reservation 3.2 in the web browser:
http://<Your URL>/<Your
Directory>/default.asp
12. Check the correct setting of the mail component in program
menu ÖProgram Settings.
illustration 1.5:
installation result in computer administration
As an example, the virtual
directory is named ‚sgz3.0’ here.
ASP Configuration
Session Timeout
The duration of a user session must be defined
on the web server (see Computer
Administration -> <Your Website > -> «Properties» -> «Root
Directory»-> «Configuration... »-> «Application Options»).
Set the ASP-Skript timeout to at least 90 secs.
“Activate Buffering” must be set to true.
Database Security
In order to protect the database
Reservation.mdb (it shall not be possible to download it directly via the web
browser), a folder ‚database’ is provided which contains the access file. We
prevent http-access to this folder (see as well http://www.4guysfromrolla.com/webtech/022300-1.shtml).
Open the computer administration settings, go
to <Your Website> -> database folder -> «Properties» -> Register
«Directory».
Define these settings:
ILLUSTRATION 1.6:
CONFIGURATION of the ‚DATABASE’-folder
‚Read’ access must be deactivated, set None for
the application permissions.
The program uses a machine dependent activation
key in its license model. The program may be used without entering the correct
key, but this limits the usage of the program to 15
user profiles and 15 reservations.
We will send you another activation key,
whenever you want to migrate the program to another server.
Illustration 1.7: request of the activation key
If not entered correctly, the key is
re-requested every time an administrator logs
in.
The program is ready for configuration and
application, after the correct key has been entered.
Reservation 3.2 for the internet offers:
|
Feature
|
Here you can
|
|
Administration of any reservation item
|
§
Add
reservations
(incl. multiple reservation object selection and incl. recurring
reservations)
§
Change
and delete reservations
§
Search
for and sort reservations
§
Correct
reservation time overlaps
§
Standby
functionality
§
Add
comments
|
|
Administration of any reservation add-on item
|
§
Add
a reservation attribute
§
Delete
and change a reservation attribute
|
|
Administration of any user data
|
§
Add
a user profile
§
Change
and delete user profiles
§
Search
for and sort user profiles
§
Choose
between card and list views
§
Mail-subscription
by user
§
Forgot
password problem solver
|
|
Administration of user groups and group rights
|
§
Assign
users to any user group
§
Change
the program rights of a group
|
|
Administration of any reservation item
|
§
Add
a reservation item
§
Change
and delete a reservation item
§
Search
for and sort reservation items
§
Deactivate
a reservation item
|
|
Report administration
|
§
Start
app. 50 reports
§
Add,
change and delete reports
§
Select
any table data, based on any SQL statement
§
Export
all data in Excel, tsv, csv, record and HTML format
|
|
Administration of any dropdown box value
|
§
Add
a selection value
§
Change
and delete selection values
|
|
Program configuration
|
§
Change
the graphical user interface
§
Change
any program text
§
Change
any help text
§
Add
a news text
§
Keep
control of data integrity
§
Choose
between CDONTS and Chilkat as email components.
|
|
Calendar configuration
|
§
Change
the graphical user interface
§
Decide
on what data to display.
|
|
Calendar overview
|
§
Show
all reservations per day, week or month
§
Add
reservations with date display
§
Choose
between 10 different views, including grouping by any reservation item on
x-axis.
§
Selection
of the first week day.
§
Choose
between details view and compact view.
§
Attach
any document and provide it via the calendar.
§
FreeCalendar!
allows to publish all reservations in a browser without the need to log in to
the program.
|
|
Automatic Mail Notification
|
§
Define
2 SMTP-Hosts for a program event
§
Enable
or disable sending of messages globally
§
Retrieve
reservation confirmation mails from any POP3 host
|
|
Online help
|
§
Request
context sensitive help
|
|
Multilanguage Capability
|
§
German,
English, French, Spain, Italian (to come).
|
Plus
any feature as described in the ‘What’s New Document’
If you’d like to migrate from version 3.1 to version
3.2, then the explanation of the new features starting with page 20 will be of most
interest to you.
After having logged in with login-id „Admin“ /
password „Admin“, the first you see is the overview screen below:
Illustration 2.1: program overview
The blue menu bar on the left looks identical
on all program pages. All program pages can be changed with the help of these
two menu items:
|
Menu item
|
Configuration Object
|
|
ÖProgram-
Settings
|
Serves to change all program texts
|
|
ÖCalendar-
Settings
|
Serves to change the calendar interface
|
Click on both menus ÖProgram-Settings
and ÖCalendar-Settings, and just try out any change at will. Start
the online-help for every item, to obtain more in-depth information.
! Before making any changes, store a
screenshot of all configuration settings. The original settings can not be
restored automatically by the program.
These are
the most important settings:
|
Setting
|
Example Value
|
|
«Skin Selection»
|
Click opens the
skin selection window.
|
|
«Program Title»
|
Reservation List
->
Can be formatted using any HTML command
|
|
«Supported Languages»
|
-> Click on a flags changes the language of
the
program user interface globally.
Mark a
checkbox if you want to provide
the linked
language to the user for
selection.
|
|
«Change Program Texts»
|
-> Click opens the text_edit page
|
|
«Mail Trigger Configuration»
|
-> Click opens the mail trigger settings.
See on page 20.
|
|
«Reservation Queue Config.»
|
-> Click opens the reservation queue
settings.
|
|
«English Date Format»
|
Auto-Detected
|
|
«Reservations for registered users only»
|
Activated
|
|
«Single-Login»
|
Deactivated
|
|
«Delete old reservations after <x>
days»
|
170
|
|
«Disable Login for Non-Admins»
|
Deactivated
|
|
«News Text»
|
Any:
->
Can be formatted using any HTML command
|
Click the command button „Change Settings“ to
activate the changes.
Click on the calendar symbol below to verify
the correctness of a setting:
Illustration 2.2: calendar symbol
Three users are already part of the database
when you install the program:
|
User
|
Password
|
Usage
|
|
Admin
|
Admin
|
Serves to configure the program initially
|
|
Gast
|
Gast
|
Serves to only have a look at the program
|
|
Neu
|
Registrieren
|
Allows a new user to add his user profile
|
For security reasons the passwords must be
changed for the already installed users:
1.
Change
the administrator account in the menu ÖUser Profile Administration–List.
Replace all data (incl. login-id and password) with yours, if you wish to
become an administrator of the program.
2.
Change
the passwords of both users Gast and Neu in the menu ÖUser
Profile Administration–List.
3.
The
program rights of all user groups can be defined in the menu ÖUser Group Administration. We
recommend to take over the settings for the users Neu and the administrators
group, as configured initially.
Every user logged in may add new profiles if
the according rights are set for his group.
A person not yet obtaining a user profile, must
first register. After having logged in with login-id „Neu“ and Password
„<Your Password>“ a new candidate may add his profile:
illustration 3.2: program rights are reduced for
the user Neu
A person may re-login with the new login-id and
password. The program rights of the person initially correspond to the rights
of the standard user group.
You need about 10 minutes to allow reservations
of an other object than aircrafts etc. Follow these steps:
1.
In
menu ÖProgram-Settings -> Program Text
Modification, select your language and then choose page „Item_add“.
2.
Rename
the labels of the text fields according to your needs. E. g., enter „Table
Collection“ instead of „Aircraft Collection“, „Place-No“ instead of
“Immatriculation”, etc.
Fields with a „*“ at the end are displayed in the object lists, such as
“Aircraft Administration”, etc.
You can also leave a text field empty. Fields without names are not displayed
on the corresponding page.
3.
Change
the texts as well for these pages (and in this order):
- item_add_reply, item_delete_reply, item_edit, item_edit_reply, item_view
- calendar, date_selection
- home
- menu
- record_not_found
- reservation_add, reservation_edit, reservation_view
- (help: Change term “object”)
4.
In
menu ÖDropDown Box Administration, the
names of the boxes have been modified automatically. Delete unwanted values
from selection lists, or insert new values:
Choose a dropdown box and the value you want to remove. Let the long
text field name d „Add / Delete / Change“ empty and press the „Value Add /
Change / Delete “ submit button.
Choose a dropdown box and write a new value into the long text field
„Add / Delete / Change“. Then press the „Value Add / Change / Delete “ submit
button.
5.
Reservation
events are administrated in the Event Administration menu and not in the
Dropdown Box menu.
6.
In
menu ÖReport Execution, rename the reports
according to your object. Click on the question mark beside of field “Report
Name” to know how it works.
The report data will remain unchanged.
7.
Now
change into menu Ö<Your object> Collection and
specify your reservation items.
Repeat steps 1-5 for the other languages you
wish to support.
A SMTP IP port must be open on the web server,
else no mails can be sent.
In menu ÖProgram-Settings, choose between
CDONTS or Chilkat email component. Note that CDONTS does not support
reservation confirmation by email. Additionally, CDONTS needs the SMTP service
running on your computer.
Then click on „Mail Trigger Configuration“ in
this same menu.
Have a look at the Online-Help (?) for
every mail option. Initially, no mails will be sent when a user just looks at
the program pages (select option). Define the program events for which you want
to receive messages. Save your settings with a click on the „Change Mail
Trigger“ button.
Activate the SMTP-letter symbols on the right
side of the page. Again, have a look at the online help for every field. Enter
your settings and do send a test mail in order to verify your configuration. The
testmail functionality is available only when you use Chilkat as email component.
When the test mail has been successfully sent, you might want to transfer some
or all settings to the mail hosts of your other program pages (e. g. for the
page “User Profile Collection”). This is reached by use of the last two boxes
on the page.
It looks like this if you want to copy the settings of the fields “ESMTP Login”
and „ESMTP Password“ to all other program pages and mail host 2:
ILLUSTRATION 3.2: TRANSFER OF
MAILHOST-CONFIGURATION ELEMENTS to other pages
Test the mail delivery after having modified the mail host(s). Create, modify
and delete reservations. Reservation 3.2
writes all mails into a queue stored in the access table mailqueue. The mails
are only processed by the server, if a users logs out from the program (via
menuitem ÖLog Out) or when the ASP-session
ends on the web server. The goal was to maintain good program performance for
the user.
If you installed the ChilkatSMTPQ service, the program writes a file *.eml into
directory C:\temp\ChilkatSmtpQ\sent for every generated mail.
If you use the SMTP service for CDONTS, the
emails are sent immediately as well. If you want to see the content of the
emails, then stop the SMTP service and open the mails in the pickup-folder of
your SMTP mail root folder.
Reservation 3.2 supports queue functionality.
The procedure is:
illustration 4.1: program
notification when date collisions occur in reservations
a.
A user
is informed in a special dialog window whenever the system detects a date
collision, caused by a new reservation. The user is informed about the position
of his reservation in the queue. (usually he gets nr. 2 or 3, etc.).
b.
The dialog
window allows editing, deleting or accepting of a collision reservation. This
applies as well for every single object, when multiple reservation objects have
been reserved at once.
c.
Now,
when the nr. 1 reservation vanishes due to reservation deletion or change, nr 2
becomes nr 1 by default. The owner of nr 2 receives a mail or sms message
automatically, which informs about the new position in the queue.
illustration 4.2: program
request for reservation confirmation
d.
The
new nr 1 reservation must be confirmed within the time span configured in menu ÖProgram-Settings. Confirmation is reached
either by logging in to the system, or by sending back the confirmation request mail to a dedicated
POP3 mail account.
e.
The
system uses a reservation queue service, which periodically checks the POP3
account for new reservation confirmation mails. Once the service detects a
confirmation mail, the reservation is marked as confirmed.
The service runs in the subfolder „reservation_check_queue_service“. The
batchfile „reservation_check_queue.bat“ can be started periodically either
based on the windows at command or based on windows scheduler.
f.
If a
reservation owner misses confirmation within the time span set, he will be
informed next time when he logs in to the system.
illustration 4.3: program
notification for missed reservation confirmations
g.
Once a
reservation confirmation is missed, the reservation will be queued back. If no
nr. 2 exists in the queue, the reservation remains nr. 1, even when a new
reservation is made which leads to a collision.
With the help of the date indicator on the right side and knowing the
confirmation time period, it’s up to the users to decide who will get the
aircraft.
The queue mechanism works as well when a
reservation is being changed. Once a reservation change of dates leads to a
collision with an existing nr 1 reservation, the edited reservation is placed
at the back of the queue concerned.
Elder reservations are given priority over new
reservations.
The current queue can be looked at either
within the queue reports, or in the menu ÖReservation-Administration.
Do not forget to get more insight in the online
help (?) in program menu
„Reservations-Queue Configuration“ under ÖProgram-Settings.
Most problems and questions can be solved using
the online help. For this reason, only some advanced program features will be
explained in this chapter. These features depend on settings of the menus ÖProgram-Settings and ÖCalendar-Settings
in most cases.
This data may be changed by the programmers of
Reservation 3.2 only.
A separate window opens if you click on a day
cell on the calendar:
illustration 5.1:
detail view of the calendar day cell
ØName
(Muster, Felix), ØAircraft (Z1) and ØEvent (Wochentagsflieger) are hyperlinks
referencing the user, aircraft and event program pages.
The name is displayed as a hyperlink only, if
it has not been entered manually on the reservation page. Manual entry becomes
possible, if the checkbox «Reservations for registered users only» is
deactivated in the menu ÖProgram-Settings.
Hint: From- and until-
reservation times are shown for the first and the last day of a reservation
period only.
Direct click on a
reservation opens a little window which allows you to either delete or change
this reservation.
ÖDropdown
Box Administration allows you to delete all user groups except for the standard
group. If a user group is being deleted, all of its users are re-assigned to
the standard user group.
Hint: The administrator group
can not be selected in the value box. Hence, it is not possible to delete or
change this group.
ÖUser
Group Administration serves you to set program rights according to your needs.
All command buttons of the program pages concerned are adapted automatically.
Two examples:
illustration 5.2:
Adminstration of user groups - Example 1
The right „Delete Report“ has been disabled for
the person logged in. Thus, this function is not displayed on the command
button on the report page (standard would be „Report Execute / Save /
Delete“).
If the right to select data is disabled (e. g.
for the menu ÖUser Profile Administration), then
the person logged in is allowed to see his own data only:
illustration 5.3:
Adminstration of user groups - Example 2
Every time a user of the administration group
logs in, the program checks whether old reservations exist (corresponding to
your setting «Delete old reservations after <x> days» in ÖProgram-Settings). If the result is positive, a
removal commitment is requested:
illustration 5.4:
request of the reservation deletion committment
Practically no static texts exist in the whole
program. Everything can be changed, as long as it remains in coincidation with
the program procedural logic.
The program texts (menus, etc.) may be changed
by clicking the «Change Program Texts» link in ÖProgram-Settings
for every page.
A mouse click besides of the version number
(red point) allows an administrator to switch quickly to the program texts of
the corresponding page:
illustration 5.5: quick
step to program text modification
Click on a flag changes the language of all
texts:
illustration 5.6:
Adaption of program texts
We recommend to fill any text box whose value
comes with a star at the end (e. g.
Type*). These fields are being used to
set up the sort lists in the relevant pages (e.g. for the page ÖAircraft Administration).
! Store a screen shot before you change anything!
! In page item_add (see illustration above) texts
no 3 (here “Group Sign”) and 4 are used to indicate the reservation object in
the reservation pages. Thus try to use attributes for these texts which allow a
reservator to uniquely identify the objects.
! If you intend to change menu items (see program
page „menu“), then do keep the Nomen – Verb
order (e. g. Aircraft (Nomen), Administration (Verb/Nomen)). The first item is used for the dropdown box description (e.g.
Aircraft¬Type) on the dropdown box administration page.
! Do not use quotes („“) and inverted commas (’)
in the names of buttons (‚Reset’, ‚Add’
etc.) and in the texts of user commit requests (‚Please enter your status?,
etc.). These may cause errors in HTML pages and in JavaScript functions.
Either, to not use these characters in the names of data attributes, e.g.
‚Availability’, ‚Business Phone-Nr’ etc:
illustration 5.7: Do not use
special characters for buttons, dialog boxes, etc.
The way how data is stored in the database and
displayed on the screen typically depends on several environment settings, such
as the country locales. Selecting the checkbox simply switches date formats
from DD/MM/YYYY to MM/DD/YYYY.
You must not switch the date format once you
have made reservations, because this may cause incorrect results (wrong date
sort order, etc.).
http://<ihre url>/<Virtual
Directory>/free_calendar.asp opens the calendar page, offering
you full calendar functionality without the need to log in to the application.
Rights assignment is based on the Guest account.
Repeat a reservation periodically. The options
are very similar to the options of the Windows task scheduler:
illustration 5.8: recurring
reservations
Instead of reservations, comments can be added
for any day or time period in the calendar. The options still remain the same
as for reservations (pass the same recurring parameters). Only leave the
reservator (“for”), the reservation object and the event empty, in order to add
a comment:
illustration 5.9:
calender-comments
Clicking the little question mark on the login
page opens the secret question / secret answer wizard. Once you answer the
secret question correctly, you will be forwarded to your user profile directly.
Just set the value to <font
color=#[0-F] [0-F] [0-F] [0-F] [0-F] [0-F]>YourValue</font> for
any new selection value you want to add in menu ÖDropdown Box Administration. Or look
how it’s done for dropdown box Event¬Colors.
http://<your url>/<Virtual
Directory>/Session.html opens the program log file. Data changes
are not logged, only page access. If you wish to log data modifications, either
use the mail functionality or have a look at the modification reports in the
program.
You can have a look at all data in the Access
database directly.
! Please do not make changes in the database manually! If you intend
to make changes, create a backup of your original mdb-file in advance.
JavaScript must be activated in your browser to
allow popup windows and confirmation requests.
Problem:
“I have installed the program, but I get errors when I enter the initial URL or
during program execution.“
Answer:
1. Most errors occur due to insufficient file and folder permission settings.
Set the
permission rights to ‘Full’ for the
IIS Accounts on all folders and files, then retry.
2. Then remove write permissions step by step
Mail Sending
Problem:
“Mail records are written into the access table mail queue, but I never receive
any mails. Mail delivery is activated in menu ÖProgram-Settings.“
Answer:
1. Log out from the program with ÖLog Out.
2. Are there still entries in table mail queue? If yes
3. Check the file session.html under
http://<your url>/<virtual
directory>/Session.html.
Can you see <- Application ended
at’ entries? If not
4. Set full permissions for machine user IWAM_<Host> on folder
http://<your url>/<virtual
directory> in the windows explorer.
Check this further, if the problem is not yet solved:
5. Verify that the application name is set on
register ‘virtual directory’ on the
properties for the virtual directory
of the web site.
6. Delete file Session.html.
7. Restart the www-publishing
service and retry to send test mails in one of the
program mail configuration dialogs.
Problem:
“The Chilkat SMTP Queue service is installed correctly, but we cannot see mails
spooled in the C:\temp\ChilkatSmtpQ\sent directory.”
Answer:
1. Check that the Chilkat SMTP Queue service is running in windows services.
2. Check these
program settings:
- Mail trigger
configuration must be “enabled” in menu ÖProgram-Settings.
- The check boxes must be selected for the events which shall trigger mail
delivery.
See in page “Mail Trigger
Administration”.
- Testmail delivery must work correctly in page “Mailhost Administration” for
the
chosen event.
- Disable the flag “Do not Send Mail to Actor” in page “Mailhost
Administration”.
- In case you wish to send SMS messages, temporarily disable flag “Only if
Primary
Host Fails” in page “Mailhost
Administration”.
- Recheck mail functionality by adding a reservation. Change of user passwords
and
other secret info does not trigger
mail sending.
Problem:
“I use Microsoft CDONTS as email component, but I never get mails.”
Answer:
1. CDONTS needs the MS SMTP service running on the computer.
2. Stop the SMTP
service temporarily. Make some reservations in the program, then
look for emails in folder
C:\inetpub\mailroot\pickup (or in the mail root as
configured on your computer).
3. Ask your
system administrator.
Problem:
“I receive error messages such as ‚Provider-Error <Number...>’ “.
Answer:
1. Restart of the www-publishing service
should solve the problem.
Problem:
“My browser is Opera – the date picker is not visible in the calendar.“
Answer:
1. The date picker is not supported with
Opera, due to the limited frame support of
this browser in version 6.x. However,
it works fine in Opera Version 7.x.
We offer free email support with the purchase
of this program. Send your questions and recommendations to:
reservation@huginfo.ch
Or use our Support forum
on http://www.hugres.ch/forum
