Export Particular Fields

**gokulakannan** · 2012-02-03, 05:49 AM

While using export, it creates an *.csv file and it contains all the fields in database. But i want to export particular fields only. Can any one guide me how to do that.

I'm using SugarCE6.4.0RC2 and MySql.

**kbrill** · 2012-02-03, 03:04 PM

There is no way to do this (in CE) that I know of, the export is set to export all fields. What you can do is to pull that file into a spreadsheet and remove the columns you dont want.

If it was something you needed over and over you would either need to move to PRO/ENT/ULT and use a report, load one of the reports modules available from the forge or exchange (not really sure if any of them have an export function, you would have to look around) or have someone tweak the export function in the code to gather fewer columns.

**gokulakannan** · 2012-02-04, 02:28 AM

Thank you for your reply Brill, can i load any report module in CE? If it is possible then kindly post back the details about the report module

**kbrill** · 2012-02-04, 09:27 PM

There are lots of report modules available. You will have to do some experiments to see if any work for you , i have not tried any of them in a long time.

**Ramblin** · 2012-02-05, 01:02 PM

Try the new AlineaSol Reports

Very clean interface, easy to use and lets customize and save reports which can export data. And it is a free download from SugarForge.

(and no. I am not connected in any way to AlineaSol; I just like their product)

Ramblin

**kuske** · 2012-02-05, 02:16 PM

Long time ago I had exactly the same problem.
At that time I found the module /include/export_utils.php with some strange array - $contact_fields and $account_fields - in it.

As they did not have any use I look for a sensful use of them.
Look at my module (from 6.1) an try to understand what I did. :-)

OK, it's ot upgrade safe, but simple...