Delete all namespace's concepts
Last Post 02 Apr 2014 01:34 PM by jbowie. 3 Replies.
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.


    ---