To create a Kroc Export you will first need to connect to the USS Meraki VPN. Credentials and Instructions to do that can be obtained from Gordon.
Once connected to the VPN you’ll use SQL Server Management Studio to connect to this server: thqazsqlstnprd1.sauss.sauss.net
Credentials for the server can be obtained from Tony Valenty. Use these connection settings:
You’ll then want to use the KrocCentral Database before you run the scripts:
There are two types of exports that the Kroc Centers might need data exported for:
Accounts and Contacts
Memberships
Below are the SQL scripts you can use to collect each respective export:
Depending on what Kroc center is requesting the export, you will need to change out the @KrocCenterId variable at the top of the corresponding script to match the Kroc Center Id of the center you are doing the export for.
You can look at the KrocCenter table to find the correct ID using this select statement:
SELECT * FROM [dbo].[KrocCenter]
There aren't many centers in the table and you should be able to find the right center manually by looking at the results.