SonarQube is an open platform to manage code quality. This program can export code analysis from a SonarQube server as a docx, xlsx, csv, markdown, and text files.

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 3 of the License, or (at your option) any later version.

This tool can be used in standalone as a JAR executable (with the command line) or as a Sonarqube plugin.

• Setup a SonarQube instance.
• Run an analysis with sonar-scanner, maven, gradle, msbuild, etc.
• Execute cnesreport:
  • In standalone, thanks to command line
  • In plugin mode, copy jar in /opt/sonarqube/extensions/plugins, restart sonarqube, then click on "More" > "CNES Report".

cnesreport does not need any installation. It is a portable Java application you can copy and run according to following examples. The only requirement is an up-to-date JRE (>=1.8).

• Copy the sonar-cnes-report.jar in the plugin folder of sonarqube (On linux path should be like /opt/sonarqube/extensions/plugins)
• Restart sonarqube (On linux: sudo service sonar restart)

Use java -jar sonar-cnes-report.jar -h to get the following help about cnesreport:

usage: java -jar sonar-cnes-report.jar [-a <arg>] [-b <arg>] [-c] [-d <arg>] [-e] [-h] [-l <arg>] [-o <arg>] [-p <arg>] [-r <arg>]
       [-s <arg>] [-t <arg>] [-v] [-w] [-x <arg>]
Generate editable reports for SonarQube projects.

 -a,--author <arg>                 Name of the report writer.
 -b,--branch <arg>                 Branch of the targeted project. Requires Developer Edition or sonarqube-community-branch-plugin. Default: usage of main branch.
 -c,--disable-conf                 Disable export of quality configuration used during analysis.
 -d,--date <arg>                   Date for the report. Format: yyyy-MM-dd. Default: current date.
 -e,--disable-spreadsheet          Disable spreadsheet generation.
 -f,--disable-csv                  Disable csv generation.
 -h,--help                         Display this message.
 -l,--language <arg>               Language of the report. Values: en_US, fr_FR. Default: en_US.
 -m,--disable-markdown             Disable markdown generation.
 -n,--template-markdown <arg>      Path to the report template in markdown. Default: usage of internal template.
 -o,--output <arg>                 Output path for exported resources.
 -p,--project <arg>                SonarQube key of the targeted project.
 -r,--template-report <arg>        Path to the report template. Default: usage of internal template.
 -s,--server <arg>                 Complete URL of the targeted SonarQube server.
 -t,--token <arg>                  SonarQube token of the SonarQube user who has permissions on the project.
 -v,--version                      Display current version.
 -w,--disable-report               Disable report generation.
 -x,--template-spreadsheet <arg>   Path to the spreadsheet template. Default: usage of internal template.


Please report issues at https://github.com/cnescatlab/sonar-cnes-report/issues

You can have more detailed logs in the hidden directory .cnesreport which should be created in your home directory at first launch.
In addition, you can have a lookt at your SonarQube server logs, which can be very helpful in debugging a problem.

This is the minimal usage of cnesreport. This example export (report + spreadsheet + configuration) the public project projectId from SonarQube server http://localhost:9000. This will use default internal templates.

java -jar sonar-cnes-report.jar -p projectId

If you have installed cnes-report in your sonarqube: open web interface, click on "CNES Report" then choose a project.

If you are using a secured instance of SonarQube, you can provide a SonarQube authentication token thanks to -t option and specify the url of the SonarQube instance with -s. The internal template for the text report can be replaced by the one given through -r option.

java -jar sonar-cnes-report.jar -t xuixg5hub345xbefu -s https://example.org:9000 -p projectId -r ./template.docx

If you are using a commercial edition of sonarqube or the sonarqube-community-branch-plugin you can export the report for a specific branch of your project using the -b option.

java -jar cnesreport.jar -p projectId -b dev

As this application is used in many enterprise contexts, we have added the ability to go through proxy. The cnesreport application use system proxy configuration so that you have no fanciful parameter to set.

To use the proxy feature be sure to set following properties:

• https.proxyHost
• https.proxyPort
• https.proxyUser
• https.proxyPassword

If your JRE's proxy is not set, you can use Java flags as follow:

java -Dhttps.proxyHost=https://myproxy -Dhttps.proxyPort=42
-Dhttps.proxyUser=jerry -Dhttps.proxyPassword=siegel
-jar sonar-cnes-report.jar -t xuixg5hub345xbefu -s https://example.org:9000 -p projectId

• Export code analysis as a set of files
• Export code analysis configuration
• Use custom templates
• Get a custom OpenXML (docx, xlsx) report
• Get a dynamic pivot table with all issues
• Export in french or english

For legacy versions, check the wiki page here : Note on legacy versions

If you experienced a problem with the plugin please open an issue. Inside this issue please explain us how to reproduce this issue and paste the log.

If you want to do a PR, please put inside of it the reason of this pull request. If this pull request fix an issue please insert the number of the issue or explain inside of the PR how to reproduce this issue.

• You can access to the plugin with the web api (/api/cnesreport/report) or with the web UI (/extension/cnesreport/report / "More" > "CNES Report").

• Plugin mode is made to provide an easier usage than standalone usage. If you need to use advanced features you should use plugin in standalone.

• Plugin mode is compatible with SonarQube branch feature.

• During execution, the plugin mode use the ${SONARQUBE_HOME}/temp folder. It writes some files, zip these files and send them to client. Files are deleted after download. If you interrupt plugin during execution (bug, stopping sonar, etc.) you may check this folder to remove useless files.

In order to compile the project, a simple mvn clean package command from the project's root, where the pom.xml is located, will do the trick.
Of course, Maven and Java JDK are required to build the JAR file.

Copyright 2021 CATLab.

Licensed under the GNU General Public License, Version 3.0