DB/TextWorks Still A Popular Choice for Teaching in Schools

by Jonathan Jacobsen Saturday, October 28, 2017 7:44 AM

Inmagic DB/TextWorks continues to be a popular software application taught in schools. For example, the Library Technician programs at Langara College and the University of the Fraser Valley in B.C, as well as at the Southern Alberta Institute of Technology, each include it in some of their cases.

Yesterday I had the pleasure of speaking to students in the Library Technologies and Information Management class at Langara College. These budding library techs will learn to create a database for a class project using DB/TextWorks, hopefully with a bit of inspiration from the ideas I was able to share with them.

The image above shows screens from the Andornot Starter Kit, a ready-to-use DB/TextWorks database suitable for a small library.

Not all software has such longevity as DB/TextWorks, but I think this popular app endures because it remains unique in the market. For clients of ours with a modest budget who need to manage diverse kinds of information and don't have programming skills, it remains an excellent choice, once we heavily recommend to many clients.

We see it used in law firms to create and manage databases of experts, memos, precedents, boilerplate documents, corporate archives, and of course a traditional library catalogue. In hospitals, it's used to manage patient education materials, and libraries with a strong circulation component. Elsewhere, we see it used to manage museum artifact collections, archival documents, databases of digitized historic documents and audio-visual recordings. In municipalities, it manages bylaws, real estate development applications, council documents… the list is endless. 

