Thankfully we have a great IT guy who can help with a lot of this, but I
need to get ideas on what to do so he can focus on his plethora of
projects. I am hoping this will help. Thanks.
On Fri, Jan 24, 2014 at 12:38 PM, Hilton Gibson <[email protected]>wrote:
> 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
