Planyo - advanced integrations

Control Locks based on reservations in Planyo

Planyo does not have an integration for controlling locks directly. Typical use for this is if you would like your code locks to automatically open x minutes before an event and lock x minutes after. Another use is to generate a unique access code for your locks based on the reference code from Planyo or part of the customers mobile phone number that will be programmed into the lock. You can also choose to send a SMS with the code to the customer with the code that they must use to unlock the door. The code will be automatically removed from the lock after x amount of minutes so it cannot be used again.

There are two know solutions that involves using 3rd party software or cloud integrations. Both solutions are using "Home automation" software or HUB . Most locks that are using Zigbee or Z-wave for controlling them are supported.

Alternative 1: Planyo Google Calendar Synchronization - Google Calendar - HomeSeer with GCal Seer plug-in

One of the most advanced and feature rich integrations that has been made to work with Planyo is the GCal Seer plug-in for HomeSeer. You must be using Planyos Google Calendar extention to control locks if your smarthouse or controller supports triggering of events based on events in Google Calendar or Planyo Notifications. This solution will allow you to control one or more electronic code locks based on events in one or more online calendars (Office 365 and Google Calendar is supported). See Control Locks based on Calendar Events using HomeSeer in hjemmeautomasjon.no for complete english instructions. Approx cost of integration approx USD 250,- one time purchase not including hardware.

• Planyo Google Cal sync: CHF 3.9/month - Support: yes from Planyo

• Google Calendar: Free - Support: Google does not offer paid support

• HomeSeer : Lifetime licence USD 250,- (on sale in May and November with 50% discount) - Support: 3rd party paid support from Intin AS

• GCal Seer HomeSeer plug-in: Free - Support: 3rd party paid support from Intin AS

Alternative 2: Planyo Notifications - Zapier - SmartThings with Rboy Lock Manager API

This solution will use the built-in Notifications feature in Planyo to trigger a Zapier "Zap" (task or workflow) that will send a webhook to the Rboy Lock Manager RESTful API creating and deleting lock codes. You may also choose to automatically open or close doors using the same solution. See Control Locks from Planyo using Rboy Lock Manager API for complete instructions. Approx cost of integration approx 250,- one time purchase including hardware but not including Zapier subscription.

• Planyo Notifications: Included with Planyo subscription - Support: yes from Planyo

• Zapier: Price depends on how many court bookings you have. If you have up to 750 bookings each month you will have to subscribe for the "Starter" plan with 1500 tasks (750 tasks to create codes/750 to delete them) See Zapier pricing for more information - Note: Zapier can be used for much more. As an example HIL Tennis use Zapier to create Coupons in Planyo based on purchase on our home page with Stripe integration using the s2member Wordpress plug-in

• Aeotec Smart Home Hub (previously SmartThings Hub): Price approx USD 150,- Can be purchased worldwide (60M+ users) Support: yes from Samsung and Aeotec

• Rboy Lock Manager API: Price USD 99,- for "Rental & Office" lifetime license including support

Recommended Locks that can be used

Small or medium use: The ID Lock 150 with Z-wave module is recommended to be used in areas with small to medium amount of access. The lock itself is good quality and works really well. Typical use is for Club House, wardrobes etc

Heavy or outdoor (both out and indoor of lock is outdoor) use: If you are planning to use the lock in areas where you require a reliable door lock, an electronic strike lock is recommended. You can in theory use any kind of electronic strike lock. HIL Tennis is using electromagnetic locks. They are cheap to purchase and durable. When power is on the door is locked, when power is off then door is unlocked. To control the lock you must use a controller that is compatible with HomeSeer. One controller that works really well is the UMV3 from Danalock. Can be purchased from Intin AS. This controller can be used together with Danapad. If you are looking to install this outdoor (IP66) for controlling access to your courts, then a electromagnetic lock MAG2500 from Locinox is recommended. Can be purchased from from Saco Teknikk in Norway approx NOK 2000,- for each lock.

Vise banekalender på enten web eller Info TV

1. Aktiver Ical feed i Planyo

2. Opprett en kalendervisning på http://www.planyo.net/ for hvert anlegg

3. Legg til kalenderfeed for ressursene (banene) som du ønsker å vise.

