determing fields by Exporting Opportunities to csv

[intraserve]

Hi all,

when using the export function ad the opportunities is there a way to only export/display the collums that i need,

now when I get all the collums but we usually need only 4 or 5 collums.

hope some one can help me on that.

Greets

Nick
IntraServe

[dpatech]

You can edit the file named "export_utils.php" in the root of the Sugar website. There is an array named $contact_fields that lists the fields to be displayed for a contact when exporting. Comment out the fields you don't want.

[eagleone]

Hello,
I found this thread very interesting and tried to change my Sugar-crm CE Version 4.51h the way it been told.
It seems to be quit different now, the File "export-utils.php you find now under \include\export-utils.php.

But my problem is, that my changes on the export-utils.php have no effect on my leads.csv file i get.

And some colums like "modified_user_id" or "deleted" are not in the export-utils.php file. They must be somewhere else.

I need very urgent help with this, so if anybody can help me.... Please do it :-)


By the way, a nother Problem I have is that in my leads.csv (Export File) are lots of Lines broken.
The Lines switched into a second line.

Thats real bad if you want to use the Exportdata.

And realy nuts is, that when I just export 500 Leads, most time their is everything ok. If export 1000 , 1500 or the entire List (over 50.000 Leads) i get broken lines.

PLEASE HELP ME. I urgently desperatly need the Data out of this F*** List. :-)

[Markku]

If you want to limit the number of colums when exporting leads, edit file modules/Leads/Lead.php

around line 274, with function create_export_query change:

Original:

 $query = "SELECT
 leads.*,
 
 users.user_name assigned_user_name";

To:

 $query = "SELECT
 leads.first_name, leads.last_name, leads.lead_source, leads.email1,
 
 users.user_name assigned_user_name";

You just have to define the column names you want to export (first_name, last_name, lead_source, email1 in this example).

[eagleone]

:-) THANK YOU VERY MUCH :-) Markku!!!!

You helped me very much. I noticed that the mistake with the line breaks only happened on 3 of 116 Users and only afte the field "primary_adress_street".

Quite strange ....

But I have one little second question, is it possible to show the assigned user name and not only the ID ???
That is really important for us.

[Markku]

Hi eagleone, glad to be of help!

Field "assigned_user_name" is already in the export query (see the line "users.user_name assigned_user_name") and it should export assigned user name. If it does not work, maybe you could post your version here?