|
KristofRisingHeart
|
March 10, 2017 at 5:16 am
Dear support,
Client would like to be able to add some extra fields from the Payment info to be added to the CSV report. (Notes / Extra Accounting). I noticed that all other fields are beeing exported to the report but not those two fields. Even when they are filled out.
Any ideas why this is happening or anything that can be done about it?
Please find a screenshot of the Payment fields that would have to be included below.
|
|
Tony
|
March 10, 2017 at 6:24 am
Hi there,
By default EE does not include those fields which is why you can’t see them.
The output for the CSV is filterable so you can add additional details to CSV, you’ll need to pull the details for the payments made on the registration to include those.
If you’d like to add those details take a look at the FHEE__EE_Export__report_registrations__reg_csv_array within Event Espresso, it passes 2 variables:
$reg_csv_array – the details that will be output to the csv for each registration.
$reg_row – registration details for the current registration row within the database.
Within reg_row you will have the TXN_ID, you can use that to pull all of the payments related to the transaction using our model system:
https://github.com/eventespresso/event-espresso-core/tree/master/docs/G–Model-System
The loop over the payments and include the extra details within $reg_csv_array and returning that array for the CSV.
Here is an example of adding event categories to the CSV:
https://gist.github.com/Pebblo/09081bb43fa217b0e83060d151d3eda2
Another showing Venues:
https://gist.github.com/joshfeck/fe12aa10c1e8deef04607189b69636d3
|
