Leads export problem

[demayro]

When I choose to export my leads into a .CSV file, SugarCRM generates a file for which the data is totally disordered.
I use to get an Excel type file in which line #1 was contaning every Leads module field names and lines #2 to whatever the leads data.
Now I get a messy file (see attached).
Any idea ?

Thanks,
Romain DEMAY.

[sugarcane]

Hello Romain,

what version of Sugar are you using? Did you upgrade to a new version? I took a look at your file and it looks like the typical export file from the list view of a module. DId you export from reports before?

[tweiss84]

Hey demayro,

Do you think you could post your code where you are exporting the Leads information please.

are you using any other Libraries for creating it, like PEAR or something?

[demayro]

Hi Sugarcane,

We had this export problem using version 4.5.1. I thought that upgrading to 5.1 and then 5.2 could sold my problem...but it didn't.
As the CSV file is being exported today by Sugar, it just can't be used in order to get a proper chart in Excel.
The data seems to be collected without any accuracy and one cell can contain the data from 25 differents fields and another cell can contain the data from 1 SugarCRM field only.
The real issue is that we use to get "clean" CSV files from SugarCRM before. We haven't made any modifications to the application and suddendly those messy CSV files came out from the CRM.

Thanks for your help,
Romain.

[demayro]

Hi Tweiss,

I'm using the inbuild librairies to export data from our Leads module.
Please find attached the php files I assume to be used by SugarCRM for the export function.

Thanks for your help,
Romain.