Jump to main Content | Jump to main Navigation

External Linked Data

The linked data feature enables you to add data from external sources into fields on your Calm records. By default, the following data sources are available in Calm: AIM25, British Library and Wikipedia. Please note: You will need an internet connection to access external data sources and this connection will be subject to environmental conditions such as your network speed and performance, which are not under Axiell's control.

This page details how to add new data sources, how to configure them so that Calm can request data and recognise the format it is returned in and how to test a data source that you have configured, as well as how to edit or delete existing data sources.

If you are using the default external data or have already configured some data sources, see the following page 'Linking Data' for an explanation of linking data to your Calm records.

Configuring or Modifying Data Sources

Before you configure a data source, you will need to research it. You need to find out the formats that the search service will accept and the format that the response will be delivered in. You will also need knowledge of XSLT, this is a standard technology for processing XML and you will need it to transform responses from external data sources into a standard XML format that Calm can understand, so data can be linked to your Calm records.

To add a new data source:
 
  • From the main menu in Calm, click on the Administration Menu button.
     
  • Click on the Linked Data button.
     
  • You will see a list of existing data sources (including the defaults supplied with Calm). Click the Add button on the right hand side.
     
  • Enter a name for the new data source. This name will appear in the list of data sources to select when linking data.
     
  • Click the Next button.

Next you need to define the query format, so that Calm knows how to construct and submit a query to the external data service. There are 2 HTTP methods generally in use, so either define a 'Get' where the search text is passed as part of the URL or, a 'Post' where the data is posted to the web server. Which method you use will be determined by the data source you are adding. Both are detailed below. Use the placeholder {0} to insert the text to be submitted.

  • To define a Get method - select Get from the drop-down box and enter the URL including the search text.

or

  • To define a Post method - select Post from the drop-down box and enter the query in the box below. You also need to enter the URL.
     
  • Click the Next button.

The next step is to define the XSLT transform code. The external data source may return its response in any XML format. You need to define XSLT transform code to process the XML into a standard format that Calm can understand.

  • You will see a default template in the XSLT transform box, use this to build your XSLT transform code.
     
  • Once you have written your XSLT transform, we recommend testing it. To do this, press the Test button under the XSLT box and see the 'Testing a Data Source' section below. Once you are happy with your XSLT transform code, continue to follow these instructions which take you through the remaining page of the wizard.
     
  • Select one or more Calm databases that this data service is relevant for.
     
  • Click the Finish button. It will now be possible to link data from this new data source to your Calm records.
     

To edit an existing data source:
 
Editing a data source is a similar process to adding a data source as described above.  
 
  • From the main menu in Calm, click on the Administration Menu button.
     
  • Click on the Linked Data button.
     
  • You will see a list of existing data sources. Click on the data source you wish to edit, this will highlight it.
     
  • Click the Edit button on the right hand side.
     
  • If you wish to edit the name of the data source, change it in the Name box. This name will appear in the list of data sources to select when linking data.
     
  • Click the Next button.
     
  • If you wish to edit the query format, change it on this page using the URL, HTTP Method and optionally Query boxes.
     
  • Click the Next button.
     
  • If you wish to edit the XSLT transform code, change it in the XSLT Transform box.
     
  • If you have edited your XSLT transform, we recommend testing it. To do this, press the Test button under the XSLT box and see the 'Testing a Data Source' section below. Once you are happy with your XSLT transform code, continue to follow these instructions which take you through the remaining page of the wizard.
     
  • If you wish to amend which database/s this data source pertains to, select more databases in the list, or click on the tick boxes of previously chosen databases to remove their selection.
     
  • Click the Finish button.
     

To delete an existing data source:

 
  • From the main menu in Calm, click on the Administration Menu button.
     
  • Click on the Linked Data button.
     
  • You will see a list of existing data sources. Highlight the data source you wish to delete.
     
  • Click on the Delete button on the right hand side.
     
  • The data source has now been deleted, you will notice its name has been removed from the list.

Testing a Data Source

This feature in Calm helps you to diagnose any problems you may encounter whilst configuring a data source. The process takes you through a step-by-step examination of results at each stage of a data query and response. The 'Test Linked Data Source' dialogue box appears during your configuration of a data source, as described in the adding and editing processes above.

  • From the XSLT Transform dialogue box, press the Test button.
     
  • In the search text box, enter some text that you know will return results from the external data source.
     
  • Click the Next button.
     
  • The next page will show the 'raw' response from the server. Check this is what you expected.
     
  • Click the Next button.
     
  • The next page will show the response after it has been processed through your XSLT transform code. Check this is what you expected.
     
  • Click the Next button.
     
  • If the transformed data is valid for Calm, the next page will show the processed results. This means that the XSLT transform is working and the data is in the correct format for Calm. If this is not the case, you will need to amend your XSLT transform code (see 'Configuring or Modifying Data Sources' above).
     
  • Click the Finish button.
     

Linking Data

By default, it is possible to link external data to the Catalog, Persons and Places databases in Calm. To add or configure data sources for other Calm databases, see the 'Configuring or Modifying Data Sources' section above. For details on linking data, see the following page 'Linking Data'.