Generate streamlined analysis workfile (CSV) from SCIO-DB

[nexb]

Generate streamlined analysis workfile (CSV) from SCIO-DB

[steven-esser]

@JonoYang has written this utility: https://github.com/nexB/spats/blob/develop/src/spats/scanpipe_results_to_xlsx.py that "flattens" the data how we normally expect it (\n characters separating multiple values) and supports package data.

@mjherzog I believe we want to support package data as well? This is on our normal work file alongside regular scancode detections.

[mjherzog]

@majurg My mistake to forget about packages. I updated the main text above with selected package fields.

[mjherzog]

The list of fields requested is my take on what is most useful for planning and simpler analysis tasks. My working assumption is that there will be other CSV workfile output variations.

[tdruez]

Closing as the existing XLSX output should be used instead.