Excel fields

  • Laus
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
13 years 1 month ago #14719 by Laus
Excel fields was created by Laus
Hi Tuan,

I have read in this thread about being able to alter the fields which appear in the Excel document. I have looked in the file 'controller.php' but can only see the possibility of changing the fields which appear in the CSV export.

Can you tell me where I might find the code which adds the fields for the Excel download (the one which is available from the details view).

Thanks.

Please Log in or Create an account to join the conversation.

More
13 years 1 month ago #14735 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: Excel fields
You can modify code in the file components/com_eventbooking/controller.php. Looks at csv_export function in that file, find the code and modify it to meet your need .

Regards,

Tuan

Please Log in or Create an account to join the conversation.

  • Laus
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
13 years 1 month ago #14752 by Laus
Replied by Laus on topic Re: Excel fields
If I export CSV file from Details View (Front End) it only shows me the following columns:

Events, First Name, Email, No of Registrants, Amount, Reg Date, Transaction ID and Payment Status.

There are many more columns specified in controller.php but these do not appear on the CSV file.

Perhaps you could tell me what columns SHOULD appear by default?

And if Community Builder integration requires any amends to this?

I have attached the export of CSV.

I want to also show Surname, Organization and Phone Number.

Please Log in or Create an account to join the conversation.

More
13 years 1 month ago #14767 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: Excel fields
Hi

Go to Event Booking -> Configuration, looks at Billing Fields tab, make sure you setup all fields you want to be Showed . After that, these fields will be available in the excell file .

Regards,

Tuan

Please Log in or Create an account to join the conversation.

More
12 years 10 months ago #16908 by stekkedoos
Replied by stekkedoos on topic Re: Excel fields
Same problem!

The problem of the missing fields is only at the front-end "Export registrants"!

Changing the billing filds parameters is only affecting the back-end csv export.

please help

Please Log in or Create an account to join the conversation.

More
12 years 10 months ago #16918 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: Excel fields
@stekkedoos: What version of the extension you are using ? Could you please upgrade to latest version (1.4.5) ?

Tuan

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc