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

