Skip to content

RCP: X.X, use the same CSV format for all export/import of data tables (metadata, results exports, lexical tables...)

Comma (,) as column separator is a mess between Windows Excel and Mac OS X Excel and Calc, etc. for TXM users.

Solution

CSV tables column separator must be set to TABULATION (TAB) for import and export.

Data structures concerned

  • metadata.csv (to rename ‘metadata.tsv’)
  • command results export tables
  • lexical tables

UI specifications

  • In the “User >Import” preference page, rename “metadata.csv file format” to “CSV file format”
  • In the “User >Export” preference page, add a “CSV file format” section around the 3 CSV items
  • the TABULATION character must be expressed by the ‘TAB’ string
  • if the character separator value is not the TAB string, use the given character literally (in this case, there must be only one character in the field)
  • UI concerned: parameters, preferences and macro parameters

Commands concerned

  • Export result
  • Import Lexical Table
  • Corpus import modules

Preferences concerned

  • metadata table separator (remove ‘text field’ character)
  • export table column separator (?)

Scripts concerned

  • some macros: CSV2XML, etc.

files specifications

  • table files must have the ‘.tsv’ (for import and export)

documentation specifications

  • update manual

samples

  • update corpus sources

(from redmine: issue id 1162, created on 2014/12/05 by Serge Heiden)

  • Relations: