[Dspace-devel] [DuraSpace JIRA] (DS-1669) create a script to clean up ePersons with null data

Fri, 20 Sep 2013 13:56:20 -0700

Issue Type: Code Task Code Task
Affects Versions: 4.0
Assignee: Unassigned
Created: 20/Sep/13 8:54 PM
Description: See DS-1666 for the backstory. It's quite easy to create ePerson records with null values, and these records serve no real purpose in the database, and can get in the way (null values in unexpected places leads to unhappy software).

A simple script which runs this SQL should solve the problem:

DELETE FROM EPerson WHERE email IS NULL AND netID IS NULL;
Project: DSpace
Priority: Minor Minor
Reporter: Hardy Pottinger
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira 
------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. 
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
_______________________________________________
Dspace-devel mailing list
Dspace-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-devel

Reply via email to