Support

Home Forums Event Espresso Premium Extending CSV export with new variables

Extending CSV export with new variables

Posted: August 6, 2019 at 11:45 am


ICLE

August 6, 2019 at 11:45 am

1. How do I identify the variables I need to use in the CSV code, Here is an example of the CSV code.
2. the slug value of the venue
3. the venue title
4. the payment type (VISA, MC or AMEX) from the transaction
Can you help?


Josh

  • Support Staff

August 6, 2019 at 12:35 pm

Hi,

I’m not exactly sure how to answer your first question, because it’s not clear what you want to identify. May I ask what exactly are you trying to identify there?

With 3, please refer to this example:
https://gist.github.com/joshfeck/fe12aa10c1e8deef04607189b69636d3

With 2, the slug value of the venue will be similar to the above example, where you could add:

$reg_csv_array['Venue Slug'] = $venue->identifier();

With 4, I do not see those as items that are stored in the transaction, so it doesn’t appear to be something you can get from the transaction.


ICLE

August 6, 2019 at 12:41 pm

The card type appears in the right column on the transaction screen.
If the data appears, it has to come from somewhere.
Example of Card Type Data on Screen.


Tony

  • Support Staff

August 6, 2019 at 12:57 pm

The information stored in that section depends on the payment method in use, some don’t have access to that info, others do and it’s not technically stored against the transaction itself but the attendee.

It’s stored as a serialized array with no specific method of pulling certain values (although you could create your own). If you’d like to investigate further take a look at at the billing_info() method on the EE_Transaction class and work through from there, you’ll end up at the billing_info_for_payment_method() method on the EE_Attendee class but the steps to get there are important and you’ll need to know them to pull the info.

As mentioned you’ll need something custom to pull specific details from that section as we don’t have anything that will do it for you at this time, the details are for reference and were not expected to be pulled out indivially.


ICLE

August 6, 2019 at 1:05 pm

My accounting department would love it as the PayEezy does not pass that data along and the different cards clear several days apart. What accounting loves, accounting usually ends up getting. You know how it is. Thanks.

The support post ‘Extending CSV export with new variables’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso