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

     

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