| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | Name | Reference | Type | Format Metadata | Field Metadata | Metadata Association | Notes |
2 | CsvSchema | https://bitbucket.org/vadwook/csvschema/wiki/Home | Library | Required Fields Field types (String, Int, Decimal) Min/Max Length (string) Permissible values (string) Min/Max Inclusive/Exclusive (numbers) Precision, Digits (numbers) Custom Rules, e.g. A or B | Configuration (Code) | ||
3 | Schema.ini | http://msdn.microsoft.com/en-us/library/ms709353(v=vs.85).aspx | Format | Character Encoding Field Delimiter Fixed length fields (no delimiter) Header Presence | Field types (numeric, currency, various text fields, date) Field length Date/time format Decimal, currency symbol Currency formats | INI File | "MaxScanRows" for autodiscovery of types |
4 | Simple Data Format | http://dataprotocols.org/simple-data-format/ | Format | Requires fixed encoding. Required headers in CSV Recommends CSV profile (comma as delimited; CRLF or LF as terminator) or use of CSV DDF | Requires use of JSON Table Schema | JSON (discovered by Convention) | Included as it recommends a specific CSV subset, as well as allowing some embedded schema description. Builds on CSV DDF and JSON Table Schema |
5 | CSV Dialect Description Format | http://dataprotocols.org/csv-dialect/ | Format | Field Delimiter Record Separator Quote Character Significant Space Double Quoting | JSON | ||
6 | JSON Table Schema | http://dataprotocols.org/json-table-schema/ | Format | Field Names Field Types (based on JSON Schema) Field Format | JSON | ||
7 | Flat File Checker | http://blog.flat-file.net/2010/04/how-to-validate-csv-file.html | Tool | Field Delimiter Fixed length fields Record Separator Quote Character Header Presence | Required Fields Uniqueness Value constraint (regex) Length constraint Custom expression Cross-Reference with external file | Parameters | |
8 | CSV Fix | http://csvfix.byethost5.com/csvfix15/csvfix.html | Tool | Field Delimiter Newlines in content Number of fields | Required Fields Field Lengths (min, max, blank) Permissible values (illegal values) Numeric types, with ranges Date types with format mask and ranges Cross-Reference with external file | Parameters | |
9 | DFDL | http://en.wikipedia.org/wiki/Data_Format_Description_Language | Format | Field Delimiter Field Encoding | Field Types (XSD) Number formats, bases | XML | |
10 | XFlat | http://serv01satpoes01.free.fr/NEWS/conveter%20xml/docs/xflat.htm | Format | Field Delimiter Record Separator Header Presence Quote Character | Field Names Required Fields Field Lengths Field Types Numeric types, with ranges Valid & Invalid Chars | XML | |
11 | Linked CSV | http://jenit.github.io/linked-csv/ | Format | None | Field Types (string, url, int, decimal, double, boolean, XSD date/times) Field language Property mapping (URI) | Embedded | Autodiscovery of field types |
12 | chkcsv | http://pythonhosted.org/chkcsv/ | Tool | Required Fields Field Lengths Field Types (string, integer, float, bool, date, datetime) Regular Expression match | Parameters, INI File | ||
13 | SuperCSV | http://supercsv.sourceforge.net/cell_processors.html | Library | Quote char Delimiter Terminator Preserve spaces Comments | Required Fields Uniqueness Field Lengths Field Types (decimal, boolean, char, date, double, int, long) Numeric types, with ranges Value checks (fixed value, valid & invalid chars) Permissible/illegal values Regular Expression match | Configuration (Code) | |
14 | CSV Validator | https://github.com/adamretter/csv-validator | Tool/Library | Number of columns Header Delimiter Quoting | Required Field Field Length Uniqueness Field Types (positive int, number, integer, char, date, uuid, uri) Numeric types, with ranges & partial dates Date types, with ranges Cross-referencing between columns Simple tests 9is, not in, starts, ends) Regular Expression matches File System checks (exists, checksum, file count) Logical operators (AND, OR, IF/THEN/ELSE) Cross-referencing between columns | Custom Format | |
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 |