Manitoba Law Library Launches New Catalogue, including Collection of Historic Judgments

by Jonathan Jacobsen Thursday, October 11, 2018 8:56 AM

The Manitoba Law Library has launched a new online catalogue featuring not only their print and electronic library resources, but a collection of over 17,500 judgments from Manitoba courts spanning 1970 to 1998. 

The new site is available at https://catalog.lawlibrary.ca and is powered by our Andornot Discovery Interface on top of Inmagic DB/TextWorks databases.

While Manitoba judgments made since 1998 are already available digitally in CANLII, the historic judgments in this collection were not previously available online or in any electronic form. Law Library staff scanned print copies of these judgments, then turned to Andornot to create a search engine for the collection.

"The Great Library has long been known to have this "secret" database of unreported judgments. Our goal was to make this collection available to everyone who wanted it, and to be able to retrieve it themselves."

-- Karen Sawatzky, Director of Legal Resources, Manitoba Law Library Inc.

Andornot created a DB/TextWorks database of judgment records out of a combination of a spreadsheet of metadata, listings of the scanned judgment PDF files on disk, and custom programming to extract additional metadata, such as Court Name, from acronyms in an Accession Number.

As the scanned print copies had not yet been OCRd to convert the images to text, we ran a process to do so for all 17,500 files. This allows the full text of the judgment to be indexed and made searchable in the new site.

This Judgments database, along with a library catalogue database also now managed with DB/TextWorks, is indexed in the https://catalog.lawlibrary.ca site.

This new site offers users the features they expect from library catalogues and all search engines: spelling corrections, "did you mean" search suggestions, relevancy ranked results powered by sophisticated algorithms, and facets such as subject, name, date and type of material to quickly and easily refine a search. When searching the historic judgments, users can also refine their search by Court.

If any search words were found in the full text of a judgment, a snippet of the relevant passage showing the words in context is display in search results. The user may then click a single button to open the judgment in their browser, showing the original scanned document, but with their search words pre-highlighted, where ever they may appear in the document. This feature saves the user from having to download, open and search all over again within the PDF for the relevant passage.

"We wanted to make it easier for our users to find material, whether it is an e-book, a print book, or a report, as well as upgrade the look and feel of our catalog. This system also allows us to create useful reports that help us demonstrate the value of our collection."

-- Karen Sawatzky

Contact Andornot for information management and search solutions for your legal or unique collections.

Inmagic Releases DB/TextWorks Version 17

by Jonathan Jacobsen Wednesday, September 19, 2018 7:11 AM

Inmagic has released version 17 of the its popular desktop database management system, DB/TextWorks, with several new features, such as:

1. Undo Record Deletion

Ah, we've all done this... deleted a record we didn't mean to, or worse, clicked Batch Delete instead of Batch Modify and wiped out hundreds or thousands of records. Oops. Of course, we all have robust backup systems (right?) so we've been able to recover from our mistake without too much grief.

But now we can recover deleted records with a couple of clicks within DB/TextWorks. This new feature needs to be specifically enabled for each DB/TextWorks user (in Tools > Options).

Once active, whenever you delete a record, a copy of it is first written to a CSV text file in your User Files directory. This applies both to single record deletions and to batches. The file is stored for 5 days, so you have a short window in which to realize your mistake, but there is no limit to the number of records that can be stored this way. There is then a new menu option (Records > Undo Delete Record(s)) to recover the most recently deleted records, working backwards through all deletions.

One important caveat is that fields in your textbase which are Automatic Number, Automatic Date and similar system-generated fields will most likely not be restored to their original values, but rather set to new ones. For example, if you have a field that stores the date a record was created, when you undo record deletion, the restored records will have today's date as the created date. A small price to pay for the ease of recovering from a mistake, though.

Savvy Windows users who want to rely on this as an even longer term insurance policy could get around the 5 day storage period with a script that runs nightly on their PC to copy the CSV text files to some other folder for permanent storage, where they won't be deleted. (Contact us if you need help with something like that).

2. Search for Duplicate Records

