Add Export fields in Employees Module

[akron]

Hello everyone!

Could anyone tell me where to find the code that defines the field for the export CSV for the employees module?
I've found it for contacts and accounts, but unfortunately not for users. I hope that this hasn't been aksed before, but I've been searching through the forums and couldn't find anything useful. I'm quite new to Sugar but made some modifications already, and understand PHP and SQL quite well, so if you just could tell me where to find the code, I think I'll be able to manage it myself.

The problem is the following:
Our company has different subcompanies in different countries. So I've added a field on the employees module that shows the right company name. We use Active Directory and the data comes automatically from the related field via LDAP.
But if I want to export a complete list of our employees to a CSV, the company name is missing.
I hope anyone can help me. Thank you very much in advance and

Best regards,

Christian

[Superman]

take a look at function create_export_query($order_by, $where) in /modules/Employees/Employee.php

[akron]

Hey, wow, thanks a lot for your fast answer. It was so obvious ...

So I just defined the needed fields in field_arrays.php (I also wanted to remove some of them and this worked very fine too).
But there's one thing I don't know how to handle:
I would like to change the order of the colums in the export. But if I do it in "export_fields" array only, then the export doesn't work anymore. I recognized that the users array has to have exactly the same order.
But can I change that or does that affect other things too? I'm afraid that I might crash something else by editing the users array ...
Thanks again and

Kind regards,

Christian

[Superman]

if you want such modifications to be applied to Employees module, then you'd better modify mentioned function.

[akron]

OK, thank you. Not that clean method, but works fine and the result counts!

[kingjatin]

Hi,

I have a custom module build to maintain the records to employees with some fields added according to our needs.

Now I want to limit the export fields, can anyone pls help to identify the function that need to be modified and which file?

Thanks