BC Teachers' Federation Launches TeachBC Resource Sharing Site

by Jonathan Jacobsen Tuesday, December 02, 2014 3:04 PM

The B.C. Teachers' Federation (BCTF) has launched a new website to enable BC teachers to share resources relevant to the K-12 BC curriculum. Called TeachBC, the site allows teachers to search for lesson plans, activities and other material, as well as upload their own teaching resources and research to share with their colleagues. 

TeachBC is publicly accessible at https://teachbc.bctf.ca and is in the early development stage. It is anticipated that this will grow quickly as BC teachers realize the value of the site as a one stop resource for quality classroom teaching resources.

Andornot developed this new site with the BCTF using a couple of our most popular technologies.

1. A pair of Inmagic DB/TextWorks databases are used as the initial data store for resource submissions. 

DB/TextWorks was selected as it's already in use and familiar to BCTF staff, and provides a quick and easy way of reviewing, editing and approving submissions.

2. The Andornot Discovery Interface (AnDI) powers the web search interface. 

Features such as spelling corrections, relevancy-ranked results and facets to refine a search help users find relevant resources quickly. 

Teachers can search by keyword, then narrow the results by grade, subject and resource type. A recommendation system allows teachers to mark resources they find most useful, and they can also easily Share them on Facebook, Twitter, Google+ or Pinterest. Download counts are also tracked to provide another indicator of popularity.

Teachers can create an account on the site and there is an online submission form which feeds into DB/TextWorks to submit resources for review by BCTF staff before they are available for viewing publicly.

Contact Andornot for more information on developing a search interface for your unique collections.

Adding dot leaders between columns in a DB/TextWorks report

by Kathy Bryce Tuesday, September 30, 2014 5:29 PM

Have you ever tried to create an index report in DB/TextWorks and wanted to have a dots to line up the entries in the two columns? The index entries are invariably different lengths so the number of dots required needs to vary.

image

The trick is to add fixed text into the box for the first column – in this case after the title. In the Box Properties set the Paragraphs tab to No added paragraph breaks. The fixed text dots have to have a space between them as in . . . . rather than ……..  This allows any excess dots for long entries to be bumped to the next line.  Under the Position tab then set the Maximum height to 1 line.

image

You may need to adjust font size and margins if your index terms are longer than one line.

Contact us if you need help with your Inmagic DB/TextWorks report designs.

How to Add a Unique Record ID and Date to an Existing Database

by Jonathan Jacobsen Wednesday, May 28, 2014 6:09 PM

The principles of good database design suggest that every record in a database should have something that uniquely identifies it and distinguishes it from every other record. In a small library catalogue, it may be that every title is different from every other, but in any larger database, there's a good chance there will be more than one very, very similar record. 

When it comes time to do more with this information, such as import it into Inmagic Presto or the VuFind discovery interface, or clean-up some older records, it's imperative that every record be able to be uniquely identified.

It's also good practice to have fields that track the date a record was created and the date it was last modified, for similar reasons.

It's very easy to create these fields in your database structure, whether in Inmagic DB/TextWorks or another system, when you are first building the database. But what can you do if you already have a database with thousands of records, and no unique record identifier or dates created or modified? With DB/TextWorks, it's very easy to add this information even after the database was built and populated. 

There are four main steps to this:

  • Backup all your existing records, just in case of a problem.
  • Verify that these fields don't already exist.
  • Add the fields to the database structure.
  • Populate the fields with data.

Backup the Database

1. Open DB/TextWorks but don't open a database. Select Manage Textbases > Dump Textbase. 

2. Browse to the location of your database and select it. 

3. Next, pick a folder to store the export in and give it a meaningful name.

4. When the export is complete, you'll now have a backup you can reload, just in case anything happens.

Verify Fields

5. Open the database in DB/TextWorks and, if it has password protection, be sure to sign in with the Master password, so you have full access.

6. Select Maintain > Edit Textbase Structure.

7. In the Edit Textbase Structure window, scroll through the list of fields to check that you don't already have a unique ID and/or dates created or modified fields. You may be able to identify them by Name (e.g. RecordID, RecordCreated, RecordModified) or by Type (e.g. Automatic Number, Automatic ID, Automatic Date).

Add Fields

8. If none are found, select Edit Fields. You will now enter information to create the new fields listed below. Be sure to select Add rather than Change after entering information for each new field.

Field Name RecordID
Field Type Automatic Number
Other Settings By default, the automatic numbering will start at 1 and increment by 1; there's usually no reason to change this.
Field Name RecordModified
Field Type Automatic Date
Other Settings Update Entry: When Record is Created or Modified.
Date Components and Format: you may choose whether to include the time, or only the date, and which format. We usually select Date Only and Short Date Format, unless your data will be imported into Presto, in which case Date and Time is best.
Field Name RecordCreated
Field Type Automatic Date
Other Settings Update Entry: When Record is Created.
Date Components and Format: you may choose whether to include the time, or only the date, and which format. We usually select Date Only and Short Date Format, unless your data will be imported into Presto, in which case Date and Time is best.

9. With all of the information entered, click Finish and OK to save your changes to the database structure.

Add Data to Existing Records

10. Select Search > Find All Records to retrieve all records from the database. This may take some time, but you can click the Stop button in the bottom status bar of DB/TextWorks to stop the formatting on the screen.

11. When the records have finished loading, select Records > Batch Modify. The trick now is to make a perfectly innocuous change to every record in your database. As DB/TextWorks goes through every one, since the database now has Automatic Number and Automatic Date fields, they will automatically be populated. 

If you happen to have an unused field in your database, you could populate it with some value, and then remove that again in a second batch modification.

Or, you could add a new field and use batch modification to populate it with some value. You can then either leave it as-is, perform another batch modification to delete the data from the field, or delete the field altogether.

The batch modification feature in DB/TextWorks is quite sophisticated and an explanation of it would expand this blog post to unwieldy dimensions. However, the help built-in to DB/TextWorks explains all the options, including new features added to recent releases. 

12. When the batch modification is complete, every record will now have a unique identifier and the date the record was last modified. To verify, search for some records and view the ID and dates.

13. Now that you have a unique ID, you can configure DB/TextWorks to record it in the textbase log file every time a change is made to a record. This has proven invaluable to several clients this month when accidental changes were made to records. We were able to use the log to undo those changes. To configure your textbase log, select Maintain > Edit Textbase Structure again, then Log File. Select your RecordID field as the First Identifying Field, and something like title as the Second.

If you need any help with the above, just let us know.

Thunder Bay and Simcoe Muskoka Health Units Launch Shared Library Catalogue

by Jonathan Jacobsen Monday, May 12, 2014 6:42 PM

In 2012, Andornot worked with the Thunder Bay District Health Unit to upgrade their DB/TextWorks library system from the older Inmagic Library Module kit to the much newer Genie Integrated Library System

This year, the Simcoe Muskoka Health Unit merged their MS Access library catalogue into this shared Genie system, providing both health units with a modern, up-to-date system for managing library holdings, serial subscriptions, orders, and more.

Amongst health care agencies in Canada, it is quite common to share library systems and resources – it makes good economic sense, and helps users and patients to more easily find resources with a single search point.

The public and patients may search the combined library holdings through http://ophc.andornot.com, a discovery interface powered by the VuFind open source software. 

VuFind includes features such as:

  • Spelling suggestions and corrections. 
  • Faceted browsing to allow users to refine searches by subject, date, collection, and other key fields. 
  • A mobile interface. 
  • Google Book covers for records with ISBNs. 
  • Permalinks to records to allow easy bookmarking and social sharing. 
  • User accounts to allow users to save searches and records to personal lists.
  • RSS feeds for user-created searches.

A custom request form developed by Andornot allows users to direct a request to borrow items to the appropriate health unit.

Data is automatically imported into the VuFind system nightly using the Andornot Data Extraction Utility, so there’s no additional work needed by library staff.

The shared Genie system is hosted by Andornot as part of our managed hosting service. Working with two separate groups on a joint system can be tricky, but in this case the cooperation between the library staff in the two health units allowed us to complete the project in a very tight time frame.

"Thanks very much for all of your hard work on this project. It is very much appreciated by us and will be by our clients." Amy Faulkner, Librarian, SMDHU

"You’ve done an exceptional job and we’re all quite appreciative of your hard work and discipline to get this through in such short time frames." Shant Alajajian, Librarian, TBDHU

Contact us to discuss upgrades to your library system and public search interface.

Peel Health Region Upgrades Library Search Interface

by Jonathan Jacobsen Wednesday, April 23, 2014 11:09 AM

The Peel Health Region library in Ontario has been using Inmagic DB/TextWorks for a number of years to manage a small, specialized collection of health care resources. 

The library contacted Andornot recently for assistance in updating the public search interface to the catalog. After reviewing the catalog and discussing their needs, Andornot recommended an upgrade to both the DB/TextWorks databases and desktop interface, as well as creating a new web search interface.  

The library’s DB/TextWorks Catalog database was upgraded to the latest one from the Andornot Starter Kit, featuring well-designed forms, query screens, and script buttons for easy navigation.

A new public search interface was built from the web portion of the Andornot Starter Kit, and is available at http://peel.andornot.com, hosted by Andornot in our data centre. This interface is based on the Twitter Bootstrap responsive web framework, allowing the site to reformat itself for the user’s browser, so that it’s as usable on full-size desktop browser as on a tablet or smartphone.

Librarian Diana Robertson was particularly interested in linking to PDFs of reports. PDFs are currently stored in a document management system only available internally. With catalog records already available for many of these, linking to the PDFs and making them available in the web interface gives much greater public access.

A list of popular topics on the home page (constructed with the help of the Andornot Search Cannery Wizard) provide quick access to areas of the collection. 

The site also features icons to indicate material type, and a selection list to allow users to email, save or print items of most interest to them. These features are standard with the Andornot Starter Kit.

Contact us for assistance with upgrading your catalog to more effective desktop and web interfaces.

Month List