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.

VuFind Version 5.0 Released

by Jonathan Jacobsen Monday, July 16, 2018 5:37 PM

Version 5.0 of VuFind, the popular open-source discovery interface, was released today, a year after the last major release (4.0). 

This version improves the software’s compatibility with recent language and operating system releases and adds several significant new features.

Some key additions:

  • New features to improve compliance with the General Data Protection Regulation (GDPR), including optional user-initiated account removal and support for encrypted session data.
  • Significant improvements to the "Channels" interface for serendipitous resource discovery, including a streamlined user interface and several new channel providers (such as "new items" and "trending items").
  • Improved support for rendering geographic data.
  • PHP 7.2 compatibility.
  • Optional user access to their own account history.
  • Upgrades to the latest Solr, SolrMarc and Zend Framework component versions.

Additionally, several bug fixes, new configuration options, performance enhancements and minor improvements have been incorporated.

Although VuFind was largely developed by and for academic libraries, we've found applications for it in other organizations, including smaller specialized libraries. Our blog has details of selected projects. In general, we recommend VuFind for organizations with purely bibliographic records and little or no need for customization, a custom graphic design, integration of other features or content, etc. For organizations with those requirements, our Andornot Discovery Interface (AnDI) is a perfect choice.

In comparison to the release schedule for VuFind Andornot’s own Andornot Discovery Interface, which shares the same Apache Solr search engine as VuFind, is continuously upgraded with each project we use it for. Earlier sites built from AnDI can be upgraded as needed, and we’ve begin doing so upon request by clients. Upgrades include any new features and bug fixes added or made to AnDI since the initial build of the site, plus upgrades to key components, such as Solr, .Net versions, Javascript libraries, and more.

Contact us to learn more about VuFind or AnDI and how either might offer your users an improved search experience for your collections and resources.

Tags: VuFind

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

by Jonathan Jacobsen Wednesday, July 04, 2018 9:08 PM

Tags: newsletters

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