Change Deposit Status in Bulk

From EPrints Documentation
Revision as of 20:13, 21 March 2007 by Fmccown (talk | contribs) (Initial article)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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:

/opt/eprints3/bin/generate_abstracts <archive_id>

Now your items should be availabe from the repository.