Forum Discussion

puneetkanchi08's avatar
puneetkanchi08
Occasional Contributor
4 years ago

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 ar...
command line client
delete review
  • 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

     

OlegB's avatar
OlegB
SmartBear Alumni (Retired)
4 years ago

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
    4 years ago

    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)
      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

       

      • puneetkanchi08's avatar
        puneetkanchi08
        Occasional Contributor
        4 years ago

        Hi Oleg,

         

        Yes, thanks for this.. I tried something similar and it works!!

        Thanks for your inputs.

         

        Regards,

        Puneet.