Sonar

Improve the CSV export mechanism on rules to prevent any issue when using special characters like coma or double quotes

Details

  • Type: Improvement Improvement
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Cannot Reproduce
  • Affects Version/s: None
  • Fix Version/s: None
  • Component/s: Rules
  • Labels:
    None
  • Number of attachments :
    0

Description

Otherwise, the CSV rule export available from the Sonar UI is corrupted.

Issue Links

is related to

Bug - A problem which impairs or prevents the functions of the product. SONAR-2139 CSV Export of quality profiles should be working with Excel "Data to columns Feature"

  • Minor - Minor loss of function, or other problem where easy workaround is present.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Fabrice Bellingard added a comment - - edited

I could not reproduce any issues on the CSV export. I tried with rule names containing comas or double quotes, generating a file like (for instance):

title,key,plugin,priority,status
"This is a rule with ""quotes"" !",ArchitecturalConstraint_1341494594,squid,INFO,ACTIVE
"This is a rule, with a comma",ArchitecturalConstraint_1341494558,squid,INFO,ACTIVE
"This is a rule, with a comma ""and"" double quotes !",ArchitecturalConstraint_1341498039,squid,INFO,ACTIVE

This kind of files is perfectly handled by (Open|Libre|Microsoft)Office. The only trick I had to do is to rename the file from "rules.csv" to "rules.csv.txt" for Microsoft Office 2007 (and later versions) to force the import wizard to ask what to use as a separator.

Show
Fabrice Bellingard added a comment - - edited I could not reproduce any issues on the CSV export. I tried with rule names containing comas or double quotes, generating a file like (for instance): title,key,plugin,priority,status "This is a rule with ""quotes"" !",ArchitecturalConstraint_1341494594,squid,INFO,ACTIVE "This is a rule, with a comma",ArchitecturalConstraint_1341494558,squid,INFO,ACTIVE "This is a rule, with a comma ""and"" double quotes !",ArchitecturalConstraint_1341498039,squid,INFO,ACTIVE This kind of files is perfectly handled by (Open|Libre|Microsoft)Office. The only trick I had to do is to rename the file from "rules.csv" to "rules.csv.txt" for Microsoft Office 2007 (and later versions) to force the import wizard to ask what to use as a separator.
Hide
Permalink
Fabrice Bellingard added a comment -

In SONAR-2139, Olivier gives a workaround to properly open the CSV file.

Show
Fabrice Bellingard added a comment - In SONAR-2139 , Olivier gives a workaround to properly open the CSV file.

People

  • Assignee:
    Fabrice Bellingard
    Reporter:
    Freddy Mallet
Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: