CSPro DB - notes

Discussions about CSEntry
leulae
Posts: 36
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

Leulae

htuser
Posts: 317
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,

josh
Posts: 1635
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”