CSV import payments

Importing payments into EME is done by using a CSV file. The csv delimiter and enclosure can be specified during import. If the delimiter value is empty, then “,” (comma) is taken as value. If the enclosure value is empty, then ‘”‘ (double quotes) is taken as value.
The first line should indicate the names of the columns being imported. Currently these names are recognized (unknown columns will be ignored):
“payment_date”,”unique_nbr”,”payment_id”,”payment_randomid”,”amount”

There are 3 columns required: “payment_date”,”amount” and one of the following 3: “unique_nbr”,”payment_id” or “payment_randomid”.
“payment_date” should be in a format that can be parsed using the PHP function date_parse (to be sure: use YYYYMMDD format). The amount should use the dot (“.”) as decimal separator. For the “unique_nbr” only the numbers will be taken into account. An example:

“payment_date”,”amount”,”unique_nbr”
“20230316”,”14.5″,”+++123/4567/89120+++”

[eme_mymemberships]

[eme_mymemberships]
Will show all memberships for the logged in user, based on the layout given by the templates. Accepts the following arguments:

  • template_id, template_id_header, template_id_footer (at least template_id is required, otherwise nothing will be rendered): use a predefined format template for the memberships list header, footer or list entry, See format templates . Because the memberships returned are a list, you can define specific templates for the header, footer and an entry in that list.

Example:
[eme_mymemberships template_id=3 template_id_header=7 template_id_footer=9]
[eme_mymemberships template_id=3]

[eme_mytasks]

[eme_mytasks]
Will show all signed up tasks for the logged in user, based on the layout given by the templates or by the generic booking list format. Accepts the following arguments:

  • scopelimit tasks to events with mentioned scope. Default value: “future”, other values: “past” or “all”
  • template_id, template_id_header, template_id_footer (optional): use a predefined format template for the bookings list header, footer or list entry
  • task_id: the task where you want to show things for
  • event_id: the event od where you want to show things for

Example:
[eme_mytasks template_id=3 template_id_header=7 template_id_footer=9 scope='past']
[eme_mtyasks template_id=3 ]

Tasks (volunteers)

EME can help you manage volunteers by defining tasks for an event.

To activate tasks, go in the EME settings, tab “General” and activate the option “Use tasks”. After that, you can define tasks per event in a separate tab, like the RSVP definition.

Once you have defined your tasks for an event, check the other settings for tasks (globally and/or per event):

  • the mails that will get send if someone signs up for a task, when some cancels his/her signup, when a signup is deleted by an admin
  • the form format
  • the setting “Allow overlap” and “require WP membership”
  • if you want reminders to be sent out (reminders are sent out at midnight): choose when the reminders are to be sent (in days before the task starts)

Once your settings are ok, you need to show the signup form. For this you can use the shortcode eme_tasks_signupform on a wordpress page (or inside a single event format, see the shortcode doc). For showing who signed up, you can use the shortcode eme_tasks_signups on a wordpress page (or inside a single event format, see the shortcode doc).

[eme_tasks_signups]

