[Vtigercrm-developers] CSV-export problem

socialboostdk socialboostdk at gmail.com
Wed Mar 4 17:23:41 GMT 2015


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/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150304/12f6c31d/attachment.html>


More information about the vtigercrm-developers mailing list