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!

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.

Richmond Archives Adds Name Origins Resource to Online Search

by Jonathan Jacobsen Tuesday, June 06, 2017 9:51 AM

I live in Richmond, part of the Metro Vancouver Regional District, and have an interest in local history, so I was particularly interested when Andornot was asked by the City of Richmond Archives to help with a project on the origins of Richmond place names. 

The City of Richmond Archives is a long time user of Inmagic DB/TextWorks for managing their collections, and were instrumental in developing the set of linked databases that became our Andornot Archives Starter Kit. Over the past couple years we’ve helped the Archives upgrade their Inmagic WebPublisher-based online search system, which is available at http://archives.richmond.ca/archives/descriptions/ 

The new Name Origins search, available at http://archives.richmond.ca/archives/places/ features almost 500 records (and growing) that document and describe the history of Richmond streets, roads, bridges, neighbourhoods, and other landmarks. It’s easy to search by keyword or by type of place, and whenever possible, a Google map of the named place is shown. This database is updated by the Friends of the Richmond Archives, volunteers with a passion for local history. Launching this new database online was made possible through the Richmond Canada 150 Community Celebration Grant Allocations. 

As I worked in the web search interface to the database, I couldn’t help but search for places in my neighbourhood and around Richmond, and become captivated by the history of them. Now community members can access this information 24-7 and learn the history behind the names of streets, areas, and landmarks in their community.

Contact Andornot for options for your Inmagic databases and for search engines and other software to make your collections accessible online.

Elgin County Museum Joins Archives in Launching Upgraded Search Interface

by Jonathan Jacobsen Saturday, February 25, 2017 8:38 PM

The Elgin County Museum, as well as the Elgin County Archives, in St. Thomas, Ontario, both use Inmagic DB/TextWorks to manage their collections. A few years ago, Andornot helped the archives upgrade their public search interface to a more modern design, using our Andornot Starter Kit web application.

This year we were pleased to help the museum upgrade their public search interface too. The museum's new look is available at http://inmagic.elgin-county.on.ca/museum/ 

Both interfaces continue to use Inmagic WebPublisher PRO as the underlying search engine, but with our modern Andornot Starter Kit web application in front. This app provides features such as automatic stemming and combining of search words, browsable indexes, a selection list for saving items, and a photo commenting feature. 

The overall design matches the Elgin County website for a more integrated look and adapts to the user's screen size, so it's just as usable on a phone or tablet as on the desktop.

Several other museums in Elgin County and St. Thomas also use this system to manage their collections. The public is now able to access these collections as well, many of which have been photographed. Users can limit their search to only records that have images available online.

"This is a much more user friendly way for our Museum Partners to manage their collections," says Mike Baker, Elgin County Museum Curator.

Contact Andornot to discuss options for bringing your search interfaces up to modern standards.

Transportation Association of Canada Library Upgrades Web Search Options

by Jonathan Jacobsen Tuesday, January 31, 2017 6:49 PM

The Transportation Association of Canada (TAC) uses Inmagic DB/TextWorks to manage a library catalogue and databases of reports, manuals, and other literature related to transportation. The collection includes materials from governments, universities, associations and the private sector, both in Canada and abroad.

TAC approached Andornot to discuss upgrading the web search interfaces to their library databases to a more modern design with some new features. The existing interfaces, as well as the new ones, use Inmagic WebPublisher PRO for search and display, but were looking dated and didn't match the TAC website.

Andornot used our Andornot Starter Kit web interface for WebPublisher PRO to design new interfaces for three of TAC's DB/TextWorks databases. Each interface is available in both English and French, and the overall design matches the TAC website for a more integrated look. 

"The search interface for the library catalogue was functional but limited.  With few internal resources to dedicate to the project, we approached Andornot about using the Starter Kit to improve the appearance and features of the interface. The result was quickly achieved and a vast improvement over the previous forms.  I'm looking forward to seeing how members respond to these new search features." -- Glenn Cole, TAC Library

Key features of the sites include automatic stemming and ANDing of search words, browsable indexes, RSS feeds, book covers from Google when available, a selection list for saving items, and an interface that adapts to the user's screen size, so it's just as usable on a phone or tablet as on the desktop.

The three databases available online for public searching include:

  1. The TAC Library Catalogue database contains over 25,000 documents from major Canadian transportation agencies as well as many international organizations. Items may be borrowed by those with a one-time need for them.
  2. The Current Practices and Innovations database contains information on maintenance, construction, road safety and climate change.
  3. The Canadian Surface Transportation Research database offers information on research about a wide range of transportation themes, such as economics, the environment, soils and materials, highway and bridge design, construction and maintenance, traffic engineering, vehicle studies and rail transportation.

Many resources in these databases are available for immediate access as PDFs.

Contact Andornot to discuss options for bringing your search interfaces up to modern standards.

Month List