There are masses of columns in the List View export. Where do they all come from?

Hello Sarah Pratt,

You can not do this from admin->studio .

If you don't know the technical field name of the fields then you should go to admin -> studio->your_module->fields.

You need to do development for this. You need to go to following path add the file.

<your_sugar_directory>/custom/Extension/modules/<your_module_name>/Ext/Vardefs/<your_file_name.php>

Add the following line into that file.

$dictionary['<your_object_name>']['fields']['<your_field_name>']['exportable']=false;

If you still have any questions then please let me know.

Thanks
Prashant Patel
Certified SugarCRM Developer Specialist
WhatsApp : +91 9016 73 9026
Email : prashant13290@gmail.com

Thanks so much for your reply - I'll try your advice.

Thanks again!

Sarah Pratt

Customer Relations, Netnod

Tel: + 46-8-562 860 00, Direct: +46 8 562 860 027, Mobile: +46 70 3813490

Franzéngatan 5 | SE-112 51 Stockholm | Sweden

sarah@netnod.se

www.netnod.se

Hi Sarah Pratt,

Exporting a record from ListView will pull the entire record, which includes all module fields as you have pointed out.

If I only want a subset of fields from a module, I make a Rows and Columns report displaying the fields I want from the module. Rows and Columns reports can be exported to .csv just like ListView exports.

This is a thorough document about exporting from ListView and Reports:

http://support.sugarcrm.com/Documentation/Sugar_Versions/7.8/Pro/Application_Guide/Export/#Exporting_From_Reports 

I hope this is helpful.

Thanks for this Patrick!

Sarah

Sarah Pratt

Customer Relations, Netnod

Tel: + 46-8-562 860 00, Direct: +46 8 562 860 027, Mobile: +46 70 3813490

Franzéngatan 5 | SE-112 51 Stockholm | Sweden

sarah@netnod.se

www.netnod.se

On 2 March 2018 at 18:41, Patrick McQueen <sugarcrm-public@jiveon.com>