select field to export

[tamhd_vn88]

when i export account list, all field in account table will show. I only want show name,city, phone.(i want customize fields export).Please help me solving this problem
thank!!


when i click export

the file .CSV will show all field


I only want file .csv show some filed as that

[davidboris]

Hi,

Upgrade safe way -----

I would suggest create your own button for export, and check the javascript function sugarListView.prototype.send_form( ) found in include/javascript/sugar_3.js

Override the function in view.list.php

You will get list of selected record ids and then you can use them in a new file which will do export like function and give you the output as you desire.

If you want to go for upgrade safe way ----- (not preferable)
modify the function create_export_query found in MODULE/MODULE.php

[kingjatin]

you can refer to this thread and it will solve your queries also it has the exact code written with only you need to modify the database name and values according to you.

Hope this helps.

Cheers

[tamhd_vn88]

you can refer to this thread and it will solve your queries also it has the exact code written with only you need to modify the database name and values according to you.

Hope this helps.

Cheers

thank David and kingjatin, your advise helped me solving my problem. Thank so much!!

[kingjatin]

Hi,

Upgrade safe way -----

I would suggest create your own button for export, and check the javascript function sugarListView.prototype.send_form( ) found in include/javascript/sugar_3.js

Override the function in view.list.php

You will get list of selected record ids and then you can use them in a new file which will do export like function and give you the output as you desire.

If you want to go for upgrade safe way ----- (not preferable)
modify the function create_export_query found in MODULE/MODULE.php

Hi David,

Can you please elaborate little more as exactly what you are referring to.

1) How can we create a button? I mean in which file ? is that the file that is included in cache folder or we need to create a new field via module builder and then call the function on that button.

2) the editing of the sugarListView.prototype.send_form( ), so where can we write the custom sql queries? Its already very complex.

The below is the function that I found.:

sugarListView.prototype.send_form=function(select, currentModule,action,no_record_txt,action_module,r eturn_info){if(document.MassUpdate.select_entire_l ist.value==1){if(sugarListView.get_checks_count()< 1){alert(no_record_txt);return false;}

It is very interesting to know as this is a upgrade safe manner..

Thanks