Difference between revisions of "Change Deposit Status in Bulk"
m (Change Deposit Statuses in Bulk moved to Change Deposit Status in Bulk)
Revision as of 15:42, 23 March 2007
At times it may be useful for you to move a large number of deposits from "User Workarea" to "Live Archive". While you could do this manually one-by-one, this could be a very time-consuming process.
To change a large number of deposits, execute the following update command in MySql:
UPDATE eprint SET eprint_status="archive" WHERE userid=3 AND eprint_status="inbox"
UPDATE eprint SET eprint_status="archive" WHERE eprintid < 101
depending on the criteria that identifies the deposits you want to change.
Then you will need to run generate_abstracts in order for the deposited items to have an abstract page:
Now your items should be availabe from the repository.