- Imagine Canada

by Administrator Sunday, November 27, 2005 9:55 AM
Imagine Canada's web site is one of this year's multifaceted projects. Along with implementing a new web site template, our EmailSavePrint (ESP), we also developed a Ratings Add-on module where users can submit comments, rate resources and provide comments on their usefullness. We also added a web based Administration area where ratings and comments can be reviewed and approved to be displayed along with each catalogue record. Finally, we also created Imagine Canada's "Special Collections" catalogues which are subsets of their catalogue each having their own search interface.

Visit their site @

CARILAW: Caribbean Law Online

by Administrator Tuesday, November 01, 2005 12:38 PM
Andornot has been working with Velma Newton, the law librarian at the University of the West Indies in Barbados, to put up the CariLaw website which includes a database of Commonwealth Caribbean primary legal materials. Access to the cases and treaties in the database is by subscription, but a sample database has been developed as a demo for potential subscribers with access via a search page and a listing by jurisdiction using canned searches.

The documents were originally created in MS Word, each with extensive controlled vocabulary indexing and these were imported into DB/TextWorks using the new Import Filters. A transformation application that works within DB/TextWorks was developed by Andornot to then move the controlled indexing into the appropriate database fields.

Andornot has been able to undertake all the design plus installation of our subscriber authentication system remotely, thus minimizing costs to the client for travel.

Contact Andornot for more information on consulting or web site design services. Click here for more information on the Andornot authentication system.

International Directory of Forest Information Services

by Administrator Sunday, October 16, 2005 11:42 AM
The International Directory of Forest Information Services: Libraries, Documentation Centers and Subject Specialists is available online at

The Directory was formally launched at the IUFRO European Regional Conference in Copenhagen in August 2002, however it was manually updated until late 2003. Andornot was approached to host the database and develop a web interface that would allow participants to both register and update their records online.

The site uses the Andornot templating system and WebPublisher PRO to provide an easy to maintain site that permits both web searching and data entry. Some simple measures were also taken to provide protection against misuse as this is a publicly available website.

Design specifics:

To avoid the possibility of pranksters entering records into a live database, an access control field was added to the database that allows the silent password (i.e. the default web access) to see only records with "Active" in this field.

When new entries are submitted through the Registration page they are tagged with a status of "New" and cannot be seen until validated and changed to "Active" by the IUFRO administrator. The registration page was exported from DB/TextWorks as a web edit form and then modified to include code for this hidden field, i.e.

Registrants in the directory can update their own records using their email address and a password. We used a Random Password Generating program which creates passwords that contain just alphanumeric characters to avoid inserting characters that have meaning to WebPublisher. We then populated the database with these passwords and created a DB/TextWorks form that included the persons name, email and new password. The text also gave instructions on how to update their record and change their password to one memorable to them. We then used the "mail each record to a different address" feature within DB/TextWorks to notify everyone of their passwords using this form.

Registrants can update their own records through the login page. ( This was created in DB/TextWorks as a query screen and then exported to HTML. A couple of validation scripts were added to this page to ensure that searches find only the one record that exactly matches the username and password. The first script turns all entries into terms, i.e. ="term" to prevent anyone entering >h* to find any entry starting with h or telus to find records with a Telus email account. It also disallows a * as a search term. Another script ensures that there is an entry in both boxes.

The registration form has popup validation lists. If new registrants enter a term not in the validation lists it will not be added. However when an Administrator edits the record to change the status to Active, on saving, these new values will be added to the validation lists. This is set in the DB/TextWorks forms. The Registration form has the value and the Admin one .

An unlinked page has been set up where the Administrator can search the Status field for newly added records. The admin password must be entered to edit these new records or delete records. Another script ensures that a password is entered to prevent edit access by anyone inadvertently finding this page. Additional display forms were created matching the public search forms but with Edit and Delete options.

The IUFRO site highlights the possibilities available with WebPublisher PRO and some minimal scripting. For sites where more stringent security or roles based access is needed, Andornot offers complete application design services.

Contact Andornot for more information

Glenbow Museum & Archives

by Administrator Wednesday, July 27, 2005 9:36 AM
The web developers for this project purchased our WPDK to customize the interface and add shopping cart functionality. They have also used the WPDK to develop many other online databases for their various collections. Visit the Glenbow Museum's Collections & Research web page @

Below are some of the online databases @ the Glenbow Museum & Archives...

The Archives Main Catalogue contains descriptions of unpublished archival records, such as diaries, letters, and minute books, for over 3000 families, organizations, and businesses in southern Alberta.

The Library Main Catalogue contains descriptions of over 100,000 books, pamphlets, journals, newspapers, and government documents relating to the history, art, Native peoples, and popular culture of Western Canada, with an emphasis on Calgary and southern Alberta.

The Map Collection Catalogue contains descriptions of over 5,000 maps relating to the exploration, settlement, and development of Western Canada, with an emphasis on Calgary and southern Alberta.

The Music Catalogue contains descriptions of over 300 pieces of sheet music (1867-1980s), and over 500 sound recordings (1914-2000s) written, published or performed by western Canadians, or which have a Western or Canadian theme.

PARC Library Catalogue - AIDS Vancouver

by Administrator Wednesday, July 27, 2005 9:32 AM
This is a new hosted site also featuring our WPDK for users to request items plus canned searches for topics on the Quick Search page. Visit their site @

Month List