Export comments from csdb

Discussions about CSEntry
Post Reply
Mariovaisman
Posts: 100
Joined: February 11th, 2013, 8:26 am

Export comments from csdb

Post by Mariovaisman » September 30th, 2019, 6:37 am

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

Re: Export comments from csdb

Post by Enkhbayar » October 1st, 2019, 9:15 am

Josh, is it possible to add one more function to export csnot files from the batch in the next release of CSPro?

josh
Posts: 1986
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: Export comments from csdb

Post by josh » October 1st, 2019, 10:53 am

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

Re: Export comments from csdb

Post by Enkhbayar » October 3rd, 2019, 2:54 pm

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

Post Reply