search

Regnology / lucy

Lucy is a component analysis platform to minimize the risk of license infringements and to support and optimize the license compliance process.
MIT License
7 stars 1 forks source link

Comment Field Bug in CSV Export #15

Closed anabotescu closed 1 year ago

anabotescu commented 1 year ago

Describe the bug When we export the full report from Lucy, the comment field is wrongly exported, mingled with libraries.

To Reproduce Steps to reproduce the behavior: 1.Open a product

  1. Go to "Reports"
  2. Click on OSS List > Full > Download
  3. See - the field "Compliance Comment" mingled with libraries.

Expected behavior One solution may be to put the compliance comment into " "-> which is the usual text identification in CSV (for Excel). It might make sense to put all text fields in "" Downloaded CSV with large comments can be opened in Excel without breaking the format of the table.

Lucy_2023

patrickwjh commented 1 year ago

The problem is that for the "Full" export the Apache commons-csv library isn't used. I've adjusted the code and now the CSV creation is done with the commons-csv library which handles all different special characters automatically, like the delimiter or quotes in the comment fields.

I've opened a pull request #16.