Difference between revisions of "Change Deposit Status in Bulk"

From EPrints Documentation
Jump to: navigation, search
m
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
 +
[[Category:Management]]
 +
 
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.
  
To change a large number of deposits, execute the following update command in MySQL:
+
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 21: Line 23:
 
</code>
 
</code>
  
Now your items should be availabe from the repository.
+
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.