Export comments from csdb

Discussions about CSEntry
Forum rules
New release: CSPro 8.0
Post Reply
Mariovaisman
Posts: 133
Joined: February 11th, 2013, 8:26 am

Export comments from csdb

Post 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
Enkhbayar
Posts: 68
Joined: November 10th, 2014, 11:48 pm

Re: Export comments from csdb

Post by Enkhbayar »

Josh, is it possible to add one more function to export csnot files from the batch in the next release of CSPro?
josh
Posts: 2399
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: Export comments from csdb

Post 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.
Enkhbayar
Posts: 68
Joined: November 10th, 2014, 11:48 pm

Re: Export comments from csdb

Post by Enkhbayar »

Tnx Josh, I managed to retrieve notes data automatically using a batch app.
Post Reply