Yes the data appears correctly when viewed using text editor(open office ) and was saving it using UTF-8 encodes. In addition the some of the data appears correctly on the dspace web interface and some of the data are not displayed correctly Correctly displayed below(Author or citation).All the databases are encoded with UTF-8 (Unicode) http://cgspace.cgiar.org/handle/10568/47 http://cgspace.cgiar.org/handle/10568/2217
incorrectly displayed below(Author) http://cgspace.cgiar.org/handle/10568/32923 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of helix84 Sent: Monday, October 07, 2013 11:15 AM To: Webshet, Sisay (ILRI) Cc: [email protected] Subject: Re: [Dspace-tech] rough characters on csv On Mon, Oct 7, 2013 at 8:40 AM, Webshet, Sisay (ILRI) <[email protected]> wrote: > We used to import a fresh data in the form of csv file from some other > system(Inmagic) and we preprocess the data using open office and saved using > UTF-8 At this stage some French characters, apostrophe etc. can be > translated or viewed properly. The problem happens when we exported the data > from dspace in to csv usually on author and abstract fields . we used > Microsoft Excel 2013 or open office to edit the file. After you preprocessed the data in OpenOffice.org and before you imported the CSV to DSpace, did the characters appear correctly when you viewed the CSV file in a text editor? What encoding did you use for the CSV file when saving in OpenOffice.org? Do those characters display correctly in the DSpace web interface? Did you create your DSpace database with the -E UNICODE flag as described in the Installation chapter? (createdb -U dspace -E UNICODE dspace) Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette ------------------------------------------------------------------------------ October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
