Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
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)
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 2/21/13, 5:58 AM|
|Seen: 8529 times|
|Last updated: 3/16/15, 8:10 AM|