Search
Back 

Forums

Welcome to the Forums for DTS 4. The following shortcuts are available for new posts and replies.

[br] = line break/new paragraph    [b] [/b] = bold font   
[i] [/i] = italicized font [u] [/u] = underlined font 
[sub] [/sub] = subscript text 
 [strike] [/strike] = strikethrough
[sub] [/sup] = superscript text    

DTS Forums

Delete all namespace's concepts
Last Post 02 Apr 2014 01:34 PM by jbowie. 3 Replies.
Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
albagjimenezUser is Offline
New Member
New Member
Posts:47


--
01 Apr 2014 06:25 AM
    ¿Is there any way to delete all concepts from a namespace without deleting the namespace in itself? I'd like to start over to create Terms first and then Concepts and their synonyms terms.

    Thanks!
    jbowieUser is Offline
    Basic Member
    Basic Member
    Posts:110


    --
    01 Apr 2014 08:28 AM
    There is no DTS Editor function for deleting all concepts. This can be done using the API, of course, but a simpler method would be to use the TQL Editor plug-in. TQL (Terminology Query Language) is a plug-in designed to simplify querying and editing the DTS database. I won't go into details on TQL here (you should check out the User Guide, other associated documentation in the kit, and the TQL Forum topic) but to delete all the concepts in your Namespace "MySpace", you would enter the query:

    from ["MySpace"] delete_concepts;

    TQL also provides XML export capabilities. One use in your case might be to export your namespace after creating all the metadata (types). Then if you find one part of your import is in error, you can delete the whole namespace and reimport from the saved file. This is an easy way to avoid having to recreate all the Type information (or type plus terms if you export after that step).

    Give TQL a try!
    albagjimenezUser is Offline
    New Member
    New Member
    Posts:47


    --
    02 Apr 2014 05:53 AM
    I'm trying TQL Editor but I have 1 problem. When I execute the query from ["MySpace"] delete_terms; or from ["MySpace"] delete_concepts; concepts/termns change their status to DELETED but they are not completelly deleted. How can I do that?

    Thanks
    jbowieUser is Offline
    Basic Member
    Basic Member
    Posts:110


    --
    02 Apr 2014 01:34 PM
    Oops. I forgot that detail!

    Like the DTS Editor, TQL "deletes" by setting the Concept Status to Deleted. We have added a "permanent" delete to the requirements for the next version of TQL, but in the interim I would suggest doing an 'export_namespace' from TQL to an XML file, deleting the namespace, creating a new namespace and reloading the xml with the Import Wizard. The default TQL behavior is to export active concepts only, so you should not have any concepts in the resulting namespace. The only other option would be to write an API program.

    Versioning has added a lot of nice new features to DTS, but has made a few other operations more cumbersome. We are continuing to try to address these issues.
    You are not authorized to post a reply.


    Apelon

    We are a privately held international software and informatics company focusing on data standardization and interoperability. Apelon’s software and professional services help leading healthcare enterprises, HIT vendors and integrators, life sciences organizations and government agencies better manage standard terminologies and transition local data to these standards. Our solutions enable semantic interoperability, consistent data analysis, and standardized reporting of health information to improve the quality, comparability, and accessibility of clinical data.

    Latest Tweets

    Copyright 2024 by Apelon, Inc.