Details about this thread
  • State Verified Answer
  • Replies 4 replies
  • Subscribers 313 subscribers
  • Views 1339 views
  • Users 0 members are here

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

Sarah Pratt

There are masses of columns in the List View export. What are these - are they the entire universe of fields for that module? Many of these are not displayed in our module view (as they're not useful to us),  and we would get rid of these from our export list if we could.

Parents
  • 0

    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

  • 0 Sugar Employee Badge in reply to Prashant Patel

    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.

Reply Children