Skip to content

Upgrade json2csv.py script to handle the new ABCD format. #339

Closed
@steven-esser

Description

@steven-esser

Currently, the json2csv.py script cannot convert ABCD formatted scan results from JSON to csv.

For example, running the current develop branch (w ABCD formatting) results in this error:

# scancode -ilpc samples/ ~/ABCD_scan_results.json && python etc/scripts/json2csv.py ~/ABCD_scan_results.json ~/ABCD_scan_results.csv
Scanning files...
  [####################################]  43                                     
Scanning done.
Traceback (most recent call last):
  File "etc/scripts/json2csv.py", line 345, in <module>
    cli()
  File "/Users/sesser/Documents/src/scancode/lib/python2.7/site-packages/click/core.py", line 664, in __call__
    return self.main(*args, **kwargs)
  File "/Users/sesser/Documents/src/scancode/lib/python2.7/site-packages/click/core.py", line 644, in main
    rv = self.invoke(ctx)
  File "/Users/sesser/Documents/src/scancode/lib/python2.7/site-packages/click/core.py", line 837, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/Users/sesser/Documents/src/scancode/lib/python2.7/site-packages/click/core.py", line 464, in invoke
    return callback(*args, **kwargs)
  File "etc/scripts/json2csv.py", line 341, in cli
    json_scan_to_csv(json_input, csv_output, strip=strip)
  File "etc/scripts/json2csv.py", line 119, in json_scan_to_csv
    scan_results = load_scan(json_input)
  File "etc/scripts/json2csv.py", line 109, in load_scan
    scan_results = scan_results['results']
KeyError: 'results'

And running on the v1.6.3 release (old scan format) generates a correct csv output file:

# scancode -ilpc samples/ ~/old_scan_results.json && python etc/scripts/json2csv ~/old_scan_results.json ~/old_scan_results.csv

Metadata

Metadata

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions