Hi Xiping, My suggestion is to import or upload your (cleaned-up) csv file into Google spreadsheets. I tested your sample data and accent marks are retained (not 100% though). See my attached screenshot. All you have to do now is to find and replace all the � characters. After cleaning it up, download as CSV and then import it back to DSpace. Take note that once you already downloaded it as CSV, refrain from editing it in MS Excel because in my experience, it will mess up your encoding again. It may seem a tedious task but I would rather do it this way than start all over again.
Hope this helps. Good luck and best regards, euler On Friday, March 11, 2016 at 1:18:05 AM UTC+8, Xiping Liu wrote: > > Hello everyone, > > A few months ago we started a project of cleaning up our electronic thesis > and dissertation records from DSpace. We exported our data from Dspace as a > csv file and after the cleanup we are ready to import the data back into > Dspace. But we noticed that some of the names (accent marks and quotes) in > our data are not showing correctly (I am assuming the encoding is not set > correctly in the very beginning after we export). But since we have already > done our clean up in our file, it will be really painful to go back and re > export the file from Dspace (so we can set the encoding correctly this > time) and redo all the editing. I wonder is there any way we can correct > the encoding after we import the data back into Dspace? Or any suggestions > to solve this problem? I have attached a small sample of our data. > > Your help is greatly appreicated. > > Xiping > > > -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
