csv_writer - bruno-beloff/scs_dev GitHub Wiki

docs > software repositories > scs_dev > commands > file-based data management

DESCRIPTION

The csv_writer utility is used to convert from JSON format to comma-separated value (CSV) format.

The path into the JSON document is used to name the column in the header row: dictionary fields are separated from their container by a period ('.') character, and array members are separated by a colon (':') character.

All the leaf nodes of the first JSON document are included in the CSV. If subsequent JSON documents in the input stream contain fields that were not in this first document, these extra fields are ignored.

SYNOPSIS

csv_writer.py [-c] [-a] [-e] [-v] [FILENAME]

Options
--version	show program's version number and exit
-h, --help	show this help message and exit
-c, --cache	cache rows in heap space until exit
-a, --append	append rows to existing file
-e, --echo	echo stdin to stdout
-v, --verbose	report narrative to stderr

EXAMPLES

./socket_receiver.py | ./csv_writer.py temp.csv -e

DOCUMENT EXAMPLE - INPUT

{"tag": "scs-ap1-6", "rec": "2018-04-04T14:50:27.641+00:00", "val": {"hmd": 59.6, "tmp": 23.8}}

DOCUMENT EXAMPLE - OUTPUT

tag,rec,val.hmd,val.tmp
scs-ap1-6,2018-04-04T14:50:38.394+00:00,59.7,23.8