How to sort empty values last in DB/TextWorks and WebPublisher PRO search results, with version 16

by Jonathan Jacobsen Thursday, August 03, 2017 7:51 AM

Inmagic DB/TextWorks version 16, released in July 2017, provides you with several great new features for managing data and databases. This blog post is one of a series providing details of how to take advantage of these new features.

This blog post is about the new ability to sort empty fields last in search results.

Suppose you search a bibliographic database and sort the results by publication date, in reverse order, so the most recently published materials appear first. This works very well when every record in the search results has a publication date. However, if a record has no date, as sometimes happens, those "empty" records will appear first in the search results. This tends to be disconcerting to users as it's not often clear why they are first.

This new feature in DB/TextWorks version 16 allows you to sort those records last. This feature can be used in DB/TextWorks and in WebPublisher PRO searches, including in web forms built from our Andornot Starter Kit.

Here's how to apply this sort option to any Report Form in DB/TextWork (a Report Form is typically used to display many records at once, usually in a brief format):

  1. Open your database in DB/TextWorks version 16.
  2. Open a form that has an existing sort order, or one you want to add it to, in the Form Designer with Display > Design Form.
  3. Select Report Options > Compulsory Sort.
  4. Note the new tick box for sorting empty fields last. Select the field you wish to apply this to, add it to the Sort Fields list on the right, and tick the Sort Empties Last option.

If you have a web interface built by Andornot using our Andornot Starter Kit, you can follow the same steps above to apply this to a Web Form. It's most suitable for something like a WebBriefDate form, where results are sorted by Date.

You can also use this new Sort Empties Last feature with reports that have no sort order applied yet, on-the-fly, by searching, then selecting Display > Sort Report and choosing this sort option (step 4 above).

Contact Andornot for help applying this new feature to your databases, or for a free assessment of your databases and suggestions to use them more efficiently or in new ways. We’d be happy to chat with you!

How to sort fields and hide deleted ones when editing a DB/TextWorks version 16 textbase

by Jonathan Jacobsen Wednesday, August 02, 2017 12:05 PM

DBTextWorks version 16, released in July 2017, provides you with several great new features. This blog post is one of a series providing details of how to take advantage of these new features.

This blog post is about the changes to the textbase structure editor.

The Edit Textbase Structure > Edit Fields dialogue has two new features:

  • Sort Field List by – This feature permits you to sort the Field List by Field Name, or by Field Type.
  • Hide <Deleted> Fields – This option permits you to hide the <Deleted> items so they do not clutter up the display.

These small changes are super helpful for textbase designers. They appear in the Edit Textbase Structure > Edit fields dialogue as shown below.

Edit Fields

We usually start our databases with fields in a logical order, either alphabetic or in the case of a library catalogue, following the traditional ISBD / MARC order. But over time, fields may be added, renamed and deleted, making it hard to find one you want to work on. Previously, fields appeared in the order in which they were added in this editor, interspersed with the word Deleted for fields that have been deleted (although the field and its data is gone, an entry such as this remains in the list of fields).

These two new features, along with the larger size of this dialogue from the previous version of DB/TextWorks, makes textbase structure work that much easier. Sorting by name helps you find a known field, while sorting by type helps you work on a group of similar fields at once. Hiding Deleted fields declutters the interface so you can focus on only active fields.

Note that selecting a sort option or hiding deleted fields is a choice you need to make each time you open the field editor. It’s not saved between sessions.

If you decide you want to eliminate the Deleted fields altogether, rather than just hide them, you can recreate your database from scratch and re-import data, forms, etc. It’s not as daunting as it sounds, and Andornot would be happy to help you. This leaves a super clean database in great shape, for you, your current staff, and especially new staff who come on board.

See also our popular series of blog posts on “spring cleaning” for your textbases for more clean-up tips. And contact Andornot for a free assessment of your databases and suggestions to use them more efficiently or in new ways. We’d be happy to chat with you!

Inmagic Releases Version 16 of DB/TextWorks, WebPublisher PRO and DB/Text for SQL

by Jonathan Jacobsen Monday, July 31, 2017 8:39 AM

Inmagic has released version 16 of the very popular and long-standing DB/TextWorks database management system, and the companion WebPublisher PRO web search interface. Several new features, as well as issues fixed from previous releases, continue to make this software great value for our clients.

New features include:

  • Sorting – When specifying sort fields, you now have the option to sort empties last. Before, records where the sort field was empty could only be listed first or omitted. Since this option does not change the perceived number of records in the report, it is also available for the textbase Default Sort Order and for WebPublisher reports.
  • Form Designer – WebPublisher reports can now easily link from a small image on a web page (a thumbnail) to the full size image. The new option is on the HTML tab of the Picture Box Properties dialog box.
  • Adding/Editing Records – When editing a Link field, a new type of box permits you to browse the values in a field other than the Link field, making it easier to select the record you want to link to. For example, you can display the list of Borrower Names, and clicking a name will paste that user’s employee ID into the Link field box.
  • Select All (Ctrl+A) – This keyboard shortcut now behaves as it does in nearly every other product. You can use it to select all the text in a box, all the boxes on a form or screen, all the text in the Command Query window, or all the annotations on an image. In previous releases, Ctrl+A was used for Redo. Redo now uses Ctrl+Y. 
  • Edit Textbase Structure – The Edit Fields dialog box has two new features:
    • Sort Field List by – This feature permits you to sort the Field List by Field Name, or by Field Type.
    • Hide <Deleted> Fields – This option permits you to hide the <Deleted> items so they do not clutter up the display.
    • Note: Both are display-only features to make it easier to find and work with the fields you want to modify. Neither affects the actual field order specified in the structure.

Other issues addressed include:

  • Print Images – If a textbase has multiple Image fields, and you print only the images from a specific field, blank pages are no longer printed for any images specified in the other fields.
  • Report window – Addressed an issue with the records sometimes not being visible past the first page when you held down the mouse scroll wheel then dragged the mouse.
  • Send Report as Mail – Improved the handling of multiple email addresses when using the "Mail to addresses specified in records" feature.
  • Textbase Information – Addressed an issue where longer short date formats caused the year to be truncated in the "Current date" specified at the top of this display.
  • Toolbar icons – The icons for Vertical Tile and Horizontal Tile were backwards in previous releases. This issue has been corrected, and the options have been renamed to "Show Windows Side by Side" and "Show Windows Stacked" to make their behavior clearer.
  • Form Designer – Addressed an issue with the Box Properties dialog box crashing when a box included an extremely large Fixed Text or Added Text string (usually HTML).
  • Textbase Information – Removed Windows Group Memberships from Textbase Information and "About this Computer System".
  • WebPublisher Browse Choices – The buttons have been optimized; for example, we've added an "Add & Close" button so that users no longer need to click "Add" then "Close".

If you upgrade from a version prior to 15 directly to 16, 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 or 15.5, you’ll have done this already.

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

Surveyor Geotagging Tool from the New York Public Library

by Kathy Bryce Monday, July 24, 2017 9:42 AM

Determining the exact location of historical photos is always a challenge, but Surveyor, a new open source tool just released by the New York Public Library (NYPL) offers a neat crowdsourcing option.  It was developed to help address the problem of photos with very general titles, or only a street name or neighbourhood, some of which may no longer exist.

The NYPL has uploaded a set of photos and users can click through and move the map until the marker is in the correct location. There is an optional step of noting the direction and angle of the view of the image.

image

This project is part of the New York City Space/Time Directory to create open source tools to help other cities, libraries and individuals to map and explore history.

Let us know if you’d be interested in adding a crowdsourcing project like this to your site. Crowdsourcing is a great way to encourage community involvement as well as enhancing the information about items in your collection. Contact Andornot to discuss possibilities!

VuFind 4.0 released with new features and fixes

by Jonathan Jacobsen Monday, July 17, 2017 7:48 AM

Version 4.0 of VuFind, the popular open-source discovery interface, was released early July 2017.

This version brings VuFind up to date with important PHP and Solr developments while also adding several new features and offering a straightforward upgrade path from the 2.x series of releases.

Some key additions and changes:

  • New channels feature. These are similar to the canned queries we include in almost all projects we work on, no matter which system, where pre-created search parameters or groups of records are offered to users through a simple link, as a guide to interesting aspects of the collection. See a demo at https://vufind.org/demo/Channels/Home.
  • New ability to create and host static content pages. This feature is especially welcome as in previous versions, additional content (e.g. About Us, Contact Us) was most easily placed on the home page, which could make for a bit of a crowded space.
  • Improved ability to load cover images from local files. We added this ourselves as custom development in a previous VuFind project, so are happy to see it appear in the core VuFind system.
  • A new theme, called Sandals. As with several previous themes, it's based on the responsive Bootstrap framework, so it works well on mobile devices. This new theme has a somewhat more modern look to it.

Additionally, several bug fixes, new configuration options 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 is a perfect choice.

Contact us to learn more about the VuFind discovery interface and how it might suit your organization.

Month List