Quick Python one-liner to get JSON output from recutils
data.rec
%rec: movies Id: 4 Title: Banana Joe Country: Italy | West Germany Date: 1982 Director: Steno Genre: Comedy Length: 93 Add_date: 05/06/2008 Audio: German (MP3) Identifier: 141 Location: Box 1 Media: DVD Amount_of_Media: 1 Rating: 6 Video_file: /media/cdrom0/Banana-Joe.avi Video_format: DX50 Viewed: 1 Borrower: none Favourite: 0 Id: 2 Title: Baraka Country: USA Date: 1992 Director: Ron Fricke Genre: Documentary Length: 96 min Add_date: 04/06/2008 Identifier: 858 Location: Box 1 Media: CD Amount_of_Media: 1 Rating: 0 Video_file: /media/cdrom0/Baraka.avi Video_format: divx Viewed: 1 Borrower: none Favourite: 0
$ rec2csv data.rec | python -c 'import csv,json,sys; print(json.dumps(list(csv.DictReader(sys.stdin)), indent=4))'
[ { "Rating": "6", "Identifier": "141", "Title": "Banana Joe", "Add_date": "05/06/2008", "Country": "Italy | West Germany", "Favourite": "0", "Video_file": "/media/cdrom0/Banana-Joe.avi", "Amount_of_Media": "1", "Director": "Steno", "Genre": "Comedy", "Length": "93", "Location": "Box 1", "Borrower": "none", "Media": "DVD", "Date": "1982", "Video_format": "DX50", "Audio": "German (MP3)", "Id": "4", "Viewed": "1" }, { "Rating": "0", "Identifier": "858", "Title": "Baraka", "Add_date": "04/06/2008", "Country": "USA", "Favourite": "0", "Video_file": "/media/cdrom0/Baraka.avi", "Amount_of_Media": "1", "Director": "Ron Fricke", "Genre": "Documentary", "Length": "96 min", "Location": "Box 1", "Borrower": "none", "Media": "CD", "Date": "1992", "Video_format": "divx", "Audio": "", "Id": "2", "Viewed": "1" } ]