Editing export parameters

[petecorbs]

Hi
I have created a custom module that handles bookings coming into a hotel. Everything is fine apart from my last task which is to customize the export function.

The module needs to produce an exported csv file relative to the clients that have checked in for house keeping etc etc.

My question is that i would like to export just certain columns from the db, like client name, room number, check in date etc etc. many of the other fields are not required such as flight arrival times and created by etc.

How can i edit this custom module just to output what i want and not the entire table, i have looked at export.php and export_utils.php but they just seem to only control contacts and accounts, also in my module bookings/bookings.php there is no function create_export_query in the code to edit like there is in leads or accounts.

Any help or a tutorial would be great.
Thanks

[mvngti]

Simply create the create_export_query method in you module's class - the fact that is its not there just means it inherits the default behavior from the SugarBean parent object.

The you can create the export query just as you want it.
Just make sure the method takes the same arguments as SugarBean::create_export_query.

M

[petecorbs]

Hi
So simply cut and past the query into my bookings.php file and change the relevant fields i want to export.
Is it thats simple?

Thanks

[mvngti]

It is not quite as simple as you make it sound.

You have to cut and paste the create_export_query method and then modify it to build the query the way you want it to be.

M