Ticket #248 (closed enhancement: wontfix)

Opened 6 years ago

Last modified 6 years ago

Searching for synonyms in ontologyterm fields when importing

Reported by: robert@… Owned by: t.w.abma@…
Priority: major Milestone:
Component: Import wizard Version:
Keywords: Cc:
Hardware: Operating system:
Product: URL:


When importing an excel sheet, the values that go into an ontology term field must match a value in the database. However, in the database only preferred names are saved, not synonyms. In the case of a cow, the term 'bovinus taurus' (or something like that) is saved, but the ontology does have 'cow' as a synonym.

It would be great if the importer would recognize these synonyms, and directly select the right term. That could be done by saving all synonyms in the database. Another option would be to query ontocat with the value in the excel sheet, and see if an exact match is found.

Change History

comment:1 Changed 6 years ago by work@…

  • Status changed from new to closed
  • Resolution set to wontfix

the idea of using ontologies is to standardize input, therefore not cow is stored, but bovinus taurus. There are two solutions:

  1. handle it in the front end (when someone searches for cow, use the ontology chooser to map it to 'bovinus taurus' and search
  2. store synonyms

Point 2 is a bit problematic as you can only store the synonym when the Term is created. However, then you only know 1 synonym (at most) as the synonyms are handled by the remote ontology.

So while this sounds easy, it is not so easy...

Also, as Ontology and Term are part of refactoring process #225 and this is basically a 'nice to have' feature, I'll close this issue...

Note: See TracTickets for help on using tickets.