Adding dot leaders between columns in a DB/TextWorks report

by Kathy Bryce Tuesday, September 30, 2014 5:29 PM

Have you ever tried to create an index report in DB/TextWorks and wanted to have a dots to line up the entries in the two columns? The index entries are invariably different lengths so the number of dots required needs to vary.


The trick is to add fixed text into the box for the first column – in this case after the title. In the Box Properties set the Paragraphs tab to No added paragraph breaks. The fixed text dots have to have a space between them as in . . . . rather than ……..  This allows any excess dots for long entries to be bumped to the next line.  Under the Position tab then set the Maximum height to 1 line.


You may need to adjust font size and margins if your index terms are longer than one line.

Contact us if you need help with your Inmagic DB/TextWorks report designs.

Revs Institute Launches VuFind Catalog of Automotive History

by Jonathan Jacobsen Saturday, September 27, 2014 8:31 AM

The Revs Institute for Automotive Research, Inc. in Naples, Florida is a not-for-profit organization that promotes the understanding and appreciation of automotive history.

Within the Revs Institute, a research library contains over one million discrete items including over 700,000 photographs, 24,000 books, over 200,000 magazines and journals, papers, other written documents, films, and ephemera.

Over 80,000 records from the library are now available in a discovery interface powered by VuFind and hosted by Andornot at

Features such as spelling corrections, relevancy-ranked search results, and facets for quick refinement of a search, help users discover information of interest to them from the fascinating collection available in the catalog.

Some of the topics featured in the collection include:

The library uses the Inmagic Genie integrated library system to manage the collection of records. Data is exported from this system nightly, using the Andornot Data Extraction Utility, and uploaded to VuFind.

"Our experience has been that the new VuFind interface adds both visual and intellectual clarity to our OPAC.  Our bib records are cleaner, more organized and more easily searchable by our users. This, of course, means that our research collections are more accessible to library patrons," says Trina Purcell, Special Collections Manager at the Revs Institute.

Contact us to discuss a discovery interface such as VuFind for your collection. 

Checking for Broken Links in Catalog Records in Inmagic Genie

by Jonathan Jacobsen Saturday, September 20, 2014 7:35 PM

Inmagic DB/TextWorks has had a very useful feature to check all the URLs in records for many years (since version 8). This handy tool (under the Tools menu) will crawl all the URLs in a field you designate, and write the results into another field (e.g. URLStatus) in your database, for review and correction of the URLs.

For libraries using the Inmagic Genie integrated library system, such a feature doesn’t yet exist. As more and more libraries catalogue more and more electronic resources, the need to periodically check URLs and correct invalid ones becomes ever more important.

Fortunately, there’s a fairly easy way to do this in Genie. Here’s how:

1. Install a link checker plug-in into your web browser. There are many available; just search the web for "URL checker" or "link checker" and the name of your browser. This tool will crawl all the links on a web page and inform you which ones are in good working order and which are problematic.

2. Search the CatURL field in your Genie Catalog for all records with a URL (hint: use an asterisk in this field to find all). 

If the URL field isn’t available on any of your Catalog search screens, it's easily added by editing  the MyQueries.config file.

3. Check that the URLs are appearing on the Genie Catalog brief results page. If that field isn’t on the brief display, you'll either need to add it or create a new report (see below for ideas about that).

4. Activate the link checker and wait while it crawls all the links on your URL Check report. Depending on the plug-in you installed, it may highlight results in different ways.  The screenshot below shows an example of a link checker that has checked 16 Genie Catalog search results. Links are colour-coded green and red to indicate status.

Note that the link checker has crawled and checked EVERY link on the page, including ones within Genie (e.g. the Edit and Full Display links, the navigation menu, etc.). The count of links checked will be much more than just the maximum 20 records per page with URLs.

5. For any broken links, click the Edit link to edit the Catalog record. Manually verify the link – it may not be broken per se, but simply redirecting the user to a different page. If appropriate, either edit or remove the URL from the Catalog record's URL field.

6. Click the Search Results link in the breadcrumb trail at the top of the Catalog edit screen to return to where you left off. Click the Next 20 Records link to advance to the next set of records with URLs and run the link checker again.

The above procedure has some pros and cons:


No need for any new reports in Genie (other than ensuring you can search for and view URLs in Catalog results).

Only have to work with 20 records at a time.

Can quickly access the Catalog Edit screen to correct URLs.


Link checker crawls more than just URLs in Catalog records, taking longer.

Can only work with 20 records at a time. Many manual steps required to work through hundreds or thousands of Catalog records with URLs.

To work with more than 20 records a time, but still have quick access to the Edit button, create a new report in the MyReports.config file specifically for URL checking:

1. Copy any existing Catalog brief results and give it a new name (e.g. URL Check), but add PageSize="0" to the header. 

2. Consider removing the Full Display and Add to Cart Links to reduce the number of internal links that the link checker will crawl.

3. Be sure to list the new report in the list of available Catalog reports at the bottom of the config file.

After searching the Catalog, select this report. All results will load into one page, rather than just 20 at a time.

Note that if you have more than 1,000 such records, only the first 1,000 may be returned. You can change this by adding TotalRecordsforXML=nnnn (where nnnn = some number, such as 2,000 or 5,000) to your WebPublisher PRO dbtwpub.ini configuration file (or icsweb.ini if you have the SQL version).

Contact us for help configuring query screens and reports to use this workflow in your Genie system.

Andornot newsletter–September 2014

by Kathy Bryce Friday, September 05, 2014 7:59 PM

Please check out the latest issue of our newsletter.

In this Issue:
  • Canadian Jewish Heritage Network Now Offering a Single Search Across Multiple Data Sources
  • How a Hospital Library and the Local Public Library Partnered to Share Patient Education Materials
  • Meet with Andornot in 2014: Last Few Conferences of 2014
  • Tips and Tricks: Add a Checkout Receipt or Loan Reminder to Inmagic Genie
  • Tweets: Round-up of Library, Archive and Museum News

Please contact us for further information or to be added to our newsletter list.

Tags: newsletters

Month List