King Institute at Stanford University Upgrades DB/TextWorks Archival Solution

by Jonathan Jacobsen Wednesday, January 20, 2016 8:44 AM

The Martin Luther King, Jr. Institute at Stanford Universityuses DB/TextWorks to manage an archival database of tens of thousands of speeches, sermons, letters, and other documents by and about Martin Luther King, Jr.

Known as OKRA (Online King Records Access), the database includes descriptive information as well as holdings details for these resources held at repositories all over the United States. Digitized audio and video recording are also available.

A web-based data entry system had been developed many years ago, using Inmagic WebPublisher PRO. However, advances in web technologies had resulted in problems with this interface. A decision was made to replace it with a purely DB/TextWorks-based solution.

Andornot upgraded the query screens, reports and data entry forms in the main database to ones based on our Andornot Starter Kit, for improved usability. Script-buttons were included to assist with searching and editing records, and scripts and other validation was added to the data entry forms to aid in looking up information in other databases, and to restrict some user groups' access the database. Secondary databases were converted to thesauri so that they could be used as validation lists, but with multiple selections possible in a field and record in the main database.

Online search access using Inmagic WebPublisher PRO remains available at http://okra.stanford.edu though this interface may also be upgraded in the near future.

Please contact Andornot for assistance with your Inmagic-based databases, and similar projects.

How to open local files from DBTextWorks search results

by Jonathan Jacobsen Wednesday, September 02, 2015 2:26 PM

Suppose you have a field called FileLink in a database, and you have a collection of PDFs or similar documents on your network. And suppose you want to catalogue these, enter the name of the PDF in the FileLink field, and then in DB/TextWorks search results, have the file name appear as a link that you can click to open the file.

Here's how to do this:

1. Open your Display Form (the one used to show all records) or a Report Form (usually used for brief results) in the Form Designer.

2. Right click on the FileLink field (or add it first if it's not there) and select Box Properties.

3. Select the Format tab, then the Added Text subtab.

4. In the 'Beginning Text' field, enter '<file://' (without quotes) and just a closing angle bracket > in Ending Text, like this:

5. Apply your changes, save the form, and return to your database.

6. Create a new record and in the FileLink field, right click and choose Browse Files. Browse to the location of the file. For example, if the file is on a network server called DOCUMENTS, in a folder called Reports, browse to \\DOCUMENTS\Reports and select the document (e.g. \\DOCUMENTS\Reports\Report123.pdf).

7. When you now search the database and view the full record, the above data will appear with <file:// in front and a closing >, like this:

<file://\\DOCUMENTS\Reports\Report123.pdf>

as shown in the image below.

8. You should be able to click this and open the file (assuming you have a PDF reader app in this case).

As always, contact us for help doing this or making other changes to your DB/TextWorks databases.

Nova Scotia Barristers' Society Migrates to VuFind Discovery Interface

by Jonathan Jacobsen Wednesday, August 26, 2015 4:40 PM

Andornot was pleased to help Nova Scotia Barristers' Society Library & Information Services migrate several of their web-based library search interfaces to the VuFind discovery interface this summer. 

The NSBS Library has used Inmagic DB/TextWorks for many years to manage a variety of databases, including a library catalogue. Inmagic WebPublisher was previously used to search some of those, and remains available for a few other databases, but now a new VuFind interface provides a single search across:

  • texts, case law reporters, legislation, forms & precedents collections, and other print material;
  • online resources licensed for in-library use; and
  • continuing professional development papers in full-text.

The new catalogue is available at https://catalogue.nsbs.org

Features such as spelling corrections and search suggestions, relevancy ranked results (with more recent items boosted higher in results), and facets to narrow searches provide the features users expect in a web search application.

The design of the new VuFind site was customized to match as closely as possible the main Society website, for a seamless transition between the two. The site adapts to the user's browser, so it's just as usable on a tablet or phone as in a desktop browser.

The initial response from library users has been very positive. 

"I've spoken to quite a few library users who've tried it and are really pleased. Find it really user-friendly. We have gotten emails from lawyers who have clearly discovered an interesting sounding resource via the catalogue and want to know more (is it in-library use only or can they borrow...). Some lawyers also got on board right away with signing up for a user account so that they could use the results management tools, like sending selected results as an email list to us, asking if resources are available." – Deborah Copeman, Librarian, NSBS

The NSBS Library joins a growing number of specialized libraries adopting discovery interfaces to search their collections. While public and academic libraries have offered this more modern style of search to their users for many years, smaller libraries are now able to join them with systems such as VuFind and our own Andornot Discovery Interface.

Contact us to discuss improvements to your library information and online search applications.

Law Society of New Brunswick Library Upgrades Web Catalogue

by Jonathan Jacobsen Wednesday, August 19, 2015 10:19 AM

Andornot recently helped the Law Society of New Brunswick Library upgrade its Inmagic DB/TextWorks and WebPublisher PRO-based library catalogue.  

We started by upgrading the DB/TextWorks database to the latest version available from our Andornot Starter Kit, including attractive query screens, reports and forms, with script buttons for easy navigation.

We then developed a new web interface using a responsive template that works as well on tablet or phone as a desktop browser. This attractive interface incorporates design elements from the Law Society’s main website, while providing maximum usability for searching the catalogue. 

The catalogue search is available in English and French, and allows society members to request items from the library with a simple form.

The new catalogue is available at http://www.nblawlib-bib.ca

"It's been an exciting and informative time with the development and launch of the new catalogue website, led by the exceptional guidance and direction of Jonathan and the team at Andornot. The Provincial Libraries Committee and myself are pleased with the outcome and look forward to patrons accessing and benefitting from the ease of use of the new template and the resources available."  -- Tanya Davis, Provincial Law Librarian

The new catalogue is hosted by Andornot as part of our managed hosting service.

Contact us to discuss improvements that might be possible for your catalogue.

DBTextWorks and WebPublisher PRO Version 15 Upgrade Tips: To Preserve or not Preserve CSS?

by Jonathan Jacobsen Friday, August 14, 2015 1:12 PM

Inmagic released version 15 of DB/TextWorks and WebPublisher PRO not long ago and many of you have or are upgrading to this new version, to take advantage of some of the great new features, especially in DB/TextWorks.

Please note that when upgrading, special attention must be paid to any forms and query screens inside your textbase that you use on the web. This may be forms that you developed yourself and use with WebPublisher, or they may be forms provided by Andornot as part of our Andornot Starter Kit or Andornot Archives Starter Kit. A change to DB/TextWorks in version 15 may affect the layout of your search pages and results.

The ReadMe file for version 15 notes the following:

Use Cascading Style Sheets to preserve formatting. In the Query Screen Designer and Form Designer the HTML tab of the Screen Properties or Form Properties dialog box includes this new option. Previous versions of DB/TextWorks asked the question each time you used Export Query Screen to HTML or Export Editing Form to HTML. In addition:

  • Whether cascading style sheets (CSS) are used is explicitly specified for each form, rather than for WebPublisher as a whole or by query screen.
  • The WebCSSOpt= DBTWPUB.INI option and the CS= URL parameter have been removed.
  • WebPublisher no longer tries to guess whether CSS will cause overlapping by automatically disabling CSS for forms that include Raw HTMLor Inline Images.
  • When DB/TextWorks upgrades a textbase for use with v15.0, all query screens and forms will be modified to have this option checked. If any of your forms include Raw HTML or Inline Images, which may cause overlapping, you may need to open them in the Form Designer to uncheck this option.

All forms that were provided by Andornot from our Starter Kits should not have Use CSS checked. With forms that you developed yourself, you may or may not wish to have this, depending on your form design.

If you've already upgraded and your web search layout is looking a bit like the morning after a wild night out (e.g. messed up), most likely it's due to the above and you simply need to open each form in the Form Designer, edit the Form Properties, and uncheck this box.

If you need assistance with the above, or have other layout issues, please feel free to contact us.

Month List