Page 1 of 1

Export comments from csdb

Posted: September 30th, 2019, 6:37 am
by Mariovaisman
Hello,

I was trying to find out the fastest way to export the comments to excel or stata from csdb data files, and the only way found was to export the data to cspro in .dat files (text files), and then export the .dat.csnot to stata or excel using a dictionary that represent that comment file.

Is it a different way to extract the comments from csdb files, otherwise there are two process, the first is to convert csdb to .dat, and second is to export the csnot file.

Thanks

Mario

Re: Export comments from csdb

Posted: October 1st, 2019, 9:15 am
by Enkhbayar
Josh, is it possible to add one more function to export csnot files from the batch in the next release of CSPro?

Re: Export comments from csdb

Posted: October 1st, 2019, 10:53 am
by josh
Will consider that. In the meantime you can get the notes from a csdb with a bit of SQL:

Code: Select all

select cases.key, notes.*
from notes join cases on notes.case_id = cases.id
This will work for versions 7.0 through 7.3. We may change the database schema a bit for the next release.

Re: Export comments from csdb

Posted: October 3rd, 2019, 2:54 pm
by Enkhbayar
Tnx Josh, I managed to retrieve notes data automatically using a batch app.