3 under-used DB/TextWorks functions that you might find useful

by Kathy Bryce Tuesday, November 13, 2018 9:28 AM

A recent project has reminded me that many clients are not aware of the power of these three functions that have been available in DB/TextWorks for years, and which can potentially streamline and speed up your workflow.

The first is Menu Screens.  Many clients have a menu screen that loads up when they open DB/TextWorks but usually the ones we see are either the default from the old Inmagic Library Module, or rudimentary boxes linking to their databases. However they can be so much more useful! Here is an example from a recent project.

CLGA menu

A menu screen is super easy to set up and we’ll be posting a detailed guide here in our blog soon.

However first we need to discuss the other two functions, as they can be used separately or in conjunction with your menu screen.

The second function is Sets. Whenever you do a search you can choose to Save the Set from the top toolbar. Sets are a great way of providing quick access to a search with several parameters to save you from entering them each time using the query screen. So for example, find all records with a Review date in the next 30 days; or find digital image records that have been entered but not checked yet; or find all books that are not on permanent loan and that have been out for more than 60 days. You can use the @date variable in the search strategy without needing to actually input an actual date each time. Never used the @date function? It can be very handy especially when combined as in @date-7:@date which retrieves all dates within the past week.   A Sets box can be added to your query screen to give you quick access to running these searches or they can be embedded in your menu screen.

The third function is Record Skeletons. You may have a student or volunteer adding records for reports in particular series; or images in a photographic collection; or documents in a fonds. You can create a record skeleton to prepopulate the edit screen with publication or descriptive data that is common to all these new records. You can find Skeletons under the Records menu. Note that once you select a skeleton to use, it will be the default until you re-set to none, or choose a different one.

In the menu screen example above, every database has a link to the search screen plus a link straight in to a new record edit screen. If your database has several edit screens these can be specified on the menu screen too, as well as specifying a skeleton appropriate for these new records. It may not seem like much, but this can save a couple of extra clicks and let you get straight to work. This screen also has Sets specified to prepopulate the query screen with the value for a particular collection. So easy to set up and a great way to ensure people can search quickly and effectively.

Check out more tips and tricks for getting the most out of DB/TextWorks in our blog archive:

We are always available to help you with updates to your databases. No project is too small!

Andornot's Professional Development Grant Available for 2019

by Jonathan Jacobsen Tuesday, November 06, 2018 8:20 AM

Andornot strongly believes in the value of attending conferences to foster professional development.

Two years ago, we introduced the Andornot Professional Development Grant, a new, annual grant to help you attend a conference or event as part of your ongoing professional development activities. Of the many excellent applications we received each year, Mark Goodwin of the BC Cancer Agency was selected in 2016, and Gayle Graham of the Nova Scotia Health Authority received the grant in 2017. Both used the funds to help them attend the Canadian Health Libraries Association Conference.

We are very pleased to be able to offer the grant again this year, to help you attend an event in 2019.

One grant of up to $1,000 is available, with an application deadline of January 31st, 2019. The funds can be used for registration or travel related expenses. We hope that this grant will provide an opportunity for someone without access to funds from their organization to network and enrich their knowledge.

To apply, just complete this application form. The recipient will be selected in early February, allowing time to register for a conference at any point in the year.

Tags: funding

Library and Archives Canada announces launch of 2019 funding cycle for Documentary Heritage Communities Program

by Jonathan Jacobsen Monday, October 22, 2018 11:44 AM

Library and Archives Canada has announced the launch of the 2019 funding cycle for the Documentary Heritage Communities Program (DHCP). This is the fifth round of what was originally envisioned as a five year program, so could potentially be the final year.

The DHCP provides financial assistance to the Canadian documentary heritage community for activities that:

  • increase access to, and awareness of, Canada’s local documentary heritage institutions and their holdings; and
  • increase the capacity of local documentary heritage institutions to better sustain and preserve Canada's documentary heritage.

The deadline for submitting completed application packages is January 8, 2019.

This program is a great opportunity for archives, museums, historical societies and other cultural institutions to digitize their collections, develop search engines and virtual exhibits, and other activities that preserve and promote their valuable resources.

There are a number of significant changes this year:

  • The upper limit of funding for a small project has increased to $24,999. Many of the projects Andornot helps with would fall into this range.
  • Organizations which receive up to half their funding from government sources are now eligible.

Types of projects which would be considered for funding include:

  • Conversion and digitization for access purposes; 
  • Conservation and preservation treatment; 
  • The development (research, design and production) of virtual and physical exhibitions, including travelling exhibits; 
  • Conversion and digitization for preservation purposes; 
  • Increased digital preservation capacity (excluding digital infrastructure related to day-to-day activities); 
  • Training and workshops that improve competencies and build capacity; and 
  • Development of standards, performance and other measurement activities. 
  • Collection, cataloguing and access based management; and 
  • Commemorative projects.

Lists of the grants and recipients in the previous four rounds of funding are available here and may help you as you think about your own application.

Further program details, requirements and application procedures are available at http://www.bac-lac.gc.ca/eng/services/documentary-heritage-communities-program/Pages/dhcp-portal.aspx

How can Andornot help?

Many Andornot clients have obtained DHCP grants in previous rounds, and Andornot has worked on many other projects which would qualify for this grant. Some examples are detailed in these blog posts:

We have extensive experience with digitizing documents, books and audio and video materials, and developing systems to manage those collections and make them searchable or presented in virtual exhibits.

Contact us to discuss collections you have and ideas for proposals. We'll do our best to help you obtain funding from the DHCP program!

Also also check out a few other grants that are open this fall in this blog post: "Grants with Fall 2018 Application Deadlines"

Tags: funding

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.

Andornot's October 2018 Newsletter Available: News, Tips and Tricks for Libraries, Archives and Museums

by Jonathan Jacobsen Tuesday, October 09, 2018 8:41 AM

Andornot's October 2018 Newsletter has been emailed to subscribers and is available to read on our website, with news, tips and tricks for libraries, archives and museums.

In This Issue

Tags: newsletters

Month List