Change Deposit Status in Bulk - Revision history

Robert.berry@liverpool.ac.uk at 08:57, 20 June 2012

2012-06-20T08:57:37Z

← Older revision		Revision as of 08:57, 20 June 2012
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.

	~~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 23:		Line 23:
	</code>		</code>

	Now your items should be ~~availabe~~ from the repository.		Now your items should be available from the repository.

Pm705 at 13:29, 8 February 2010

2010-02-08T13:29:05Z

← Older revision		Revision as of 13:29, 8 February 2010
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.

Fmccown at 18:44, 10 April 2007

2007-04-10T18:44:01Z

← Older revision		Revision as of 18:44, 10 April 2007
Line 1:		Line 1:
	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.		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~~:		To change a large number of deposits, execute the following update command in MySQL:

	<code>		<code>

Fmccown: Change Deposit Statuses in Bulk moved to Change Deposit Status in Bulk

2007-03-23T15:42:24Z

Change Deposit Statuses in Bulk moved to Change Deposit Status in Bulk

← Older revision	Revision as of 15:42, 23 March 2007
(No difference)

Fmccown: Initial article

2007-03-21T20:13:27Z

Initial article

New page

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:

<code>
UPDATE eprint SET eprint_status="archive" WHERE userid=3 AND eprint_status="inbox"
</code>

or

<code>
UPDATE eprint SET eprint_status="archive" WHERE eprintid < 101
</code>

depending on the criteria that identifies the deposits you want to change.

Then you will need to run <tt>generate_abstracts</tt> in order for the deposited items to have an abstract page:

<code>
/opt/eprints3/bin/generate_abstracts <archive_id>
</code>

Now your items should be availabe from the repository.