Well in that case, you're in luck. Just tell your IT guy that he just needs to
change the 'email' attribute on the 'eperson' table. He should be able to do
that in a few minutes.
Cheers!
Bill Ingram
University of Illinois
Urbana, IL 61801
217-333-4648
[email protected]
From: Matthew Sherman [mailto:[email protected]]
Sent: Friday, January 24, 2014 11:51 AM
To: Ingram, William A
Cc: Hilton Gibson; dspace-tech
Subject: Re: [Dspace-tech] Making Changes to User Accounts
Actually what you did is exactly what we are running into. The e-mail server
has changed but the only aspect of the e-mail that has changed is the domain
name (@my.bridgeport.edu<http://my.bridgeport.edu> vs.
@bridgeport.edu<http://bridgeport.edu>).
On Fri, Jan 24, 2014 at 12:47 PM, Ingram, William A
<[email protected]<mailto:[email protected]>> wrote:
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<http://uiuc.edu> address
to @illinois.edu<http://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<tel:217-333-4648>
[email protected]<mailto:[email protected]>
From: Hilton Gibson
[mailto:[email protected]<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<tel:%2B27%2021%20808%204100> | Cell: +27 84 646
4758<tel:%2B27%2084%20646%204758>
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<tel: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
