things are going good in my office: a lot of University of Bologna journals are asking us to move to OJS
Although this is a good thing, there much work to do: for example, I succesfully imported a list of 25 issues with the new OJS of this journal (http://journals.unibo.it/riviste/index. ... tica/index
but as you can see here the Authors list contains a lot of authors written with capital letters (http://journals.unibo.it/riviste/index. ... ch/authors
We have tried to find the right table, in the db, which contains all the metadata for Authors:
it could be fairly easy to run a script to correct automatically the case in Name and Last name fields, and this could save us a lot of time
(as you know authors double easily in OJS for mismatched metadata, so there will be a lot of manual polishing anyway...).
Although, we *did* not find that table, we don't know where those authors metadata are in the db.
Could you help us in this? Do you think this approach is feasible?