We had a similar problem a few years ago. But ours was easy, we only changed
domain names. We went from everyone having a @uiuc.edu address to
@illinois.edu, but the user names stayed the same (e.g.,
[email protected]<mailto:[email protected]> =>
[email protected]<mailto:[email protected]>).
But if you’re going from [email protected]<mailto:[email protected]> =>
[email protected]<mailto:[email protected]>, then that’s a much harder problem.
Bill Ingram
University of Illinois
Urbana, IL 61801
217-333-4648
[email protected]
From: Hilton Gibson [mailto:[email protected]]
Sent: Friday, January 24, 2014 11:38 AM
To: Ingram, William A
Cc: Matthew Sherman; dspace-tech
Subject: Re: [Dspace-tech] Making Changes to User Accounts
I agree with Bill about modifying the database directly. Maybe somebody on the
list is willing to craft a SQL query for you for some sort of compensation
perhaps?
Cheers
hg
Hilton Gibson
Ubuntu Linux Systems Administrator
JS Gericke Library
Room 1025D
Stellenbosch University
Private Bag X5036
Stellenbosch
7599
South Africa
Tel: +27 21 808 4100 | Cell: +27 84 646 4758
http://scholar.sun.ac.za
http://bit.ly/goodir
http://library.sun.ac.za
http://za.linkedin.com/in/hiltongibson
On 24 January 2014 19:33, Ingram, William A
<[email protected]<mailto:[email protected]>> wrote:
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
[email protected]<mailto:[email protected]>
From: Matthew Sherman
[mailto:[email protected]<mailto:[email protected]>]
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
<[email protected]<mailto:[email protected]>> 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>
[email protected]<mailto:[email protected]>
From: Matthew Sherman
[mailto:[email protected]<mailto:[email protected]>]
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
[email protected]<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
