[Vtigercrm-developers] CSV-export problem

[Conrado Maggi]

Hi,

You can use textedit or any other text editor
El 04/03/2015 18:26, "socialboostdk" <socialboostdk at gmail.com> escribió:

> Thanks for the quick reply!
>
> (I agree that anything is better than Excel ;-))
>
> There is no linebreak-setting when importing - I can only define some
> things like what seperator, etc. :-/
>
> I did read online that adding "BOM" to the file could help out, but cannot
> figure out how to do that (on mac).
>
> :) Kim
>
> On 4 March 2015 at 18:14, Alan Lord <alanslists at gmail.com> wrote:
>
>>
>>
>> On 04/03/15 16:57, socialboostdk wrote:
>>
>>> Hi there,
>>>
>>> When exporting from VT6.2 to CSV -> Excel, i have the problem that the
>>> linebreaks are affecting the Excel-file - ie. everything looks good
>>> until a certain row where the linebreaks are in a description, and from
>>> there, the excel-file does not keep them in the cell, but does actual
>>> new lines :-/
>>>
>>
>> Try using LibreOffice ;-)
>>
>> More seriously, there should be a setting when you first import the CSV
>> to tell it what to do with linebreaks... They should be inside a pair of ""
>> anyway.
>>
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150304/771da48e/attachment.html>