When I use export tool, carriage returns in fields (eg: partner comment, product description) are converted into spaces.
When I re-import the generated file, there is no more CR in fields, the whole content is in one line separated with spaces.
Is it possible to import data fields with multiples lines with CSV file ?
It normally works fine - I have never had this problem
The file at http://www.filedropper.com/respartner was directly exported from OpenERP 7.0 and all carriage returns are preserved.
It sounds like it is either the editor you are using; the method you are using to get the file to your computer (email, file transfer); or something to do with your regional settings that affect field delimeters.
Yes it is possible, I do it everyday without any problem. (with V6.1) OpenERP csv import and export feature works without any problem.
You should use a better csv file editor. I use ASAP extension for excel to import and export csv files http://www.asap-utilities.com
Openoffice also imports csv files nicely however cannot export them nicely (if you have HTML tags and CR LF characters in the fields.
For changing encoding of files to UTF-8 I use Notepad++ (cut the text -> change the encoding -> paste the text back)
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 2/21/13, 5:58 AM|
|Seen: 6655 times|
|Last updated: 3/16/15, 8:10 AM|