Multi-Level CSV (csv_ml) is a light(er)-weight data interchange format equivalent to JSON and XML
Java HTML
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
.settings
javascript
src
.classpath
.gitignore
.project
LICENSE
README.md
TODO
csv_ml_android_demo-1.0.0.apk
csv_ml_swing_demo-1.0.0.jar
csvdoc.pdf
json-simple-1.1.1.jar
sqlite-jdbc-3.7.2.jar

README.md

#Multi-level CSV (CSV_ML)

This is an Advanced Parser for CSV (Comma-separated-value), TSV (Tab-separated-value), TDV (Tab-delimited-value) or even files with custom delimiters such as the Pipe symbol (|). It supports streams and pull parsing for handling huge data files. It also supports comments and empty lines within the delimited files for annotation.

In addition to parsing regular tabular formats with or without header, it can also parse structured delimited files and convert them to XML DOM or JSON objects.

This article proposes the idea of using CSV format for defining structured relational data in additional to tabular data. The idea is nick named CSV_ML (Multi-level CSV). CSV_ML attempts to provide a simple unambiguous format for representing structured data that includes schema definition.

CSV_ML is expected to

  • save storage space (about 50% compared to JSON and 60-70% compared to XML)
  • increase data transfer speeds
  • be faster to parse compared to XML and JSON
  • allow full schema definition and validation
  • make schema definition simple, lightweight and in-line compared to DTD or XML Schema
  • recognize standard data types including text (varchar), integer, real, date, datetime
  • allow database binding
  • be used in EAI (Application Integration) for import and export of data
  • be simpler to parse, allowing data to be available even in low memory devices

Applications

  • Enterprise Application Integration (EAI)
  • Lightweight alternative to JSON or XML in Three-tier architecture
  • Alternative to XML in transfer of data using AJAX
  • Data storage and transfer format for embedded platforms such as Arduino and Raspberry PI.
  • Data storage and transfer format for mobile/tablet devices based on Android, Windows or iOS.
  • Data transfer format for spreadsheets as Tab delimited values through clipboard or otherwise.

For complete documentation and examples, download Multi-level nested CSV.pdf

The examples given in the documentation are available as demo applications:

For running Javascript and Java Applet demos, you may have to change security settings in your browser.

The given demos convert between CSV, TDV. XML and JSON (CSV to XML DOM, CSV to JSON, TDV to XML DOM, TDV to JSON, XML to CSV). It is basically a CSV TDV TSV to JSON XML Convertor. It also demonstrates how database binding can be achieved using SQLite db.

Contact arun@siara.cc for any queries or feedback.