search

tematres / TemaTres-Vocabulary-Server

Web application for management formal representations of knowledge, like controlled vocabularies, taxonomies, thesauri and glossaries
https://vocabularyserver.com
120 stars 52 forks source link

Adding two exports : multicolumn CSV output (for easy import to other tools) ; one list label for translation process #4

Open gautiermichelin opened 8 years ago

gautiermichelin commented 8 years ago

Hi again,

I've hacked Tematres to add under the export menu two new options :

Are you ok for such a pull request ? Do you want me to separate those ?

Bye,

Gautier

tematres commented 8 years ago

Hi Gautier :), we work in the same direction, but in order to create a source file useful for any CSV ingest process, we see other tools who export structure like this: term_id, term, type_relation/vinculation, term_id2,term2

and the same for notes or foreing relations. This model export more than one row for each term. Is less flat buy more simple. What do you think?

About export terms for translation process, in advaced options export form there are filtres to export only the terms without mapping relations, this option is useful for you? If you export terms with no options in Advanced reports you obtain CSV with one label per row. ok?

thank you!! :)

gautiermichelin commented 8 years ago

Hi,

diego ferreyra mailto:notifications@github.com 3 mai 2016 13:41

Hi Gautier :), we work in the same direction, but in order to create a source file useful for any CSV ingest process, we see other tools who export structure like this: term_id, term, type_relation/vinculation, term_id2,term2

and the same for notes or foreing relations. This model export more than one row for each term. Is less flat buy more simple. What do you think?

Not interested in this one for me, but this is definitely an alternative for other tools. Why not implement both ? One CSV with one raw per term, with parenthood, and other relations ; one CSV centered on the links.

About export terms for translation process, in advaced options export form there are filtres to export only the terms without mapping relations, this option is useful for you? If you export terms with no options in Advanced reports you obtain CSV with one label per row. ok?

I'll have a check, thanks for the tip. Nevertheless, I've concat'ed the code with the label (to avoid ambiguity on transifex returns to database ingestion questions).

thank you!! :)

— You are receiving this because you authored the thread. Reply to this email directly or view it on GitHub https://github.com/tematres/TemaTres-Vocabulary-Server/issues/4#issuecomment-216502964

Best regards,

Gautier

tematres commented 8 years ago

Hi, Yes... may be the 2 options are useful :), we go ahead.

marijane commented 4 years ago

I just had a user ask if they can export our vocabulary to Excel, I could really use this. Is there a fork somewhere with this code?

tematres commented 4 years ago

hi @marijane , following the @gautiermichelin suggestion in the lasts version of tematres (3.0 and 3.1) we incude some reports oriented to export all the vocab to excel. In Reports you can found (all the terms, all the relations, all the notes) . It is the solution?

marijane commented 4 years ago

Aha! I was looking at the exports, not the reports.

These are interesting, but I suspect I need some kind of table-shaped export that shows the hierarchical relationships. I've asked my user what shape they need their data in, and I may try writing a SQL query to pull it.

tematres commented 4 years ago

Hi :) but if you can access to SQL environment, the best way is export SQL dump from Export menu (Menu -> Administration -> Export: SQL dump)