| Re: how to associate detail information [message #73 is a reply to message #72] |
Fri, 10 July 2015 23:08   |
thomas
Messages: 715
Registered: June 2014
|
Senior Member |
|
|
Dear Axel,
if I understand you correctly, the solution to your problem is probably more defining a lookup URL
rather than using the detail mechanism. Usually, we use details internally at Actelion, when we
have some biological results that are extracted from a non-alphanumerical raw data or if we have
more detailed information in the database. Typically the raw data is some SVG, PNG or JPEG and
further information is in HTML, plain text. In these cases the DataWarrior file contains links to
the detail source, e.g. an Oracle CLOB or BLOB column, or a web service. When moving the mouse over
the result, the detail is fetched on-the-fly and shown in the detail area. When saving the DataWarrior
file, one can retrieve all details and store them within the DataWarrior file (compressed and text
encoded). Details are always shown within the DataWarrior application, e.g. in the detail area
(bottom right) or as part of the form view. Image data and plain text are rendered reasonable well,
but the Swing based HTML viewer is rather simple and does not render modern websites well.
The URL lookup mechanism does not render HTML within DataWarrior itself, but offers with a right
mouse click to open an external website in the default web browser. If you add three simple column
properties to a file that has a column with ChEMBL-IDs then you get a new option in the popup menu
for every row like 'Open ChEMBL Page of 123456 in Web Browser'. For this to work you need to add
the following lines to the column properties section of the dwar file:
<columnName="ChEMBL-ID">
<columnProperty="lookupURL0 https://www.ebi.ac.uk/chembl/compound/inspect/%s">
<columnProperty="lookupName0 ChEMBL Page">
<columnProperty="lookupCount 1">
The DataWarrior upgrade, which is due very soon, will use this mechanisms for Wikipedia
compound search and ChEMBL database access.
Hope this helps,
Thomas
|
|
|
|
Search
Help
Members
Register
Login
Home
