| how to associate detail information [message #72] |
Thu, 09 July 2015 12:03  |
chemist69
Messages: 7
Registered: June 2015
Location: Germany
|
Junior Member |
|
|
Dear Thomas,
could you please give an example on how to associate detail information to a table, as in the flyingObjects example?
I have a ChEMBL data set and would like to associate the cells in the <Chembl_Id> column with a link to the compound on the ChEMBL website (https://www.ebi.ac.uk/chembl/compound/inspect/<Chembl_Id>)
Many thanks in advance for your help.
Kind regards,
Axel
If you're not part of the solution - you're part of the precipitate.
|
|
|
|
| Re: how to associate detail information [message #73 is a reply to message #72] |
Fri, 10 July 2015 23:08  |
thomas
Messages: 711
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
|
|
|
|
| Re: how to associate detail information [message #74 is a reply to message #73] |
Mon, 13 July 2015 16:57 |
chemist69
Messages: 7
Registered: June 2015
Location: Germany
|
Junior Member |
|
|
Dear Thomas,
many thanks again for your help.
What you desctribe is exactly what I was looking for. However, when I try your example with the columnProperty lines, the .dwar file is not loaded and Java throws the following error:
java.lang.StringIndexOutOfBoundsException: String index out of range: -95
at java.lang.String.substring(String.java:1955)
at com.actelion.research.c.u.a(Unknown Source)
at com.actelion.research.c.u.run(Unknown Source)
at java.lang.Thread.run(Thread.java:745)
When I rename Chembl-Id to ChemblId, then the index is out of range at -94, etc.
Kind regards,
Axel
If you're not part of the solution - you're part of the precipitate.
|
|
|
|
|
|
|
|
|
|
| Re: how to associate detail information [message #103 is a reply to message #98] |
Mon, 07 September 2015 11:28 |
chemist69
Messages: 7
Registered: June 2015
Location: Germany
|
Junior Member |
|
|
Dear Thomas,
now it's my turn to apologize. I completely lost this out of focus, but I would still be interested in your help on this issue. I have mailed you the file again, I hope, it's not ending up in your spam filter.
Kind regards,
Axel
If you're not part of the solution - you're part of the precipitate.
|
|
|
|
Search
Help
Members
Register
Login
Home
