Hi Michael,
If you're using the most recent release of OCS 1.x and want to add an additional field to the author metadata:
- Add two new columns to your database:
- Code: Select all
ALTER TABLE papers ADD COLUMN my_new_column VARCHAR(255);
ALTER TABLE papers ADD COLUMN add_my_new_column VARCHAR(255);
- Use the "affiliation" and "add_affiliation" fields as an example for your new "my_new_column" and "add_my_new_column" fields. Search for "affiliation" and duplicate or extend the code to include the new fields. You'll need to make changes to the following files:
- admin/editpaper.php
- admin/invitedspeakers.php
- admin/reviews.php
- papers.php
- reviews.php
- schedule.php
- search.php
- viewabstract.php
- viewappendix.php
- viewbio.php
- viewpaper.php
- submitform.php
- validate.php
- comments.php
- admin/masterlist.php
- oai/include/functions.inc.php
- rst/config.inc.php
- rst/functions.inc.php
- Of course, some of the above scripts might not need to be changed, depending on what behavior you'd like (i.e. whether or not it'll be included in OAI extracts, etc.)
The reason there are two table columns associated with a new field -- and this is a hare-brained design decision that someone made a long time ago -- is that the first column contains the value for the first author, and the second column contains the value for the second and subsequent authors, separated by newlines. Again, just follow the code examples for affiliation and rest assured that OCS 2.0 will not suffer from this.
Regards,
Alec Smecher
Open Journal Systems Team
---
Don't miss the First International PKP Scholarly Publishing Conference
July 11 - 13, 2007, Vancouver, BC, Canada
http://ocs.sfu.ca/pkp2007/