|
zorrove
|
August 21, 2023 at 11:05 pm
Hello i need to add a column with registrants name + lastname to the csv report is this possible?
Regards,
|
|
Rio
|
August 21, 2023 at 11:12 pm
If you just put that in sheet, then you can open the CSV in Microsoft excel or similar app, then Add column and add formula of CONCAT.
=CONCAT(cell1, delimiter, cell2)
delimiters could be Dash(-), space or any symbol you want.
Check this article here.
https://www.w3schools.com/excel/excel_concat.php
thanks
|
|
zorrove
|
August 22, 2023 at 9:52 am
Hello Rio
Thats ecxactly what im doing right now but it takes me some minutes to format. i just want to save some time every time i need to import this data into my timing system.
is it possible?
Regards,
|
|
Tony
|
August 23, 2023 at 1:28 pm
Hi there,
So you just need a column with the registrant’s full name?
The CSV output is filtered using:
FHEE__EventEspressoBatchRequest__JobHandlers__RegistrationsReport__reg_csv_array
So you can hook in and create your own columns (and specify the order if required) using that, you could use the existing columns and combine the values within another, or pull the full name directly from the registration.
I don’t have an example of this specific request but if you are comfortable with PHP you’ll find examples of using that filter here:
https://gist.github.com/search?p=1&q=FHEE__EventEspressoBatchRequest__JobHandlers__RegistrationsReport__reg_csv_array
|
