HXL-CPLP / forum

Fórum do Grupo de Usuários do Padrão HXL da Comunidade dos Países de Língua Portuguesa, "HXL-CPLP"
https://github.com/HXL-CPLP/forum/issues
The Unlicense
2 stars 0 forks source link

[EN] Current state of tools with explicit support for the .hxl extension (in special over .csv) #24

Open fititnt opened 3 years ago

fititnt commented 3 years ago

Quick links


Note: this issue on @HXL-CPLP in special will be preferable written in English

The main objective of this issue is both document some tests with tools beyond the ones provided by the @HXLStandard organization. While often (and in fact, even HXL-Proxy seems to default to .csv extension, but remove the lines before the first heading) the .hxl files actually have more features than standard .csv. Also some tools, in special the ones that try to make auto detection of values, could get confused by the extra lines of HXL.

fititnt commented 3 years ago

Google Drive consider .hxl extension as binary file.

Google Drive consider .hxl extension as binary file. I did not tested, but I would assume this could means it would not try to apply compression when trying to download such datasets.


Captura-de-tela-de-2020-12-07-21-07-10


Google Drive don't try to preview .hxl files

This may affect user editing files.

Captura de tela de 2020-12-07 21-09-46

Here the same, but as .txt

Captura de tela de 2020-12-07 21-09-36

fititnt commented 3 years ago

Ok, here a tricky that make Google Drive render .hxl as text file (even somewhat can render as csv like file):

  1. Upload the file with .csv (or .tsv) extension., like v_br_cep.tsv
  2. Using Google Drive web interface, rename v_br_cep.tsv to v_br_cep.hxl. It will continue to me considered an text file even if you upload a new file v_br_cep.hxl over the old one.
fititnt commented 3 years ago

About GitHub preview (tested on 2020-12-08)

If using HXL on .csv and not prefix metadata at the start of the file it will somewhat works. Good. Not perfect, but good.

With .hxl it will not even try parse

Captura de tela de 2020-12-08 16-50-19