Change Deposit Status in Bulk: Difference between revisions
No edit summary |
No edit summary |
||
| Line 3: | Line 3: | ||
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 using the Web interface one-by-one, this could be a very time-consuming process. | 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 using the Web interface one-by-one, this could be a very time-consuming process. | ||
The following [http://files.eprints.org/777/ plug in] allows you to do this from the command line. Otherwise, execute the following update command in MySQL: | |||
<code> | <code> | ||
| Line 23: | Line 23: | ||
</code> | </code> | ||
Now your items should be | Now your items should be available from the repository. | ||
Latest revision as of 08:57, 20 June 2012
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 using the Web interface one-by-one, this could be a very time-consuming process.
The following plug in allows you to do this from the command line. Otherwise, execute the following update command in MySQL:
UPDATE eprint SET eprint_status="archive" WHERE userid=3 AND eprint_status="inbox"
or
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 available from the repository.