There are many highly-specific database applications available, tailored to the needs of particular organizations (e.g. Inmagic Genie for specialized libraries, Lucidea's Argus for museums, etc.), but few tools that are as easy to use as DB/TextWorks that can be applied to managing any kind of information. Anyone can learn to create a database and snazzy search and edit screens and have a functional, aesthetically pleasing database in a very short time, with little technical aptitude needed. Managing this information is easy with the many built-in, pre-programmed features, such as validation lists, batch modifications, the URL checker, and so on.

Two other long-standing database programs are of course MS Access, included with almost every copy of the MS Office suite, and Apple's FileMaker. The former is practically free and so ubiquitous that many people use it out of necessity, while the latter is quite visually appealing and with many useful features. However, in our experience, both require a higher level of technical skills to really make useful. DB/TextWorks simply has more of the programming already done.

It's reasons like this that cause it to still be an excellent choice in many cases, when budgets and user skills are modest, and thus is well-worthwhile learning to use in a library technician or similar programm. Paired with a search interface like our Andornot Discovery Interface, VuFind, Omeka, or Inmagic Presto, it becomes a perfect back-end to a highly functional front-end, a great combination for managing and searching information.

Contact us to learn more about any of the above, or if you're a school or student and would like a trial version of DB/TextWorks to use.

Join us at the SLA Western Canada Chapter 2017 Year End Event, Featuring CBC's Johanna Wagstaffe

by Jonathan Jacobsen Friday, October 20, 2017 3:40 PM

Andornot is delighted to be once again sponsoring the SLA Western Canada Chapter Year End Event, on November 27, 2017.

This year's guest speaker is is CBC Vancouver’s on-air meteorologist Johanna Wagstaffe. As a prominent woman in STEM and a podcaster for CBC's Fault Lines and 2050: Degrees of Change, Johanna will be addressing her experiences communicating specialized information and research to non-specialist audiences.

Catered snacks and a beer or wine is included with your ticket and will be available from 6:15pm. A cash bar will also be available.

When: Monday, November 27th, 2017. Doors at 6:15pm, keynote address at 7:15pm.

Where: The Post @ 750, an event space located at 110-750 Hamilton Street in downtown Vancouver (on Hamilton, between Robson and Georgia).

Tickets: Purchase your tickets online today and your name will be added to the guest list at the door. Students and SLA members receive a discount but all information professionals and interested students are welcome to attend. Should you wish to sponsor a ticket for a student, you may purchase that option at the link above and event organizers will contact you with further details.

We look forward to seeing you there!

Tags: events

Andornot's Professional Development Grant Available for 2018

by Jonathan Jacobsen Friday, October 20, 2017 3:23 PM

Andornot strongly believes in the value of attending conferences to foster professional development. We attend events across Canada and the United States all year long to learn about new trends and technologies, meet with clients, and share our expertise with like-minded folks.

Last year, 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, Mark Goodwin of the BC Cancer Agency was selected, and attended the Canadian Health Libraries Association Conference in Edmonton.

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

One grant of up to $1,000 is available, with an application deadline of January 31st, 2018. 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.

Read more and apply online here.

Be sure to check out our list of all the conferences and events we’re planning to attend in 2018 as well as our list of other grants and funding options that could help you with project to improve your collections.

Tags: events | funding

Andornot's September 2017 Newsletter Available: News, Tips and Tricks for Libraries, Archives and Museums

by Jonathan Jacobsen Thursday, September 07, 2017 4:45 PM

Tags: newsletters

Is it time to rejuvenate the search option for your collections? The Anglican Church of Canada Archives launches a new search portal to provide better access to a wider selection of records of national significance.

by Jonathan Jacobsen Monday, August 14, 2017 8:45 AM

The Archives of the Anglican Church of Canada has provided web search access to some of their collections for many years, but it was time for a refresh to keep up with current expectations. Situations like theirs are all too common, with issues such as:

  • each of several databases had to be searched separately, one at a time;
  • the separate search interfaces were dated, with a restrictive searching syntax;
  • the graphic design no longer matched the main website;
  • the layout was not responsive for viewing on tablets or phones;
  • there was a desire to put up additional content; and
  • the server that was home to all the software and data was due for replacement as both the hardware and operating system were aged. 

Undertaking these updates was a somewhat daunting prospect for the archives staff, with little time or experience to work on the necessary changes. However, Andornot has worked with the Anglican Church for many years, and over several months developed a plan for the updates that fit with both Archives and IT staff requirements. The result is a modern, functional new single search portal that will be of benefit to anyone interested in the records of the church.  

The new site is now available at http://archives.anglican.ca

Rather than simply migrate everything to a new server as-is, the archives and the Church's IT staff took this as an opportunity to make substantial improvements. To help fit the work into everyone's busy schedules, the project was divided into two phases, making each half more manageable.

In the first phase, Andornot provided a methodology to help staff analyze their multiple existing Inmagic DB/TextWorks databases and determine data clean-up options. We worked with IT staff to provision a new server with a fresh installation of the latest version of DB/TextWorks. Databases were migrated, client workstations updated, menu screens linked, and the system otherwise made ready for use. This provides the archives with a stable, up-to-date, clean system that should run well for many years to come. 

In the second phase, we built a new search interface using our Andornot Discovery Interface. The new system allows users to explore and research archival descriptions, official statements, press releases, journal articles and photographs. Additional databases managed in DB/TextWorks may be added over time.  

The software is hosted on the Church's servers but during the design phase we hosted it locally to simplify making modifications during the rounds of feedback, and reducing the involvement needed from IT. We also offer long-term hosting for clients who don't have their own servers or the staff and resources to manage them.

The new site design is clean and simple and now coordinates with the look and feel of the main Anglican Church website. In addition, the seamless, single search across the formerly separate databases is both easy to use and encourages serendipitous discovery of information from unexpected sources.

“The General Synod Archives has already seen many researchers using the new search engine and requesting information and photographs. We have received compliments on the layout and information included, as well as the benefits of having each entry tagged so that we know exactly what the researcher is requesting without having to redo the search. The new search engine has made it a lot easier for us to make our photographs available for research and selection. Searching by rough dates and being able to break them down using the decade facet produces faster results. Indeed the various facets for refining the search have been a bonus.”

-- the archivists of the General Synod Archives, Anglican Church of Canada

As with all our Andornot Discovery Interface projects, this site for the Anglican Archives now provides the best possible search experience, and includes the following features we now regard as essential in a modern search interface:

  • Automatic spelling corrections and search suggestions.
  • Relevancy ranked results with additional sort options.
  • Facets to easily narrow or refine a search.
  • Easy sharing of records or photos on social media such as Facebook and Pinterest.
  • Add to list option to select records.
  • Responsive layout for use with tablets and smart phones.
  • Accessibility for users with disabilities.

We're always available to discuss upgrades to your DB/TextWorks-based systems, or enhanced search interfaces for any collection using one of the several software systems we support. Send us a link to your current search interface and we'll get back to you with our evaluation! 

Month List