How to query Crucible code review data

Question

Hi,

I am evaluating Crucible for peer code review option. I am looking for option to query Crucible data for metrics and reporting. I need to know how many code reviews are done in certain time frame with how many defects or comments.

Is there any way to query Crucible data and generate report? I did see basic reporting in Crucible which does not display the condition that I need.

Thanks,

Sharad

chandraprabha hegde · Answer

Is this tool still available? The link seems to be broken. I am need of an excel export tool for crucible review with review comments, file names and line numbers included.

John Werner1 · Answer

Crucible makes a lot of data available through its REST API.  You might want to check if it has what you are looking for.

Crucible Excel Dump is a C# tool that was written by one of the contributors to this site who was nice enough to make the code available.  It uses the REST API to export information to Excel.  If nothing else, it will show you how to access the API.

Avdhesh Chauhan · Answer

We use MS SQL DB - for the same reason we devloped some simple Crystal report - its simple to configure and we get all the information as required