CSPro DB - notes

Discussions about CSEntry
Posts: 39
Joined: December 16th, 2016, 5:51 am

CSPro DB - notes

Postby leulae » January 22nd, 2018, 11:16 am

Dear all,

While notes for CSPro DB files are stored within the file itself, how do I make one text file with all notes.

Thank you all


Posts: 334
Joined: December 19th, 2011, 6:26 pm
Location: HAITI

Re: CSPro DB - notes

Postby htuser » January 22nd, 2018, 3:48 pm

Hi Leulae,
Notes are stored in the notes table in Csdb, who's a sqlite family file, so do in column in the Csweb's MySQL. So, if you can access to this database using credentials: user and password for MySQL or sqlite browser for Csdb, you'll see all notes (case and field) and you can export them to Excel, Csv, txt etc.

Best regards,

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

Re: CSPro DB - notes

Postby josh » January 22nd, 2018, 5:09 pm

While you could try to extract the data using sqlite, we do not recommend doing that as the file format could change in future versions of CSPro. Instead, take a look at this post on how to export the notes by first converting the csdb file to text: viewtopic.php?f=7&t=2098&p=6876

Return to “Entry”