OS 010: Archive Data using TSV and JSON

Implemented

Contrary to XML or JSON, TSV is perfectly suited to represent records with the least possible overhead. There are a lot of tools, like spreadsheet editors, which can read and modify TSV files. The file’s size is at the possible minimum, and the performance of the converter is significantly better than with the other formats.

TSV is preferred to import data into the application or export information from the solution. The format is also the preferred solution to import data into or export data from the solution.

TSV files cannot express complex nested structures. Regular business models are often quite flat and translate well to a set of TSV files.

We recommend JSON format for complex nested documents.

The solution tangly ERP is a well-constructed solution using TSV format for import and export of bounded domain persistent data.

The complex documents defining invoices are exported as imported using a JSON format.