Re: [Dspace-tech] batch modifications

2011-01-25 Thread Peter Dietz
Hi Sisay,

My colleague Maureen gave a presentation on batch editing at the DSpace
User's Group a few months ago.

http://hdl.handle.net/1811/47279 --  Batch Metadata Editing in DSpace 1.6+

To answer your question, I think the trick is to delete the columns from the
spreadsheet that you will not be modifying, otherwise it reapplies each
column of data in your spreadsheet.

--
Peter Dietz
Systems Developer/Engineer
Ohio State University Libraries



On Tue, Jan 25, 2011 at 8:56 AM, Webshet, Sisay (ILRI)
s.webs...@cgiar.orgwrote:

  Dear Friends,



 I want to do batch modifications on dspace 1.6.2.  I have modified some
 metadata information

 on some .csv file using excel  When I try to import it the issue date is
 added and removed the previous issue data setting.

 Is there a way to block or ignore issue data modification.



 Thanks

 Sisay


 --
 Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
 Finally, a world-class log management solution at an even better
 price-free!
 Download using promo code Free_Logger_4_Dev2Dev. Offer expires
 February 28th, so secure your free ArcSight Logger TODAY!
 http://p.sf.net/sfu/arcsight-sfd2d
 ___
 DSpace-tech mailing list
 DSpace-tech@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/dspace-tech


--
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
February 28th, so secure your free ArcSight Logger TODAY! 
http://p.sf.net/sfu/arcsight-sfd2d___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech


Re: [Dspace-tech] batch modifications

2011-01-25 Thread Stuart Lewis
Hi Sisay,

Peter's suggestion will work, and is perhaps the best option.  Remove any 
columns that you are not editing.

However what might be happening is that Excel is converting the date string to 
a date-formatted cell, and when it saves it back to the CSV it saves it in a 
different format.  DSpace will then replace the date format with the new 
version from Excel.

You might find it easier to use OpenOffice to edit the CSVs, as you can more 
easily tell it to use UTF-8 encoding, and to leave dates alone, than you can in 
Excel.

See: - 
https://wiki.duraspace.org/display/DSPACE/Batch+Metadata+Editing+Prototype 
('CSV editing hints' section)

Thanks,


Stuart Lewis
Digital Development Manager
Te Tumu Herenga The University of Auckland Library
Auckland Mail Centre, Private Bag 92019, Auckland 1142, New Zealand
Ph: +64 (0)9 373 7599 x81928


On 26/01/2011, at 7:09 AM, Peter Dietz wrote:

 Hi Sisay,
 
 My colleague Maureen gave a presentation on batch editing at the DSpace 
 User's Group a few months ago.
 
 http://hdl.handle.net/1811/47279 --  Batch Metadata Editing in DSpace 1.6+ 
 
 To answer your question, I think the trick is to delete the columns from the 
 spreadsheet that you will not be modifying, otherwise it reapplies each 
 column of data in your spreadsheet.
 
 --
 Peter Dietz
 Systems Developer/Engineer
 Ohio State University Libraries
 
 
 
 On Tue, Jan 25, 2011 at 8:56 AM, Webshet, Sisay (ILRI) s.webs...@cgiar.org 
 wrote:
 Dear Friends,
 
  
 I want to do batch modifications on dspace 1.6.2.  I have modified some 
 metadata information
 
 on some .csv file using excel  When I try to import it the issue date is 
 added and removed the previous issue data setting.
 
 Is there a way to block or ignore issue data modification.
 
  
 Thanks
 
 Sisay
 
 
 --
 Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
 Finally, a world-class log management solution at an even better price-free!
 Download using promo code Free_Logger_4_Dev2Dev. Offer expires
 February 28th, so secure your free ArcSight Logger TODAY!
 http://p.sf.net/sfu/arcsight-sfd2d
 ___
 DSpace-tech mailing list
 DSpace-tech@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/dspace-tech
 
 
 ATT1..txtATT2..txt



--
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
February 28th, so secure your free ArcSight Logger TODAY! 
http://p.sf.net/sfu/arcsight-sfd2d
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech


Re: [Dspace-tech] batch modifications

2011-01-25 Thread Webshet, Sisay (ILRI)
Hi Friends

 

It woks fine. Thank you very much

 

Thanks 

 

Sisay

 



From: pdiet...@gmail.com [mailto:pdiet...@gmail.com] On Behalf Of Peter
Dietz
Sent: Tuesday, January 25, 2011 9:10 PM
To: Webshet, Sisay (ILRI)
Cc: dspace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] batch modifications

 

Hi Sisay,

 

My colleague Maureen gave a presentation on batch editing at the DSpace
User's Group a few months ago.

 

http://hdl.handle.net/1811/47279 --  Batch Metadata Editing in DSpace
1.6+ 

 

To answer your question, I think the trick is to delete the columns from
the spreadsheet that you will not be modifying, otherwise it reapplies
each column of data in your spreadsheet.


--
Peter Dietz
Systems Developer/Engineer
Ohio State University Libraries




On Tue, Jan 25, 2011 at 8:56 AM, Webshet, Sisay (ILRI)
s.webs...@cgiar.org wrote:

Dear Friends,

 

I want to do batch modifications on dspace 1.6.2.  I have modified some
metadata information

on some .csv file using excel  When I try to import it the issue date
is added and removed the previous issue data setting.

Is there a way to block or ignore issue data modification.

 

Thanks 

Sisay



--
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better
price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

 

--
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
February 28th, so secure your free ArcSight Logger TODAY! 
http://p.sf.net/sfu/arcsight-sfd2d___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech