Hi Ronee, > Has anyone experienced a metadata export where the diacritics are not handled > properly? > > Here is an example of what it should look like and what it came out in the > exported Excel file as. > > Jrade, Cathy Login. Rubén Darío y la búsqueda romántica de la unidad : el > recurso modernista a la tradición esotérica. México: Fondo de Cultura > Económica, 1986. > > Jrade, Cathy Login. RubeÌn DariÌo y la buÌsqueda romaÌntica de la unidad > : el recurso modernista a la tradicioÌn esoteÌrica. > > Is this something that could be generated by the export or by importing into > excel? Any ideas?
It is possible that the text is being mutilated by Excel. If the CSV file opens by default in Excel, then it tends to get upset by the diacritics, and converts dates to date objects rather than leaving them as text. OpenOffice is better at opening CSV files - it asks what encoding you want to use (select 'UTF-8') and you can select what formatting to apply to the columns (click on the top left cell to highlight them all, and select the column type of 'Text'. - http://oldwiki.dspace.org/index.php/Batch_Metadata_Editing_Prototype#CSV_editing_hints Thanks, Stuart Lewis IT Innovations Analyst and Developer 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 ------------------------------------------------------------------------------ Virtualization is moving to the mainstream and overtaking non-virtualized environment for deploying applications. Does it make network security easier or more difficult to achieve? Read this whitepaper to separate the two and get a better understanding. http://p.sf.net/sfu/hp-phase2-d2d _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
