Kroc Export Instructions

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:

Open

You’ll then want to use the KrocCentral Database before you run the scripts:

Open

There are two types of exports that the Kroc Centers might need data exported for:

1. Accounts and Contacts

2. 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:

There aren't many centers in the table and you should be able to find the right center manually by looking at the results.

Some centers may ask to have certain memberships or accounts filtered out or add additional columns.

If you need to filter out data add your filter to the Where clauses of the first two select statements selecting into a temp table.

If you need to add an additional column you’ll need to add another column to all three selects statements as all the data is combined with a union at the end and they need to have the same amount of columns.

After you’ve finished and run the SQL statement, export them to a CSV file, delete the first column, and upload the file to the corresponding folder for the Center and Datatype your pulling to their shared google drive here: https://drive.google.com/drive/u/1/folders/1JmvsNZ5sNtaB_DP4fns_JYm77z1PnMo9

(You’ll need to request access to get into that drive. Be sure to request access from your commonforge.co email)