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)

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.