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
Export comments from csdb
Re: Export comments from csdb
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
Will consider that. In the meantime you can get the notes from a csdb with a bit of SQL:
This will work for versions 7.0 through 7.3. We may change the database schema a bit for the next release.
Code: Select all
select cases.key, notes.*
from notes join cases on notes.case_id = cases.id
Re: Export comments from csdb
Tnx Josh, I managed to retrieve notes data automatically using a batch app.