The database I am using on my DSpace installation is PostgreSQL
From: Lewatle Phaladi
Sent: 13 February 2013 10:44 AM
To: [email protected]
Subject: Updating items with wrong metadata simultaneously
Dear All,
I have one collection with more than 300 items where erroneously user has
submitted items giving them correct day, month but incorrect year under
published date, by rectifying the error I would like to know if there is SQL
statement that I could use to modify the entire items so they can use similar
year on date but keep different day and month, the itema reflect 2010 as year
published instead of 1987.
If there is any additional info to clarify any of the above details I would be
glad to give it to you.
Regards,
Lewatle
<html><p><font face = "verdana" size = "0.8" color = "navy">This communication
is intended for the addressee only. It is confidential. If you have received
this communication in error, please notify us immediately and destroy the
original message. You may not copy or disseminate this communication without
the permission of the University. Only authorized signatories are competent to
enter into agreements on behalf of the University and recipients are thus
advised that the content of this message may not be legally binding on the
University and may contain the personal views and opinions of the author, which
are not necessarily the views and opinions of The University of the
Witwatersrand, Johannesburg. All agreements between the University and
outsiders are subject to South African Law unless the University agrees in
writing to the contrary.</font></p></html>
------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
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
