* Export the Google spreadsheet to a TSV file (not CSV) * Run dos2unix on the exported TSV file * Run the script this way: ./tsv2toml-good.py good.tsv $(pwd)/approved "approved" ./tsv2toml-good.py good-fonts.tsv $(pwd)/approved-fonts "approved-fonts" The good.tsv file is the exported spreadsheet from Google with the column header row removed and any summary total rows below the license rows removed. The second argument to the script is the subdirectory to store the licenses. Right now we're only writing out approved licenses. * The script will display which rows caused problems and save the bad rows to "errors.tsv" which can be imported in to another Google spreadsheet if you want. After the conversion, you will need to check the expression field to ensure it's a list of strings. Most of these will just be a list of one element, but where there are more then it needs commas between the string members. Ideally we will just remedy the problem rows and run this script again until everything is imported. At that point the spreadsheet can be discarded and all continuing work will be in the git repo. Of course, the work for unapproved licenses and special case things can be handled before we completely discard the spreadsheet side of the information. Repeat the above process for the bad.tsv license list using tsv2toml-bad.py script. The source spreadsheets are different formats. -- David Cantrell <dcantrell@redhat.com>