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]> 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]
>
>
>
> *From:* Matthew Sherman [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]>
> 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
>
> [email protected]
>
>
>
> *From:* Matthew Sherman [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]
> 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
