Exporting data, containing line-breaks

[krafft]

Hi,

when exporting contacts into csv, field entries with a line-break (eg. in Address or Description) are divided into two lines (two datasets), which make the export useless.
How can I tell the system to ignore those line breaks?

I read another threat about field separators, however my Admin section does not allow me to select anything like this (see http://www.sugarcrm.com/forums/showt...export+contact)

thanks for any help,
cheers

[goodwasabi]

I have exactly the same problem, have you found a soltion for it?

Thankyou,

Marco

[krafft]

I have exactly the same problem, have you found a soltion for it?

Thankyou,

Marco

Unfortunately not.
So far we had to do it manually.

[goodwasabi]

I guess the easyest thing is to make a small program/macro that searches for all line breaks and carriage returns within the field delimitors " or | and changes them with something like --

I'll let you know if I find something better,

Marco

[Snook]

Yop,

I just found a way to solve this issue:

In the file: include/export_utils.php
Search for:

  foreach (array_values($val) as $key => $value) { 
  

Before:

 array_push($new_arr, preg_replace("/\"/","\"\"", $value)); 
  

Add:

 $value = str_replace("\r\n"," -- ","$value"); 
  

So in this case I add " -- " instead of the linebreaks, which can be " <br />" or simply an empty string "".

Hope this is a clean way to resolve the problem.

--
Damien Snoeck
Optaros

[ReeKeePee]

Thank you! Works perfectly.

One question comes to mind: our consultant, who installed Sugar on our server, told me about the /custom folder to which I copy the export_utils.php file in so the modification is upgrade proof (actually the file is copied in /custom/include). Was he right? At first, we copied the file (export_utils.php) in the "/custom/include" folder and modified this copy. It didn't work. What went wrong? Was I misled?

Thanks!