Her er eksempel på hvordan vi viser våre 3 innebaner. Pass på å velge akkurat det som er valgt under for å få med alle detaljer!

Automatic refund of Stripe payments in Planyo

Planyo only offers you to manually refund payments. If you would like to automate this process you can forward the "Reservation cancelled by client" email to Zapier Mail parser and extract the necessary information to be used by Zapier to create a refund in Stripe. There are other ways of doing this of course since Planyo offers API and list_reservation_payments, but the method described below will enable you to do this without writing any code.

Activate "Reservation cancelled by client" notification to "Site admin" in Planyo

1. Goto https://www.planyo.com/notifications.php

2. Find "Reservation cancelled by client"

3. Activate Email for "Site Admin"

4. In Subject create a codeword that will be used to filter the email for forwarding to the Zapier Mail Parser.

5. Modify "Subject" in template to : $(if) $(coupon_used) $(then)Reservation paid for with coupon has been cancelled$(endif)$(if) $(reservation_payment_count) greater than 0 $(then)reservation cancelled planyo_auto_refund_stripe$(endif) This will send you an email wth the subject "Reservation paid for with coupon has been cancelled" if the reservation was paid for by using a Coupon and cancelled by the client. If a reservation was cancelled and it was paid for by using Stripe, the subject will be : "reservation cancelled planyo_auto_refund_stripe". We will use the codeword "planyo_auto_refund_stripe" to filter and forward the email later.

6. In "Your message" in the message template insert the following:

$(if) $(coupon_used) $(then)Reservation paid for with coupon has been cancelled by

Customer firstname: $(first_name)

Customer lastname: $(last_name)

Customer email: $(email)

Coupons has been recharged.

$(endif)$(if) $(reservation_payment_count) greater than 0 $(then)

Reservation ID $(reservation_id)

Resource: $(resource)

Date: $(start_date)

Start time: $(start_time)

End time: $(end_time)

Payment method and amount: $(foreach:$(reservation_payment_count))$(reservation_payment_mode:$(it)) $(reservation_payment_amount:$(it))$(endfor)

Customer firstname: $(first_name)

Customer lastname: $(last_name)

Customer email: $(email)

Stripe TXN: $(reservation_payment_id:1)

$(endif)

Remember to press "Submit" to save the template.

Create a Zapier account, Email Parser by Zapier mailbox and create a forwarding rule in your email

Before you start: Create a Zapier account. You can choose the "Free" plan since you will only use one trigger and event. If you would like to have multi-steps you must subscribe to the "Starter plan". Before you create your Zap (Zapier event) you will need to create an Email Parser by Zapier mailbox that will be used to parse information in the email from Planyo:

1. Goto https://parser.zapier.com/login/ Choose "Log in with your Zapier account" (provided you already have a Zapier account)

2. Choose "Create Mailbox"

3. The message "We're waiting... " and " Send an email to ****@robot.zapier.com!" is displayed

4. Goto your mailbox and creat a forwarding rule for email received that has the subject "planyo_auto_refund_stripe" to be forwarded to ****@robot.zapier.com (replace the **** with the actual email address)

5. Login to your planyo site and choose to edit the "Reservation cancelled by client" Site admin Email.

6. Go to the bottom of the page an choose "Test". Make sure you test wit a reservation that has been cancelled by client and was paid for by Stripe. When you press OK an email with information about the cancellation will be sent to the site admin

7. If all goes well the mail that was sent from Planyo was automatically forwarded to ****@robot.zapier.com - normally you also need to confirm the forwarding emailaddress following the procedure informed by your mail service provider. In Gmail you must confirm forwarding by entering a code.

Create an Email parser template to extract the information from the notification email from Planyo

If you have followed the steps above you should now have an email from Planyo in your ***@robot.zapier.com mailbox. You will have to create a template to be able to extract the information that is going to be used for automatically refund in Stripe. The only information that is required for refund is the Stripe TXN. If you would like to create extra steps with name of the customer and so on you need to select the other fields in the template.

1. Log into https://parser.zapier.com/mailboxes

2. Find the mailbox you created and click the cogwheel to edit the template

3. select Stripe TXN (pi_a long number) and name it "stripetxn". Stripe TXN: {{stripetxn}} By doing this the Stripe TXN will be available in the Zap you will create later for refunding the payment