A new entry on the Edit menu, "Browse Duplicated Terms", opens the Query Choices Browser with a new radio button option, "Duplicated Terms", selected. This shows all entries in the selected field which are present in more than one record. In other words, where the Term Index shows all entries, this omits all those that appear in a single record only.

This feature is useful for fields that ought to be unique, such as Call Number in a Library Catalogue or Accession Number in an Archival Accessions or Descriptions database. You,ll quickly be able to see, find and correct inappropriate duplicates.

3. Send Report as Mail supports specifying alternative port

This feature is handy if you use a service such as SendGrid to send bulk emails to addresses stored in a DB/TextWorks databases, as these sorts of services often require that you use a specific port, rather than the email default port of 25.

Bug Fixes

Also addressed in this release are fixes several issues that appeared in the previous one:

  • Specified sort in Genie report is ignored.
  • Dead URL Link Checker: cannot handle TOC info (pound sign) in URL. The checker is more robust, but some URLs still may not be handled correctly (Due to obsolete WinHTTP stack in 32-bit window).
  • Copy Special operation may not include all data in a record.

If you upgrade from a version prior to 15 directly to 17, be sure to read the instructions about the necessary upgrade to your textbases as well as the software. If you're already using version 15, 15.5 or 16, you'll have done this already.

Customers with a current Inmagic maintenance subscription will receive emails from advantage@inmagic.com with instructions for downloading this release. As always, contact us with any questions about this new release, to check the status of your maintenance subscription, or for help upgrading.

Snazzy up your DB/TextWorks databases!

by Kathy Bryce Wednesday, July 04, 2018 10:58 AM

DB/TextWorks has been around since the late 1990’s and we sometimes come across clients with databases that were developed almost that long ago!  Two recent projects we are working on involve rationalizing older databases to modern standards.   It’s amazing how old, ugly, inefficient interfaces can be spruced up through the use of one of our kits for libraries, archives and museums.  We use these as a starting point, and after updating field names to be as descriptive as possible, we import our query screens, report and edit forms and adjust these to show the clients fields.  If you have report designs you like, you can do this too!  Under Maintain > Manage Textbase Elements you can import and export forms from one database to another.  We like to color code our databases and it’s possible to open the exported forms in Notepad or other text editor and carefully edit to replace background colors. Archives_Accessions

Inevitably requirements change over the years, so we help clients review how fields are being used, and suggest adding or deleting fields to better handle their needs.  We also make sure to add automatic number and date fields, appropriate validation and substitution lists and work with clients to clean up their data by batch modifying or updating values through the validation lists. After so many years working with DB/TextWorks we have a lot of tricks up our sleeves, and often export data, adjust it in other software and re-import to split or combine fields.

If you need assistance with your databases, please check out some of our past blog posts that provide various suggestions for improvements.  Note that some of these reference older versions of DB/TextWorks so the location of functions may not be identical.

Spring Cleanup series:

Give your databases a new lease on life and contact us for a quote to help you love them again!

New ThinkWood Research Library Launches

by Jonathan Jacobsen Sunday, July 01, 2018 8:42 AM

The ThinkWood Research Library is a central resource for research on designing and building with wood. An enhanced search engine for this collection has just been launched at https://research.thinkwood.com

The library links to research publications from around the world about structural systems composed of mass timber, heavy timber, and light-frame construction (for buildings five stories and up). Research topics include design and systems, connections, mechanical properties, acoustics and vibration, energy performance, fire, seismic, moisture, wind, serviceability, environmental impact, cost and market adoption.

The library is managed by Forestry Innovation Investment Ltd, a provincial crown corporation, who approached Andornot for assistance with improving management and searching of this library.

Andornot recommended and then implemented a system using Inmagic DB/TextWorks as the back-end database and our Andornot Discovery Interface as the public search system. Data was converted and de-duplicated from two sources: MS Access and a WordPress site.

The result works well for both FII staff who catalog new resources and architects and engineers who have an easier means to search for them.

In the back-end DB/TextWorks database, a few features have proven to be particularly useful in this project, including:

  • Validation lists to ensure consistent application of names, keywords, topics, product types, etc.;
  • dead URL Link Checking to find and edit links to resources that move; and
  • batch modification to clean up older data.

