how to download an indexed database as a csv file?

CorText Manager Q&A forumCategory: Data processinghow to download an indexed database as a csv file?
estela asked 5 years ago
1 Answers
Jean-Philippe Cointet Staff answered 5 years ago

Dear Estela, 
Two options for doing so, 
if your corpus is not too big, you can try the first simplest one, which consists in using corpus explorer script. First select fields you are interested in exporting and then create a csv or xls file using buttons that should show up in the top right part of the corpus explorer interface.
The second option is to download the full .db file on your computer and then use any sqlite database software to open it and export tables in csv format. 
Sqlite Manager (https://addons.mozilla.org/fr/firefox/addon/sqlite-manager/) is very efficient for instance. 

estela replied 5 years ago

Merci bien, Jean-Philippe.
The problem is that once the db is indexed according to a list of terms (and therefore the corresponding indexing column added, which is what I am interested in), I cannot access the .db file to download it all. And my database is so large that the download buttons do not appear in Cortext when I use the Corpus Explorer script. It is driving me crazy! I need to download the indexed file to re-analyse some stuff but I am stuck 🙁
Any help welcome!

Jean-Philippe Cointet Staff replied 5 years ago

You mean that it’s impossible for you to download the .db file ?
What is happening exactly ? You get disconnected or something alike ?

estela replied 5 years ago

Yep, I do not know where to access the list of .db files to select and download one of them…
I can download the original .db file after parsing it, that is fine, but after indexing it I do not get to access the list of .db files again to download them (once indexed, my db file contains a few more columns with the indexed terms, which is what I am interested in). Is there something I have missed?
The other huge doubt I have (sorry to bother you so much, Jean-Philippe!) is: how can I reclassify the indexed terms? I’ve assigned each term to a bunch of categories (e.g., the term “water quality” shall be assigned to the “Environmental” category and so on), and I’ve got the complete list of terms and the corresponding categories in a separate file, but I do not know what script I shall use to link them. Is there a way to do it in Cortext (I bet there is!)?
Merci beaucoup!!!

Jean-Philippe Cointet Staff replied 5 years ago

actually new information are added to the same file. You can scroll down to the original .db file and it will include the additional indexations you did !

Corpus_list_indexer is dedicated to recoding categories. You should find a video showing how to use it in the documentation.

estela replied 5 years ago

Ok, many, many, many thanks!!! I’ll check and try the List Indexer, then

Bonne journée! 🙂