Bulk delete of Reviews

[puneetkanchi08]

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]

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]

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 · Accepted solution]

@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]

Hi Oleg,

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

Thanks for your inputs.

Regards,

Puneet.