Relation:File formats

.rel files

Relation files are unicode text files and contain the code exactly as in the application, but not formatted.

.csv files

There is no formal definition of comma separated files.

Relation accepts the following formats:

  • Text encoding: UTF8, Latin1, Windows Latin1 and MaxRoman.
  • Line separator: CR, LF or CRLF.
  • Field separator: semicolon or comma.
  • Field names: The first line must contain the field names. On reading the files, invalid names are converted to valid names.
  • Quotes: Double quotes are optional for values that do not contain a field separator. Quotes are escaped by repeating them. Single quotes are not supported.
  • Newline in fields: Newline in quoted values are converted to spaces. Newline in values without quotes are not supported.

Relation writes the following formats:
  • Text encoding: UTF8
  • Line separator: LF.
  • Field separator: comma.
  • Field names: First line
  • Quotes: Numeric values without, other values with quotes.

.txt files

Text files are read as tab-separated files.

  • Text encoding: UTF8, Latin1, Windows Latin1 and MaxRoman.
  • Line separator: CR, LF or CRLF.
  • Field separator: tab
  • Field names: The first line must contain the field names. On reading the files, invalid names are converted to valid names.
  • Quotes: no quotes
  • Newline in fields: not supported.

Text files are imported file with one single field.
  • Text encoding: UTF8, Latin1, Windows Latin1 and MaxRoman.
  • Line separator: CR, LF or CRLF.
  • Field name: constant (line)
  • Field separator: none
  • Quotes: no quotes
  • Newline in fields: not supported.

Relation writes the following formats:
  • Text encoding: UTF8
  • Line separator: LF.
  • Field separator: Tab.
  • Field names: First line
  • Quotes: No quotes.

.json files

Relation reads the first table it finds in a .json file.

Relation writes json files.

The feature is explerimental as the hierarchical structure of a JSON file cannot always be represented in a table.

.html files

The exported files are HTML5 files with UTF8-Encoding and basic features.

The following styles definition are inline:

  • table.datatable, table.datatable th, table.datatable td { margin-bottom: 5px; padding: 5px; border: 1px solid black; border-collapse: collapse;}
  • ul {margin-block-start: 0em; margin-block-end: 0em;}
  • .error {color:red;}

You may overrule these definition using a template.

.txt wikitext files

wikitext files are simple text files in UTF8 encoding and mostly compatible with MediaWiki and Sofawiki.

Only a subset of wikitext is implemented.

  • header ==h2== to ====h4====
  • unnumbered lists *
  • tables {| and |}, table row |-, header cell ! and normal cell |
  • italic with two single quotes, bold with three single quotes

.txt template files

template files are simple text files in UTF8 encoding and mostly compatible with MediaWiki and Sofawiki.

Markers use double curly braces {{ and }}

  • {{first}} to be shown for the first row
  • {{group field}} to be shown for each group by one field, before or after each
  • {{each}} to be shown for for each row
  • {{last}} to be shown after the last row
  • {{end}} to ignore the following