Thank you, Hardy. Yes, I thought that it would be a SQL fix. I was hoping for a "non-techy" for my colleagues who don't do database management. Oh, well.
George Kozak Digital Library Specialist Cornell University Library Information Technologies (CULIT) 501 Olin Library Cornell University Ithaca, NY 14853 607-255-8924 ________________________________________ From: Pottinger, Hardy J. [[email protected]] Sent: Monday, May 02, 2011 5:57 PM To: George Stanley Kozak; [email protected] Subject: Re: [Dspace-tech] Problem with display and viewing records in DSpace 1.7.1 Hi, George, I've run into some odd display problems that related to metadata that was wrong in unplanned-for ways, such as an incomplete or null URI field (due to quota issues with our database). I ended up resolving those issues by working with the Oracle tables directly, using SQL Developer on my desktop. If you're running PostreSQL, the idea would be similar: query and modify the metadata directly, using whatever tool you have on hand for database inspection and editing. -- HARDY POTTINGER <[email protected]> University of Missouri Library Systems http://lso.umsystem.edu/~pottingerhj/ "No matter how far down the wrong road you've gone, turn back." --Turkish proverb On 5/2/11 3:41 PM, "George Stanley Kozak" <[email protected]> wrote: >Hi, Everyone: > >Last Friday I wrote about a ³bug² that I found in DSpace 1.7.1, and I >haven¹t heard back from anyone about this. So, I am thinking that what >I wrote wasn¹t clear enough, and, therefore, I am resubmitting my email >with some additional information. > >I have some records that someone submitted with the batch loader in which >the date was improperly encoded (for instance ³April, 1994² instead of >³1994-04²). >In DSpace 1.6.2, these records display properly except that the Date >display is something like ³-1-Uns- -1². No problem, I can go in and fix >them. > >HOWEVERŠ > >In Dspace 1.7.1 (using the JSPUI interface), these types of records do >not display at all. > >- If I do an item display, I get a blank screen. >- If I do a Browse by Title, Author, Date or Subject, in the >collection that the items are in, I get a blank screen >- If I do a Browse all Titles or Author or Date or Subject, it >works fine until I get to the ³damaged² items, then I get an abbreviated >display that contains some HTML displayed (such as <a >href="/browse?type=author&value=Bauder%2) > >I can see where if someone uploaded a batch file with ³badly formatted² >dc.date.issued, it would be difficult to figure out what records are bad >since they don¹t display and mess up the search and browse displays that >they appear in. > >So, does anyone have any ideas what to do about this? > >George Kozak >Digital Library Specialist >Cornell University Library Information Technologies (CUL-IT) >501 Olin Library >Cornell University >Ithaca, NY 14853 >607-255-8924 > ------------------------------------------------------------------------------ WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
