Forum Discussion

puneetkanchi08's avatar
puneetkanchi08
Occasional Contributor
4 years ago
Solved

Bulk delete of Reviews

Hello,

 

I am new to Collaborator, so please bear with me if this is a simple/silly question: 

 

As a part of clean up process, I need to archive and delete multiple reviews. 

 

I am able to archive multiple reviews through ccollab admin archive review <review ID1, review Id2, etc> command. However from the documentation I am unable to find a way to delete multiple/bulk reviews at one go.

 

Can someone please help?

 

Thanks,
Puneet.

  • OlegB's avatar
    OlegB
    4 years ago

    puneetkanchi08 

     

    This command proceeds only one parameter (review) at a time. You can develop a script that will take a review ID from e.g. a file and run the "admin review delete" command one by one. Here is an example of a very simple batch file with this command:

    @echo off
    for /f %%G IN (list.txt) DO "C:\Program Files\Collaborator\ccollab.exe" --url http://localhost:8080/ --user admin --password "admin" admin review delete %%G

     

    As an input, it requires a file with reviews IDs split into new lines:

    24

    34

    53

     

    Otherwise, you can generate a .xml file and process it with the admin batch command. The command-line client will open one single connection to the server and process with all the commands specified in the .xml file. 

    https://support.smartbear.com/collaborator/docs/reference/command-line/ccollab-admin-batch.html

     

4 Replies

  • OlegB's avatar
    OlegB
    SmartBear Alumni (Retired)

    Hi puneetkanchi08,

     

    Collaborator allows deleting only non-progress reviews (reviews in the "Planning" phase). All other reviews can only be canceled or rejected. There is no way to do that in one bulk call in the WebUI. But you can collect the review IDs using the "Reports" feature using certain criteria and delete or cancel them by using the command-line utility:

    https://support.smartbear.com/collaborator/docs/reference/command-line/ccollab-admin-review.html - Delete and Cancel commands. 

     

    These commands can be scripted: https://support.smartbear.com/collaborator/docs/custom-integrations/scripting/overview.html

     

     

     

     

     

    • puneetkanchi08's avatar
      puneetkanchi08
      Occasional Contributor

      Hi Oleg,

       

      Many thanks for the response. I have tried the command -- ccollab admin review delete <reviewid> -- however this one too deletes just one review.

       

      I tried doing ----> ccollab admin review delete <reviewid1>, <reviewdid2> ---- but this command errored out.

       

      If I were to develop script, can I will be passing all review IDs to be deleted as an input to the script, but this ccollab admin review delete deletes only one review.

       

      Thanks,

      Puneet.

      • OlegB's avatar
        OlegB
        SmartBear Alumni (Retired)

        puneetkanchi08 

         

        This command proceeds only one parameter (review) at a time. You can develop a script that will take a review ID from e.g. a file and run the "admin review delete" command one by one. Here is an example of a very simple batch file with this command:

        @echo off
        for /f %%G IN (list.txt) DO "C:\Program Files\Collaborator\ccollab.exe" --url http://localhost:8080/ --user admin --password "admin" admin review delete %%G

         

        As an input, it requires a file with reviews IDs split into new lines:

        24

        34

        53

         

        Otherwise, you can generate a .xml file and process it with the admin batch command. The command-line client will open one single connection to the server and process with all the commands specified in the .xml file. 

        https://support.smartbear.com/collaborator/docs/reference/command-line/ccollab-admin-batch.html