I know how to do it with PostgreSQL.
pg_dump dspace > dspace_dump.sql
# make your changes; then
psql dspace < dspace_dump.sql
That's basically it. There are other ways around the problem as well, maybe
better ones.
Read this for more info:
http://www.postgresql.org/docs/9.3/interactive/backup-dump.html
Use the --table option on pg_dump to isolate the eperson table.
Probably something like this:
pg_dump --table=eperson -E UNICODE -U dspace dspace > eperson_dump.sql
See:
http://www.postgresql.org/docs/9.3/static/app-pgdump.html
Make sure to back up your db first!
Bill Ingram
University of Illinois
Urbana, IL 61801
217-333-4648
wingr...@illinois.edu
From: Matthew Sherman [mailto:matt.r.sher...@gmail.com]
Sent: Friday, January 24, 2014 11:16 AM
To: Ingram, William A
Cc: dspace-tech
Subject: Re: [Dspace-tech] Making Changes to User Accounts
Is there a way to export this data make that change? I am a little fuzzy on
the process.
On Fri, Jan 24, 2014 at 12:12 PM, Ingram, William A
<wingr...@illinois.edu<mailto:wingr...@illinois.edu>> wrote:
I think this depends on whether or not you have a mapping from old e-mail to
new e-mail. Or better yet, a method from going from old to new; i.e., f(old) =
new. If so, can use this method on the e-mail field of the eperson table. That
should do it.
Bill Ingram
University of Illinois
Urbana, IL 61801
217-333-4648<tel:217-333-4648>
wingr...@illinois.edu<mailto:wingr...@illinois.edu>
From: Matthew Sherman
[mailto:matt.r.sher...@gmail.com<mailto:matt.r.sher...@gmail.com>]
Sent: Friday, January 24, 2014 10:15 AM
To: dspace-tech
Subject: [Dspace-tech] Making Changes to User Accounts
Hello,
I am hoping someone can give me some insights on an issue we are hoping to head
off. Over the summer our University changed e-mail servers and now students
have a different e-mail address than they did last year. The problem is DSpace
does not reflect this change in the user accounts since the e-mail is set when
an account is first created. We are concerned this will be a problem in a few
months when they turn off the old server. Does anyone know a way we can bulk
edit the e-mails in the user accounts so we can head off any submission or
subscription e-mail issues? Any insights would be appreciated as I have not
been able to find any documentation online that can tell me how to fix this
without changing everyone directly in the XMLUI. Thanks for your time.
Matt Sherman
------------------------------------------------------------------------------
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today.
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette