Access the Settings page on https://gym.sendmoregetbeta.com/admin/editGym Dashboard.

</aside>

<aside> 1️⃣

Please follow along here for how to

Preliminary Information has been gathered from your website, but please note you may want to edit this information and update your Gym Picture.

</aside>

<aside> 2️⃣

On Business and above? Please follow along here for how to set your Custom Widget color & styling

</aside>

<aside> 3️⃣

Please follow along here for how to Set a default country & required fields in forms

</aside>

<aside> 4️⃣

On Business and above? Please follow along here for how to Collect marketing data on widgets

</aside>

<aside> 5️⃣

Please follow along here for how Edit Gym’s Default Emails

</aside>

<aside> 6️⃣

You can control which note/certifications appear in your dropdown list in your dashboard.

See here how to Create and Edit a Tag/Proficiency

</aside>

This step is handled by BETA!

</aside>

<aside> Access your dashboard, from:

We suggest bookmarking the BETA dashboard to your browser, and we suggest Google Chrome for speed and reliance.

</aside>

<aside>

Last few steps!

Congrats, we are almost there. The day before your launch date, we’ll need a final set of exports from RGP. Certain reports will require custom SQL queries within RGP to ensure data accuracy and information which cannot be migrated from the API.

From these reports, our BETA bots will import the latest data into BETA, ensuring it’s accurate and up-to-date for your launch.

<aside>

Multiple locations?

BETA will require the export from each location.

</aside>

<aside>

How do I run a custom report to export from Rock Gym Pro?

Please read the Full RGP article here on “Adding a custom report using SQL” **https://support.rockgympro.com/hc/en-us/articles/360056598792

—**

*Once you have the SQL query, here’s how to load it into a custom report.

In the Data Entry main window click Reporting and then select General Reports to open the Reporting window.
Click the Custom Reports tab.
Click the Add SQL button.
Enter a title in the Title field.
Copy and paste the SQL query (code) provided to you into the SQL field. Make sure to copy all of the code.
Click OK to save.

You can now run your report from the Custom reports tab at any time.*

</aside>

RGP SQL Queries Final Export (Last Evening)

› 1 ᴏꜰ 5 | Customer Notes & Proficiencies

Notes cannot be pulled from the API, so we import these on the last day, to get the latest info - this can be done on the night, or for multi-locations, over the first few days of operation.

The header of these export should be as follows:

CUSTOMER_ID NOTES EMAIL GUID DELETED FIRSTNAME LASTNAME

SELECT
notes.customer_id AS 'RGP CUSTOMER ID',
CAST(DATE_FORMAT(notes.postdate, '%Y-%m-%d %H:%i:%s') AS CHAR) AS 'CREATED DATE',
CAST(DATE_FORMAT(notes.editdate, '%Y-%m-%d %H:%i:%s') AS CHAR) AS 'EDIT DATE',
IF(notes.alert, 7, 0) AS 'CERTIFICATION TYPE',
notes AS 'CERTIFICATION NOTE',
notes.important AS 'IMPORTANT',
firstname AS 'FIRST',
lastname AS 'LAST',
email AS 'EMAIL',
CAST(DATE_FORMAT(bday, '%Y-%m-%d') AS CHAR) AS DOB,
guid AS 'RGP GUID'
FROM notes
LEFT JOIN customers ON notes.customer_id=customers.customer_id
WHERE notes.deleted=0;

SELECT * FROM notes LEFT JOIN customers ON notes.customer_id=customers.customer_id;

<aside>

Optional only if you want to make changes in the Proficiency mapping since the migration process began.

Select c.guid, c.customer_custom_type, c.belay_certified from customers as c where c.belay_certified <> '' OR c.customer_custom_type <> '';

</aside>

› 2 ᴏꜰ 5 | Final membership report

Please follow the RGP help page to https://support.rockgympro.com/hc/en-us/articles/360056598852-Exporting-customer-query-data-to-a-CSV-file

SELECT
customer_id AS 'RGP CUSTOMER ID',
firstname AS 'FIRST',
lastname AS 'LAST',
email AS 'EMAIL',
CAST(DATE_FORMAT(bday, '%Y-%m-%d') AS CHAR) AS DOB,
guid AS 'RGP GUID',
membership_form_of_payment AS 'PREPAID OR SUBSCRIPTION',
current_status AS 'CURRENT STATUS',
CAST(DATE_FORMAT(membership_start_date, '%Y-%m-%d') AS CHAR) AS 'START DATE',
CAST(DATE_FORMAT(membership_exp_date, '%Y-%m-%d') AS CHAR) AS 'EXPIRATION',
DATEDIFF(membership_exp_date, membership_start_date) AS 'NB! Used to decide on entry config',
'' AS 'ENTRY CONFIG',
EFT_DUES_AMOUNT as `Eft Dues Amount`,
extra_dues_amount_list,
'' AS 'Extra Product Id List',
responsible_party_id AS 'SUBSCRIPTION OWNER',
next_bill_date,
is_billable
FROM customers
WHERE customer_type='MEMBER'
AND membership_form_of_payment NOT IN ('NONE', 'FREE')
AND current_status != 'TERMINATED';

</aside>

SELECT * FROM customers WHERE customer_type='MEMBER';

› 3 ᴏꜰ 5 | Gift Cards

set @giftcardid=(select value from settings where name='GiftCardProductId');
set @enddate = date_add(date(('{ENDDATE}')), interval 1 day);
SELECT REPLACE
	( cardnum, 'GiftCard-', '' ) AS CardNumber,
	(
	SELECT
		i.postdate 
	FROM
		invoices i
		JOIN invoice_items ii ON ii.invoice_id = i.invoice_id 
	WHERE
		ii.EXTRAINFO = cardnum 
		and i.POSTDATE<@enddate
	ORDER BY
		i.postdate ASC 
		LIMIT 1 
	) AS SoldDate,
	CONVERT ((
		SELECT
			sum( PRICE ) 
		FROM
			invoice_items ii
			JOIN invoices i ON ii.INVOICE_ID = i.INVOICE_ID 
		WHERE
			i.VOIDEDINVOICE = 0 
			and i.POSTDATE<@enddate
			AND ii.EXTRAINFO = cardnum 
			AND ii.PRODUCT_ID = @giftcardid 
			),
	DECIMAL ( 10, 2 )) AS Balance 
FROM
	(
	SELECT DISTINCT
		( EXTRAINFO ) AS cardnum 
	FROM
		invoice_items ii
		JOIN invoices i ON ii.INVOICE_ID = i.INVOICE_ID 
	WHERE
		i.VOIDEDINVOICE = 0 
		and i.POSTDATE<@enddate
		AND EXTRAINFO LIKE 'GiftCard%' 
	) AS distinctcards 
HAVING
	balance > 0;

› 4 ᴏꜰ 5 | Punch entries

For you Punch entries, we will need to get the full list, as punch use date is not kept on the RGP database.

SELECT
c.guid AS 'RGP GUID',
SUM(p.delta),
'' AS 'ENTRY CONFIG',
'' AS 'COUNT USED',
CAST(DATE_FORMAT(CURRENT_TIMESTAMP, '%Y-%m-%d %H:%i:%s') AS CHAR) AS 'START DATE'
FROM punches AS p
LEFT JOIN customers AS c ON p.customer_id = c.customer_id
WHERE p.voided = false
GROUP BY c.guid
HAVING SUM(p.delta) > 0;

Select c.guid, sum(p.delta) from punches as p left join customers as c on p.customer_id = c.customer_id where p.voided=false group by c.guid;

› 5 ᴏꜰ 5 | Outstanding membership credit/debit

Optional only if you want to import outstanding membership credit or debit.

Please follow the RGP help page to https://support.rockgympro.com/hc/en-us/articles/360057047751-Reviewing-credit-due-balances

See the RGP steps to export credit due balances </aside>

› Event Bookings [not required]

<aside>

Optional this is only required, if there are any errors in the API export.

Bookings

SELECT 
    DATE_FORMAT(b.BOOKING_DATE, "%Y-%c-%d %T"),
    b.ORIGINAL_BOOKED_OFFERING_NAME,
    DATE_FORMAT(b.ORIGINAL_BOOKED_TIME, "%Y-%c-%d %T"),
    b.NOTES,
    b.PARTICIPANT_COUNT,
    b.CANCELLED,
    c.firstname,
    c.lastname,
    c.email,
    c.bday 
FROM 
    schedule_bookings AS b 
LEFT JOIN 
    customers AS c ON b.customer_id = c.customer_id 
LEFT JOIN 
    schedule_events AS se ON b.course_guid = se.session_guid 
WHERE 
    se.startdate > CURDATE();

Schedule

SELECT 
    DATE_FORMAT(startdate, "%Y-%c-%d %T"),
    DATE_FORMAT(enddate, "%Y-%c-%d %T"),
    DATE_FORMAT(last_session_enddate, "%Y-%c-%d %T"),
    session_count,
    title 
FROM 
    schedule_events 
WHERE 
    startdate > CURDATE();

Last few steps!

RGP SQL Queries Final Export (Last Evening)

› 1 ᴏꜰ 5 | Customer Notes & Proficiencies

› 2 ᴏꜰ 5 | Final membership report

› 3 ᴏꜰ 5 | Gift Cards

› 4 ᴏꜰ 5 | Punch entries

› 5 ᴏꜰ 5 | Outstanding membership credit/debit

› Event Bookings [not required]

Videos

Step 0 - During Video Call

Step 1 - Hardware Req

Step 2 - Editing Gym Details

Step 3 - Granting Permission

Step 4 - Payment Methods

Step 5 - Creating

Step 5.1 - Events