Location of information in the OCS MySQL database

[RickMath]

Hi PKP Support

I am trying to transfer information from the OCS database to a local Access database to generate some reports.

What I am trying to do is generate queries for aothors and paper titles and abstracts.

I have exported the users table and the papers table and worked with these. I cannot find where the titles and abstracts are stored to link them to the paper id and the author id.

Any help on this would be appreciated. I have phpMyAdmin access to our database.

Thanks for your response.

Rick

[jamief]

Hi. One method (beyond just telling you where they are! - which I don't remember at the moment) is to make an mySQL dump of your dbase. Using a text editor like word or phpedit, you can use a search on a abstract string of the file, in there you will see the insert command, and thus, know which tables and fields contents are being stored.

[RickMath]

Ah ha!

After searching around, I finally found them. They are in the paper_settings table.

Thanks for being patient with me. Guess I missed checking that table the first time around.

Rick