[eme_tasks_signups]
Returns a list of signups for event tasks. Accepts the following arguments:

  • event_id: the ID of the event you want to show the bookings for. If not present, all future events with tasks activated will be chosen. The events matching this shortcode also get influenced by the [eme_filterform] shortcode
  • template_id, template_id_header, template_id_footer (optional). These options define – per event – the header (“template_id_header” option, shown above the task signups for that event, the entry (“template_id” option, repeated for each signup for tasks for that event, ordered per task and the tasks ordered as per their definition in the event) and the footer (“template_id_footer” option, shown below the task signups for that event). Since this shortcode can contain tasks for multiple events, these options are used to define the layout of the tasks per event and get repeated for each event.
    If template_id is not provided, a default setting will be used that can be set in the EME settings for tasks.
  • ignore_filter: if set to 1, the shortcode will ignore the eme filter form if present on the page. Defaults to 0. Using this you can use several shortcodes on 1 page and only some are optionally influenced by the eme_filterform shortcode.

See the doc concerning task and task signup placeholders for the placeholders you can use in the templates for this shortcode.

Example (shows the task signups for all future events):
[eme_tasks_signups]
Or, when using it inside a single event format, show the task signups for that event when viewing the event details with a custom template:
[eme_tasks_signups event_id=#_EVENTID template_id=3]
Or, when showing it for event with ID 12 with all custom templates:
[eme_tasks_signups event_id=12 template_id=3 template_id_header=7 template_id_footer=9]

[eme_tasks_signupform]

[eme_tasks_signupform]
Returns a form where people can signup for event tasks. Accepts the following arguments:

  • event_id: the ID of the event you want to show the bookings for. If not present, all future events with tasks activated will be chosen. The events matching this shortcode also get influenced by the [eme_filterform] shortcode. If your event is hidden, you need to specify the event_id argument, otherwise its tasks won’t be shown.
  • template_id, template_id_header, template_id_footer (all optional). These options define – per event – the header (“template_id_header” option, shown above the tasks for that event, the entry (“template_id” option, repeated for each task for that event) and the footer (“template_id_footer” option, shown below the tasks for that event). Since this shortcode can contain tasks for multiple events, these options are used to define the layout of the tasks per event and get repeated for each event.
    If template_id is not provided, the default setting will be used (from the EME generic settings for tasks). An example (the default) for the template content used for template_id is #_TASKSIGNUPCHECKBOX #_TASKNAME (#_TASKBEGIN - #_TASKEND) (#_FREETASKSPACES/#_TASKSPACES) <br> , which shows the task checkbox, the name, task begin/end datetime, free and total spaces for that task.
  • signupform_template_id (optional): below all tasks, the signup form is shown. The default is <table class='eme-rsvp-form'>
    <tr><th scope='row'>Last name*:</th><td>#_LASTNAME</td></tr>
    <tr><th scope='row'>First name*:</th><td>#REQ_FIRSTNAME</td></tr>
    <tr><th scope='row'>Email*:</th><td>#_EMAIL</td></tr>
    </table>
    #_SUBMIT

Next to these, also the following arguments can be used, just like for events (see the eme_events shortcode doc for the info on these):
scope , order , category , showperiod , author , contact_person , location_id , show_ongoing , notcategory , show_recurrent_events_once , ignore_filter

See the doc concerning task signup form placeholders for the placeholders you can use in the templates for this shortcode.

While the above info generates the form to choose which tasks someone wants to signup for, the part of the form where the person enters his name/email (and the submit button) is a generic option in the EME settings.

Example (shows the task form where people can select tasks for all future events):
[eme_tasks_signupform]
Or, when using it inside a single event format and a custom template:
[eme_tasks_signupform event_id=#_EVENTID template_id=3]
Or, when showing it for event with ID 12 and all custom templates:
[eme_tasks_signupform event_id=12 template_id=3 template_id_header=7 template_id_footer=9]

Tasks and task signup placeholders

When defining a task, a huge amount of work can go into the definition/layout of the task signup form and the mails being send when someone signs up for a task, cancels a signup or the signup gets deleted. EME provides you with simple defaults, which you can either adapt globally or per event.
These mails can contain placeholders to make your life easier.

Task placeholders

When you want to visualize task info (either in a task signup form, in the task signup mails sent to a person or the online info on task signups), you can use all event placeholders and the following:

  • #_TASKNAME displays the name of the task
  • #_TASKID displays the ID of the task, this can e.g. be used in the shortcode eme_taskssignups (taskid=#_TASKID option) per task and use an extra template option if you ever want to change the layout of signups per event
  • #_TASKDESCRIPTION displays the task description
  • #_TASKSTARTDATE or #_TASKBEGIN returns the task start datetime. You can optionally provide a datetime argument to change the output format to your liking §php datetime format). Example: #_TASKBEGIN{j M H:i}
  • #_TASKENDDATE or #_TASKEND returns the task end datetime. You can optionally provide a datetime argument to change the output format to your liking §php datetime format). Example: #_TASKEND{j M H:i}
  • #_TASKSPACES returns the total number of spaces defined for this task
  • #_FREETASKSPACES returns the number of free spaces for this task
  • #_USEDTASKSPACES returns the number of used spaces for this task
  • #_TASKSIGNUPS returns a simple list of signups for this task. The layout can be changed in the EME settings. You can also use [ eme_taskssignups taskid=#_TASKID] per task and use an extra template option if you ever want to change the layout of signups per event.
  • #_USER_IS_REGISTERED returns 1 if the current logged in user is registerd for this task, 0 otherwise

Signup placeholders

For task signups, all the placeholders used for people and tasks (see above) can be used. Next to those, you can use the following 2 placeholders in a mail so people can cancel a task signup:

  • #_TASKSIGNUPCANCEL_URL returns a url to cancel the signup for this task. This can be used to create your own clickable links
  • #_TASKSIGNUPCANCEL_LINK returns a clickable link to cancel the signup for this task

Payment gateway placeholders

When showing the payment form, you can use certain placeholders to indicate info on a payment gateway (like the extra cost for that gateway). These placeholders can also be used in made bookings or members (so you can show info on the payment gateway used in mails sent after payment for example).

  • #_EXTRACHARGE indicates the extra cost for the payment gateway being mentioned (in the payment forms) or the payment gateway used (after payment, for a member or booking). If possible, the price is localized according to your preferences (so including currency symbol).
  • #_EXTRACHARGE_NO_VAT the extra cost without VAT (the VAT percentage is taken from the relevant event or membership). If possible, the price is localized according to your preferences (so including currency symbol).
  • #_EXTRACHARGE_VAT_ONLY the total VAT on the extra charge (the VAT percentage is taken from the relevant event or membership). If possible, the price is localized according to your preferences (so including currency symbol).
  • #_PRICE_INCLUDING_CHARGES indicates the total cost (including extra charges for that payment gateway) for a booking or membership for the payment gateway being mentioned (in the payment forms) or the payment gateway used (after payment, for a member or booking). If possible, the price is localized according to your preferences (so including currency symbol).
  • #_PRICE_INCLUDING_CHARGES_NO_VAT the total price without VAT (the VAT percentage is taken from the relevant event or membership). If possible, the price is localized according to your preferences (so including currency symbol).
  • #_PRICE_INCLUDING_CHARGES_VAT-ONLY the total VAT (the VAT percentage is taken from the relevant event or membership). If possible, the price is localized according to your preferences (so including currency symbol).
  • #_CURRENCY the relevant currency used
  • #_CURRENCYSYMBOL the relevant currency symbol