While in AnDI, features such as spelling corrections, relevancy-ranked results, and facets to help narrow a search all combine to make for a simple and enjoyable search process. In particular for this project, made use of AnDI's synonyms feature to equate terms with their acronyms and variations, such as:

  • GLT, glulam, glued laminated timber, glue laminated timber
  • CLT, cross laminated timber, xlam, x-lam, cross-lam 

Whenever any term in a comma-separated set of terms is searched, all the others in the set are also searched for, resulting in broader discovery of resources, especially where different terms have been used.

To improve the visual appeal of the site, we took a small screenshot of each resource (PDFs and web pages) and included it as a thumbnail in the search results.

Andornot was delighted at the positive feedback we received, such as:

"Thank you very much for all the hard work and for all of your expertise. The whole team is very happy with the aesthetics and functionalities of the database and website.

-- Antje Wahl, Manager, Industry Innovation, Forestry Innovation Investment Ltd.

"This is very exciting! Overall, this was one of FII's smoothest web refits/redesigns! Well done to all that were involved :-)

  -- Lindsay Bridgman, Manager, IT, Forestry Innovation Investment Ltd.

Contact us to discuss projects to better manage your resources and library collections.

Arctic Health Upgrades Search Engine for Easier Access by Researchers

by Jonathan Jacobsen Monday, June 11, 2018 7:46 AM

Arctic Health, intended for students, researchers, and anyone with an interest in health aspects of the Arctic, is a central source for information on diverse aspects of the Arctic environment and the health of northern peoples. The Arctic Health website provides access to a database of over 280,000 evaluated publications and resources on these topics. To improve access to this collection, a new search engine has just been launched at https://arctichealth.org

Search results in Arctic Health include published and unpublished articles, reports, data, and links to organizations pertinent to Arctic health, as well as out-of-print publications and information from special collections at the University of Alaska. Resources come from hundreds of local, state, national, and international agencies, as well as from professional societies, tribal groups, and universities.

Arctic Health is managed by the Alaska Medical Library at the University of Alaska Anchorage, by Prof. Kathy Murray and a team of staff. Andornot has worked with this group since 2005 and designed several previous search interfaces using Inmagic WebPublisher PRO and dtSearch.

Prof. Murray approached Andornot last year with several updates in mind, such as to ensure the search results are accessible on mobile devices, not just desktops. Rather than simply adjust the existing site, this precipitated a complete review of the current system, including data entry workflow and the actual content to be included, as well as discussions on a more modern search engine.  

As we do with many projects, Andornot began this challenge by separating out the user groups and functions. Library staff need a system to manage and upload records, with features for adding, editing, converting and validating data. Researchers and health care practitioners, on the other hand, need an easy to use, robust system for searching the vast archive of resources. With such a large number of records, a sophisticated search engine is needed to float the most relevant results to the top of any search.

For the back-end, Andornot developed a web application that uses Inmagic DB/TextWorks for data storage, and Inmagic WebPublisher PRO as a middle layer. We were able to update and re-use an XSLT we'd previously developed that UAA uses to import records in XML format from PubMed. This hybrid approach of using existing commercial software and a custom-developed web application provided the features needed by library staff at a more economical cost than a completely custom written system. 

For the public search interface, we used our Andornot Discovery Interface (AnDI). AnDI is a modern search engine based on the popular Apache Solr system, with features such as:

  • Excellent keyword search engine and relevancy-ranked search results.
  • Automatic spelling corrections and “did you mean?” search suggestions.
  • Full text indexing of linked documents.
  • Facets, such as subjects, authors, places, dates, and material types, to allow users to quickly and simply refine their search.
  • A selection list allows users to mark items of interest as they search, then view, print or email the list.

AnDI helps users quickly find relevant materials from the large collection at Arctic Health and is a significant improvement over the previous search options.

Both systems in this solution are hosted by Andornot as part of our Managed Hosting Service.

Check out the new iteration of the Arctic Health resource database at https://arctichealth.org, and contact Andornot for help with your project.

Month List