Re: [Dspace-tech] Bulk Edit Export problem resolved--kind of.

2011-05-25 Thread Jeffrey Trimble
The problem really isn't the exporter. It's Microsoft Excel and how it reads a .cvs file. If I open a exported metadata file with a long field, such as description.abstract. That field, if it has paragraph breaks, is interpreted as a line return by Microsoft. Very strange. If you open this

Re: [Dspace-tech] Bulk Edit Export problem resolved--kind of.

2011-05-25 Thread Stuart Lewis
Hi Jeff, Yes - we tend to advise using OpenOffice as it doesn't try to be so 'clever' when it interprets the CSV. For the date issue - we recommend setting all columns to 'Text' in the 'how shall I open this file' dialog by clicking on the top left cell (which highlights all cells) and