Hello Jeff,if you did not run the cleanup script and still got the bitstreams marked as deleted in the bitstream table, you can access the bitstreams via the UI by
[YourDSpaceURL]/retrieve/[bitstream_id] or write a little script to retrieve all the bitstreams flagged deleted. You can get all the bitstreams flagged as deleted with the sql command: select * from bitstream where delete=true;This will return all the deleted bitstreams regardless of the collection the items has been it. Having deleted the parent community/collection this information is not available anymore.
Hope that helps Claudia Jürgen Am 28.05.2010 23:34, schrieb Jeffrey W. Pearson:
Thank you for the feedback even though it is bad news. Just to clarify though and making sure I understand. We don't care about the metadata. The plan was to transfer the content to another cms. We were going to have to open each one and re-catalog anyway. The point of concern is getting those content files back. Agani, I have everything at the file system. So theoretically, I actually have the content files. They are just encoded into the 'bitstream' files that dspace uses and we can't read them. There is nothing that will extract the original pdf files from these? Once again, thank you all for the suggestions and information. Jeff Pearson USC Libraries Mark Diggory wrote:Jeff, Unfortunately, There is significantly more than just the Community table that is effected here. You actually loose the Item, Metadata and Bundle table entries that were present. All that is left is the Bitstream Table with the flag that the Bitstream has been deleted. You would need to restore the database from a backup to recover that database state for not only the Community and Collections objects, but also the Item and Bundle Objects the Bitstreams were attached to. This is unfortunate news. The only other possibility for recovering the data may be if a third party harvested your OAI gateway and has indexed those dc records, unfortunately, I think such data would also be partial. Sorry the news is not better. Mark On May 28, 2010, at 12:23 PM, Jeffrey W. Pearson wrote:Thank you for the info so far: The problem with getting technical info from a user :-( OK. The user did not delete the individual items, he actually deleted the COMMUNITY. I dont see the data for the record in the community table. Are we SOL? Again, thank you all for the suggestions and the user GREATLY appreciates the efforts to saving his fanny... Jeff Pearson USC Libraries Peter Dietz wrote:I would look in the database table "item". It has a field called "item"."in_archive". Typically when an item gets deleted it sets item.in_archive to FALSE So from the DB, you could look for all of the "deleted" items. So use your favorite SQL query tool (perhaps pgAdmin3 if your DB is postgres) SELECT * FROM item where item.in_archive = false; Or get all the metadata for the deleted items. SELECT item.item_id, item.in_archive, metadatafieldregistry.element, metadatafieldregistry.qualifier, metadatavalue.text_value, item.last_modified FROM public.item, public.metadatavalue, public.metadatafieldregistry WHERE item.item_id = metadatavalue.item_id AND metadatavalue.metadata_field_id = metadatafieldregistry.metadata_field_id AND item.in_archive = FALSE ORDER BY last_modified DESC; However, I think deletions to communities and collections make them go away, the items may remain behind as an artifact. Peter Dietz Systems Developer/Engineer Ohio State University Libraries On Fri, May 28, 2010 at 2:35 PM, Sands Alden Fish<[email protected] <mailto:[email protected]> <mailto:[email protected]>> wrote: Others should provide some clarification on this, but typically deletions are not "hard deletes" but soft, in that there is a deletion flag that a cleanup process operates on occasionally. Perhaps the database still contains the items, and you can revert the deletion by modifying the correct tables? Sorry that this isn't more detailed. I've never had to dig around in that logic before. -- sands fish Software Engineer MIT Libraries Technology Research& Development [email protected]<mailto:[email protected]> <mailto:[email protected]> E25-131 On May 28, 2010, at 2:30 PM, Jeffrey W. Pearson wrote:Quick question: We had a user delete things he should not have. We have been able to restore the filesystem stuff from backups. Unfortunately, the database backups have been lost. All we really need is the content files. Is there a way to rebuild the content files from just using what is on the file system? Any help would be GREATLY appreciated, especially by the user who deleted the data.... Jeff Pearson USC Libraries ------------------------------------------------------------------------------ _______________________________________________ Dspace-devel mailing list [email protected] <mailto:[email protected]> <mailto:[email protected]> https://lists.sourceforge.net/lists/listinfo/dspace-devel------------------------------------------------------------------------------ _______________________________________________ Dspace-devel mailing list [email protected] <mailto:[email protected]> <mailto:[email protected]> https://lists.sourceforge.net/lists/listinfo/dspace-devel------------------------------------------------------------------------------ _______________________________________________ Dspace-devel mailing list [email protected] <mailto:[email protected]> https://lists.sourceforge.net/lists/listinfo/dspace-develMark R. Diggory Head of U.S. Operations - @mire http://www.atmire.com - Institutional Repository Solutions http://www.togather.eu - Before getting together, get t...@ther------------------------------------------------------------------------------ _______________________________________________ Dspace-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-devel
<<attachment: Claudia_Juergen.vcf>>
------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________ Dspace-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-devel
