Feature #1162

Feature #2163: RCP: X.X, Standardize export mechanism

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

Added by Serge Heiden almost 5 years ago. Updated 6 months ago.

Status:New Start date:12/05/2014
Priority:High Due date:
Assignee:- % Done:

0%

Category:Development Spent time: -
Target version:TXM X.X

Description

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

History

#1 Updated by Sebastien Jacquot over 2 years ago

  • Parent task set to #2163

#2 Updated by Matthieu Decorde almost 2 years ago

  • Subject changed from RCP: X.X, TAB default value for column separator in CSV tables (metadata, results exports) to RCP: X.X, use the same CSV format for all export/import of data tables (metadata, results exports, lexical tables...)
  • Description updated (diff)
  • Target version changed from TXM X.X to TXM 0.8.0a (split/restructuration)

#3 Updated by Matthieu Decorde almost 2 years ago

  • Description updated (diff)
  • Priority changed from Normal to High

#4 Updated by Sebastien Jacquot about 1 year ago

  • Target version changed from TXM 0.8.0a (split/restructuration) to TXM 0.8.0

#5 Updated by Matthieu Decorde 6 months ago

  • Target version changed from TXM 0.8.0 to TXM X.X

Also available in: Atom PDF